Mastering Data Science with SQL: Querying for Data

Mastering Data Science with SQL: Querying for Data

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 0h 52m | 315 MB

In SQL, queries are the means for extracting information from data. Learn how to query a data source, filter and sort the results, optimize performance with indexes, employ inner and outer joins, and more in this demo-laden session from SQL guru Eric Greene.

Table of Contents

00:00:00 Introduction
00:01:23 Overview of Queries
00:02:57 Choosing Entity Attributes
00:05:33 Choosing Columns and Using Aliases (Demo)
00:08:19 Filtering and Sorting Results
00:10:31 Using Where and Order By (Demo)
00:14:52 Optimizing Queries with Indexes
00:20:33 Creating and Using Indexes (Demo)
00:27:54 Connecting Related Entities
00:33:55 Using Inner and Outer Joins (Demo)
00:42:20 Combining Queries
00:43:40 Union Queries (Demo)
00:46:05 Aggregating Data
00:47:49 Using Aggregation Functions (Demo)
00:52:08 Conclusion