Querying Data with SQL Server

Focused View

1:56:25

18 View

1. Course Overview

1. Course Overview.mp4

01:46

2. Selecting Data

1. Overview.mp4

03:53

2. Sample Database.mp4

04:19

3. SQL Terminology.mp4

06:09

4. Demo - Selecting Data.mp4

03:51

5. Demo - Filtering Data.mp4

04:12

3. Aggregating Data

1. Aggregate Functions.mp4

03:17

2. Grouping Data.mp4

04:37

3. Filtering Groups of Data.mp4

03:11

4. Ordering Data.mp4

04:46

5. Summary.mp4

01:12

4. Joining Data

1. Overview.mp4

02:41

2. Cross Joins.mp4

02:25

3. Inner Joins.mp4

01:54

4. Demo - Inner Joins.mp4

03:33

5. Outer Joins.mp4

03:26

6. Self Joins.mp4

02:35

5. Cleaning Data

1. Text Manipulation Functions.mp4

03:27

2. Demo - Text Manipulation Functions.mp4

04:32

3. Data Types.mp4

02:59

4. Working with NULLs.mp4

05:22

6. Using Subqueries and CTEs

1. Subqueries.mp4

02:03

2. Demo - Subqueries.mp4

03:28

3. Common Table Expressions.mp4

04:47

4. Pivoting and Unpivoting Data.mp4

02:05

5. Demo - Pivoting and Unpivoting Data.mp4

03:16

7. Working with Window Functions

1. Window Functions.mp4

03:47

2. The OVER Clause.mp4

02:36

3. Ranking Window Functions.mp4

02:37

4. Demo - ROW NUMBER().mp4

02:59

5. Demo - RANK() and DENSE RANK().mp4

03:40

6. Demo - NTILE().mp4

01:29

7. Window Aggregate Functions.mp4

01:43

8. Demo - Window Aggregate Functions.mp4

03:57

9. Offset Window Functions.mp4

03:51

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.