SQL Beginner to Advanced For Data Professionals

SQL Beginner to Advanced For Data Professionals
US$15.00
Buy Now

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.


4.9

(246 ratings)

2584 learners

Last Updated : Feb 23, 2023 12:04 AM

English

Free Lifetime Access

What do learners say about this course?

View more
quotes-testimonial
View more

Course Curriculum

79 Lectures   |   11:12

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

System Requirements

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

Course Instructors/Creators

Dhaval Patel

Dhaval Patel

Data Entrepreneur (12+ Years), 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.

Hemanand Vadivel

Hemanand Vadivel

Ex- Data Analytics Manager, 8+ Years in Europe, 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.

Frequently Asked Questions

1. I have never done programming and belong to a non-technical background. Can I take this course?

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. Over there, you can watch his videos and read comments to get an idea of his teaching style.

For the initial basics, we used a toy dataset of movies. But for advanced concepts, we used a dataset 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.

We have an active Discord server where you can post your question, and you will get an answer in a reasonable time frame.

Get Certified

certificate
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


SQL Beginner to Advanced For Data Professionals
US$15.00
Buy Now
This course includes:
  • play 11:12 on-demand video
  • lectures 79 Lectures
  • assignments 6 Practice Business Scenarios with Solution
  • list 9 Quizzes
  • mobile Access on tablet and phone
  • trophy Certificate of completion
  • hourglass Free Lifetime Access

Share With Friends