Opening: 08:30AM - 04:00PM

Database Fundamentals

10 h Labs - 10 h Lectures 20 total hours

Database Fundamentals

This course introduces basic concepts for database design. We consider this course basic introduction for different terminologies related to database engineering. Students will learn the main features of     different DBMSs in the market. 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. They will apply normalization to data for effective, stable database design.

  • What you'll learn
  • Database Definition
  • Entity-Relationship Model
  • Mapping
  • Normalization
  • DBMS Definition
  • Introduction to MySQL.
  • DDL.
  • Create database, Indexes, Creating tables.
  • Data-types.
  • Primary key & foreign key.
  • DML [Insert, Delete, Update].
  • SELECT statement & Sub-queries.
  • Group by & Having.