MS SQL Server

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

Comments are closed.