SQL Beginner to Advanced For Data Professionals

US$ 15.00

Beginners to advanced course for those preparing for a data career (data analyst, data scientist, or data engineer). This course is carefully curated to simulate real-time organizational experience to prepare you for the current job market and at the same time provides you with an ultimate learning experience through a storytelling mode that you would see in movies.

Beginner

Beginner to Advanced

lng

English

gg_sand

Free Lifetime Access

person

Created by : Dhaval Patel, Hemanand Vadivel

clock-history

Last updated : Nov 21, 2022 3:36 AM

4.9 (32)

Testimonials

What do learners say about this course?

Course Curriculum

93 Lectures | 11:10:26

Let’s See

What you'll learn

  • SQL Basics (SELECT, WHERE, BETWEEN, GROUP BY, ORDER BY, etc.)
  • Joins (LEFT, RIGHT, INNER, FULL, CROSS)
  • Subqueries, CTEs, Views, Temporary Tables
  • Fundamentals of ETL, Data Warehouse, OLAP, OLTP
  • User Defined Functions, Stored Procedures
  • Window Functions (Over, ROW_NUMBER, RANK, DENSE_RANK, etc.)
  • Data Engineer-Specific Topis: Indexes, Triggers, Events, User Accounts & Privileges
  • Kanban Project Management
  • Real dataset with >1 million records with industry-style project-based learning
  • Exercises, Quizzes, and Certificate Upon Course Completion

It’s really for everyone

Who can enroll in this course?

  • Total beginners who want to make a career in the data industry
  • Those who know SQL but want to upgrade their skills

Prepare yourselves

System Requirements

  • Any computer with 4GB or more RAM
  • OS: Windows, Mac, or Linux

Get

Certified

certificate-example
When You Complete This Course

You receive a ‘Certificate of Completion’ signed and addressed personally by me, your guide and mentor – Dhaval Patel Add and Share this certificate with your Resume/ CV or on your LinkedIn Profile

Meet your

Course Instructor/Creator

dhaval
Dhaval Patel

Data Entrepreneur | Youtuber | Ex - Bloomberg, NVIDIA

I have 17 years of experience in programming and data science working for big tech companies like NVIDIA and Bloomberg. I also run a famous youtube channel called Codebasics where I pursue my passion for teaching. Codebasics is one of the top channels on youtube when it comes to data science, machine learning, data structures, etc. I firmly believe that “Anyone can code” and I use analogies, simple explanations, and step-by-step storytelling to explain difficult concepts in such a way that even a high school student can understand them easily.

Co-Creator

hemanand
Hemanand Vadivel

Data & Analytics Manager | Microsoft Certified | Certified Supply Chain Professional

I’m a mechanical engineer who transitioned to a full time Data & Analytics manager in the UK & Germany by teaching myself Power BI, excel & anything else that was required to solve the problem. I have worked with complex data across Supply Chain, Sales, Marketing, Revenue Management, Finance and HR functions over the last 8 years to deliver effective solutions. To me, Analytics is an extra sensory organ that anyone can develop to become a superhuman at work. I have conducted several workshops and internal training to help non-technical people to become superhuman at work and now, really excited for this opportunity to share all that knowledge with you.

Answers even before you ask

Frequently Asked Questions

Yes, this is the perfect course for anyone who has never done coding and wants to build a career in the IT/Data Analytics industry or just wants to perform better in their current job or business using data.
This course is for absolute beginners hence you do not need any specific skills other than basic familiarity with computers
Most of the courses available on the internet teach you how to build x & y without any business context and do not prepare you for real business world problem-solving. This course is rather an experience in which you will learn SQL by solving real-life use cases in an imaginary company called AtliQ Hardware. The tutorials are very easy to understand and also have a lot of fun elements into them so that you don’t get bored 😊
Yes. Absolutely you can mention the AtliQ Hardware project experience in your resume with the relevant skills that you will learn from this course
Don’t worry. Many videos in this course are free so watch them to get an idea of the quality of teaching. Dhaval Patel (the course instructor) runs a popular data science YouTube channel called Codebasics. On that, you can watch his videos and read comments to get an idea of his teaching style
For initial basics, we have used a toy dataset of movies but for advanced concepts, we used a dataset that is crafted to mimic the real business world by consolidating our years of experience and the FMCG industry. That dataset contains more than 1 million records
Yes
We have an active discord server where you can post your question and most of the time you will get an answer in a reasonable time frame

US$ 15.00

Buy Now

What's Included

11:10:26 on-demand video
78 Lectures
15 Exercises
9 Quizzes
Access on tablet and phone
Certificate of completion
Free Lifetime Access