Overview What You Will Learn Curriculum Instructor

Course Overview

SQL (or Structured Query Language) is a powerful programming language that is used to communicate with and extract various insights from databases. SQL is an essential tool in a data scientist's toolbox since it is critical in accessing, updating, inserting, manipulating, and modifying Data.  

 There are some variants in SQL   such as MYSQL, PostgreSQL, SQL Server, Oracle, SQLite, etc. I will be using MySQL during the course as it is the first choice for any web-based projects which require a database for Data Transactions because of its ease of use and speed.

In this course, you will be learning core concepts of databases, SQL programming for handling data in databases with a focus on data science, and some advanced SQL techniques.

This course is all about learning SQL to create databases, extract useful insights, prepare complex queries, prepare reports and dashboards, and practice working on real-world projects.

The necessary resources for this course are in the "Resources" section of Video 1.1. You can also access them through this direct link - https://github.com/ec-council-learning/Hands-on-SQL-for-Data-Science

What You Will Learn

  • Prepare the Database
  • Basic SQL syntax to extract meaningful data from databases
  • Advanced SQL syntax like Grouping
  • Subqueries and Aggregate Functions to extract new features from the Data and communicate better with the stakeholders.
  • Understand basic Database terminology to ace a SQL interview
  • Perform small SQL exercise after each section to practice SQL queries
  • Perform database connections using Python and SQL
  • the 2 most in demand programming languages for a data professional

Program Curriculum

  • Installation and Setup
  • $7 Million Cybersecurity Scholarship by EC-Council

  • What is a Database?
  • Types of Databases and Relational Database Concepts
  • SQL Commands
  • Data Types
  • Primary and Foreign Key Constraints
  • Introduction to Normalization
  • Chapter 2 Quiz

  • Introduction
  • Create a Table
  • Alter a Table
  • Drop a Table
  • Insert Statements
  • Select Data
  • Select Comparison Operator
  • Select Logical Operator
  • Update Delete
  • Chapter 3 Quiz

  • Introduction 
  • String Functions
  • Date, Month and Year Function
  • Aggregate Functions
  • Group Data Using Group by and Having Clauses
  • SQL Syntax: CASE () and Limit ()
  • Introducing Subqueries 
  • SQL Joins
  • Chapter 4 Quiz

  • Introduction
  • Introduction to Anaconda
  • Working with CSV File
  • Python and MYSQL Connection
  • Data Visualization
  • Chapter 5 Quiz

Epilogue

Load more modules

Instructor

Oindrila Sen

Oindrila Sen data enthusiast who has 10+ years of experience in analyzing, visualizing and working with Data. She is a Data Scientist who is currently working on a Customer Retention project for her client. She works in collecting, cleaning, extracting new features and Visualizing Text Data to get an insight. She also publishes her work on different platforms. She is passionate about Data and NLP since a text can tell you a whole new story.

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

$ 499.00
Billed annually or $59.00 billed monthly
Get Started Now
Start your 7-day trial for $1

What is included

  • 700+ Premium Short Courses
  • 50+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

$ 599.00
Billed annually or $69.00 billed monthly
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 800+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month
  • 3 Official EC-Council Essentials Certifications¹ (retails at $897!)
    Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

  • Statistics Fundamentals: Bundled

    Statistics Fundamentals: Bundled

    Short Course

    Statistics Fundamentals: Bundled

    Data Science

    Theory and Python

    $59.99

    Beginner

    14 hr 32 m

  • Data Wrangling with Pandas - Part 2

    Data Wrangling with Pandas - Part 2

    Short Course

    Data Wrangling with Pandas - Part 2

    Data Science

    Explore the World of Data Processing with Pandas and Get a Ch...

    $59.99

    Beginner

    3 hr 11 m

  • Hands-on Python Web Scraping from Scratch

    Hands-on Python Web Scraping from Scratch

    Short Course

    Hands-on Python Web Scraping from Scratch

    Data Science

    Master the art of programming & building custom web scrap...

    $69.99

    Beginner

    4 hr 30 m

  • Data Visualization Using Tableau - Part 3

    Data Visualization Using Tableau - Part 3

    Short Course

    Data Visualization Using Tableau - Part 3

    Data Science

    Master Tableau Calculations and Create Your Own Dashboards!

    $49.99

    Beginner

    2 hr 30 m

  • Applied Logistic Regression

    Applied Logistic Regression

    Short Course

    Applied Logistic Regression

    Data Science

    A data-driven approach to classification

    $59.99

    Beginner

    3 hr 9 m

  • A Crash Course to Build Your Own Chatbot

    A Crash Course to Build Your Own Chatbot

    Short Course

    A Crash Course to Build Your Own Chatbot

    Data Science

    Learn the essentials of creating your chatbot from scratch us...

    $79.99

    Beginner

    4 hr 0 m

  • Deep Dive into Snowflake

    Deep Dive into Snowflake

    Short Course

    Deep Dive into Snowflake

    Data Science

    Master Snowflake for Advanced Data Warehousing and Analytics

    $49.99

    Advanced

    2 hr 30 m

  • Business Intelligence with Power BI Desktop

    Business Intelligence with Power BI Desktop

    Short Course

    Business Intelligence with Power BI Desktop

    Data Science

    Master Power BI, Data analysis, Visualization, and Designing ...

    $59.99

    Intermediate

    7 hr 8 m

1 8