Practical SQL for Beginners, Product Managers, Marketing

Focused View

Phil Ebiner,Video School,Faisal Memon,EmbarkX Official

5:56:34

53 View

1. Introduction to SQL

1. Introduction to the Course.mp4

03:11

2. Understanding Databases and Tables.mp4

05:16

3. Overview of SQL and Its Importance.mp4

04:14

4. What are the Primary Keys.mp4

05:01

5. NULLs in Table.mp4

02:15

6. Introduction to Replit.mp4

04:25

7. Getting Started.mp4

07:06

8.1 sql-non-techies-0180-setting-up-things.zip

8. Setting up things.mp4

06:05

9.1 source-sql-non-techies-0200-basic-sql-queries.zip

9. Basic SQL queries (SELECT, FROM, WHERE).mp4

07:57

10.1 source-sql-non-techies-0220-comments.zip

10. Comments.mp4

03:41

11. Section Summary.mp4

05:59

2. Data Analysis with SQL

1. Section Introduction.mp4

02:15

2.1 source-sql-non-techies-0280-getting-users-from-a-city-on-a-particular-date.zip

2. Getting users from a city on a particular date.mp4

08:01

3. Data Types.mp4

08:08

4.1 source-sql-non-techies-0320-counting-the-users.zip

4. Counting the users.mp4

06:09

5.1 source-sql-non-techies-0340-giving-output-column-pretty-names.zip

5. Giving output column pretty names.mp4

03:52

6.1 source-sql-non-techies-0360-operators.zip

6. Operators.mp4

05:10

7.1 source-sql-non-techies-0380-comparison-operators-in-action.zip

7. Comparison Operators in Action.mp4

04:59

8.1 source-sql-non-techies-0400-excluding-a-particular-city.zip

8. Excluding a particular city.mp4

01:37

9.1 source-sql-non-techies-0420-getting-users-from-city-with-name.zip

9. Getting Users From City with name.mp4

01:57

10.1 source-sql-non-techies-0440-getting-users-who-live-in-any-of-the-cities.zip

10. Getting users who live in any of the cities.mp4

02:23

11.1 source-sql-non-techies-0460-excluding-a-particular-city-another-way.zip

11. Excluding a particular city (Another way).mp4

03:33

12.1 source-sql-non-techies-0480-challenge-segmenting-users-emails.zip

12. Challenge Segmenting users for sending emails.mp4

06:40

13.1 source-sql-non-techies-0500-challenges-lets-hands-on-practice.zip

13.2 sql-non-techies-0500-challenges-lets-hands-on-practice.zip

13. Challenges Lets get some hands on Practice.mp4

17:13

14. Section Summary.mp4

04:29

3. Grouping and Segmenting Data

1. Section Introduction.mp4

00:56

2. Grouping Data Introduction.mp4

05:21

3.1 source-sql-non-techies-0580-count-users-citywise.zip

3. Count users citywise.mp4

02:40

4. Aggregation functions.mp4

02:05

5.1 source-sql-non-techies-0600-challenge-total-fare-amount-earned.zip

5. Challenge Find the total fare amount earned by each driver.mp4

04:44

6.1 source-sql-non-techies-0640-analyzing-drivers-data.zip

6. Analyzing drivers data.mp4

06:44

7.1 source-sql-non-techies-0660-sorting-drivers-data.zip

7. Sorting drivers data.mp4

07:27

8.1 source-sql-non-techies-0680-getting-top-3-earning-drivers.zip

8. Getting top 3 earning drivers.mp4

05:24

9.1 source-sql-non-techies-0700-filtering-drivers-data-by-total-fare-amount.zip

9. Filtering drivers data by Fare Amount.mp4

03:32

10. Section Summary.mp4

03:40

4. Measuring User Behaviour and Engagement

1. Section Introduction.mp4

01:33

2.1 source-sql-non-techies-0760-working-with-subqueries.zip

2. Working with Subqueries.mp4

10:23

3. User Behaviour and Engagement Metrics to Track.mp4

02:43

4.1 sql-non-techies-0790-load-setup-data.zip

4. Load Setup Data.mp4

02:12

5.1 source-sql-non-techies-0800-calculating-feature-usage-rate.zip

5. Calculating Feature Usage Rate.mp4

08:29

6. Understanding Retention Rate.mp4

04:43

7.1 source-sql-non-techies-0840-case-statements.zip

