Database Management Systems

Track: Enterprise Data Scientist (EDS)
Learn the principles, technique and practices relevant to Relational Databases. Gain practical knowledge in storing and retrieving data using SQL, a query language used in all relational database management systems.

Store and Get Data From Any Relational Database System

Share on facebook
Share on google
Share on twitter
Share on linkedin

Relational Database is still the most used database to store and retrieve structured data. All data professionals need at some point to extract data from a Relational Database. Even for other non-relational databases (like NoSQL systems), the query language is very similar to SQL, thus knowing SQL is definitely a must.

Learning outcome:

Upon completion, participants should be able to demonstrate each of the following;
  1. Comprehend the principles, techniques and practices relevant to Relational Database and SQL
  2. Store and get data from any Relational Database system

Who should attend:

Professionals that work with data

3 days of in depth learning

Face to face with experienced Data Scientist.

Course Methodology

This course will utilize a combination of Presentations and Workshops.

Pre-requisite:
Introduction to Programming

HRDF Claimable

HDRF claimable. EPP option available for selected credit card.

CADS Certification​

Earn certification upon completion.

Minimum Qualification:
Undergraduate Degree

Training Track

Enterprise Data Scientist (EDS)

Database Management System is one of the modules under our Enterprise Data Scientist (EDS) programme. EDS is a 42-day training program that provides participants with the tools to be key leaders and contributors of a data science team and be able to analyze data to drive informed business decisions.

Details of Subject

Day 1 & 2
  1. Introduction –
    • Fundamentals of Set Theory and Relational Algebra
  2. Data Manipulating Language (DML) –
    • Insert into
    • Update table
    • Delete table
    • Truncate
    • Select from
    • More complex queries using AND/OR, IN subqueries, nested queries
    • Calculating results with CASE
    • Filtering grouped results using HAVINGJoin related tables using JOIN, Outer-joins, and combining multiple joins
Day 2
  1. Data Definition Language (DDL) –
    • Create and alter database and tables
    • Indexes
Day 3
  1. Database Design ER model –
    • Primary key
    • Foreign key
    • Normalization, denormalization
  2. Transactions, cursors

Lead Instructor

Mohammad Mehdi Lotfinejad
Mehdi is an experienced computer scientist who is technically proficient in software development and database management. His expertise includes data mining, web development, data engineering and he is very knowledgeable in project management as well. In addition, he has been very active in academia in the past where he worked as a lecturer at the Payame Noor University and published papers for many conferences and journals as well as authoring technical text books on computer science subjects.

CADS Certification

EDS CADS Certified Enterprise Data Scientist

Certification information for this module & track will be made available soon.

Hear from Our Alumni

Apply Now

Database Management Systems