Course Highlights
  • Utilize SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files.
  • Appropriately handle text and dates in databases and create stored procedures.
  • Identify hashtag algorithm and their attributes.
  • Construct regular expressions to select rows that match a pattern.
Curriculum

26 Topics
Welcome to Intermediate SQL!
Altering Table Schema
Dates
DISTINCT / GROUP BY
Demonstration: SELECT DISTINCT
Demonstration: GROUP BY
Subqueries
Demonstration: Subqueries
Concurrency and Transactions
Demonstration: Concurrency and Transactions
Stored Procedures
Demonstration: Stored Procedures
Office Hours Hyderabad India - PyCon
Office Hours: Puebla Mexico
Help Us Learn More About You
Syllabus
Each Course Uses a Different Database
How Assignments Work
Connecting to Your Database Server
Assessment Philosophy
Intermediate SQL
Initial Database Setup
Making our First Tables
Alter Table
SELECT DISTINCT
Creating a Stored Procedure

8 Topics
Demo Reading and Parsing Files
Demonstration: Creating and Loading a Database
Demonstration: Loading and Normalizing CSV Data
Office Hours - Gingerman Raceway South Haven Michigan USA
Office Hours - Haag Netherlands
Musical Tracks Many-to-One
Unesco Heritage Sites Many-to-One
Musical Track Database plus Artists

14 Topics
Text in Databases
Text Function
Character Sets
Character Sets in Python
Inside Hashes
Bruce Schneier - Cryptography Hashing and NIST
Index Choices and Index Techniques
Demonstration: Generating and Scanning Text
Office Hours - New York City
Office Hours Miami Florida USA
Bruce Schneier - Cryptography Hashing and NIST
Text and PostgreSQL
A Hash-based Puzzle
Generating Text

9 Topics
Regular Expressions
Using Regular Expressions
Demonstration: Regular Expressions
Demonstration: Flat files Regex Email
Course Wrap Up
Office Hours Mountain View California USA
Post-Course Survey
Regular Expressions
Regular Expression Queries

  Write a Review

Intermediate PostgreSQL

Go to Free Course