Essential SQL Server Development Tips for SQL Developers

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course! What Will You Learn?

Lecture 2: About SQL Server

Lecture 3: SQL vs T-SQL

Lecture 4: How will this Course Help You?

Lecture 5: This Course’s Demo Environment

Lecture 6: Section Recap

Chapter 2: Tips for Programming in SQL Server with T-SQL

Lecture 1: Section Overview

Lecture 2: Sequence Objects in SQL Server

Lecture 3: The DATE Data Type in SQL Server

Lecture 4: The TIME Data Type in SQL Server

Lecture 5: DATETIME2 vs DATETIME in SQL Server

Lecture 6: The MERGE Statement in SQL Server

Lecture 7: Row Constructors in SQL Server

Lecture 8: The STRING_SPLIT Function in SQL Server

Lecture 9: Built-In JSON Support in SQL Server

Lecture 10: Working with Temporal Tables in SQL Server

Lecture 11: Table-Valued Parameters (TVPs) in SQL Server

Lecture 12: Segmenting Strings in SQL Server

Lecture 13: Dynamically Generating T-SQL Statements

Lecture 14: Searching for Keywords in SQL Server Agent Jobs

Lecture 15: Section Recap

Chapter 3: Working with Unstructured Data

Lecture 1: Section Overview

Lecture 2: How to Import and Export Unstructured Data Using the VARBINARY Data Type

Lecture 3: How to Import and Export Unstructured Data in SQL Server Using FILESTREAM

Lecture 4: How to Import and Export Unstructured Data in SQL Server Using FileTables

Lecture 5: Section Recap

Chapter 4: Useful T-SQL Tips for SQL Developers

Lecture 1: Section Overview

Lecture 2: Retrieving Security-Related Info for SQL Server Logins

Lecture 3: Inserting Leading Characters to a String

Lecture 4: Getting all the Records from all Tables in all User Databases

Lecture 5: Retrieving SQL Server Instance-Related Information

Lecture 6: Executing T-SQL Statements Against All Databases in SQL Server

Lecture 7: How to Create a Simple Linked Server Between SQL Server Instances

Lecture 8: Other Useful T-SQL Scripts

Lecture 9: Section Recap

Chapter 5: Special SQL Server Development Topics

Lecture 1: Section Overview

Lecture 2: Where are Programmability Objects Stored in SQL Server?

Lecture 3: Executing Heavy Set-Based Operations Against VLDBs in SQL Server

Lecture 4: Using the OUTPUT Clause: A simple Data Archiving Example

Lecture 5: Using Computed Columns in SQL Server

Lecture 6: Handling NULL and Empty Values in SQL Server

Lecture 7: The multi-part identifier … could not be bound

Lecture 8: Using the “GO” Command in SQL Server

Lecture 9: How to Suppress the “N Row(s) Affected” Output Message in SQL Server

Lecture 10: Section Recap

Chapter 6: Other Special Topics (Updated)

Lecture 1: Section Overview

Lecture 2: The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered

Lecture 3: Benefits of Primary Keys in Database Tables

Lecture 4: Differences Between Batch and Streaming Data

Lecture 5: Benefits of Using Stored Procedures in Databases

Lecture 6: How to Find the Version of a SQL Server Instance

Lecture 7: What are T-SQL Snippets in SSMS?

Lecture 8: Introducing Transparent Data Encryption (TDE) in SQL Server

Lecture 9: How to Retrieve SQL Server's Version Name using T-SQL

Lecture 10: SQL Server Database Backup and Recovery Guide

Chapter 7: Putting it All Together

Lecture 1: What Have you Learned in this Course?

Chapter 8: Learning More

Lecture 1: Bonus Lecture