The Complete SQL Bootcamp

The Complete SQL Bootcamp
The Complete SQL Bootcamp

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 8.5 Hours | 1.61 GB
eLearning | Skill level: All Levels


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

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

PostGreSQL Installation (Windows)
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

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

GROUP BY Statements
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

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

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

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

Assessment Test 3
82 Assessment Test 3
83 Solutions to Assessment Test 3

Extra Views
84 Views

Extra PostGreSQL with Python
85 Overview of Python and PostgreSQL
86 Psycopg2 Example Usage
87 Psycopg2 Resources


Download from Turbobit

Download from DepositFiles

Download from Rapidgator