educative.io

Database Design Fundamentals for Software Engineers (Educative)


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/courses/database-design-fundamentals/xVoNoMx13DB). Introduction - What to Expect Who is this course for and what are the learning outcomes? View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/3jzk9KoNBjQ). Fundamental Concepts - Database management systems (DBMS) This lesson introduces DBMS and its functionality. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/xVLnLRr7m6B). 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/courses/database-design-fundamentals/qAVEP0VW0E2). 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/courses/database-design-fundamentals/39PnDMR5pXO). Normalization - Exercise 1 This exercise will test your knowledge of 2NF. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/xoYMyj8Er0l). Normalization - Solution to Exercise 2 In this lesson we will discuss the solution to exercise 2. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/N8J5k6Z2DNv). 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/courses/database-design-fundamentals/Y5Nogx2OBL2). 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/courses/database-design-fundamentals/qVgJjxVjDOD). 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/courses/database-design-fundamentals/xoYjP6Mn233). 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/courses/database-design-fundamentals/g2mKng46JwG). 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/courses/database-design-fundamentals/7AJK026234B). 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/courses/database-design-fundamentals/YM9xG6MjPnp). 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/courses/database-design-fundamentals/N8xG2l27lAz). 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/courses/database-design-fundamentals/3Y8rWOZL91p). Entity-Relationship Data Model - Solution to Exercise 1 Solution to exercise 1. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/YQqDKG0Dxy9). 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/courses/database-design-fundamentals/mym0NlAmyKp). Entity-Relationship Data Model - Solution to Exercise 2 Solution to exercise 2. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/YQvLwAnE0JM). 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/courses/database-design-fundamentals/qV3kk2pzXDR). 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/courses/database-design-fundamentals/3wMgrpLOWrA). Structured Query Language - Structured Query Language (SQL) This lesson introduces users to SQL. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/xooMWR9n7or). 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/courses/database-design-fundamentals/YVxG3XGJW50). 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/courses/database-design-fundamentals/q2KMvow56lG). 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/courses/database-design-fundamentals/YMvXkozK1Op). 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/courses/database-design-fundamentals/3YN4YEkz16p). 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/courses/database-design-fundamentals/NEAykQNLJl8). 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/courses/database-design-fundamentals/7DMRyNzoJvB). Structured Query Language - INNER JOIN In this lesson, we will study the INNER JOIN in SQL. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/7nG23Wr0PO8). Structured Query Language - LEFT JOIN In this lesson, we will discuss the LEFT JOIN keyword. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/my6ZGoDpQVG). Structured Query Language - Exercise 1 This first exercise will test your knowledge of aggregate functions. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/39rLlRP3YAA). Structured Query Language - Solution to Exercise 2 Solution to exercise 2. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/qVojMn274v7). 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/courses/database-design-fundamentals/mEkJ84Y2DnR). Structured Query Language - Exercise 4 This exercise will test your knowledge of aggregate functions. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/x1poogjp5Gl). Structured Query Language - Solution to Exercise 4 Solution to exercise 4. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/JY6kD0OymZ9). Conclusion - Where to Go from Here In this lesson, we will conclude our course. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/g28KRY05GJG). 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/courses/database-design-fundamentals/g7MgVJPGRLj). 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/courses/database-design-fundamentals/gx2GRZOq31j). 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/courses/database-design-fundamentals/R89K2z86QLK). 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/courses/database-design-fundamentals/YQn6wwoZn7O). Data Modeling - Quiz! This quiz will test your knowledge of data models. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/g7GBGWpLj4Z). 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/courses/database-design-fundamentals/myBA0zVyl1E). 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/courses/database-design-fundamentals/g2gpq3MZBkY). 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/courses/database-design-fundamentals/gxN1XONDovG). The Relational Data Model - Quiz! This quiz will test your knowledge of relational databases. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/q2kW88xLK7R). Structured Query Language - RIGHT JOIN In this lesson, we will discuss the RIGHT JOIN keyword. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/qAK24LVgmkR). Structured Query Language - Exercise 2 This first exercise will test your knowledge of JOINS. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/m7MP38JyqkO). 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/courses/database-design-fundamentals/R8VjPrRyDwK). 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/courses/database-design-fundamentals/m27EEZ263n0). 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/courses/database-design-fundamentals/YVpn127GXAp). 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/courses/database-design-fundamentals/gx3vnK4gjM9). 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/courses/database-design-fundamentals/YMMqA6EwnoA). 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/courses/database-design-fundamentals/JYmr9nPNxoK). 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/courses/database-design-fundamentals/YMBoGRW4opY). 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/courses/database-design-fundamentals/gxVwrP9jo9Y). 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/courses/database-design-fundamentals/3j4E1VLRlW9). Normalization - Solution to Exercise 1 In this lesson we will discuss the solution to exercise 1. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/YMN6GkzNlOK). Normalization - Quiz! This quiz will test your knowledge of normalization and the different normal forms. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/qAoxD10N45k). 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/courses/database-design-fundamentals/qZr2O72L9gG). Structured Query Language - The HAVING Clause In this lesson, we will learn about the HAVING clause. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/39K3ALxX589). Structured Query Language - Solution to Exercise 3 Solution to exercise 3. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/3j6qVNl5BRr). 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/courses/database-design-fundamentals/B6VQBZ6NnnW). Fundamental Concepts - Quiz! This quiz will test your knowledge of the fundamentals of databases. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/3joP5BGQ0mQ). 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/courses/database-design-fundamentals/m790A9r5YVp). 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/courses/database-design-fundamentals/BnwlyN5AJv2). Functional Dependencies - Quiz! Quiz on functional dependencies. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/R1NGoZonOAV). Normalization - Exercise 2 This exercise will test your knowledge of 3NF. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/gxY6PvkZA6Y). 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/courses/database-design-fundamentals/mEkDEVgRk5p). 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/courses/database-design-fundamentals/m7JnY9Xm6Qp). Structured Query Language - Solution to Exercise 1 Solution to exercise 1. View the lesson [here](https://www.educative.io/courses/database-design-fundamentals/x1rk2vP4Z0P). 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/courses/database-design-fundamentals/399koKmNENn). 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/courses/database-design-fundamentals/qVBkXw7kGw0). 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/courses/database-design-fundamentals/YMZZY1v5KGn). 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/courses/database-design-fundamentals/JP5xw4DoMrP). 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/courses/database-design-fundamentals/g2vzEBGNMxG).
About the Database Design Fundamentals for Software Engineers (Educative) category [Database Design Fundamentals for Software Engineers (Educative)] (1)