SQL Techniques-Lectures
Welcome to Intermediate SQL!
()
Help Us Learn More About You
Syllabus
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
()
SQL Techniques-Assignments
Each Course Uses a Different Database
How Assignments Work
Connecting to Your Database Server
Assessment Philosophy
SQL Techniques-Bonus Materials
Office Hours Hyderabad, India - PyCon
()
Office Hours: Puebla, Mexico
()
Using SQL Techniques-Lectures
Demo Reading and Parsing Files
()
Demonstration: Creating and Loading a Database
()
Demonstration: Loading and Normalizing CSV Data
()
Using SQL Techniques-Bonus
Office Hours - Gingerman Raceway, South Haven, Michigan, USA
()
Office Hours - Haag, Netherlands
()
Text in PostgreSQL-Lectures
Text in Databases
()
Text Function
()
Character Sets
()
Character Sets in Python
()
Inside Hashes
()
Bruce Schneier - Cryptography, Hashing, and NIST
Bruce Schneier - Cryptography, Hashing, and NIST
()
Index Choices and Index Techniques
()
Demonstration: Generating and Scanning Text
()
Text in PostgreSQL-Bonus
Office Hours - New York City
()
Office Hours, Miami, Florida, USA
()
Regular Expressions-Lectures
Regular Expressions
()
Using Regular Expressions
()
Demonstration: Regular Expressions
()
Demonstration: Flat files, Regex, Email
()
Regular Expressions-Wrap Up
Course Wrap Up
()
Post-Course Survey
Regular Expressions-Bonus
Office Hours, Mountain View, California, USA
()