SQL SERVER DEVELOPER
What are the SQL Server datatypes? The SQL Server datatypes dictate the type of data an object can hold. Examples are integer, strings, decimals, binary, and so forth. We can divide them in Numeric Character Strings Binary Strings Date & Time Other Numeric, as the name say, has to do with numbers. BIT TINYINT SMALLINT…
Need a database? Think about designing first to achieve the desired model. Avoid the black box syndrome. Black box syndrome is just the idea of thinking that databases are software used to save and retrieve data. It is “kind of” true in the sense that it does that. However, there is a phase in the…
What is Normalization in RDBMS? Normalization is a process to reduce or eliminate data redundancies by correcting table structures inside a relational database management system. There are, as of 2022, 7 different forms of normalization. They are 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, and 6NF. To understand how this works, we will take this table…
The main feature in RDBMS (Relational Database management system) is the relational or the relationship part of it. If done correctly, it makes the connections among entities easier and faster to retrieve. It also eliminates data anomalies and redundancies. Business rules will dictate that, so a clear understanding of the rules will make it easier…
SQL means Structured Query Language. Through SQL you can establish communication with a database. According to the American National Standards Institute, SQL is the language that is used for RDMS. RDMS is the short form of relational database management systems. Structured Query Language is designed to make the management and retrieval of data easier. SQL…