SQL Server 2014 Professional Diploma

SQL Server 2014 Professional Diploma

Course Outlines


Querying Microsoft SQL Server

  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.

Developing Microsoft SQL Server Databases

  1. Introduction to Database Development.
  2. Designing and Implementing Tables.
  3. Ensuring Data Integrity through Constraints.
  4. Introduction to Indexing.
  5. Advanced Indexing.
  6. Columnstore Indexes.
  7. Designing and Implementing Views.
  8. Designing and Implementing Stored Procedures.
  9. Designing and Implementing User-Defined Functions.
  10. Responding to Data Manipulation via Triggers.
  11. Using In-Memory Tables.
  12. Implementing Managed Code in SQL Server
  13. Storing and Querying XML Data in SQL Server.
  14. Working with SQL Server Spatial Data.

Administering Microsoft SQL Server

  1. Introduction to SQL Server 2014 Database Administration.
  2. Installing and Configuring SQL Server 2014.
  3. Working with Databases and Storage.
  4. Planning and Implementing a Backup Strategy.
  5. Restoring SQL Server 2014 Databases.
  6. Importing and Exporting Data.
  7. Monitoring SQL Server 2014.
  8. Tracing SQL Server Activity.
  9. Managing SQL Server Security.
  10. Auditing Data Access and Encrypting Data.
  11. Performing Ongoing Database Maintenance.
  12. Automating SQL Server 2014 Management.
  13. Monitoring SQL Server 2014 by Using Alerts and Notifications.
  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