- 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
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Database Queries Global CoursesEGP 755
EGP 7,107Duration: 2 Hours - SQL Global CoursesEGP 755
EGP 7,107Duration: 2 Hours