EssentialSQL: Data Modeling & Relational Data Architecture

Database Design | Data Model | Data Architecture | Relational Database Design | Database Normalization | Data Modeling

Created by: Kris Wenzel
Let me teach you SQL using simple to understand English.

Created by: Essential Sql
Learn everything you need to use SQL in your next project

What Will I Learn?

• Understand the fundamental concepts of data architecture and principles of data modeling, including entities, attributes, relationships, and keys.
• Understand the various types of data models, including conceptual models, logical models, and physical models.
• Be able to choose the appropriate data model for a given situation.
• Be able to analyze and design a database using the Entity-Relationship (ER) data model.
• Know how to transform a conceptual data model into a logical data model using normalization.
• Understand the principles of data modeling and database design to create a well-designed database.
• Know how to use data modeling tools, such as ER (Entity Relationship) diagrams and data modeling software, to create and document data models.
• Be able to communicate effectively about data modeling concepts and designs with both technical and non-technical audiences.

Requirements

• No programming experience is needed.
• No prior knowledge of MySQL, SQLServer, PostgreSQL or Oracle is required!
• Appreciate basic database concepts such as knowing about columns, rows, and tables.
• Interest in a class hyper-focused on database design and data architecture -- nothing else!

Target audience

• Students baffled by their professor's database normalization explanations
• DBAs seeking common sense definitions of database normal forms.
• Anyone studying MySQL, Oracle, or SQL Server wanting to become a better database designer.
• People preparing for SQL related job interviews.
• Anyone looking to take a class whose singular purpose is to teach you database design.
• Anyone who doesn't have time to weed through dense textbooks trying to sort out academic explanations.