7. CASE Statements Evaluating Outputs Based on Condition.mp4

07:10

8.1 source-sql-non-techies-0860-calculating-retention-rate.zip

8. Calculating Retention Rate.mp4

11:35

9. Understanding Feature Adoption.mp4

01:18

10.1 source-sql-non-techies-0900-calculating-feature-adoption.zip

10. Calculating Feature Adoption.mp4

05:54

11. Understanding Churn Rate.mp4

04:01

12. What are Foreign Keys and Relationships.mp4

07:38

13.1 source-sql-non-techies-0960-creating-reports.zip

13. Creating reports.mp4

14:47

14.1 source-sql-non-techies-0980-managing-missing-data.zip

14. Managing Missing Data.mp4

07:12

15.1 source-sql-non-techies-1000-managing-missing-data-with-case.zip

15. Managing Missing Data with CASE.mp4

02:03

16. Section Summary.mp4

03:27

5. Marketing Analytics

1. Section Introduction.mp4

01:27

2.1 sql-non-techies-1060-understanding-the-how-data-is-stored.zip

2. Understanding the how data is stored.mp4

04:07

3.1 source-sql-non-techies-1100-measuring-effectiveness-of-campaign.zip

3. Measuring effectiveness of campaign.mp4

04:11

4.1 source-sql-non-techies-1120-measuring-effectiveness-in-terms-of-revenue-generated.zip

4. Measuring effectiveness in terms of revenue generated.mp4

04:35

6. Building Funnels

1. Section Introduction.mp4

01:00

2. What are Funnels.mp4

06:14

3.1 source-sql-non-techies-1200-working-with-with-as.zip

3. Working with With AS.mp4

08:46

4.1 source-sql-non-techies-1220-measuring-funnels.zip

4. Measuring Funnels.mp4

06:49

5.1 source-sql-non-techies-1240-funnel-analytics-monthly-pass.zip

5. Funnel Analytics for Monthly Pass Subscription.mp4

06:55

6.1 source-sql-non-techies-1260-challenge-funnel-ride-request.zip

6. Challenge Funnel to Ride Request.mp4

04:25

7.1 source-sql-non-techies-1300-set-operations-introduction.zip

7. SET Operations Introduction.mp4

02:55

8.1 source-sql-non-techies-1320-union.zip

8. Union.mp4

03:20

9.1 source-sql-non-techies-1340-insersect.zip

9. Intersect.mp4

01:19

10. Section Summary.mp4

03:38

7. Revenue Analytics

1. Section Introduction.mp4

00:51

2. Understanding Revenue Metrics.mp4

03:14

3.1 source-sql-non-techies-1440-calculating-arr.zip

3. Calculating ARR.mp4

02:55

4.1 source-sql-non-techies-1460-calculating-mrr.zip

4. Calculating MRR.mp4

01:54

5.1 source-sql-non-techies-1480-calculating-arpu.zip

5. Calculating ARPU.mp4

02:55

6. Section Summary.mp4

01:28

8. Going from here

1. Different Database Vendors Available.mp4

05:09

2. What is a Client and Database Server.mp4

04:55

3. Getting Access to the Database.mp4

04:15

Description

Learn SQL for Data Analytics. Database & SQL Concepts applicable to MySQL, PostgreSQL, Oracle, and Microsoft SQL Server

What You'll Learn?

Learn SQL for data analysis
Write SQL queries on their own confidently
Get a job or promotion by understanding SQL
Help Data Analysts, Marketers, Product Managers, or any non-tech person learn SQL and analyze data on your own
Apply your skills to Databases like MySQL, PostgreSQL, Oracle, and Microsoft SQL Server
Compile data (Data Analytics) into comprehensive data reports for use in decision-making
Gain hands-on experience in using SQL for real-world data analytics scenarios to influence business decisions
Use SQL to track and understand user behavior and engagement, crucial for product development and marketing strategy
Group and segment data using SQL to gain deeper insights
Create and analyze funnels, measuring the effectiveness of marketing campaigns using advanced SQL
Calculate crucial revenue metrics using SQL like ARR, MRR, and ARPU

Who is this for?

Anyone who wants to learn SQL

Anyone Who Wants to Learn How to Analyze Data: Basic computer literacy is required, but no prior experience with SQL or programming languages is needed.

