• Lesson 1: Overview of Relational Databases
• Lesson 2: Introduction to Microsoft SQL Server 2012
• Introducing Microsoft SQL Server 2012
• Getting Started with SQL Server Management Studio
• Creating Database Objects
• Lab : Working with SQL Server 2012 Tools
• Lesson 3: Introduction to T-SQL Querying
• Introducing T-SQL
• Understanding Sets
• Understanding Predicate Logic
• Understanding the Logical Order of Operations in SELECT statements
• Lab : Introduction to Transact-SQL Querying
• Lesson 4: Writing SELECT Queries
• Writing Simple SELECT Statements
• Eliminating Duplicates with DISTINCT
• Using Column and Table Aliases
• Writing Simple CASE Expressions
• Lab : Writing Basic SELECT Statements
• Lesson 5: Querying Multiple Tables
• Understanding Joins
• Querying with Inner Joins
• Querying with Outer Joins
• Querying with Cross Joins and Self Joins
• Lab : Querying Multiple Tables
• Lesson 6: Sorting and Filtering Data
• Sorting Data
• Filtering Data with a WHERE Clause
• Filtering with the TOP and OFFSET-FETCH Options
• Working with Unknown and Missing Values
• Lab : Sorting and Filtering Data
• Lesson 7: Views and Indexes
• Using Views
• Every Thing About Views
• Indexes
• Lesson 8: Working with SQL Server 2012 Data Types
• Introducing SQL Server 2012 Data Types
• Working with Character Data
• Working with Date and Time Data
• Lab : Working with SQL Server 2012 Data Types
• Lesson 9: Using Built-In Functions
• Writing Queries with Built-In Functions
• Using Conversion Functions
• Using Logical Functions
• Using Functions to Work with NULL
• Lab : Using Built-In Functions
• Lesson 10: Grouping and Aggregating Data
• Using Aggregate Functions
• Using the GROUP BY Clause
• Filtering Groups with HAVING
• Lab : Grouping and Aggregating Data
• Lesson 11: Using Subqueries
• Writing Self-Contained Subqueries
• Writing Correlated Subqueries
• Using the EXISTS Predicate with Subqueries
• Lab : Using Subqueries
• Lesson 12: Using Table Expressions
• Using Derived Tables
• Using Common Table Expressions
• Using Inline Table-Valued Functions
• Lab : Using Table Expressions
• Lesson 13: Using Set Operators
• Writing Queries with the UNION Operator
• Using EXCEPT and INTERSECT
• Using APPLY
• Lab : Using Set Operators
• Lesson 14: Using Window Ranking, Offset and Aggregate Functions
• Creating Windows with OVER
• Exploring Window Functions
• Lab : Using Window Ranking, Offset and Aggregate Functions
• Lesson 15: Pivoting and Grouping Sets
• Writing Queries with PIVOT and UNPIVOT
• Working with Grouping Sets
• Lab : Pivoting and Grouping Sets
• Lesson 16: Querying SQL Server Metadata
• Querying System Catalog Views and Functions
• Executing System Stored Procedures
• Querying Dynamic Management Objects
• Lab : Querying SQL Server Metadata
• Lesson 17: Executing Stored Procedures
• Querying Data with Stored Procedures
• Passing Parameters to Stored Procedures
• Creating Simple Stored Procedures
• Working with Dynamic SQL
• Lab : Executing Stored Procedures
• Lesson 18: Programming with T-SQL
• T-SQL Programming Elements
• Controlling Program Flow
• Lab : Programming with T-SQL
• Lesson 19: Implementing Error Handling
• Using TRY / CATCH Blocks
• Working with Error Information
• Lab : Implementing Error Handling
• Lesson 20: Implementing Transactions
• Transactions and the Database Engine
• Controlling Transactions
• Lab : Implementing Transactions
• Lesson 21: Improving Query Performance
• Factors in Query Performance
• Displaying Query Performance Data
• Lab : Improving Query Performance
• Lesson 22: Working with XML
• XML Data Type
• XML Schema Collections
• Querying XML
• Lesson 23: SQL Services Overview
• Overview of Integration Services
• Overview of Analysis Services
• Overview of Reporting Services

• طلاب كليات الحاسب.
• موظفي ومديري نظم المعلومات.
• المهتمين بالعمل في مجال البرمجيات.

للدخول الى هذه الدوره يجب ان يكون لديك معرفه جيده بقواعد البيانات الارتباطيه, برجاء مراجعة المسارات التعليميه لمزيد من المعلومات

يمكنك بعد انتهاء هذه الدوره العمل بوظيفة مبرمج قواعد بيانات MS SQL Server