GPay, PhonePe, Paytm or Amazon Pay on +91-8888092582. View refund policy »
Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL language that is used with Microsoft SQL Server and Azure SQL Database.
Learn the T-SQL fundamentals in an instructor-led training sessions either in online or classroom mode.
This training will get you started with query processing fundamentals to help you write powerful, performant T-SQL queries. You will also learn to build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to address various challenges in T-SQL execution
Syllabus
Please check the syllabus tab above. ☝- Introduction to Transact-SQL
- Understand what SQL is for
- Identify database objects in schemas
- Identify SQL statement types
- Use the SELECT statement
- Work with data types
- Handle NULLs
- Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Return paged results
- Remove duplicates
- Filter data with predicates
- Combine multiple tables with JOINs in T-SQL
- Describe join concepts and syntax
- Write queries that use inner and outer joins
- Write queries that use cross joins
- Write queries that use self joins
- Write Subqueries in T-SQL
- Understand what subqueries are
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
- Use built-in functions and GROUP BY in Transact-SQL
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
- Modify data with T-SQL
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
- Advance SQL server management
- Backup and Restore Of Database
- Attach and Detach of Database
- Normalization
Manoj S. Mahajan
Senior IT trainer, Owner
25+ years experience, Microsoft Certified Trainer (MCT) and VMware Certified Instructor (VCI) with many certifications completed.
View profile...Student Testimonials
Utkarsh
Wipro Infotech
Over all experience is very good. The training what I got by you was excellent.read more »
Prabhakar
IBM
It was good experience. Thank you sir.
read more »
Amol
Accenture
It was a good experience overall. All the concept were cleared. read more »
Join Free Class
