Database Management Systems

Track: Enterprise Data Analyst (EDA)
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 Analyst (EDA)

Database Management Systems is one of the modules under our Enterprise Data Analyst (EDA) program. EDA is a 28-day training program that provides analysts with the tools to be immediate contributors to a data science team. They will assist to frame business requirements as analytics models.

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

EDA CADS Certified Enterprise Data Analyst

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

Hear from Our Alumni

Apply Now

Database Management Systems