Topic 3 – Objectives
Topic 3 – Objectives
Beginning SQL Server TSQL Programming
Module 1 - Introduction
Module 1 - Introduction
Module 2 – Navigating SSMS
Module 2 – Navigating SSMS
Module 3 – DML, the Data Manipulation Language
Module 3 – DML, the Data Manipulation Language
Module 4 – DDL, the Data Declaration Language
Module 4 – DDL, the Data Declaration Language
Module 5 – DCL, the Data Control Language
Module 5 – DCL, the Data Control Language
Module 6 – Using JOINS in Queries
Module 6 – Using JOINS in Queries
Module 7 – The ORDER BY clause
Module 7 – The ORDER BY clause
Module 8 – The GROUP BY clause
Module 8 – The GROUP BY clause
Module 9 – Aggregate Functions
Module 9 – Aggregate Functions
Module 10 – UNION and UNION ALL
Module 10 – UNION and UNION ALL
Module 11 – String Functions
Module 11 – String Functions
Module 12 – Date Functions
Module 12 – Date Functions
Module 13 – TSQL Deep Dive
Module 13 – TSQL Deep Dive
Module 14 – Wrap Up
Module 14 – Wrap Up
Lesson Homework Assignments
Lesson Homework Assignments
Lesson Homework Templates
Lesson Homework Templates
Lesson Homework Solutions
Lesson Homework Solutions
Create Databases DDL
Create Databases DDL
Create Database Tables
Create Database Tables
Welcome to the topic section on mastering Microsoft SQL Server programming with T-SQL!
Our primary objective in this course is to equip you with the essential skills needed to become proficient in writing T-SQL queries, creating and managing databases and tables, and loading data efficiently. Throughout this course, you'll delve into the fundamentals of T-SQL programming, starting with the basics of querying data using SELECT statements and gradually progressing to more complex queries involving joins, subqueries, and common table expressions.
In addition to querying data, we'll explore the intricacies of database and server instance security, ensuring you understand how to implement robust security measures to protect your data assets effectively. Furthermore, you'll learn the art of index creation to optimize query performance and improve the efficiency of your database operations. Understanding how to generate query plans will be pivotal in fine-tuning your queries for optimal performance.
Lastly, we'll cover the use of aggregate functions to perform calculations on data sets, providing you with the tools needed to discover valuable information from your data.
By the end of this course, you'll be well-equipped to navigate the world of SQL Server T-SQL programming confidently, with the skills necessary to write efficient queries, manage databases securely, and optimize performance for maximum efficiency. Let's dive in and embark on this learning journey together!