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 Will I 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 Setup and Installation of PgAdmin and PostgreSQL
7 Installation Notes
1 Introduction
2 Course Curriculum Overview
3 Overview of Databases
4 Course FAQs
5 Time to get your Computer Set-Up
6 Setup and Installation of PgAdmin and PostgreSQL
7 Installation Notes
PostGreSQL Installation (Mac OS)
8 Mac OS X – Quick Note
9 Mac OS Installation
10 Mac Sample Database Download
11 Mac Database Set-up
12 Review of Set-up
8 Mac OS X – Quick Note
9 Mac OS Installation
10 Mac Sample Database Download
11 Mac Database Set-up
12 Review of Set-up
PostGreSQL Installation (Windows)
13 Windows – Quick Note
14 Windows Installation
15 Sample Database Download
16 Windows Command Line Installation Lecture
13 Windows – Quick Note
14 Windows Installation
15 Sample Database Download
16 Windows Command Line Installation Lecture
Databases and Tables
17 Databases and Tables Overview
18 Creating and Restoring a Database
19 Overview of Challenges
20 Challenge Restore a Database
21 Restoring a Table Schema
22 Challenge Restore a Table Schema
23 Review of Section
17 Databases and Tables Overview
18 Creating and Restoring a Database
19 Overview of Challenges
20 Challenge Restore a Database
21 Restoring a Table Schema
22 Challenge Restore a Table Schema
23 Review of Section
SQL Statement Fundamentals
24 SQL Cheat Sheet
25 SQL Statement Fundamentals
26 SELECT Statement
27 Challenge SELECT task.
28 SELECT DISTINCT
29 Challenge SELECT DISTINCT
30 SELECT WHERE
31 Challenge SELECT WHERE
32 COUNT
33 LIMIT
34 ORDER BY
35 Challenge ORDER BY
36 BETWEEN
37 IN
38 LIKE
39 General Challenge 1
24 SQL Cheat Sheet
25 SQL Statement Fundamentals
26 SELECT Statement
27 Challenge SELECT task.
28 SELECT DISTINCT
29 Challenge SELECT DISTINCT
30 SELECT WHERE
31 Challenge SELECT WHERE
32 COUNT
33 LIMIT
34 ORDER BY
35 Challenge ORDER BY
36 BETWEEN
37 IN
38 LIKE
39 General Challenge 1
GROUP BY Statements
40 MIN MAX SUM and AVG
41 GROUP BY
42 ChallengeGROUP BY
43 HAVING
44 Quick Note
45 ChallengeHAVING
40 MIN MAX SUM and AVG
41 GROUP BY
42 ChallengeGROUP BY
43 HAVING
44 Quick Note
45 ChallengeHAVING
Assessment Test 1
46 Overview of Assessment Test 1
47 Assessment Test 1
48 Solutions to Assessment Test 1
46 Overview of Assessment Test 1
47 Assessment Test 1
48 Solutions to Assessment Test 1
JOINS
49 Overview of JOINS
50 AS Statement
51 Overview of Inner Join
52 Examples of Inner Joins
53 Overview of Join types
54 Example of Outer Joins
55 Union
56 Join Challenges
49 Overview of JOINS
50 AS Statement
51 Overview of Inner Join
52 Examples of Inner Joins
53 Overview of Join types
54 Example of Outer Joins
55 Union
56 Join Challenges
Advanced SQL Commands
57 Overview of Advanced SQL Commands
58 Timestamps and Extract
59 Mathematical Functions
60 String Function and Operators
61 SubQuery
62 Self-Join
57 Overview of Advanced SQL Commands
58 Timestamps and Extract
59 Mathematical Functions
60 String Function and Operators
61 SubQuery
62 Self-Join
Assessment Test 2
63 Assessment Test 2 Overview
64 Assessment Test 2
65 Solutions to Assessment Test 2
63 Assessment Test 2 Overview
64 Assessment Test 2
65 Solutions to Assessment Test 2
Creating Databases and Tables
66 Overview of Section
67 Data Types
68 Primary Keys and Foreign Keys
69 Resource for Create Table Code
70 Note on Constraints
71 Create Table
72 Challenge Create Table
73 Challenge Create Table – SOLUTION
74 Insert
75 Update
76 Delete
77 Alter Table
78 Drop Table
79 CHECK Constraint
80 NOT NULL Constraint
81 UNIQUE Constraint
66 Overview of Section
67 Data Types
68 Primary Keys and Foreign Keys
69 Resource for Create Table Code
70 Note on Constraints
71 Create Table
72 Challenge Create Table
73 Challenge Create Table – SOLUTION
74 Insert
75 Update
76 Delete
77 Alter Table
78 Drop Table
79 CHECK Constraint
80 NOT NULL Constraint
81 UNIQUE Constraint
Assessment Test 3
82 Assessment Test 3
83 Solutions to Assessment Test 3
82 Assessment Test 3
83 Solutions to Assessment Test 3
Extra Views
84 Views
84 Views
Extra PostGreSQL with Python
85 Overview of Python and PostgreSQL
86 Psycopg2 Example Usage
87 Psycopg2 Resources
85 Overview of Python and PostgreSQL
86 Psycopg2 Example Usage
87 Psycopg2 Resources
The Complete SQL Bootcamp
English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 8.5 Hours | 1.61 GB
English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 8.5 Hours | 1.61 GB
Download from Turbobit
Download from DepositFiles
Download from Rapidgator
No comments: