لیست مطالب


SQL Server Design and Implementing

  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2012 Data Types
  • Using Built-In
  • Grouping and Aggregating Data
  • Using Sub queries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions