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 Quiz!

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

Relationships, Relationship Sets and Relationship Types

Degrees of Relationship Types

Binary Relationship Type Constraints

Attributes of Relationship Types

Weak Entity Types

Solution to Exercise 1

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

Solution to Exercise 1

Solution to Exercise 2

Solution to Exercise 3

Solution to Exercise 4

Conclusion

Where to Go from Here

Database Design Fundamentals for Software Engineers/

...

/

Exercise 2

Exercise 2

This first exercise will test your knowledge of JOINS.

We'll cover the following...

Problem statement

Write a SQL query to fetch employee names having a salary greater than or equal to $40,000 and less than or equal $60,000.

Input

The following tables are available to you as inputs:

EMPLOYEE Table

Em

...

SALARY Table

Emp_

...