Complete Guide to T-SQL for Data Analysts (Video)

Description

6.5 Hours of Video Instruction

SQL has long been and will continue to be a foundational language for data analysts and data professionals. Whether you are new to data analysis, or are trying to expand your data skills, this course will provide you with the skills to use immediately, and to build upon as you progress in your career.

In this approachable, business-friendly video, Chris Sorensen helps you build the foundational skills so that you can read, understand, and write SQL that is rooted in best practices from the ground up.

Skill Level

Beginner-Intermediate

Learn How To

• Design a basic relational database using Normalization
• Implement a basic relational database using Data Definition Language (DDL)
• Interact with a relational database using Data Manipulation Language (DML)
• Learn the fundamentals of managing data integrity
• Learn the fundamentals of indexing your system for speed
• Be introduced to next level database concepts to help guide you in choosing next steps on your journey

Who Should Take This Course

• Business users who are curious about SQL but dont know where to start
• Business users that may have started using SQL but want to take a step back to ensure they are building from a solid foundation
• IT users looking for a place to start their data journey

Course Requirements

• Familiarity with the process and challenges of collecting and managing data is useful

Sample Content

Table of Contents

Introduction

Lesson 1: Data Concepts and Technical Setup

Learning objectives

1.1 Introduction to SQL and T-SQL

1.2 Describe Features of Structured Data

1.3 Describe Features of Semi-Structured Data

1.4 Describe Features of Unstructured Data

1.5 Describe Common Data Storage Mechanisms

1.6 Relational Database Concepts

1.7 Describe Features of Transactional Workloads

1.8 Describe Features of Analytical Workloads

1.9 GitHub Repository

1.10 Tool Installation

1.11 Database Setup

1.12 Schema Walkthrough

Lesson 2: Writing Single Table Queries

Learning objectives

2.1 Introduction to Writing SQL

2.2 Basic SQL

2.3 Filtering Result Sets - Basics

2.4 Filtering Result Sets - Handling NULLS

2.5 Filtering Result Sets - Next Level

2.6 Sorting Result Sets

2.7 Single Row Functions

2.8 Aggregate Functions

2.9 End of Lesson Exercise

Lesson 3: Joining Multiple Tables

Learning objectives

3.1 Introduction to Joins

3.2 INNER Joins

3.3 OUTER Joins

3.4 CROSS Joins

3.5 Special Joins

3.6 End of Lesson Exercise

Lesson 4: Writing Subqueries

Learning objectives

4.1 Introduction to Subqueries

4.2 Self-Contained Subqueries

4.3 Correlated Subqueries

4.4 End of Lesson Exercise

Lesson 5: Set Operators

Learning objectives

5.1 Defining and Rules for Using Set Operators

5.2 UNION

5.3 EXCEPT

5.4 INTERSECT

5.5 End of Lesson Exercise

Lesson 6: Manipulate Data in a Database

Learning objectives

6.1 Inserting Data

6.2 Updating Data

6.3 Deleting Data

6.4 Truncating a Table

6.5 End of Lesson Exercise

Lesson 7: Design a Database

Learning objectives

7.1 System Development Life Cycle (SDLC)

7.2 Logical Design

7.3 Normalization

7.4 End of Lesson Exercise

Lesson 8: Build a Database

Learning objectives

8.1 Creating and Managing Tables

8.2 Data Integrity Constraints

8.3 Speeding Data Access Indexing

8.4 Create Interfaces to the Database Using VIEWS

8.5 End of Lesson Exercise

Lesson 9: Manage a Database

Learning objectives

9.1 Controlling User Access

9.2 Transactions

9.3 Metadata

Lesson 10: Exploring the Road Ahead

Learning objectives

10.1 Other T-SQL Constructs - Next Level

10.2 Peek into Azure Databases

Summary

Updates

Submit Errata