Practical SQL Bootcamp for Data Analysts and Data Scientists

Practical SQL Bootcamp for Data Analysts and Data Scientists

What you’ll 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

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 QuestionsSUPER BONUS 2: SQL Technical Written Interview Prep QuestionsWho 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 scientistsThis 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 tablesFilter rows or get the desired observations for your analysisAdvanced filter functions that include pattern matchingLimit the output to a number of rows rather than show the full datasetOrder or sort the output based on desired columnsBe able to join multiple tables together to get the needed attributesConduct arithmetic operationsRename your attributesSummarize data by performing data aggregationsPerforming data aggregations and arithmetic operations by subgroupsHow to structure data for analysisLearn how to use subquery to make your coding and querying a lot more efficientBe able to use if/then statementsData cleaning such as extracting a subset of string from the left, right or middleConcatenating columnsNew Bonus! SQL Interview Questions*Please refer to the class curriculum below for the particular SQL commands covered.LEARN TO CODE BY DOINGStart 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 INSTRUCTORThe 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 NEEDEDNo 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 LEARNERSJoin 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

Overview

Section 1: WEEK 1: INTRODUCTION

Lecture 1 Introduction to SQL

Lecture 2 Why Use SQL? Excel vs SQL

Lecture 3 Overview of Database

Lecture 4 About PostgreSQL

Section 2: WEEK 1: THE SET-UP AND THE DATASET

Lecture 5 Overview of Software Installation

Lecture 6 Download the sample database

Lecture 7 Software Installation – Part 1 (For Mac users)

Lecture 8 Software Installation – Part 2 (For Mac users)

Lecture 9 Software Installation – Part 1 (For Windows users)

Lecture 10 Software Installation – Part 2 (For Windows users)

Lecture 11 Starting Up PgAdmin4

Lecture 12 Practice Dataset: DVD Rental Database

Lecture 13 Database Entity-Relationship Diagram

Lecture 14 Creating a Database (For Mac users)

Lecture 15 Restoring a Database (For Mac users)

Lecture 16 Creating a Database (For Windows users)

Lecture 17 Restoring a Database (For Windows users)

Lecture 18 For Windows Users: How to Copy the Pathname of dvdrental file

Section 3: Week 1: BASIC SQL STATEMENTS

Lecture 19 SELECT & FROM

Lecture 20 SELECT & FROM Examples

Lecture 21 Quiz: SELECT & FROM

Lecture 22 Solutions: SELECT & FROM

Lecture 23 Best Practices on Formatting

Lecture 24 WHERE

Lecture 25 WHERE Examples

Lecture 26 Quiz: WHERE

Lecture 27 Solutions: WHERE

Section 4: WEEK 1CHALLENGE

Lecture 28 Week 1 CHALLENGE Questions

Lecture 29 Week 1 CHALLENGE Solutions

Section 5: Week 2: ADVANCED FILTER OPERATORS AND THE NULL VALUE

Lecture 30 Week 2 Overview

Lecture 31 IN Operator

Lecture 32 IN Example 1

Lecture 33 IN Example 2

Lecture 34 Quiz: IN

Lecture 35 Solutions: IN

Lecture 36 LIKE OPERATOR (Pattern Matching)

Lecture 37 LIKE Example 1

Lecture 38 LIKE Example 2

Lecture 39 ILIKE Operator

Lecture 40 ILIKE Example 1

Lecture 41 ILIKE Example 2

Lecture 42 Quiz: LIKE

Lecture 43 Solutions: LIKE

Lecture 44 NULL VALUE

Lecture 45 NULL Example

Section 6: Week 2: LIMIT AND ORDER BY STATEMENTS

Lecture 46 LIMIT

Lecture 47 LIMIT Example

Lecture 48 Quiz: LIMIT

Lecture 49 Solutions: LIMIT

Lecture 50 ORDER BY

Lecture 51 ORDER BY Example

Lecture 52 Quiz: ORDER BY

