Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Practical SQL Bootcamp for Data Analysts and Data Scientists

Master One of the Most In-Demand Skills for Data Analysts in 2020!
4.6
4.6/5
(751 reviews)
4,263 students
Created by

9.3

CourseMarks Score®

8.6

Freshness

9.3

Feedback

9.3

Content

Platform: Udemy
Video: 3h 39m
Language: English
Next start: On Demand

Top SQL courses:

Detailed Analysis

CourseMarks Score®

9.3 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

8.6 / 10
This course was last updated on 5/2020 .

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

9.3 / 10
We analyzed factors such as the rating (4.6/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.3 / 10
Video Score: 8.1 / 10
The course includes 3h 39m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 29 minutes of 253 SQL courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

101 articles.
19 resources.
0 exercise.
0 test.

Table of contents

Description

Master One of the Most In-demand Skills for Data Analysts in 2020!
This guided bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Nowadays, with so many companies relying on big data analytics for decision-making, analysts with good SQL skills are some of the most sought after by employers. Whether you’re in marketing, operations or finance, this course will help you gain lots of practice and confidence in your SQL skills.
The Practical SQL Bootcamp for Data Analysts and Data Scientists course is a step-by-step guide to learning the fundamental SQL commands commonly used by analysts and future data scientists in their day-to-day tasks. The course walks you through each SQL command, provides examples for applying such command in typical query that analysts use in their day-to-day job and then allows you to apply or test what you’ve learned through exercises and challenges. 
Bonuses available:
SUPER BONUS 1: SQL Oral Interview Test Prep Questions
SUPER BONUS 2: SQL Technical Written Interview Prep Questions

Who is this course for?
•Absolute beginners in SQL can take this course
•You’ll go from not knowing anything about SQL to being someone ready for SQL technical interview and confident with their SQL skills. Most business or data analyst and data scientist positions will test your SQL skills, so this course will equip you with the essential skills you need for your job!
•Aspiring business analysts, data analysts or data scientists
•This course is for students who are aspiring to be analysts. You’ll learn the essential commands used by actual business analysts, data analysts or data scientists in their day-to-day jobs.  You will be doing a lot of data manipulation and analysis!
•Those who want to learn PostgreSQL!
•PostgreSQL is arguably the most advanced and powerful open-source enterprise class relational database system. It’s also free! A lot of companies use PostgreSQL. The commands that you will learn in this course do apply to other relational databases as well such as MySQL.

What this course is NOT?
•The course is not going to teach you how to create a database or how to manage database. If you find yourself in tutorials talking about things like: CREATE DATABASE, DROP DATABASE, INSERTING DATA, etc. — you’ve gone down the wrong rabbit hole! These tasks are usually done by engineers and database administrators —- not analysts or data scientists.  Pick tutorials that are geared towards DATA ANALYSIS.

Ok, you’ll learn how to code using SQL and at the same time learn how to think critically when analyzing data!
By the end of the course, you’ll learn how to:
•Retrieve data from specific tables
•Filter rows or get the desired observations for your analysis
•Advanced filter functions that include pattern matching
•Limit the output to a number of rows rather than show the full dataset
•Order or sort the output based on desired columns
•Be able to join multiple tables together to get the needed attributes
•Conduct arithmetic operations
•Rename your attributes
•Summarize data by performing data aggregations
•Performing data aggregations and arithmetic operations by subgroups
•How to structure data for analysis
•Learn how to use subquery to make your coding and querying a lot more efficient
•Be able to use if/then statements
•Data cleaning such as extracting a subset of string from the left, right or middle
•Concatenating columns
•New Bonus! SQL Interview Questions
*Please refer to the class curriculum below for the particular SQL commands covered.

•LEARN TO CODE BY DOING
Start coding like analysts do with hands on exercises and challenges that use real-world database. The examples are meant to help you understand the concept in a practical way; the exercises are meant to help you apply what you’ve learned; and the challenges are meant to further test your knowledge and perfect your new skills.
•GET PERSONALIZED FEEDBACK FROM THE INSTRUCTOR
The instructor aims to assist each student in their learning. The instructor gives her personalized feedback to the student’s weekly challenge (upon submission). Solutions are also available for students to review.
•GET ASSISTANCE FROM THE INSTRUCTOR AS NEEDED
No need to feel stuck on any concept or challenge! You can easily send a message to the instructor or send an email if you need help. Our students are on our priority list!
•JOIN THE COMMUNITY OF LEARNERS
Join the community of students and learn SQL together, and maybe meet new friends along the way.
•GET A COURSE CERTIFICATE 
Students who pass all the challenges will get a course certificate! You may also get LinkedIn recommendation (upon request) 

Hoping to embark on a data analyst or data scientist career? Learn SQL — one of the most in-demand data analytic skills today.
As a previous Professor and now a Statistics/Analytics content manager for an education tech company, I use a teaching method that makes it super easy for students to learn. I teach SQL in a practical way so I explain concepts with examples, then you have an opportunity to apply what you’ve learned through exercises and further test your knowledge with weekly challenges.

WHAT SOME OF MY STUDENTS SAY ABOUT THE COURSE:
“It was a great course and very easy to follow especially for someone who had no experience in SQL. The examples given were simple and Dr. Cas breaks it down really well so you can understand better. She walks you through all the different queries thoroughly and also writes down some helpful hints if you get stuck. She was also very attentive when I got stuck on one of the challenges and reached out to her one late night. She helped me understand it better by giving me more guidance and helped me think outside the box.
Overall, this was a great course to take and now I have another skill under my belt all thanks to Dr. Cas! Thanks for everything!”
– Karla Flores, Senior Financial Analyst, Adobe (California, USA)

“Excellent course and terrific inputs about every query. Majority of the job interviews that I appeared before this course had questions on SQL and I used to mess it up since I didn’t have my basics strong.This course not just helped me with the basics but also with the advanced concepts. It’s absolutely brilliant. I just feel completely charged up to attend any DS interview where SQL is a skill set that is asked. My motivation was not to give any chance to the interviewer/recruiter is to not provide any more opportunities to them to reject me and this helped me at least get to that stage. Rest of the outcome depends on the practice that I do. Only need some practice on the Data Cleaning section else I think I am prepared from an interview standpoint. Thanks for all the inputs and support Ava.” – R Suraj Kumar

“This was my first time taking an online data analysis class outside an academic setting. I worried about how the design would work for me as a working professional and if it would enable me grasp the material, but I must say that everything about the online course was smooth, convenient, and enjoyable.
The concise tutorial videos, quizzes with solutions and availability of the instructor, made it easy for me to understand the topics. The method, order, and scheduling were accommodating and in my opinion, makes it convenient for anyone, anywhere to take the course, and of course, the content was very useful to me.
I’m glad I took this course and I will strongly recommend it and others to follow, to anyone trying to develop more skills for data analysis. “
– Clare Ofodile, Project Manager, Quality Assurance and Research Development Agency Nigeria (Lagos, Nigeria)

“I like this course as it is very easy to understand and relevant for a beginner like me. I wish I could have some more courses like this one. I really enjoyed it and I started to like SQL more. A big thank you to my teacher!” – Ana Rotari

This instructor is highly effective and efficient in getting the critical knowledge across. Unlike other courses, this one did not drag. Time was well managed with the instructor’s teaching approach. In just three and a half hours, this course can be a career changing investment. – Jose Floresca Jr.

“This course sparks my most interest in SQL and you MUST take to get strong foundation in SQL. Teacher Ava provides a very organized and informative course which is worth best 5 ***** (stars). And more than that, she always be there to support you to clarify your confusion. Believe me, after this course, your level of confidence improves a lot and exceed your expectation. For me, I’d like to attend more SQL courses from Ava in next levels. I hope she will have some good news.” – Dannie Le

You will learn

✓ Learn how to do SQL queries that analysts implement in their day-to-day tasks
✓ Learn how to extract, pull and filter data from the database
✓ Practice using more advanced filter functions that involve complex conditions and pattern matching.
✓ Learn to join tables and execute subqueries to do more complicated analysis in an efficient way.
✓ Perform aggregations and groupings to summarize data and get a better understanding of the company’s performance.
✓ Be able to use if/then statements and string functions to clean and structure data.

Requirements

• This is great for beginners or those without any SQL experience.
• You may use either PC or Mac

This course is for

• College students, masters level students and entry-level analysts
• Upper level high school students may also take it

How much does the Practical SQL Bootcamp for Data Analysts and Data Scientists course cost? Is it worth it?

The course costs $17.99. And currently there is a 82% discount on the original price of the course, which was $99.99. So you save $82 if you enroll the course now.
The average price is $17.8 of 253 SQL courses on Udemy.

Does the Practical SQL Bootcamp for Data Analysts and Data Scientists course have a money back guarantee or refund policy?

YES, Practical SQL Bootcamp for Data Analysts and Data Scientists has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Practical SQL Bootcamp for Data Analysts and Data Scientists course, but there is a $82 discount from the original price ($99.99). So the current price is just $17.99.

Who is the instructor? Is Ava Cas, PhD a SCAM or a TRUSTED instructor?

Ava Cas, PhD has created 1 courses that got 751 reviews which are generally positive. Ava Cas, PhD has taught 4,264 students and received a 4.6 average review out of 751 reviews. Depending on the information available, Ava Cas, PhD is a TRUSTED instructor.
Data Science Practitioner
I have over 15 years of experience in statistical data analysis and consulting and over 7 years of university-level teaching experience. I enjoy teaching and loves to share my knowledge in statistics and statistical tools to my students.

I have served as consultant for the World Bank and for companies in Washington, D.C. area as well as countries such as Japan, Indonesia, Nigeria, Guatemala and the Philippines. I also served as an Assistant Professor of Economics at a School of Business and Economics at The Catholic University of America.

I have an undergraduate degree in Statistics and Ph.D. in Economics (PhD at Duke University).

9.3

CourseMarks Score®

8.6

Freshness

9.3

Feedback

9.3

Content

Platform: Udemy
Video: 3h 39m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Practical SQL Bootcamp for Data Analysts and Data Scientists rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/practical-sql-bootcamp-for-data-analysts-and-data-scientists/" target="_blank" title="Practical SQL Bootcamp for Data Analysts and Data Scientists on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/93.svg" width="200px" alt="Practical SQL Bootcamp for Data Analysts and Data Scientists rating"/></a>