Data Analysis and Wrangling with SQL

Categories: Corporate
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

The online course on Data Analysis and Wrangling with SQL is designed to provide participants with a comprehensive understanding of SQL (Structured Query Language) and its application in data analysis and data manipulation tasks. This course is suitable for beginners and intermediate learners who want to enhance their skills in querying, analyzing, and transforming data using SQL.

Course Objectives:

  1. Understand the fundamentals of SQL and its role in data analysis and data manipulation.
  2. Learn how to write SQL queries to extract, filter, and aggregate data from relational databases.
  3. Gain proficiency in data wrangling techniques, including data cleaning, transformation, and joining.
  4. Explore advanced SQL functions and operators for performing complex calculations and data manipulation tasks.
  5. Understand how to apply SQL for exploratory data analysis and generating meaningful insights.
  6. Learn techniques for optimizing SQL queries and improving query performance.
  7. Discover methods to handle missing data, duplicates, and outliers using SQL.
  8. Develop skills in creating views, stored procedures, and user-defined functions for efficient data manipulation.
  9. Understand how to work with multiple tables and perform advanced data joins using SQL.
  10. Apply the knowledge acquired throughout the course to real-world data analysis and wrangling scenarios.
Show More

Course Content

Module 1: Starting with SQL

  • Indexes in SQL
    07:09
  • Views
    05:59
  • Cluster
    04:15

Module 2: Deep Dive into SQL

Module 3: Oracle Database

Module 4: Introduction to PL/SQL

Module 5: Database Object

Want to receive push notifications for all major on-site activities?