Share Description
In this course, you will :
- The fundamental concepts of databases, including why and when they are used, what relational databases are, and entity-relationship diagrams.
- Introduced to techniques such as normalisation, which aid in increasing the efficiency of databases.
- The fundamentals of Structured Query Language (SQL).
- Able to progress to more advanced courses involving database systems and SQL after completing this course.
Syllabus :
1. Introduction
- What to Expect
- Before the Advent of Databases
- Disadvantages of File-Based System
2. 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
3. Data Modeling
- Introduction to Data Models
- Schemas and Instances
- The Three-Schema Architecture
- Data Independence
- Classification of Database Management Systems
4. 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
5. 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
6. Functional Dependencies
- Intro to Functional Dependencies
- Rules of Functional Dependencies
- Dependency Diagrams
7. Normalization
- What Is Normalization?
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form
8. 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
- TheWHERE Clause
- The AND & OR Clauses
- Aggregate Functions in SQL
- ORDER BY & GROUP BY
- The HAVING Clause
- Alias Syntax
- SQL Joins
