0% completed

All LessonsFree Lessons (5)

Introduction

What to Expect Before the Advent of Databases Disadvantages of File-Based System

Fundamental Concepts

What is a Database?

Database management systems (DBMS)

An Example of a Database

Characteristics of the Database Approach

Benefits of the Database Approach

Data Modeling

Introduction to Data Models Schemas and Instances The Three-Schema Architecture Data Independence Classification of Database Management Systems Quiz!

Entity-Relationship Data Model

Intro to Entity-Relationship Model Entities, Entity Sets and Entity Types Attributes Keys Relationships, Relationship Sets and Relationship Types Degrees of Relationship Types Binary Relationship Type Constraints Attributes of Relationship Types Weak Entity Types Exercise 1 Solution to Exercise 1 Exercise 2 Solution to Exercise 2

The Relational Data Model

Relational Model Concepts Properties of a Table Introduction to Database Keys Integrity Rules and Constraints Relational Database Schemas Common Relational Database Operations Quiz!

Functional Dependencies

Intro to Functional Dependencies Rules of Functional Dependencies Dependency Diagrams Quiz!

Normalization

What Is Normalization?First Normal Form Second Normal Form Third Normal Form Boyce-Codd Normal Form Exercise 1 Solution to Exercise 1 Exercise 2 Solution to Exercise 2 Quiz!

Structured Query Language

Structured Query Language (SQL)SQL Data Types and Operators SQL Constraints CREATE, DROP, and USE Databases CREATE, DROP, and INSERT Table The SELECT Clause The WHERE Clause The AND & OR Clauses Aggregate Functions in SQL ORDER BY & GROUP BY The HAVING Clause Alias Syntax SQL Joins INNER JOIN LEFT JOIN RIGHT JOIN Exercise 1 Solution to Exercise 1 Exercise 2 Solution to Exercise 2 Exercise 3 Solution to Exercise 3 Exercise 4 Solution to Exercise 4

Conclusion

Where to Go from Here

Database Design Fundamentals for Software Engineers/

...

/

Quiz!

Quiz!

This quiz will test your knowledge of the fundamentals of databases.

We'll cover the following...

Technical Quiz

1.

Which of the following is NOT an example of a database?

A.

A Microsoft Excel sheet

B.

A banking database

C.

A website database

D.

None of the above

1 / 5

With this quiz, the chapter comes to an ...