DP-080T00: Querying Data with Microsoft Transact-SQL
* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us: sales@ccslearningacademy.com.
Student financing options are available.
Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Looking for group training? Contact Us
Course schedule:About This Course
Course Description
This course will teach you how to use Transact-SQL to query and modify 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.
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.
Learning Objectives
Inclusions
- 2 Day Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
Target Audience
- 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.
Curriculum
Module 1: 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
Module 2: Sort and filter results in T-SQL
Sort your results
Limit the sorted results
Return paged results
Remove duplicates
Filter data with predicates
Module 3: 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
Module 4: Write Subqueries in T-SQL
Understand what subqueries are
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries
Module 5: 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
Module 6: 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
Your Instructors
Write a review
$1,545.00
Inclusions
- 2 Day Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
Course categories