Computer

Learn about SQL Server and its Principles – SQL Tutorial Part 5     B-tree In SQL Server 2005, all indexes are structured in the form of B-Trees. A B-Tree structure can be visualized as an inverted tree with roots right at the top splitting into branches and then into leaves right at the bottom. … Read more Learn about SQL Server and its Principles – SQL Tutorial Part 5

SQL Tutorial – Learn about SQL Server and its Principles – Part 4     SQL Tutorial Part 4   Welcome to the module Introduction to Indexes. Indexes are created for faster retrieval of data. Sorted data is more easily accessible than unsorted data. Hence, queries on indexed tables are executed faster and with lesser strain on … Read more SQL Tutorial – Learn about SQL Server and its Principles – Part 4

Working with SQL Server 2005 – SQL 2005 Tutorial – Learn SQL Part 3     Integrity Constraints   Constraints are used to ensure validity of data in a table and consistency of data across tables. You can define constraints at the column or table level. A constraint defined at the column-level is a part … Read more Working with SQL Server 2005 – SQL 2005 Tutorial – Learn SQL Part 3

Working with SQL Server 2005 – SQL 2005 Tutorial – Learn SQL Part 2       SQL Server 2005 Tutorial Part 2   Types of Data Integrity   A database needs to maintain data integrity so that the information derived from the data is accurate and up-to-date. Integrity of data can be classified into the … Read more Working with SQL Server 2005 – SQL 2005 Tutorial – Learn SQL Part 2

Working with SQL Server 2005 – SQL 2005 Tutorial – Learn SQL Part 1     Welcome to the course Working with SQL Server Database Objects. This course aims to teach advanced features of SQL Server 2005 such as Indexes, Stored Procedures, Triggers and Views.   Data Integrity   In a database when data is … Read more Working with SQL Server 2005 – SQL 2005 Tutorial – Learn SQL Part 1