[TMP - Data Engineering] | Session #01 - Introduction to Database and SQL

Start your Data Engineering journey here!

This is Session 01: Introduction to DB and SQL , part of the Technical Mentorship Program (TMP) by the Microsoft Student Club - KFS.

Join mentor Mennah Elsheikh as she covers the absolute fundamentals for any data career:
- File-Based Systems vs. Databases: Why We Use Databases.
- The Database Life Cycle: The 4 stages of database design and implementation.
- Entity-Relationship Modeling (ERD): How to design a database blueprint using entities, attributes, and relationships.
- ERD to Relational Mapping: Learn the essential rules for converting your ERD design into actual database tables.
- Hands-on T-SQL: with basic queries and creating an actual database.

This is the perfect starting point for beginners. Join us for more!

Timeline:
0:00:00 Introduction & Course Overview
0:00:24 What's data?
0:04:00 File-Based Systems
0:05:00 Problems with File-Based Systems
0:09:02 Database Approach & Advantages
0:12:47 Why DB for Data Engineering?
0:13:36 Database Life Cycle
0:16:36 ERD Concepts
0:17:48 Keys & Relationships
0:34:42 Case Study: Hospital Database (ERD Example)
0:51:47 Mapping from ERD to Relational Model
0:55:48 Mapping of regular entities
1:05:12 Mapping of weak entities
1:06:00 Mapping relationships
1:33:10 Hands-On T-SQL (Basic Queries)
2:03:33 Creating DB using T-SQL

#DataEngineering #SQL #Databases #DatabaseDesign #ERD #MicrosoftStudentClub

Видео [TMP - Data Engineering] | Session #01 - Introduction to Database and SQL канала Microsoft Student Club - KFS