Course Content
Introduction to Databases
- What is a database?
- Why Use A Database?
- Types Of database
Relational Databases
- Terminology
- Connecting Tables
- Advantages of Relational Databases
- Relational Database Management Systems
- (RDBMS)
- Relational Database Applications
- Relational Database Design Process
- Business Needs Analysis
- Database Specification
- Identifying Database & Programming
- Functions
- Design Phases
Relational Data Model
- The Conceptual Data Model
- The Entity-Relationship Data Model
Entity-Relationship Diagrams
- The Role of E-R Diagrams
- Construction of E-R Diagrams
- Testing Your Data Model
Microsoft SQL Server RDBMS
- Microsoft SQL Server Tools
- Enterprise Manager
- Query Analyzer
Normalisation
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Fourth Normal Form (4NF)
- Fifth Normal Form (5NF)
Creating the Physical Database
- Data Definition SQL Statements
- Creating A Database
- Creating A Table
- Altering A Table
- Dropping A Table
- Creating An Index
- Dropping An Index
- Constraints
Working with Data
- Loading Data Into A Database
- Inserting Data Into A Table
- Retrieving Records