educative.io

Database Design Fundamentals for Software Engineers (Educative)


Introduction - What to Expect Who is this course for and what are the learning outcomes? View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6109440912654336). Introduction - Before the Advent of Databases In this lesson we will discuss the history of databases and the system used before its inception. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6316263049527296). Introduction - Disadvantages of File-Based System We will highlight the issues that arise when we use a file-based system and how databases are the solution. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5709722667712512). Fundamental Concepts - Database management systems (DBMS) This lesson introduces DBMS and its functionality. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5761156578803712). Data Modeling - The Three-Schema Architecture In this lesson, we will define the three levels of data abstraction. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5992350910251008). Entity-Relationship Data Model - Entities, Entity Sets and Entity Types In this lesson, we will discuss the first component of an ER diagram: entities. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6110034155012096). Data Modeling - Data Independence In this lesson, we will look at one of the results of the three-schema architecture. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4649892578328576). Functional Dependencies - Quiz! Quiz on functional dependencies. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4771635078889472). Entity-Relationship Data Model - Intro to Entity-Relationship Model This lesson introduces the concept of entity-relationship model. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6734179473555456). Entity-Relationship Data Model - Attributes In this lesson, we discuss the different types of attributes present in an ER diagram. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4824336793862144). Entity-Relationship Data Model - Keys In this lesson, we discuss the basics of keys and how they are represented using ER diagrams. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5165127659683840). Entity-Relationship Data Model - Relationships, Relationship Sets and Relationship Types In this lesson, we will study the basics of relationships between entities. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6523778555183104). Entity-Relationship Data Model - Degrees of Relationship Types In this lesson, we will learn about the different degrees of relationship types. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5189344455294976). Entity-Relationship Data Model - Binary Relationship Type Constraints In this lesson, we will look at the two major constraints on binary relationship types. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5288118905208832). Entity-Relationship Data Model - Attributes of Relationship Types In this lesson, we will take a look at relationships with attributes. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5430174411653120). Entity-Relationship Data Model - Weak Entity Types In this lesson, we will look at the last component of our ER model. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4978650355073024). Entity-Relationship Data Model - Exercise 1 In this exercise, you will design the ER diagram for the UNIVERSITY database. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6608022384148480). Entity-Relationship Data Model - Solution to Exercise 1 Solution to exercise 1. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5767991323000832). Entity-Relationship Data Model - Exercise 2 In this exercise, you will design the ER model for flight database. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4711372191432704). Entity-Relationship Data Model - Solution to Exercise 2 Solution to exercise 2. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5615020173950976). The Relational Data Model - Introduction to Database Keys In this lesson, we will highlight some of keys that are present in databases. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6020477912875008). The Relational Data Model - Relational Database Schemas In this lesson, we will discuss the basic concepts behind relational database schemas. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5263191787438080). Normalization - What Is Normalization? In this lesson, we will learn about the different normalization forms and why we use the normalization technique. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5195669063073792). Normalization - Boyce-Codd Normal Form In this lesson, we will learn about Boyce-Codd normal form with the help of an example. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4841328959553536). Normalization - Exercise 1 This exercise will test your knowledge of 2NF. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6738803333005312). Normalization - Solution to Exercise 2 In this lesson we will discuss the solution to exercise 2. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5383993077792768). Structured Query Language - Structured Query Language (SQL) This lesson introduces users to SQL. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6331466520723456). Structured Query Language - SQL Constraints In this lesson, we will take a look at the different constraints enforced on columns and tables. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6665291108974592). Structured Query Language - CREATE, DROP, and USE Databases In this lesson, we will look at the syntax for creating and deleting a database. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6388567808933888). Structured Query Language - CREATE, DROP, and INSERT Table In this lesson, we will take a look at three commands regarding relations/tables. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6444879158706176). Structured Query Language - The SELECT Clause In this lesson, we will take a look at the SELECT statement. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5468513470775296). Structured Query Language - TheWHERE Clause In this lesson, we will learn how to use the WHERE clause in SQL to view specific data from table. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4992220555902976). Structured Query Language - Aggregate Functions in SQL In this lesson, we will learn about the different aggregate functions available in SQL. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6629559296327680). Structured Query Language - Alias Syntax In this lesson, we will learn about assigning aliases to tables and columns. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5977533650567168). Structured Query Language - ORDER BY & GROUP BY In this lesson, we will learn about the ORDER BY and GROUP BY clauses. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6430059072061440). Structured Query Language - INNER JOIN In this lesson, we will study the INNER JOIN in SQL. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6019673000771584). Structured Query Language - LEFT JOIN In this lesson, we will discuss the LEFT JOIN keyword. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4580132838703104). Structured Query Language - Exercise 1 This first exercise will test your knowledge of aggregate functions. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5180935613972480). Structured Query Language - Solution to Exercise 2 Solution to exercise 2. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5802638555742208). Structured Query Language - Exercise 3 This exercise will test your knowledge of GROUP BY and ORDER BY. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5194749101211648). Structured Query Language - Exercise 4 This exercise will test your knowledge of aggregate functions. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4863955887456256). Structured Query Language - Solution to Exercise 4 Solution to exercise 4. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5585132972933120). Conclusion - Where to Go from Here In this lesson, we will conclude our course. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4515502640594944). Data Modeling - Introduction to Data Models We will look at the meaning behind data models and the different types of models. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5668096180224000). Data Modeling - Schemas and Instances The schema and instance are the essential terms related to databases. In this lesson, we will discuss the key differences between the two. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6664283779760128). Data Modeling - Classification of Database Management Systems This lesson describes the different metrics by which we can classify DBMS. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5844900119576576). Data Modeling - Quiz! This quiz will test your knowledge of data models. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6475741803839488). The Relational Data Model - Relational Model Concepts In this lesson, we will discuss the fundamentals of relational databases. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5478641104322560). The Relational Data Model - Properties of a Table In this lesson, we will outline some of the characteristics of relations (tables). View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4792234639622144). The Relational Data Model - Common Relational Database Operations In this lesson, we will look at some of the different operations that can be performed on relational databases. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4915721618325504). The Relational Data Model - Integrity Rules and Constraints In this lesson, we will discuss the different types of constraints present on relational databases. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5885999802482688). The Relational Data Model - Quiz! This quiz will test your knowledge of relational databases. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5290225351786496). Structured Query Language - RIGHT JOIN In this lesson, we will discuss the RIGHT JOIN keyword. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6703769670647808). Structured Query Language - Exercise 2 This first exercise will test your knowledge of JOINS. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6342688162971648). Fundamental Concepts - What is a Database? In this lesson we will discuss the basics of databases and their properties. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4864528938434560). Fundamental Concepts - An Example of a Database In this lesson we will take a look at a simple university database. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6522892474908672). Fundamental Concepts - Characteristics of the Database Approach In this lesson we will discuss the characteristics of a database. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4913859389292544). Fundamental Concepts - Benefits of the Database Approach In this lesson we will discuss the advantages of the database approach. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5706191265071104). Fundamental Concepts - Quiz! This quiz will test your knowledge of the fundamentals of databases. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6160392688500736). Functional Dependencies - Intro to Functional Dependencies In this lesson, we will discuss the basic concepts of functional dependencies. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6025776719724544). Functional Dependencies - Rules of Functional Dependencies In this lesson, we will take a look at the different rules of FDs. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6187879053131776). Functional Dependencies - Dependency Diagrams In this lesson, we will look at the diagrammatic representation of functional dependencies. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5062033907122176). Normalization - First Normal Form In this lesson, we will take a look at first normal form with some examples. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6033890516926464). Normalization - Second Normal Form In this lesson, we will discuss how to decompose a table into second normal form and see some examples. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5225862850936832). Normalization - Third Normal Form In this lesson, we will discuss the concept behind 3NF using an example. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5842119891615744). Normalization - Solution to Exercise 1 In this lesson we will discuss the solution to exercise 1. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5254920720613376). Structured Query Language - The AND & OR Clauses In this lesson, we will discuss how can we combine multiple conditions in WHERE using the AND & OR operators. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6129185808449536). Normalization - Exercise 2 This exercise will test your knowledge of 3NF. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5567087063859200). Normalization - Quiz! This quiz will test your knowledge of normalization and the different normal forms. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/6420449770602496). Structured Query Language - SQL Data Types and Operators In this lesson, we will learn about the different data types supported by SQL. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4610655258673152). Structured Query Language - The HAVING Clause In this lesson, we will learn about the HAVING clause. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5105170964807680). Structured Query Language - SQL Joins In this lesson, we will highlight the different types of joins in SQL. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5070119015284736). Structured Query Language - Solution to Exercise 3 Solution to exercise 3. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/5641745607950336). Structured Query Language - Solution to Exercise 1 Solution to exercise 1. View the lesson [here](https://www.educative.io/collection/page/10370001/5119687241236480/4664373706489856).
About the Database Design Fundamentals for Software Engineers (Educative) category [Database Design Fundamentals for Software Engineers (Educative)] (1)