Querying Databases Using Transact-SQL

Home>

Courses>

The course teaches the core syntax and concepts of Transact-SQL.

Intermediate

51 Lessons

15h

Certificate of Completion

The course teaches the core syntax and concepts of Transact-SQL.

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

Introduction to the Course

Course Structure

T-SQL Basics

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

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

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

Subqueries

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

T-SQL Programming Basics

9 Lessons

Additional Programming Constructs

10 Lessons

Course Comprehension Assessment

Assessment

Conclusion

1 Lesson

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

Souvik Kundu

Front-end Developer

Eric Downs

Musician/Entrepeneur

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!

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath