Essential Sql Server Development Tips

Sharpen your SQL Server T-SQL programming skills and learn useful database programming techniques

Last updated 2022-01-10 | 4.6

- How to efficiently perform essential database development tasks in SQL Server
- using a variety of techniques and methodologies
- How to work with unstructured data in SQL Server using all the available techniques
- How to implement specialized development-related tasks in SQL Server

What you'll learn

How to efficiently perform essential database development tasks in SQL Server

using a variety of techniques and methodologies

How to work with unstructured data in SQL Server using all the available techniques

How to implement specialized development-related tasks in SQL Server

Useful tips for easily resolving SQL Server database development issues

* Requirements

* Basic knowledge of the SQL Server fundamentals
* Basic knowledge of SQL Server Management Studio (SSMS)

Description

In this course, via a combination of lectures, downloadable resources and over than 30 live demos/hands-on guides, you will learn many useful SQL Server database programming hands-on tips, that will help you efficiently develop data processes for your SQL Server databases, using T-SQL and a variety of methods and techniques.

Microsoft SQL Server, is one of the world's leading Data Platforms. SQL Server, among other, allows you to easily develop sophisticated data processes via it's feature-rich T-SQL scripting language and its powerful Database Engine.

This course, will help you strengthen your SQL Server database programming skills, and thus enable you to easily implement data processes and mechanisms in SQL Server, using its powerful T-SQL scripting language, along with combining it with efficient database programming methodologies and techniques.

The course begins with introducing what you can do with SQL Server, and then jumps right into a rich set of hands-on tips, for programming in SQL Server using its powerful T-SQL scripting language. Then, we talk about all the available techniques and features, for handling unstructured data via SQL Server's Database Engine. After that, we talk about essential T-SQL tips that can be very helpful for SQL developers, and finally we discuss about how you can implement specialized database development tasks in SQL Server.

This is a hands-on course, with many live guides, that show you step-by-step, how you can develop a variety of data processes in SQL Server.

WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

"An excellent course, matching my needs and expectations"
"A very good, complete course. Understandable, extremely informative, excellent structure! Congratulations!"
"The course provides many useful SQL development tips."
"Clear, informative and helpful presentation."

THE BENEFITS OF THIS COURSE:

By the time you complete this course:

You will know how to efficiently perform different development tasks in SQL Server, using a variety of techniques and methodologies
You will have strengthen your T-SQL coding skills
You will know how to work with unstructured data in SQL Server using all the available techniques
You will know how to perform specialized development-related tasks in SQL Server

MAJOR LEARNING OBJECTIVES:

Throughout the course, I will take you through many important SQL Server development tips and techniques.

First, you will learn many useful tips for programming SQL Server database with T-SQL. After that, we will talk about, how you can work with unstructured data in SQL Server. Then, we will cover other major T-SQL techniques for performing different tasks in SQL Server.

Finally, we’ll go over different special topics, via which you will learn how to implement special SQL Server development tasks.

PREREQUISITES:

Basic knowledge of the SQL Server fundamentals
Basic knowledge of SQL Server Management Studio

THIS COURSE CONTAINS/OFFERS:

4+ hours of high-quality video
More than 30 live demonstrations and hands-on guides that will help you perform many essential SQL Server development tasks
Useful quizzes for testing your knowledge on each section
Many downloadable resources such as T-SQL scripts and links
A practice test in the end of the course
Ability to ask the instructor questions via the Q&A section
Certificate on course completion

Who this course is for:

SQL Developers who want to strengthen their SQL Server database programming skills
SQL Server DBAs and Software Developers who want to learn more about developing in SQL Server
IT Architects who want to learn more about SQL Server database development

Course content

8 sections • 55 lectures

Introduction 7 lectures

Welcome to the Course! What Will You Learn? Preview 04:39

This is the introduction to the course. We will talk about how this course is structured and what will you learn after completing this course.

About SQL Server Preview 02:28

In this lecture, we will go through a list of things you can do, when using SQL Server.

SQL vs T-SQL Preview 02:47

In this lecture, we will compare the SQL vs the T-SQL scripting languages.

How will this Course Help You? Preview 00:52

In this lecture, we will talk about how this course can help you improve your SQL Server development skills.

This Course’s Demo Environment Preview 19:24

In this lecture, we will talk about this course’s demo environment.

Section Recap Preview 01:31

This lecture, is a recap of what you have learned in this introductory section.

Introduction

Test what you've learned in this section, via a short quiz.

Tips for Programming in SQL Server with T-SQL 16 lectures

Section Overview Preview 00:49

This lecture, is an overview of what you will learn in this section.

Sequence Objects in SQL Server Preview 06:21

In this lecture, we will talk about the Sequence objects in SQL Server.

The DATE Data Type in SQL Server Preview 03:28

In this lecture, we will talk about the DATE data type in SQL Server.

The TIME Data Type in SQL Server Preview 03:21

In this lecture, we will talk about the TIME data type in SQL Server.

DATETIME2 vs DATETIME in SQL Server Preview 06:32

In this lecture, we will compare the DATETIME data type in SQL Server with DATETIME2.

The MERGE Statement in SQL Server Preview 12:45

In this lecture, we will talk about the MERGE statement in SQL Server.

Row Constructors in SQL Server Preview 04:59

In this lecture, we will talk about Row Constructors in SQL Server.

The STRING_SPLIT Function in SQL Server Preview 03:11

In this lecture, we will talk about the STRING_SPLIT function in SQL Server.

Built-In JSON Support in SQL Server Preview 04:12

In this lecture, we will talk about the built-in JSON support in SQL Server.

Working with Temporal Tables in SQL Server Preview 10:20

In this lecture, we will talk about how you can use temporal tables in SQL Server.

Table-Valued Parameters (TVPs) in SQL Server Preview 05:16

In this lecture, we will talk about table-valued parameters (TVPs) in SQL Server.

Segmenting Strings in SQL Server Preview 07:19

In this lecture, we will talk about how you can segment strings in SQL Server.

Dynamically Generating T-SQL Statements Preview 08:05

In this lecture, we will talk about how you can generate T-SQL statements in SQL Server.

Searching for Keywords in SQL Server Agent Jobs Preview 08:15

In this lecture, we will talk about how you can search for specific keywords in SQL Server Agent Jobs using T-SQL script.

Section Recap Preview 01:19

This lecture, is a recap of what you have learned in this section.

Tips for Programming in SQL Server with T-SQL

Test what you've learned in this section, via a short quiz.

Working with Unstructured Data 6 lectures

Section Overview Preview 01:04

This lecture, is an overview of what you will learn in this section.

How to Import and Export Unstructured Data Using the VARBINARY Data Type Preview 10:59

In this lecture, you will learn how to import and export unstructured data in SQL Server using the VARBINARY Datatype.

How to Import and Export Unstructured Data in SQL Server Using FILESTREAM Preview 08:33

In this lecture, you will learn how to import and export unstructured data in SQL Server using the FILESTREAM feature.

How to Import and Export Unstructured Data in SQL Server Using FileTables Preview 09:18

In this lecture, you will learn how to import and export unstructured data in SQL Server using the FileTables feature.

Section Recap Preview 01:26

This lecture, is a recap of what you have learned in this section.

Working with Unstructured Data

Test what you've learned in this section, via a short quiz.

Useful T-SQL Tips for SQL Developers 10 lectures

Section Overview Preview 00:58

This lecture, is an overview of what you will learn in this section.

Retrieving Security-Related Info for SQL Server Logins Preview 03:24

In this lecture, you will learn how to retrieve security-related info for SQL Server logins.

Inserting Leading Characters to a String Preview 03:46

In this lecture, you will learn how you can insert leading characters to a string in SQL Server.

Getting all the Records from all Tables in all User Databases Preview 02:56

In this lecture, you will learn how you can retrieve all the records from all tables in all user databases in SQL Server.

Retrieving SQL Server Instance-Related Information Preview 03:28

In this lecture, you will learn how to retrieve SQL Server instance-related information.

Executing T-SQL Statements Against All Databases in SQL Server Preview 05:48

In this lecture, you will learn how you can execute T-SQL statements against all databases, within a SQL Server instance.

How to Create a Simple Linked Server Between SQL Server Instances Preview 05:46

In this lecture, you will learn how to create a simple linked server between SQL Server instances.

Other Useful T-SQL Scripts Preview 11:57

In this lecture, you will learn a variety of useful T-SQL tips.

Section Recap Preview 01:11

This lecture, is a recap of what you have learned in this section.

Useful T-SQL Tips for SQL Developers

Test what you've learned in this section, via a short quiz.

Special SQL Server Development Topics 11 lectures

Section Overview Preview 01:47

This lecture, is an overview of what you will learn in this section.

Where are Programmability Objects Stored in SQL Server? Preview 04:56

In this lecture, you will learn how to find the programmability objects in SQL Server, and retrieve their meta-information.

Executing Heavy Set-Based Operations Against VLDBs in SQL Server Preview 04:51

In this lecture, you will learn how you can execute heavy set-based operations, against very large databases (VLDBs) in SQL Server.

Using the OUTPUT Clause: A simple Data Archiving Example Preview 06:20

In this lecture, you will learn how to build a simple data archiving mechanism, using the OUTPUT clause in SQL Server.

Using Computed Columns in SQL Server Preview 07:31

In this lecture, you will learn how to use computed and persisted columns in SQL Server tables.

Handling NULL and Empty Values in SQL Server Preview 06:06

In this lecture, you will learn how to handle NULL and empty values in SQL Server table records.

The multi-part identifier … could not be bound Preview 04:42

In this lecture, you will learn how to troubleshoot the error message: the multi-part identifier…could not be bound.

Using the “GO” Command in SQL Server Preview 05:23

In this lecture, you will learn how you can use the GO command in SQL Server, in order to separate different T-SQL batches.

How to Suppress the “N Row(s) Affected” Output Message in SQL Server Preview 03:06

In this lecture, you will learn how to suppress the “N Row(s) Affected” Output Message in SQL Server.

Section Recap Preview 01:47

This lecture, is a recap of what you have learned in this section.

Special SQL Server Development Topics

Test what you've learned in this section, via a short quiz.

Putting it All Together 2 lectures

What Have you Learned in this Course? Preview 03:33

This lecture, is a recap on what you have learned in this course.