Querying Microsoft SQL Server

sql server 2014 query

Course Outlines


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

Ashraf Bedaewy

Senior SQL Server Trainer
  • Over 10 years experience with Microsoft technologies.
  • Over 3000 hours of training Microsoft technologies.

Working as authorized trainer in the following Centers:

  • New Horizons .
  • Global Knowledge .
  • Computek .
  • Orascom Telecom .
  • ITI Institute .

CERTIFICATIONS

  1. Microsoft Certified Solution Developer (MCSD)

Train the following courses :



Professional In : C#, Asp.net, MVC5, Web API, MS SQL Server, ADO.NET, Entity Framework,SharePoint2013, Bootstrap, MYSQL, OOP, JS, JQuery, HTML5, Css3 , LINQ , Web Service , WCF and Problems Analysis.


  • Over 10 years experience with Microsoft technologies.
  • Over 2000 hours of training Microsoft technologies.
  • Over 20 web application.

Working as authorized trainer in the following Centers:

  • New Horizons .
  • Global Knowledge .
  • Computek .
  • Orascom Telecom .
  • ITI Institute .

Who I trained?

  • Vodafone.
  • YellowPages.
  • MUST-Misr University for Science & Technology.
  • Health Insights.
  • Cairo Government.

CERTIFICATIONS

  1. Microsoft Certified Solution Developer (MCSD)
  2. Sun Java Programmer Certified V5.0 (SCJP).
  3. IBM WebSphere Application developer
  4. IBM WebSphere Commerce

Train the following courses :


Afternoon (4 hours/day 6PM : 10PM)
Friday & Saturday (8 hours/day 9Am : 5PM)
For more information call us now on : 0100 460 35 84 - 01111 07 61 35