Top Database Bundle: MySQL, PostgreSQL, SQLite3, SQL Server

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: First Things First: How To Get Support Fast!

Chapter 2: Using MySQL Databases With Python

Lecture 1: Introduction

Lecture 2: What Is A Database

Lecture 3: Install Python

Lecture 4: Install Git Bash Terminal

Lecture 5: Download MySQL

Lecture 6: Install MySQL and Workbench

Lecture 7: Install MySQL Connector

Lecture 8: Connect to Database in Python

Lecture 9: Explore MySQL Workbench

Lecture 10: Create A Database

Lecture 11: Create A Table

Lecture 12: Insert One Record Into Table

Lecture 13: Insert Many Records Into Table

Lecture 14: Understanding Data Types

Lecture 15: Select Data From Table

Lecture 16: Format Our Results

Lecture 17: The Where Clause

Lecture 18: The Like Clause and Wildcards

Lecture 19: Using AND and OR

Lecture 20: Updating Records

Lecture 21: Limit and Ordering

Lecture 22: Delete Records

Lecture 23: Delete (Drop) A Table And Backups

Chapter 3: Intro To PostgreSQL Databases With PgAdmin For Beginners

Lecture 1: Introduction

Lecture 2: Installing pgAdmin and PostgreSQL

Lecture 3: What Is A Database

Lecture 4: pgAdmin Overview

Lecture 5: Create Table Columns

Lecture 6: Add Data To A Table

Lecture 7: PostgreSQL Select Statements

Lecture 8: PostgreSQL Where Clause

Lecture 9: PostgreSQL Wildcards

Lecture 10: PostgreSQL AND OR NOT

Lecture 11: PostgreSQL Order By

Lecture 12: PostgreSQL Insert Into

Lecture 13: PostgreSQL Update

Lecture 14: PostgreSQL Delete

Lecture 15: PostgreSQL Limit

Lecture 16: pgAdmin Menu Walkthru

Lecture 17: PostgreSQL Foreign Keys

Lecture 18: PostgreSQL Inner Join

Lecture 19: PostgreSQL Join Where Hack

Lecture 20: PostgreSQL Delete Table

Lecture 21: PostgreSQL Import and Export Tables

Lecture 22: PostgreSQL Backup and Restore Database

Chapter 4: Intro To SQLite Databases for Python Programming

Lecture 1: Introduction

Lecture 2: Install Python

Lecture 3: Install Sublime Text And Git Bash Terminal

Lecture 4: Create SQLite Connection

Lecture 5: Create A Database Table

Lecture 6: Insert One Record Into The Table

Lecture 7: Insert Many Records Into The Table

Lecture 8: Query and Fetchall

Lecture 9: Format Results

Lecture 10: Primary Key ID

Lecture 11: Where Clause

Lecture 12: Update Records

Lecture 13: Delete Records

Lecture 14: Order Results By

Lecture 15: And / Or

Lecture 16: Limiting Results

Lecture 17: Drop Table

Lecture 18: Our App – Show All Function

Lecture 19: Our App – Add A Record Function

Lecture 20: Our App – Delete a Record Function

Lecture 21: Our App – Add Many Records Function

Lecture 22: Our App – Where Clause Function

Chapter 5: Learn SQL With Microsoft SQL Server

Lecture 1: Introduction

Lecture 2: Database Concepts

Lecture 3: Data Types

Lecture 4: Download and Install SQL Server

Lecture 5: SQL Server Download Update

Lecture 6: Download and Install SSMS

Lecture 7: Connect To Server

Lecture 8: System Databases

Lecture 9: Creating a Database and Table

Lecture 10: Adding Data To A Table

Lecture 11: Intro To SQL

Lecture 12: Select Statements

Lecture 13: Where Clause

Lecture 14: And or Not

Lecture 15: Order By

Lecture 16: Group By

Lecture 17: The Having Clause

Lecture 18: The Top Clause

Lecture 19: Select Distinct

Lecture 20: Union

Lecture 21: Functions

Lecture 22: Insert Statement

Lecture 23: Update Statement

Lecture 24: Delete Statement

Lecture 25: Alter Table

Lecture 26: Null