HomeCoursesQuerying Databases Using Transact-SQL

Updated 27 Aug

AI-powered learning

Save

Querying Databases Using Transact-SQL

Name: Querying Databases Using Transact-SQL
Price: 59 USD
Author: Aidil Umarov

Gain insights into T-SQL, create tables, manage data, and explore advanced constructs like stored procedures, functions, and triggers to enhance your database development skills.

4.5

51 lessons

15h

Created by Aidil Umarov

What's included

51 lessons across 9 modules
7 quizzes with instant feedback
AI Tutor on every lesson

Join 3.1 million developers at

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.

Learning Roadmap

51 Lessons7 Quizzes2 Assessments

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

5 Lessons

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

Grouping and Aggregation

5 Lessons

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

Subqueries

5 Lessons

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

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

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

What's Next?

Certificate of Completion

Showcase your accomplishment by sharing your certificate of completion.

About this course

WHY I WROTE THIS COURSE

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 will be sufficiently adept with T-SQL and be able to perform your day-to-day tasks as software and database developers effectively.

ABOUT THE AUTHOR

Aidil Umarov

I am a person who loves learning and promotes learning opportunities to other people.

Learn more about Aidil

Trusted by 3.1 million developers working at companies

These are high-quality courses. Trust me the price is worth it for the content quality. Educative came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks

Anthony Walker

@_webarchitect_

Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!

Evan Dunbar

ML Engineer

You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it.

Software Developer

Carlos Matias La Borde

I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site

Souvik Kundu

Front-end Developer

Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content.

Vinay Krishnaiah

Software Developer

Course

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

Discover common SQL antipatterns, their pitfalls, and solutions. Gain insights into logical, physical, query, and application antipatterns. Learn about effective, risk-free database practices.

6 h 45 m

beginner

Course

Simple Anomaly Detection using SQL

Gain insights into using SQL for anomaly detection. Delve into applying mean, standard deviation, and z-score to identify and investigate data anomalies, enhancing your analytical skills.

1 h

beginner

Course

MongoDB: The Complete Guide

Gain insights into MongoDB's core concepts, including queries, CRUD operations, aggregation, and more. Discover how to build applications with hands-on experience and interactive widgets.

3 h

intermediate

Course

Introduction to Computers & Programming

Gain insights into basic computer anatomy, binary systems, and program lifecycles. Delve into logic building and core programming concepts with hands-on exercises and quizzes to reinforce learning.

6 h

beginner

Course

Database Design Fundamentals for Software Engineers

Gain insights into fundamental database concepts, relational databases, and entity-relationship diagrams. Learn about normalization techniques and basics of SQL to enhance database efficiency.

8 h

beginner

Course

An Introductory Guide to SQL

Gain insights into SQL by exploring database creation, data manipulation, and advanced queries. Learn about practical applications and practice for SQL interviews to build confidence and readiness.

13 h

beginner

Course

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

beginner

6 hour 45 min

Course

Simple Anomaly Detection using SQL

beginner

1 hour

Course

MongoDB: The Complete Guide