Database Systems and SQL

General Course Description

This course will enable the trainees to unlock the power of data management and harness the capabilities of relational databases with our comprehensive course on Database Systems and SQL using MySQL.

This course is tailored to provide the trainees with a robust foundation in database design, management, and SQL querying.

The trainees will learn the basics of relational model, analysis and design of database schemas, data-driven database design, ERD design, DDL-SQL, DML-SQL, complete implementation of database development using MySQL Database, Queries and Reporting.

Course Outline

  • Introduction to data and Information.
  • what is structured data?
  • Relational Model
  • Entity Relational Diagrams
  • From ERD to database schema.
  • Hands on case studies to create ERD and DB schema for selected domains.
  • Structured Query Language: DLL
  • Introducing MySQL Database.
  • Example Application of DLL using MySQL
  • Structured Query Language: DML
  • Example Library system DML using MySql.

Course Duration: 18 (3 hours / Session)

Target Audience: General Front-end and Back-end Desktop, Mobile and Web-based Developers, Systems Analysts and Architects, System Designers

 

Instructor: PhD Degree Holder in Software Engineering

Pre-Requisite Knowledge and Experience

  • Basic programming concepts only.
  • Basic English.

Certificate: TBD

Training Room: Smart TV, Mini-PC’s, Whiteboard, AC, Fiber Internet Access