• LOGIN
  • No products in the cart.

SQL is the most commonly used data analysis tool for data analysts and data scientists. In this course, you’ll learn to extract and analyze data through Structured Query Language (SQL). You’ll first learn to extract data, join tables and perform aggregations. Then you’ll learn to do more complex analysis and. By the end of the course, you’ll be able to write efficient SQL queries to successfully handle a variety of data analysis tasks.

Assessment

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: Udacity

Course Curriculum

Lesson 1: Basic SQL
SQL Introduction 00:01:00
The Parch & Posey Database 00:01:00
The Parch & Posey Database 2 00:01:00
Why SQL 00:03:00
How Databases Store Data 00:01:00
Types of Statements 00:01:00
SELECT & FROM 00:02:00
LIMIT 00:01:00
ORDER BY 00:01:00
ORDER BY Part II 00:02:00
WHERE 00:02:00
WHERE with Non-Numeric Data 00:01:00
Arithmetic Operators 00:01:00
LIKE 00:01:00
NOT 00:01:00
AND and BETWEEN 00:02:00
Lesson 2: SQL Joins
Motivation 00:01:00
Why Would We Want to Split Data Into Separate Tables? 00:03:00
Introduction to JOINs 00:01:00
Alias 00:01:00
Motivation for Other JOINs 00:01:00
LEFT and RIGHT JOINs 00:05:00
JOINs and Filtering 00:02:00
Lesson 3: SQL Aggregations
Introduction to Aggregation 00:02:00
Introduction to NULLs 00:01:00
NULLs and Aggregation 00:02:00
First Aggregation – COUNT 00:01:00
COUNT & NULLs 00:02:00
SUM 00:01:00
MIN & MAX 00:01:00
AVG 00:01:00
GROUP BY 00:02:00
GROUP BY Part II 00:01:00
DISTINCT 00:01:00
HAVING 00:02:00
DATE Functions 00:03:00
DATE Functions II 00:03:00
CASE Statements 00:04:00
CASE & Aggregations 00:01:00
Lesson 4: SQL Subqueries & Temporary Tables
Introduction to Subqueries 00:01:00
Write Your First Subquery 00:03:00
More On Subqueries 00:02:00
Solution Video: More On Subqueries 00:07:00
WITH 00:02:00
Subquery Conclusion 00:01:00
Lesson 5: SQL Data Cleaning
Introduction to SQL Data Cleaning 00:01:00
LEFT & RIGHT 00:02:00
POSITION, STRPOS, & SUBSTR 00:02:00
CONCAT 00:01:00
CAST 00:02:00
COALESCE 00:01:00
Lesson 6: [Advanced] SQL Window Functions
Introduction to Window Functions 00:01:00
Window Functions 1 00:03:00
ROW_NUMBER & RANK 00:03:00
Aggregates in Window Functions 00:02:00
Aliases for Multiple Window Functions 00:01:00
Comparing a Row to Previous Row 00:02:00
Introduction to Percentiles 00:01:00
Percentiles 00:01:00
Lesson 7: [Advanced] SQL Advanced JOINs & Performance Tuning
Introduction to Advanced SQL 00:01:00
JOINs with Comparison Operators 00:03:00
Self JOINs 00:02:00
UNION 00:02:00
Performance Tuning Motivation 00:01:00
Performance Tuning 1 00:03:00
Performance Tuning 2 00:03:00
Performance Tuning 3 00:01:00
JOINing Subqueries 00:07:00
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.7

4.7
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

510 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
Edukite is A Part Of Ebrahim College, Charity Commission
Reg No 110841