SQL Server

• RDBMS Basics: What Makes Up a SQL Server Database
• Creating and Altering Tables
• Normalization
• Constraints
• Triggers
• Introduction to the Query: The SELECT Statement
• Expressions, Conditions, and Operators
• Functions: Molding the Data You Retrieve
• Clauses in SQL
• The Foundation Statements of T-SQL
• Joins
• Subqueries: The Embedded SELECT Statement
• Manipulating Data
• Creating and Maintaining Tables
• Creating Views and Indexes
• Controlling Transactions and Maintaining Locks
• Cursors
• Stored Procedure
• User Defined Functions
• Database Security
• Advanced SQL Topics
• Dynamic Uses of SQL
• Streamlining SQL Statements for Improved Performance