Querying Databases Using Transact-SQL
Intermediate
51 Lessons
15h
Certificate of Completion
Takeaway Skills
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.
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
Course Content
Before We Start
T-SQL Basics
Querying Multiple Tables
Grouping and Aggregation
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
How You'll Learn
You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.
Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.
Learn faster and smarter with adaptive AI tools embedded in every Educative course.
Built-in assessments let you test your skills. Completion certificates let you show them off.
Recommended Courses
BEFORE STARTING THIS COURSE
AFTER FINISHING THIS COURSE