The Complete SQL Bootcamp

The Complete SQL Bootcamp
The Complete SQL Bootcamp
English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 8.5 Hours | 4.02 GB

Become an expert at SQL!

Learn how to use SQL quickly and effectively with this course!

You’ll learn how to read and write complex queries to a database using one of the most in demand skills – PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you’ll learn quickly and receive challenges and tests along the way to improve your understanding!

What you’ll learn

  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and PostgreSQL on their resume
Table of Contents

Course Introduction
1 Introduction
2 Course Curriculum Overview
3 Overview of Databases
4 Course FAQs
5 Time to get your Computer Set-Up!
6 Installing PostGreSQL and PgAdmin with Database Setup
7 Installation Notes

SQL Statement Fundamentals
8 Overview of Challenges!
9 COUNT
10 LIMIT
11 ORDER BY
12 Challenge ORDER BY
13 BETWEEN
14 IN
15 LIKE
16 General Challenge 1
17 SQL Cheat Sheet
18 SQL Statement Fundamentals
19 SELECT Statement
20 Challenge SELECT task.
21 SELECT DISTINCT
22 Challenge SELECT DISTINCT
23 SELECT WHERE
24 Challenge SELECT WHERE

GROUP BY Statements
25 MIN MAX SUM and AVG
26 GROUP BY
27 ChallengeGROUP BY
28 HAVING
29 Quick Note
30 ChallengeHAVING

Assessment Test 1
31 Overview of Assessment Test 1
32 Assessment Test 1
33 Solutions to Assessment Test 1

JOINS
34 Overview of JOINS
35 AS Statement
36 Overview of Inner Join
37 Examples of Inner Joins
38 Overview of Join types
39 Example of Outer Joins
40 Union
41 Join Challenges

Advanced SQL Commands
42 Overview of Advanced SQL Commands
43 Timestamps and Extract
44 Mathematical Functions
45 String Function and Operators
46 SubQuery
47 Self-Join

Assessment Test 2
48 Assessment Test 2 Overview
49 Assessment Test 2
50 Solutions to Assessment Test 2

Creating Databases and Tables
51 Overview of Section
52 Update
53 Delete
54 Alter Table
55 Drop Table
56 CHECK Constraint
57 NOT NULL Constraint
58 UNIQUE Constraint
59 Data Types
60 Primary Keys and Foreign Keys
61 Resource for Create Table Code
62 Note on Constraints
63 Create Table
64 Challenge Create Table
65 Challenge Create Table – SOLUTION
66 Insert

Assessment Test 3
67 Assessment Test 3
68 Solutions to Assessment Test 3

Extra Views
69 Views

Extra PostGreSQL with Python
70 Overview of Python and PostgreSQL
71 Psycopg2 Example Usage
72 Psycopg2 Resources

Databases and Tables
73 Databases and Tables Overview
74 Creating and Restoring a Database
75 Challenge Restore a Database!
76 Restoring a Table Schema
77 Challenge Restore a Table Schema!
78 Review of Section

Command Line Install Lectures (OPTIONAL — FEEL FREE TO SKIP)
79 Mac OS X – Quick Note
80 Mac OS Installation
81 Mac Sample Database Download
82 Mac Database Set-up
83 Review of Set-up
84 Windows – Quick Note
85 Windows Installation
86 Sample Database Download
87 Windows Command Line Installation Lecture

BONUS SECTION THANK YOU!
88 Bonus Lecture