Querying Data with Transact SQL
Learn to write and optimize queries using Transact-SQL. This course helps you retrieve, filter, and manage data in SQL Server, improving your database querying skills for data analysis and reporting.
Contact UsWhat You’ll Learn
Introduction to SQL and T-SQL
-
SQL - The Language for Business
-
Understanding T-SQL
Basic Querying Techniques
-
Basic Select Queries
-
Sorting Rows
-
Rules of Precedence
Working with Functions
-
Scalar Text Functions
-
Numeric Functions
-
Date Functions
Advanced Expressions and Parameters
-
Case Expressions
-
Parameters
-
Conversion Functions
Table Relationships and Queries
-
Table Relationships - JOINS
-
Subqueries
-
Join vs Subqueries
Views and Subqueries
-
Views
-
WITH - Subqueries as a Table
Schema and Table Management
-
Schemas and Table Creation
-
Constraints
Aggregations and Filters
-
Group By and Aggregates
-
Having Clause
Partitioning and Advanced Concepts
-
Other DML Statements
-
Group By vs Partition
Collaborative Learning
-
Team Activity
10
Sections
24
Chapters
Why Train with ByteSize?
Free Access to LMS with AI Q&A
Enjoy complimentary access to our Learning Management System (LMS) with AI-powered Question & Answer features to enhance your learning experience.
Surveys, Quizzes and Games
Make learning interactive and engaging with our innovative tools like surveys, quizzes, and games tailored to boost retention and fun.
Access to Learner Dashboard
Monitor learner progress with our comprehensive dashboards, providing real-time insights to measure engagement and performance.
Let’s Build Your Team’s Skills
Take the first step to transform your organization with data analytics. Fill out the form, and we’ll get back to you with a tailored solution.