Curriculum

Overview of SQL Course(06:08)

Installing SQL(15:32)

Introduction to SQL Query(12:12)

Basic Data Filtering using SQL(13:15)

Unions, Functions & Operations(17:18)

Keys and Joins in SQL(14:22)

Sub-Queries and CTE(10:38)

Window Functions(13:52)

Date Function(12:12)

SQL Challenge-Sakila(29:34)

SQL Query Structure

SQL Data Types

SQL Operators

Aggregation Functions

String Functions

Numeric Functions

Window Functions

SQL Joins

Set Operators

Sub Queries

Date Function

Analyzing Sales Data

Order Table Assignment

Basic Statistics using SQL

SQL Query Optimization

Why you should take this course?

There are several reasons why it can be beneficial for a data scientist to learn SQL:

  1. SQL is a standard language for working with relational databases, which are commonly used to store data in the field of data science. This means that many data science projects will involve interacting with databases using SQL.
  2. SQL can be used to quickly and efficiently extract, transform, and manipulate data from databases, which is a key part of the data preparation process in data science.
  3. SQL skills can be useful for collaborating with database administrators and other IT professionals, as they often use SQL to manage and maintain databases.
  4. SQL can be a useful tool for exploring and understanding data, as it allows you to quickly and easily run queries and visualize the results.

Overall, learning SQL can help data scientists to more effectively work with data in their projects, and can also make them more versatile and valuable as professionals.

Testimonials

We are proud of our wonderful customer reviews.