Share
Explore

Intro to SQL for Data Science Course

4-hour live instructor-led SQL training session
Complete the setup and installation 💻 (given below) before the session
Postgres: PostgreSQL is a powerful, open source object-relational database system
Click
to go to the Postgres download page
Download the latest version based on your OS
Follow the Setup guide
Set up the password
pgAdmin: It is the most popular and feature rich Open Source administration and development platform for PostgreSQL
Click
to go to the pgAdmin download page
Download the latest version based on your OS
Follow the Setup guide & setup a password
Open the application with the above pwd
Click on the Server to start and enter the Postgres pwd to connect!
FAQs:
I have registered, how do I get the details of the event? 🎟️
You will receive an email from hello@careernub.com on your registered email id with all the details.
(Please check your spam too 🙏🏻 | Shoot us an email if you can’t find it)
Event Date: Sunday, 12th Sep 2021
Event Time: 9AM to 1PM PST
Link to Join: Will be in your calendar invite and email with all details

Who is this course for? 🤔
This is a Beginner Friendly course for everyone who wants to:
Build a career in data science/analytics, engineering, product, marketing etc.
Learn SQL programming language from scratch
Solve business problems by analyzing big data
Pull large quantities of data

What will you earn through this course? 👑
Certificate of Completion 🥳
Access to our data science Slack community (continue learning from peers & mentors)
Access to class recordings

Who will be the Instructor for this course? 🧑‍🏫
is a top data scientist in the silicon valley with 6+ years of experience working with leading tech companies and the Co-founder of CareerNub (a professional growth platform)
What you will learn in this course? 💡
The training is broken down in to two sessions of 1hour 45 mins each with a 30-min break in between. Following are the details of each session:
Session 1: [1 hour 30 mins + 15 mins QnA]
Basics of Database
Creating & Deleting Tables
Selecting columns from a table
Aliasing table & column names
Filtering data with single condition
Filtering data with multiple condition
Mathematical Operators on columns
General Aggregate Functions in SQL
Statistical Aggregate Functions in SQL
Rounding values in SQL
Grouping Functionality in SQL
Numbered Aliasing of columns
Sorting data in SQL
Sorting & Limiting
Session 2: [1 hour 30 mins + 15 mins QnA]
Subqueries
Common Table Expressions (CTEs)
Case When (SQL's If Else statements)
Date Functions
SQL Joins (Inner, Outer, Left, Right, Self)
Window Functions (Aggregate, Ranking, Lead/Lag etc.)
Order of Execution in SQL
SQL Optimization
Writing clean SQL code

What are the pre-requisite setup and installation for the course? 💻
Please complete the following setup & installations before the training session:
Postgres: PostgreSQL is a powerful, open source object-relational database system
Click
to go to the Postgres download page
Download the latest version based on your OS
Follow the Setup guide
Set up the password
pgAdmin: It is the most popular and feature rich Open Source administration and development platform for PostgreSQL
Click
to go to the pgAdmin download page
Download the latest version based on your OS
Follow the Setup guide & setup a password
Open the application with the above pwd
Click on the Server to start and enter the Postgres pwd to connect!

How much does the course cost? 💰
The fee for this course is $50 only

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.