Querying Databases Using Transact-SQL

Gain insights into T-SQL syntax, table creation, data manipulation, and relationships. Delve into advanced constructs like stored procedures, functions, and triggers to enhance your database development skills.

Intermediate

51 Lessons

15h

Certificate of Completion

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

2 Assessments

132 Playgrounds

7 Quizzes

This course includes

2 Assessments

132 Playgrounds

7 Quizzes

Course Overview

T-SQL is a dialect of SQL that is used in Microsoft SQL Server. The popularity of Microsoft's database management system sustains high market demand for people well versed in T-SQL. This course teaches the core concepts and syntax of T-SQL. First, you will learn how to create tables, insert data, update existing records, and create relationships between tables. Then, you will be exposed to more advanced constructs of T-SQL, like stored procedures, functions, and triggers. By the end of the course, you w...Show More

TAKEAWAY SKILLS

Sql

Database

What You'll Learn

Familiarity with T-SQL’s role in database development

Ability to read data from and write data to Microsoft SQL Server databases

A hands-on experience with T-SQL core syntax

A working knowledge of database development using functions, stored procedures, and other programmability objects.

What You'll Learn

Familiarity with T-SQL’s role in database development

Course Content

Before We Start

Get familiar with T-SQL fundamentals, operations, and procedures for Microsoft SQL Server.

Introduction to the Course

Course Structure

T-SQL Basics

Unpack the core of T-SQL, databases, tables, data manipulation, querying, filtering, and data modification.

Introduction to T-SQL Databases: Creating and Removing Tables: Creating and Removing Inserting Data in Tables Retrieving Data from Tables Filtering the Data from Tables Query Limits, and Distinct and Ordered Data Updating and Deleting Data from Tables Quiz Yourself: T-SQL Basics

Querying Multiple Tables

Work your way through table relationships, foreign key constraints, and various SQL joins.

Table Relationships Foreign Key Constraints: Inserting Data into Dependent Tables Querying with Joins Types of SQL Joins Quiz Yourself: Querying Multiple Tables

Grouping and Aggregation

Grasp the fundamentals of aggregate functions, GROUP BY, window functions, and the PARTITION BY clause in T-SQL.

Aggregate Functions Uses of the GROUP BY Function Window Functions The PARTITION BY Clause Quiz Yourself: Grouping and Aggregation

Subqueries

Dig deeper into efficient data retrieval using subqueries, versatile use cases, and comparison operators.

Introduction to Subqueries Use Cases for Subqueries Comparing Values Operators: EXISTS and IN Quiz Yourself: Subqueries

T-SQL Fundamentals Assessment

Assessment

Built-in Functions

5 Lessons

Investigate T-SQL's string manipulation, date and time management, casting, and handling NULL values.

T-SQL Programming Basics

9 Lessons

Build on T-SQL basics with views, variables, temporary tables, functions, and stored procedures.

Additional Programming Constructs

10 Lessons

Step through advanced T-SQL programming constructs for robust database management and control.

Course Comprehension Assessment

Assessment

Conclusion

1 Lesson

Look at the next steps in advancing your MS SQL Server and T-SQL skills.

Course Author

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!