Description: overview videos for each section below - MOV format.

• Bio
• Bio snippets - brief descriptions of projects - areas of research
• How to learn
• Learning advice
• Data - Why do we care?
• Data - titles and titles, oh, my!
• What is data engineering?
• Data Engineering - the full beast
• Types of databases
• Volume, variety, velocity

Description: overview videos for each section below - MOV format.

• Intro
• Installation
• Modeling
• Physical Implementation
• Selecting Data
• Clients
• Analysis
• Project

Description: Installation of MySQL Server and Workbench.

Description: The conceptual and logical design of relational database systems.

Description: The physical design of the data model.

Description: Database design homework

Description: Selecting data from the database. Solution to exercises in PPT deck, green slides. RegEx samples. SQL Script.

Description: Data analysis in SQL. Sakila diagrams. Bad Sakila Schema. Bad Sakila Data. Date & Time code.

Description: Data analysis in SQL. Education installation script.

Course project. The dataset used in the project is the Monthly Retail Trade Survey (MRTS).

Description: Variables, Strings, Integers, Floats, Complex, Boolean -Types, printing types -Comparison Operators -Slicing Strings -Casting Variables -Variable Naming Conventions -Booleans and Comparisons -Conditional (if, elif, else) -Python Blocks -Python Functions -Variable Scope, Global and Local -Function Arguments and Return Values

Description: Lists, Dictionaries, Tuples, Sets, Literals, Loops (for and while), Slicing Lists a[ start : end : step ], append and pop, sort, reverse, index, tuples as keys, looping over a dictionary, adding to set

Description: Collections, Pass by Value, Pass by Reference