syllabus

Course Link: https://www.youtube.com/watch?v=ztHopE5Wnpc

⭐️ Contents ⭐

• ⌨️ (0:00:00) Introduction
• ⌨️ (0:03:12) What is a Database?
• ⌨️ (0:11:04) What-Is-A-Relational-Database
  From What-Is-A-Relational-Database

  Go to text →

  • terms
    • entity: anything we store data about (we store data about a user)
    • attribute: (user's email, phone number, age, etc.)

• ⌨️ (0:23:42) RDBMS
  From RDBMS

  Go to text →

  • RDBMS -> RelationalDatabase Management System
    • can run queries on db tables
    • view mechanim: change surface appearance of data
    • transactions
    • Tools examples:
      • SQL Server
      • MySQL
      • PostgreSQL

• ⌨️ (0:37:32) Introduction to SQL
• ⌨️ (0:44:01) Naming Conventions
• ⌨️ (0:47:16) What-Is-Database-Design
  From What-Is-Database-Design

  Go to text →

  • Data-Integrity:
    • Repeating Data
    • Updated Data
  • Levels of Database Design
    • Conceptual
      • draw it out, decide tables and dependencies
    • Logical
      • structure tables, design schema
    • Physicals
      • Decide tools and implementation

• ⌨️ (1:00:26) Data-Integrity
  From Data-Integrity

  Go to text →

  • Anomalies: Error in data integrity.
  • Entity Integrity
    • uniqueness (ID's)
  • Referential Integrity
    • reference ID from one table in another table
    • foreign key
  • Domain Integrity
    • Each rows values should have validation (column: phone number value: cake should not be allowed because cake is not a 10 digit number)
    • Data types
    • Foreign Key
  • Normalization: Process of insuring Data Integrity

• ⌨️ (1:13:28) Database Terms
• ⌨️ (1:28:28) More Database Terms
• ⌨️ (1:38:46) Atomic Values
• ⌨️ (1:44:25) Relationships
• ⌨️(1:50:35) One-to-One Relationships
• ⌨️ (1:53:45) One-to-Many Relationships
• ⌨️ (1:57:50) Many-to-Many Relationships
• ⌨️ (2:02:24) Designing One-to-One Relationships: stored as attribute or as a reference to another table associated only with that entit y
• ⌨️ (2:13:40) Designing One-to-Many Relationships
• ⌨️ (2:23:50) Parent Tables and Child Tables
• ⌨️ (2:30:42) Designing-Many-ToMany
  From Design-Many-to-Many

  Go to text →

  
  

  create intermediary table with ids of both tables

  
  

  class table

  id	class_name
  5	Math
  9	Art
  2	Science

  
  intermediary table

  id	class_id
  5	5
  2	9
  3	5
  4	2
  1	9

  
  

  student table

  id	student_name
  5	John
  4	Joe
  7	Paul

• ⌨️ (2:46:23) Summary of Relationships
• ⌨️ (2:54:42) Introduction to Keys
  From Introduction-to-Keys

  Go to text →

  • unique
  • never null
  • never changing

• ⌨️ (3:07:24) Primary Key Index
• ⌨️ (3:13:42) Look up Table
• ⌨️ (3:30:19) Superkey and Candidate Key
• ⌨️ (3:48:59) Primary Key and Alternate Key
• ⌨️ (3:56:34) Surrogate Key and Natural Key
• ⌨️ (4:03:43) Should I use Surrogate Keys or Natural Keys?
• ⌨️ (4:13:07) Foreign Key
• ⌨️ (4:25:15) NOT NULL Foreign Key
• ⌨️ (4:38:17) Foreign Key Constraints
• ⌨️ (4:49:50) Simple Key, Composite Key, Compound Key
• ⌨️ (5:01:54) Review and Key Points....HA GET IT? KEY points!
• ⌨️ (5:10:28) Introduction to Entity Relationship Modeling
• ⌨️ (5:17:34) Cardinality
• ⌨️ (5:24:41) Modality
• ⌨️ (5:35:14) Introduction to Database Normalization
• ⌨️ (5:39:48) 1NF (First Normal Form of Database Normalization)
• ⌨️ (5:46:34) 2NF (Second Normal Form of Database Normalization)
• ⌨️ (5:55:00) 3NF (Third Normal Form of Database Normalization)
• ⌨️ (6:01:12) Indexes (Clustered, Nonclustered, Composite Index)
• ⌨️ (6:14:36) Data Types
• ⌨️ (6:25:55) Introduction to Joins
• ⌨️ (6:39:23) Inner Join
• ⌨️ (6:54:48) Inner Join on 3 Tables
• ⌨️ (7:07:41) Inner Join on 3 Tables (Example)
• ⌨️ (7:23:53) Introduction to Outer Joins
• ⌨️ (7:29:46) Right Outer Join
• ⌨️ (7:35:33) JOIN with NOT NULL Columns
• ⌨️ (7:42:40) Outer Join Across 3 Tables
• ⌨️ (7:48:24) Alias
• ⌨️ (7:52:13) Self Join