Database Fundamentals Using SQL Server Registration

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