Marketers: If you're a marketing professional aiming to measure the effectiveness of your campaigns, segment users for more personalized campaigns, or understand customer behavior in more depth, this course is designed with you in mind. Basic computer literacy is required, but no prior experience with SQL or programming languages is needed.

Entrepreneurs and Start-Up Founders: If you're running a start-up or small business and need to handle data analysis yourself, this course can help you grasp SQL essentials. It will enable you to extract insights from your user data, measure campaign effectiveness, track user behavior, and make data-driven decisions for your business.

Product Managers: This course is ideal for product managers who are looking to gain proficiency in data analysis and extraction using SQL. Learners in this category may be hoping to better understand their product's usage, customer behaviors, or to inform their product strategy and roadmap. Basic computer literacy is required, but no prior experience with SQL or programming languages is needed.

What You Need to Know?

No programming experience is needed for you to get started. You will learn everything you need to get started

A computer / laptop with steady internet connection along with willingness to learn. That's it.

More details

Description
Do you want to learn SQL? If so, this is the perfect SQL course for beginners.
Entry level SQL developers make up to $100,000 according to Glassdoor & ZipRecruiter. This is an in-demand skill that you can **start learning right now.
Gain proficiency in SQL, and advanced SQL techniques, specifically designed for Product Managers, Marketers, and aspiring Data Analysts. Learn how to leverage the power of databases for data analytics, transforming raw data into actionable business insights. Take control of your business data with our comprehensive course.
Our course covers all you need to know, from basic SQL queries to writing advanced queries that would be needed to create reports and analyze data. You'll learn the fundamentals of databases and tables, understanding how they store and manage data. Explore user segmentation for targeted marketing, learn to track user behavior, and assess the effectiveness of your marketing campaigns.
Go beyond just data collection and dive deep into data analysis.
Group, segment, and analyze data to glean critical insights, and inform strategic decisions. You'll also gain hands-on experience in constructing and analyzing funnels for understanding user progression and drop-offs. By the course's end, you'll be able to calculate key revenue metrics like ARR, MRR, and ARPU using SQL.
Whether you're a beginner exploring data analytics, an Excel user looking to step up with SQL, or a product manager/marketer wanting to make data-driven decisions, this course offers a comprehensive learning journey. Leverage the power of SQL to drive your business forward!
COURSE BENEFITS

Become an SQLÂ Pro:Â Help Data Analysts, Marketers, Product Managers, or any Non Techie or person from Non Engineering background learn SQL and analyze data without the help of anyone.

Applicable skills to other Databases: Concepts you learn will be applicable to Databases like MySQL, PostgreSQL, Oracle, and Microsoft SQL Server

Understand the structure and role to get data you need: Learners will be able to understand the basic architecture of SQL databases and tables and their role in storing and managing data.

Create SQL reports: Learners will be able to compile data into comprehensive data reports for use in decision-making.

Demonstrate proficiency in basic SQL queries: By the end of this course, students will be able to write and execute basic SQL and MySQL queries such as SELECT, FROM, and WHERE.

Apply SQL to real-world Data Analysis scenarios: Learners will gain hands-on experience in using SQL for real-world data analytics scenarios to influence business decisions.

Perform user segmentation for targeted marketing with SQL: Learners will have the proficiency to segment users for targeted marketing strategies using SQL and MySQL.

Learn to use Aggregation Functions and SQL Operators: Students will understand how to use various SQL Aggregate functions and operators to manipulate and analyze data.

Group and Segment Data with SQL: By the end of this course, learners will be able to group and segment data using SQL to gain deeper insights.

Monitor User Behavior and Engagement with SQL: Learners will gain the ability to use SQL to track and understand user behavior and engagement, which is crucial for product development and marketing strategy.

Evaluate Marketing Campaign Effectiveness: Students will be able to measure the effectiveness of marketing campaigns using SQL, informing future marketing strategies.

Design and Analyze Funnels: Learners will be proficient in creating and analyzing funnels using advance SQL to understand user progression and drop-offs.

Compute Key Revenue Metrics: Learn about different revenue metrics like ARR, MRR, and ARPU and be able to calculate crucial revenue metrics using SQL.

