SQL Mastery: From Zero to Superstar

SQL Mastery: From Zero to Superstar

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3.5 Hours | 559 MB

Learn to talk to databases.

Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.

I want to teach you how to start talking to databases through SQL, the universal language of SQL databases. We will walk through

  • Basic selection statements
  • Joining multiple tables together
  • Grouping records to get aggregate data
  • Inserting, updating and deleting records
  • Creating tables and indexes

What Will I Learn?

  • Query databases and answer business question
  • Perform joins across multiple tables
  • Use Group By to generate aggregate data
Table of Contents

Introduction
1 Introduction

Installing PostgreSQL and pgAdmin
2 Installing PostgreSQL
3 Install Northwind Database

Simple Selection of All Records
4 Selecting All Data From a Table
5 Selecting Specific Fields
6 Selecting Distinct Values
7 Counting Results
8 Combining Fields in SELECT

Using WHERE to Select Records
9 WHERE Selection for Text Fields
10 WHERE Selection for Numeric Fields
11 WHERE with Date Fields
12 WHERE Using Logical AND Operator
13 WHERE Using Logical OR Operator
14 WHERE Using Logical NOT Operator
15 WHERE Combining AND OR and NOT
16 Using BETWEEN
17 Using IN

Intermediate SELECT Statements
18 ORDER BY
19 Using MIN and MAX Functions
20 Using AVG and SUM
21 LIKE to Match Patterns
22 Renaming Columns With Alias
23 LIMIT to Control Number of Records Returned
24 NULL Values

Joining multiple tables together
25 Diagramming Table Relationships
26 Inner Join for Two Tables
27 Inner Join for Multiple Tables
28 Left Joins
29 Right Joins
30 Full Joins
31 Self Joins

Group By and Unions
32 Group By
33 Use HAVING to Filter Groups
34 Union

Subqueries
35 Subquery Using EXISTS
36 Subquery Using ANY and ALL
37 IN Using Subquery

Modifying Data In Tables INSERT UPDATE and DELETE
38 INSERT INTO
39 UPDATE
40 DELETE
41 SELECT INTO
42 INSERT INTO SELECT

Modifying Databases Tables and Indexes
43 CREATE DATABASE
44 DROP DATABASE
45 CREATE TABLE
46 ALTER TABLE – Part One
47 ALTER TABLE – Part Two
48 ALTER TABLE – Part Three
49 CREATE INDEX
50 DROP INDEX
51 DROP TABLE

Table Constraints
52 NOT NULL Constraint
53 UNIQUE Constraint
54 PRIMARY KEY Constraint
55 FOREIGN KEY Constraint
56 CHECK Constraint
57 DEFAULT Constraint

Thanks and Good Luck
58 Thank You