This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
- 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
About Computek Training Center
It is the first and largest provider of computer software and hardware training in Egypt.
We_They is fast growing training provider over 20 years of experience in the delivery of computer training.
Our organization is dedicated to provide education excellence to meet the needs of each technology, simultaneously, as customer expand designed solutions to meet his particular organization's business needs.
Also Compuek is aimed by great companies and institutions for training their human resources looking for their progress and growth, and to make HR learn this promising technology at that time. For 20 years, the center is supplying the career market by highly qualified HR members who having broad minded, acquired with high technique and capable to work on the most difficult systems by all easiness and facility.
Computek is distinguished by its remote sighted management that enjoyed advanced thinking and firmness in order to enable the trainees to get as much training as possible by easy and simple way and in fine, splendid, and very organized training halls acquired with high capability PCs that are continuously upgraded to maintain high performance.See all Computek Training Center courses