DatabaseBeginnerQuerying and Managing Data with Transact-SQL
2 Days (16 Hours)Face to Face / Online
Unlock the power of relational data with Transact-SQL. Learn to write efficient queries, work with joins, aggregations, and subqueries, and manage data effectively in SQL Server and Azure SQL environments.
| Duration | 2 Days (16 Hours) |
|---|---|
| Level | Beginner |
| Category | Database |
| Training Method | Face to Face / Online |
Course Outline
- SQL Server and database fundamentals
- SELECT statements and filtering data
- Joins and set operations
- Aggregations and grouping
- Subqueries and common table expressions
- Data modification: INSERT, UPDATE, DELETE
- Basic stored procedures and views
- Query performance basics
Frequently Asked Questions
Do I need prior database experience?
No, this course is beginner-friendly and starts from the fundamentals.
Is Excel experience enough to get started?
It's helpful but not required.
Does T-SQL apply only to SQL Server?
T-SQL is used with both SQL Server and Azure SQL.
Is this hands-on?
Yes, query-writing labs run throughout the course.
Notes
Beginner level, 2 days (16 hours), delivered face-to-face or online. A foundational course recommended before the SQL Server Development or Administration courses.