Querying Sql Server

New Microsoft Beginner

What you'll learn

A minus obcaecati optio pariatur porro.

Curriculum

Module1:Foundation of Querys

Open Close

Module 2:Getting Started with Select Statement

Open Close

Module 3:Filtering and Sorting Data

Open Close

Module 4:Combining Sets

Open Close

Module 5:Grouping and Windowing

Open Close

Module 6:Querying Full Tex tData

Open Close

Module 7:Quering and Managing XML Data

Open Close

Module 8:Creating Tables and Enforcing Integrity

Open Close

Module 9:Designing and Creating Views ,Inline functions and Synonyms

Open Close

Module 10:Inserting ,Updating and Deleting Data

Open Close

Module 11:Data Modification Aspects

Open Close

Module 12:Implementing transactions ,Error Handling and Dynamic SQL

Open Close

Module 13:Desigining and Implementing T-SQL Routines

Open Close

Module 14:Using tools to Analyze Query performance

Open Close

Module 15:Implementing Indexes and Statistics

Open Close

Module 16:Understanding Cursors ,Sets and Temporary Tables

Open Close

Module 17:SQL Server Aspects for Query Optimization

Open Close


Course

2 months  
Instructor: Yasir Fazal
Max. students: 15


Yasir Fazal

Yasir Fazal

Biography