HOW IS THIS COURSE DESIGNED?
Here's what makes this course unique:
Effortless Start: You'll learn SQL without installing anything on your machine. We'll be using an online IDE called Replit, which provides a user-friendly and less overwhelming environment for beginners.
Engaging Scenarios: We'll utilize a hypothetical startup "Hopride," a ride-sharing app, as a case study. Through this, you'll be exposed to various practical scenarios where data is critical - analyzing marketing campaigns, measuring user behavior, calculating marketing analytics, creating user segmentation, establishing funnels, and much more.
Comprehensive Resources**: The course comes with all the necessary sample data you need to get started, eliminating the hassle of finding data sets on your own.
By the end of this course, you'll be able to extract, manipulate, and analyze data using SQL, removing your dependency on others for your data needs. You'll gain a new skill that not only increases your efficiency but also boosts your career potential in a world driven by data.
So, are you ready to empower yourself with SQL and become data-independent? If so, join me in this course, "Demystifying SQL: Empowering Non-Techies with Data". Let's embark on this learning journey together!

Who this course is for:
Anyone who wants to learn SQL
Anyone Who Wants to Learn How to Analyze Data: Basic computer literacy is required, but no prior experience with SQL or programming languages is needed.
Marketers: If you're a marketing professional aiming to measure the effectiveness of your campaigns, segment users for more personalized campaigns, or understand customer behavior in more depth, this course is designed with you in mind. Basic computer literacy is required, but no prior experience with SQL or programming languages is needed.
Entrepreneurs and Start-Up Founders: If you're running a start-up or small business and need to handle data analysis yourself, this course can help you grasp SQL essentials. It will enable you to extract insights from your user data, measure campaign effectiveness, track user behavior, and make data-driven decisions for your business.
Product Managers: This course is ideal for product managers who are looking to gain proficiency in data analysis and extraction using SQL. Learners in this category may be hoping to better understand their product's usage, customer behaviors, or to inform their product strategy and roadmap. Basic computer literacy is required, but no prior experience with SQL or programming languages is needed.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

MySQL

PostgreSQL

Microsoft SQL

Phil Ebiner

Instructor's Courses

great courses for beginnersI'll teach you the skills necessary to stand out from the crowd. Whether it’s a personal passion or a business pursuit, you can learn video, photography, art, design, marketing skills and more here.learn by doingStep-by-step tutorials and project-based learning.get supportOne-on-one support from experts that truly want to help you.don’t stress. have fun.more about philMy professional background is in video production and editing. I graduated from Loyola Marymount University's School of Film and Television in 2011. Since then, I've worked on thousands of projects that have appeared in movie theaters, film festivals, television and online.Today, I create all kinds of things from photographs that can be seen on my Instagram to homemade sourdough bread that feeds my family. Who knows where life will take me. But I know wherever I am, I'll be creating.Since 2012, I've been creating online courses that over two million students from around the world have taken. Course topics include everything from photography and video to design and business courses. If I can't teach it , I collaborate with other experts who share their skills with absolute beginners.I can't wait to see you in class!- Phil

Video School

Instructor's Courses

Learn creative skills, from absolute beginner to advanced mastery. Video School exists to help you succeed in life. Each course has been hand-tailored to teach a specific skill from photography and video to art, design and business.Whether you’re trying to learn a new skill from scratch, or want to refresh your memory on something you’ve learned in the past, you’ve come to the right place.Education makes the world a better place. Make your world better with new skills!Our courses can be watched 24/7 wherever you are. Most are fully downloadable so you can take them with you. You can also view them on mobile devices with the Udemy mobile app.All courses have a 30-day money-back guarantee so that you can check it out, make sure it’s the right course for you, and get a refund if it’s not!

Faisal Memon

Instructor's Courses

Hey - this is Faisal and thanks for checking out my course.I have over 12+ years of experience building global products being used by millions of users across the globe. I love technology and teaching it.Currently, I am heading Product at one of the fast-paced startups in India and enjoying every moment of it. Prior to his, I built out a couple of startups that had over half a million users across the globe, raised funding from Google + other investors, and was part of Google Launchpad Accelerator. I have experience in building products from scratch and scaling to global users.I am here on Udemy to share my knowledge with seekers and help them grow personally and professionally.Glad to meet you :)

EmbarkX Official

Instructor's Courses

We don't teach, We educate.Over 40,000+ Students across the globe love our courses. Our courses have been also used by various corporates for upskilling their employees.We are experts in Java, Object oriented programming, Python, Spring Boot, Blockchain, Bitcoin, etc.We are on a mission to educate 1 Million people across the globe in an affordable way.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.