Data Engineering

Database Management Systems

• Intro to Database Management Systems

• Connecting to a database

• ACID Overview
  • Atomicity
  • Consistency
  • Isolation
  • Durability

• Intro to SQL: DDL, DML, DQL

• Data Definiton Language
  • Table Schemas and Constraints
  • The Database Index
• Data Manipulation Language
  • Seeding a Database
  • Conditional Updates
• Data Querying Language
  • Viewing Data
  • Relational Data
  • Aggregation/Analytics/Processing
• Normalization
  • First Form
  • Second Form
  • Third Form

Walkthroughs

• Install MySQL
• Install PostgreSQL
• Install DBeaver
• My First Database
• Exporting and Migrating Data

Troubleshooting

• Access Denied For User Root @ localhost