Post Description

Lesson 01.Introduction to SQL Server 2012
Lesson 02.Introduction to Relational Databases
Lesson 03.Introduction to SELECT Statements
Lesson 04.Filtering Results with WHERE Statements
Lesson 05.Utilizing Joins
Lesson 06.Executing Subqueries and UNION Statements
Lesson 07.Aggregating Data
Lesson 08.Advanced Data Aggregations
Lesson 09.Built-In Functions
Lesson 10.Query Optimization
Lesson 11.Modifying Data Duration
Lesson 12.Advanced Data Modification
Lesson 13.Managing Transactions
Lesson 14.Implementing Error Handling
Lesson 15.XML Basics
Lesson 16.Retrieving XML
Lesson 17.Importing XML
Lesson 18.Creating and Altering Tables
Lesson 19.Data Validation with Constraints
Lesson 20.Creating and Modifying Triggers
Lesson 21.Creating and Modifying Views
Lesson 22.Creating and Modifying Stored Procedures
Lesson 23.Creating and Modifying User Defined Functions