Trained 50k+ People
Over 100+ Countries
By Specialist Trainers
With Over 20 Years' Experience
By the end of this course, learners will be able to retrieve and filter data using SELECT statements, sort and group results efficiently, use joins, subqueries, and table expressions, modify data with INSERT, UPDATE, and DELETE statements, and implement transactions and error handling in T-SQL to manage data safely and effectively.
1 - Introduction to Transact-SQL
2 - Sort and filter results in T-SQL
3 - Combine multiple tables with JOINs in T-SQL
4 - Write Subqueries in T-SQL
5 - Use built-in functions and GROUP BY in Transact-SQL
6 - Modify data with T-SQL
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
Basic understanding of relational databases and fundamental SQL concepts
Microsoft Docs: T-SQL Reference
This course prepares learners for the Microsoft DP-080: Administering a SQL Database Infrastructure certification exam. The exam tests your ability to manage, query, and modify data in SQL Server using T-SQL, including working with tables, views, indexes, stored procedures, and transactions. Practical experience through labs and exercises in this course directly supports exam readiness. Candidates should expect a combination of multiple-choice, scenario-based, and practical questions. Passing this exam demonstrates proficiency in T-SQL and SQL Server data management and is a key step toward Microsoft Certified: Data Analyst or Database Administrator certification paths.
After this course, learners can advance to courses such as Administering Relational Databases (DP-300) or Implementing Data Models and Reports.
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
All of our trainers have achieved exceptionally high delegate pass rates for accredited examinations for all our courses. We also offer complimentary pre and post-course support for any questions you may have.
We try and be as flexible as we can and accommodate your needs. We can swap delegates at any time with no charge. We can also create bespoke content should this be required.
We specialise in IT Service and Project Management. All of our Trainers and Consultants have considerable years of hands-on experience in IT Service / Project Management, working across a wide number of industry sectors.
Our training, sales and admin staff are all professional, helpful, friendly and approachable. We believe in providing excellent customer service. You will always have a dedicated friendly Account Manager
INFORMATION
There are currently no course dates that match your selected filter options. Please try another filter or contact one of our dedicated account managers on +44 208 1428 961 to discuss your requirements. Thanks.
Live Chat
Contact Us
DURATION
TYPE 
PRICING 