MCSA: Querying Microsoft SQL Server 2012 هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012

Outline

• Module 1: Introduction to Microsoft SQL Server 2012
• Module 2: Getting Started with SQL Azure
• Module 3: Introduction to T-SQL Querying
• Module 4: Writing SELECT Queries
• Module 5: Querying Multiple Tables
• Module 6: Sorting and Filtering Data
• Module 7: Working with SQL Server 2012 Data Types
• Module 8: Using Built-In Functions
• Module 9: Grouping and Aggregating Data
• Module 10: Using Subqueries
• Module 11: Using Table Expressions
• Module 12: Using Set Operators
• Module 13: Using Window Ranking, Offset and Aggregate Functions
• Module 14: Pivoting and Grouping Sets
• Module 15: Querying SQL Server Metadata
• Module 16: Executing Stored Procedures
• Module 17: Programming with T-SQL
• Module 18: Implementing Error Handling
• Module 19: Implementing Transactions
• Module 20: Improving Query Performance