Lecture 53 Solutions: ORDER BY

Section 7: Week 2 CHALLENGE

Lecture 54 WEEK 2 CHALLENGE Questions

Lecture 55 WEEK 2 CHALLENGE Solutions

Lecture 56 Week 2 Closing Message

Section 8: Week 3: INNER JOINS, ALIAS, SHORTCUTS, RENAMING ATTRIBUTES

Lecture 57 Week 3 Overview

Lecture 58 Primary Key and Foreign Key

Lecture 59 Introduction to INNER JOIN

Lecture 60 How to do an INNER JOIN

Lecture 61 INNER JOIN Example 1

Lecture 62 INNER JOIN Example 2

Lecture 63 Quiz: INNER JOIN

Lecture 64 Solutions: INNER JOIN

Lecture 65 Alias

Lecture 66 Shortcuts

Lecture 67 Renaming Attributes

Lecture 68 Arithmetic Operations in SELECT

Lecture 69 Joining Multiple Tables Overview

Lecture 70 Joining Multiple Tables Example 1

Lecture 71 Joining Multiple Tables Example 2

Lecture 72 Quiz: Joining Multiple Tables

Lecture 73 Solutions: Joining Multiple Tables

Lecture 74 Introduction to OUTER JOIN

Lecture 75 LEFT JOIN

Lecture 76 LEFT JOIN Example

Lecture 77 RIGHT JOIN

Lecture 78 RIGHT JOIN Example

Lecture 79 Quiz: LEFT & RIGHT JOIN

Lecture 80 Quiz Hint: When do we use LEFT JOIN, JOIN or RIGHT JOIN again?

Lecture 81 Solutions: LEFT & RIGHT JOIN

Lecture 82 FULL JOIN

Lecture 83 UNION

Lecture 84 UNION Example

Section 9: Week 3 CHALLENGE

Lecture 85 Week 3 Challenge Questions

Lecture 86 Week 3 CHALLENGE Solutions

Lecture 87 Week 3 Closing Message

Section 10: Week 4: AGGREGATIONS AND GROUPING

Lecture 88 Week 4 Overview

Lecture 89 COUNT & COUNT WITH DISTINCT

Lecture 90 COUNT Example

Lecture 91 COUNT Example 2

Lecture 92 SUM & AVG

Lecture 93 SUM & AVG Example 1

Lecture 94 SUM & AVG Example 2

Lecture 95 Quiz: SUM & AVG

Lecture 96 Solutions: SUM & AVG

Lecture 97 GROUP BY

Lecture 98 GROUP BY Example 1

Lecture 99 GROUP BY Example 2

Lecture 100 Quiz: GROUP BY

Lecture 101 Solutions: GROUP BY

Lecture 102 MIN & MAX

Lecture 103 MIN & MAX Example

Lecture 104 Quiz: MIN & MAX

Lecture 105 Solutions: MIN & MAX

Section 11: Week 4: DATE TRUNCATION & FILTERING AGGREGATIONS

Lecture 106 DATE_TRUNC

Lecture 107 DATE_TRUNC Example 1

Lecture 108 DATE_TRUNC Example 2

Lecture 109 Quiz: DATE_TRUNC

Lecture 110 Solutions: DATE_TRUNC

Lecture 111 HAVING

Lecture 112 HAVING Example 1

Lecture 113 HAVING Example 2

Lecture 114 Quiz: HAVING

Lecture 115 Solutions: HAVING

Section 12: Week 4 Challenge

Lecture 116 Week 4 Challenge Questions

Lecture 117 Week 4 Challenge Solutions

Section 13: Bonus Week 5: SUBQUERIES

Lecture 118 Introduction to Subqueries

Lecture 119 WHERE Clause Subquery Example

Lecture 120 Quiz: WHERE Subquery

Lecture 121 Solutions: WHERE Subquery

Lecture 122 FROM Clause Subquery Example

