- Location: 93 Mostafa Alnahas , Nasr City , Cairo, Egypt
- Duration: 40 Hours
Course details
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012
Outline
- 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
Course Location
About HeroTec
Herotec is network professional training provider, founded 2007 to focus on IT professional training.
Herotec provides professional training programs at their premises or onsite training (client premises)
their exclusive specialization in the field of IT & network professional training with both sectors) technical & management) gives us the advantage to be the leader in identifying unique training opportunities for both corporate & individuals.
See all HeroTec courses Are you from HeroTec ? Claim your course!
Courses you can instantly connect with... Do an online course on MCSA starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- EGP 2,461Duration: 1 To 2 Months
- Administering a SQL Database Infrastructure Global EdulinkEGP 4,928
EGP 35,497Duration: Upto 22 Hours
