Learn how to design and plan a database for beginners. This database design course will help you understand database concepts and give you a deeper grasp of database design. Database design is the organisation of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.
This database design course will help you understand database concepts and give you a deeper grasp of database design.
Database design is the organisation of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.
⭐️ Contents ⭐ ⌨️ (0:00:00) Introduction ⌨️ (0:03:12) What is a Database? ⌨️ (0:11:04) What is a Relational Database? ⌨️ (0:23:42) RDBMS ⌨️ (0:37:32) Introduction to SQL ⌨️ (0:44:01) Naming Conventions ⌨️ (0:47:16) What is Database Design? ⌨️ (1:00:26) 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 ⌨️ (2:13:40) Designing One-to-Many Relationships ⌨️ (2:23:50) Parent Tables and Child Tables ⌨️ (2:30:42) Designing Many-to-Many Relationships ⌨️ (2:46:23) Summary of Relationships ⌨️ (2:54:42) Introduction to Keys ⌨️ (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
Writing a SQL Database from scratch in Go, we'll extend gosql to implement the database/sql driver interface. This will allow us to interact with gosql the same way we would interact with any other database.
Introduction to Relational Database and SQL. Learn how to create one of the most efficient ways of storing data - relational databases! Full scale SQL and Relational Database course - How to design a relational database and how to write SQL. It covers all the important SQL statements, including CREATE, INSERT, UPDATE, DELETE, SELECT, ALTER, and DROP, and provide some insight into entity-relationship model design. Entity Relationship Model.
Learn to Build SQL Query| Ultimate SQL and DataBase Concepts
In this SQL tutorial course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.
Getting Started with Microsoft SQL Server on Mac and Windows in 2020. SQL for beginners 2020 - How to install Microsoft SQL Server on Mac and Windows with sample database