Lecture 123 Quiz: FROM Subquery

Lecture 124 Solutions: FROM Subquery

Lecture 125 SELECT Clause Subquery Example

Lecture 126 Quiz: SELECT Subquery

Lecture 127 Solutions: SELECT Subquery

Section 14: Bonus Week 5: Data Cleaning and Structuring

Lecture 128 Data Cleaning Overview

Lecture 129 CASE

Lecture 130 CASE Example

Lecture 131 Quiz: CASE

Lecture 132 Solutions: CASE

Lecture 133 LEFT, RIGHT & LENGTH

Lecture 134 LEFT, RIGHT & LENGTH Example 1

Lecture 135 LEFT, RIGHT & LENGTH Example 2

Lecture 136 Quiz: LEFT, RIGHT & LENGTH

Lecture 137 Solutions: LEFT, RIGHT & LENGTH

Lecture 138 POSITION, SUBSTRING, UPPER & LOWER

Lecture 139 POSITION & SUBSTRING Example 1

Lecture 140 POSITION & SUBSTRING Example 2

Lecture 141 Quiz: POSITION & SUBSTRING

Lecture 142 Solutions: POSITION & SUBSTRING

Lecture 143 CONCAT

Lecture 144 CONCAT Example

Lecture 145 Quiz: CONCAT

Lecture 146 Solutions: CONCAT

Section 15: Bonus Week 5 CHALLENGE

Lecture 147 Bonus Week 5 Challenge Questions

Lecture 148 BONUS Week 5 Challenge Solutions

Lecture 149 Closing Message

Section 16: Super Bonus 1: SQL Oral Interview Questions

Lecture 150 Question 1

Lecture 151 Question 1 Suggested Answer

Lecture 152 Question 2

Lecture 153 Question 2 Suggested Answer

Lecture 154 Question 3

Lecture 155 Question 3 Suggested Answer

Lecture 156 Question 4

Lecture 157 Question 4 Suggested Answer

Lecture 158 Question 5

Lecture 159 Question 5 Suggested Answer

Lecture 160 Question 6

Lecture 161 Question 6 Suggested Answer

Lecture 162 Question 7

Lecture 163 Question 7 Suggested Answer

Lecture 164 Question 8

Lecture 165 Question 8 Suggested Answer

Lecture 166 Question 9

Lecture 167 Question 9 Suggested Answer

Lecture 168 Question 10

Lecture 169 Question 10 Suggested Answer

Lecture 170 Question 11

Lecture 171 Question 11 Suggested Answer

Lecture 172 Question 12

Lecture 173 Question 12 Suggested Answer

Section 17: SUPER BONUS 2: SQL Written Interview Test Prep

Lecture 174 Introduction

Lecture 175 How to Create Practice Tables in SQL

Lecture 176 How to Insert Values in Practice Tables

Lecture 177 Quiz: Creating a Table & Inserting Data into it (Optional)

Lecture 178 Solutions: Creating a Table & Inserting Data into It (Optional)

Lecture 179 SQL Written Test 1

Lecture 180 SQL Written Test 1 Solution

Lecture 181 SQL Written Test 2

Lecture 182 SQL Written Test 2 Solution

Lecture 183 SQL Practice Test 3

Lecture 184 SQL Written Test 3 Solution

Lecture 185 SQL Written Test 4

Lecture 186 SQL Written Test 4 Solution

Lecture 187 SQL Written Test 5

Lecture 188 SQL Written Test 5 Solution

Lecture 189 SQL Written Test 6

Lecture 190 SQL Written Test 6 Solutions

Lecture 191 SQL Written Test 7

Lecture 192 SQL Written Test Solutions

Lecture 193 SQL Written Test 8

Lecture 194 SQL Written Test 8 Solutions

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

Course Information:

Udemy | English | 3h 39m | 1.40 GB
Created by: Ava Cas, PhD

You Can See More Courses in the Business >> Greetings from CourseDown.com