Description
In this module we’ll learn how to extract data from a relational database using Structured Query Language, or SQL. We’ll cover all the basic SQL commands and learn how to combine and stack data from different tables. We’ll also learn how to expand the power of our queries using operators and handle additional complexity using subqueries. The following areas will be covered in this course.
- Introduction – Data Extraction Using SQL
- Introduction to SQL
- Aggregating and Sorting Data in SQL
- Extracting Data from Multiple Tables
- Stacking Data with UNION Command
- Extending SQL Queries Using Operators
- Using SQL Subqueries
- Enforcing Data Integrity
Who is This Course Suitable For
- Anyone working or intending to work in an organisational role which requires extracting, loading and transforming data.
- The course is equally suitable for recent graduates or professionals who wants to build a career in Data Analysis
- A recent graduate looking to switch career path to Business Intelligence.
Pre-Requisite:
No Pre-requisite Required
Course Type:
Classroom & Online
Course Duration:
The SQL for Data Analysis course is a 5 weeks long Course. Classes are held online on Saturdays from 12:30 pm – 5pm.
Reviews
There are no reviews yet.