Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

The Complete SQL Bootcamp

Video Introducing this tutorial

Course Introduction :
Introduction
Course Curriculum Overview
Overview of Databases
Course FAQs
Time to get your Computer Set-Up!
Setting Up with pgAdmin 4
Installation Notes


PostGreSQL Installation (Mac OS) :
Mac OS X - Quick Note
Mac OS Installation
Mac Sample Database Download
Mac Database Set-up
Review of Set-up


PostGreSQL Installation (Windows) :
Windows - Quick Note
Windows Installation
Sample Database Download
Windows Command Line Installation Lecture


Databases and Tables :
Databases and Tables Overview
Creating and Restoring a Database
Overview of Challenges!
Challenge: Restore a Database!
Restoring a Table Schema
Challenge: Restore a Table Schema!
Review of Section


SQL Statement Fundamentals :
SQL Cheat Sheet
SQL Statement Fundamentals
SELECT Statement
Challenge: SELECT task.
SELECT DISTINCT
Challenge: SELECT DISTINCT
SELECT WHERE
Challenge: SELECT WHERE
COUNT
LIMIT
ORDER BY
Challenge: ORDER BY
BETWEEN
IN
LIKE
General Challenge 1


GROUP BY Statements :
MIN MAX SUM and AVG
GROUP BY
Challenge:GROUP BY
HAVING
Quick Note
Challenge:HAVING


Assessment Test 1 :
Overview of Assessment Test 1
Assessment Test 1
Solutions to Assessment Test 1


JOINS :
Overview of JOINS
AS Statement
Overview of Inner Join
Examples of Inner Joins
Overview of Join types
Example of Outer Joins
Union
Join Challenges


Advanced SQL Commands :
Overview of Advanced SQL Commands
Timestamps and Extract
Mathematical Functions
String Function and Operators
SubQuery
Self-Join


Assessment Test 2 :
Assessment Test 2 Overview
Assessment Test 2
Solutions to Assessment Test 2


Creating Databases and Tables :
Overview of Section
Data Types
Primary Keys and Foreign Keys
Resource for Create Table Code
Note on Constraints
Create Table
Challenge: Create Table
Challenge: Create Table - SOLUTION
Insert
Update
Delete
Alter Table
Drop Table
CHECK Constraint
NOT NULL Constraint
UNIQUE Constraint


Assessment Test 3 :
Assessment Test 3
Solutions to Assessment Test 3


Extra: Views :
Views


Extra: PostGreSQL with Python :
Overview of Python and PostgreSQL
Psycopg2 Example Usage
Psycopg2 Resources


Bonus Offers :
Bonus Offers

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396