LMS

Certificate Program

Microsoft Excel: Practical MS Excel + MS Excel Data Analysis

The SQL for Data Science course is designed to provide participants with a solid foundation in SQL (Structured Query Language) and its application in data analysis and data science. Through a combination of theory, practical exercises, and hands-on projects, this course aims to equip learners with the skills to manipulate and query databases efficiently for data analysis purposes.

Enroll Now →

Download Syllabus

Estimated Time

08 Weeks

Total duration: 90 Notional hours

Next Intake

March 25, 2023

Get registration to course immediately on enrollment

Prerequisites

No need any prior Knowledge or Experience to complete this course

Introduction

Welcome to the SQL for Data Science course, your essential gateway to building a strong foundation in SQL (Structured Query Language) within the context of data analysis and data science. This program combines theory, practical exercises, and hands-on projects to empower participants with the crucial SQL skills needed to efficiently manipulate and query databases for data analysis purposes.

Dive into the world of SQL with our SQL for Data Science course. Through a curriculum that encompasses both theory and practical application, learners gain expertise in using SQL as a powerful tool to extract, manipulate, and analyze data for data science projects, enhancing their ability to derive meaningful insights from databases.

Enroll in the SQL for Data Science course and embark on a transformative learning journey. This course equips participants with the capabilities to confidently work with SQL, enabling them to efficiently harness the power of databases and contribute effectively to data-driven projects in the field of data science. Join us in mastering the SQL skills essential for data analysis success.

 

Enroll Now

What you will learn

Master the fundamentals of SQL, including commands like SELECT, FROM, and WHERE, along with logical operators.

Learn how to combine data from multiple sources using different types of JOINs to answer complex business questions.

Use aggregations like COUNT, SUM, MIN, and MAX to summarize data. Explore CASE and DATE functions and handling NULL values.

Utilize subqueries to execute multiple queries together and understand their placement and formatting.

Learn data cleaning techniques in SQL, including normalization and column creation.

Course Content

Module :

Lesson 1

Basic SQL

  • Write common SQL commands including SELECT, FROM, and WHERE.
  • Use logical operators like LIKE, AND, and OR.

Lesson 2

SQL Joins

  • Write JOINs in SQL to combine data from multiple sources to answer more complex business questions.
  • Understand different types of JOINs and when to use each type.

Lesson 3

SQL Aggregations

  • Write common aggregations in SQL including COUNT, SUM, MIN, and MAX.
  • Write CASE and DATE functions, as well as work with NULLs.

Lesson 4

SQL Subqueries & Temporary Tables

  • Write subqueries to run multiple queries together.
  • Learn the types of subquery placement and formatting.
  • Use temp tables to access a table with more than one query.

Lesson 5

SQL Data Cleaning

  • Learn and apply the basics of data cleaning strategies in SQL to normalize or create a column from existing data.
  • Perform the appropriate data-cleaning methodology based on goals for further analysis.

Lesson 6

SQL Window Functions

  • Apply core window functions to tackle analysis tasks that require further targeting or segmentation.
  • Use other window functions including RANK, NTILE, LAG, and LEAD, and use new functions along with partitions to complete complex tasks.

Lesson 7

SQL Advanced JOINs & Performance Tuning

  • Learn how and when to use advanced JOINs (e.g., self-JOINs) to write queries that run quickly across giant datasets.
  • Learn the high-level tradeoffs with queries, including performance and what you can do to optimize them.

Final Project

  • Applying the acquired knowledge and skills to solve a real-world problem.

Our Lecturers

Mr. Udara Alagalla

Lecturer @ APIBA

BSc degree holder specializing in Business Information Systems.  A visiting lecturer in a reputed institute for CA in Sri Lanka. Has worked Faculty of Management Studies and Commerce, University of Sri Jayewardenepura.

Mr. Chandika Witharana

Lecturer @ APIBA

Lecturer in Software Engineering & Business Intelligence at the Faculty of Management Studies and Commerce University of Sri Jayewardenepura from 2014 – 2022. Chief Executive Officer & Founder at APIBA. Chief Executive Officer & Founder at Xenosys Software solutions.  

Assessment
100% compulsory to pass the assessment at the end of the program (50% or above)
Student Support
Learning Management Systems (LMS) or Contact Coordinator of the course
Mode of Delivery
100% conducted live with access to recordings

Get Hands On Experience With Our Industry Partners

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Benefits of learning from us

High-quality content

8+ hands-on projects

Weekly assessments

Certificate on completion

Course Fees : LKR. 35,000

Get Started

“I’m extremely glad I signed up for the program. I definitely got what I wanted from the program and strongly recommend it.”

Javier R. Olaechea Financial Data Analyst

“I’m extremely glad I signed up for the program. I definitely got what I wanted from the program and strongly recommend it.”

Javier R. Olaechea Financial Data Analyst

“I’m extremely glad I signed up for the program. I definitely got what I wanted from the program and strongly recommend it.”

Javier R. Olaechea Financial Data Analyst