SQL Server 2014 Professional Diploma

Course Outlines
Querying Microsoft SQL Server
- Introduction to Microsoft SQL Server 2014.
- Introduction to T-SQL Querying.
- Writing SELECT Queries.
- Querying Multiple Tables.
- Sorting and Filtering Data.
- Working with SQL Server 2014 Data Types.
- Using DML to Modify Data.
- Using Built-In Functions.
- Grouping and Aggregating Data.
- Using Subqueries.
- Using Table Expressions.
- Using Set Operators.
- Using Window Ranking, Offset, and Aggregate Functions.
- Pivoting and Grouping Sets.
- Executing Stored Procedures.
- Programming with T-SQL.
- Implementing Error Handling.
- Implementing Transactions.
- Improving Query Performance.
- Querying SQL Server Metadata.
Developing Microsoft SQL Server Databases
- Introduction to Database Development.
- Designing and Implementing Tables.
- Ensuring Data Integrity through Constraints.
- Introduction to Indexing.
- Advanced Indexing.
- Columnstore Indexes.
- Designing and Implementing Views.
- Designing and Implementing Stored Procedures.
- Designing and Implementing User-Defined Functions.
- Responding to Data Manipulation via Triggers.
- Using In-Memory Tables.
- Implementing Managed Code in SQL Server
- Storing and Querying XML Data in SQL Server.
- Working with SQL Server Spatial Data.
Administering Microsoft SQL Server
- Introduction to SQL Server 2014 Database Administration.
- Installing and Configuring SQL Server 2014.
- Working with Databases and Storage.
- Planning and Implementing a Backup Strategy.
- Restoring SQL Server 2014 Databases.
- Importing and Exporting Data.
- Monitoring SQL Server 2014.
- Tracing SQL Server Activity.
- Managing SQL Server Security.
- Auditing Data Access and Encrypting Data.
- Performing Ongoing Database Maintenance.
- Automating SQL Server 2014 Management.
- Monitoring SQL Server 2014 by Using Alerts and Notifications.
- Pivoting and Grouping Sets.
- Executing Stored Procedures.
- Programming with T-SQL.
- Implementing Error Handling.
- Implementing Transactions.
- Improving Query Performance.
- Querying SQL Server Metadata.
- 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
- Microsoft Certified Solution Developer (MCSD)
Train the following courses :
Mohamed Adam
Founder and CEO
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
- Microsoft Certified Solution Developer (MCSD)
- Sun Java Programmer Certified V5.0 (SCJP).
- IBM WebSphere Application developer
- IBM WebSphere Commerce
Train the following courses :
- Angular 1 & Angular 2
- Web developing Diploma (HTML5 - SQL - JS - Angular - C# - MVC 5 )
- Programming in HTML5 with JavaScript and CSS3
- Developing ASP.NET MVC 5 Web Applications
- SharePoint 2013 administrator
- SharePoint 2013 developer
- C#
- Querying SQL Server 2014
- Developing SQL Server 2014
- Administering SQL Server 2014
- Asp.net