SQL (DTP/CDT Students only) - Password required

This course is for DTP and CDT students only.

.

You will be required to bring a laptop for this course.

SQL is one of the top skills that is requested by employers, when they look to fill a data science vacancy. This course, aimed at those from a non-technical background, will allow you to understand, work with, and manipulate databases using SQL. By the end of the course, you will be able to understand and explain about concepts such as the relational model, and relational databases. You will be able to design, create, query, and manipulate relational databases using SQL and a contemporary database management system. You will also learn how to create efficient database queries to obtain the requested data faster, and how to create custom views so that you can display only the important data to clients

Timetable:
Arrival: 10:30-11
11:00-12:30 Session 1: Introduction to Databases
12:30 -13:30 Lunch
13:30 – 15:00 Session 2: Basic SQL
15:00-15:15 Break
15:15 -17:00 Session 3: Advanced SQL Queries, and SQL Views

DAY 2
9:30 - 11:00 Session 4: Database Design
11:00 - 11:15 Break
11:15 - 12:45 Session 5: Implementing your Design
12:45 - 13:45 Lunch
13:45 – 15:00 Session 6: Capstone Task