Database_L4DC DIA(92& 94)

Database_L4DC DIA(92& 94)

About this Course

This unit aims to give the learner a thorough grounding in practical techniques for the design and development of database systems, and the theoretical frameworks that underpin them.

Learning Outcomes
The Learner will:
1. Understand the concepts associated with database systems
2. Understand the concepts associated with the relational model
3. Understand how to design and develop a database system
4. Be able to develop a logical database design
5. Be able to develop a database system using SQL

SQL (1)

• The purpose and role of SQL
• Basic concepts of SQL
• Standards and flavours of SQL
SQL (1)
• The purpose and role of SQL
• Basic concepts of SQL
• Standards and flavours of SQL
Database Design
• Understanding requirements
• Identify a set of tables from an ER model
• The data dictionary
• Use of CASE tools
• Entities to tables
03 - Database Fundamentals - Creating Databases and Database Objects
3 - This module describes data types, database objects, DDL statements, and creating scripts.
02 - Database Fundamentals - Relational Concepts
2 - In this module you'll learn about normalization, referential integrity, and constraints.