Topic 2 – Who is the Grumpy Old IT Guy?
Topic 2 – Who is the Grumpy Old IT Guy?
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
I’m a published author and data architect with over 30 years of experience in Business Intelligence, Data Architecture, Data Warehousing, and Data Modeling. In the last twenty years, I have also participated in several large-scale master data and data quality initiatives and achieved CIMP certification in master data and data quality to support them. I love the Microsoft BI stack and have been using SQL Server for more years than I care to mention. (Remember SQL Server 2005?) Lastly, I hold a master’s degree in computer science and a bachelor’s degree in electrical engineering, which I earned when Pratt Institute had an engineering program! So, get ready to learn the grumpy way!