Course Syllabus
Database Concepts
1.1 Data and Information
1.2 Introducing the Database
1.3 The Importance of Database Design
1.4 Evolution of File System Data Processing
1.5 Database Systems
Data Models
2.1 The Importance of Data Models
2.2 Data Model Basic Building Blocks
2.3 Business Rules
2.4 The Evolution of Data Models
2.5 Degrees Of Data Abstraction
The Relational Database Model
3.1 A Logical View of Data
3.2 Keys
3.3 Integrity Rules
3.4 The Data Dictionary and the System Catalog
3.5 Relationship within the Relational Database
3.6 Indexes
Entity Relationship (ER) Modeling
4.1 Basic Modeling Concepts
4.2 The ER Model
4.3 Developing an ER Diagram
4.4 A Comparison of ER Modeling Symbols
4.5 The Challenges of Database Design
Normalization of Database Tables
5.1 The Need for Normalization
5.2 The Normalization Process (1NF, 2NF, 3NF)
5.3 Improving the Design
5.4 Normalization and Database Design
5.5 Denormalization
Database Design
6.1 The Information System
6.2 The Systems Development Life Cycle (SDLC)
6.3 The Database Life Cycle (DBLC)
6.4 Database Design Strategies
6.5 Centralized versus Decentralized Design
Structured Query Language
7.1 Introduction to SQL
7.2 Data Definition Commands
7.3 Data Manipulation Commands
7.4 SQL Operators
7.5 Additional Data Management Commands
7.6 Additional Select Queries
7.7 Subqueries
7.8 Joining Database Tables
Current Trends and Issues in Database
8.1 Introduction to Specific Area of Database (i.e. Big Data etc)
8.2 Conceptual model on the Specific Area of Database
8.3 Data Management Issues
1.1 Data and Information
1.2 Introducing the Database
1.3 The Importance of Database Design
1.4 Evolution of File System Data Processing
1.5 Database Systems
Data Models
2.1 The Importance of Data Models
2.2 Data Model Basic Building Blocks
2.3 Business Rules
2.4 The Evolution of Data Models
2.5 Degrees Of Data Abstraction
The Relational Database Model
3.1 A Logical View of Data
3.2 Keys
3.3 Integrity Rules
3.4 The Data Dictionary and the System Catalog
3.5 Relationship within the Relational Database
3.6 Indexes
Entity Relationship (ER) Modeling
4.1 Basic Modeling Concepts
4.2 The ER Model
4.3 Developing an ER Diagram
4.4 A Comparison of ER Modeling Symbols
4.5 The Challenges of Database Design
Normalization of Database Tables
5.1 The Need for Normalization
5.2 The Normalization Process (1NF, 2NF, 3NF)
5.3 Improving the Design
5.4 Normalization and Database Design
5.5 Denormalization
Database Design
6.1 The Information System
6.2 The Systems Development Life Cycle (SDLC)
6.3 The Database Life Cycle (DBLC)
6.4 Database Design Strategies
6.5 Centralized versus Decentralized Design
Structured Query Language
7.1 Introduction to SQL
7.2 Data Definition Commands
7.3 Data Manipulation Commands
7.4 SQL Operators
7.5 Additional Data Management Commands
7.6 Additional Select Queries
7.7 Subqueries
7.8 Joining Database Tables
Current Trends and Issues in Database
8.1 Introduction to Specific Area of Database (i.e. Big Data etc)
8.2 Conceptual model on the Specific Area of Database
8.3 Data Management Issues
Frequently Asked Questions
Q1 : Who can enroll this course?
A1 : Anyone who wants to learn more about database design
Q2 : Can non-IT enroll this course?
A2 : Definitely yes!
A1 : Anyone who wants to learn more about database design
Q2 : Can non-IT enroll this course?
A2 : Definitely yes!