Course Overview:
This course introduces basic concepts for database design. It focuses on building ERD using practical case studies. It explores how to build a relational database from the logical database design. This course covers how to design, build and query a relational database.
Being Creative Duration Study Load:
- 18 Hours
- 12 Hours
The Outlines:
- What is database?
- What is database System?
- DBMS & its functions
- Entity-Relationship Model :
- Entities
- Keys (Primary, foregin keys)
- Relationships
- Cardinality
- Obligations
- Mapping
- Basic SQL database structure
- Schema (DDL)
- Tables (DDL)
- Simple Queries (DML)
- Complex Queries (DML)
The target Segment:
Beginner
The success requirements in the field:
None