Practical SQL for Beginners, Product Managers, Marketing

سرفصل های دوره

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

1. Introduction to SQL

1. Introduction to the Course

2. Understanding Databases and Tables

3. Overview of SQL and Its Importance

4. What are the Primary Keys

5. NULLs in Table

6. Introduction to Replit

7. Getting Started

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

8. Setting up things

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

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

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

10. Comments

11. Section Summary

2. Data Analysis with SQL

1. Section Introduction

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

3. Data Types

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

4. Counting the users

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

5. Giving output column pretty names

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

6. Operators

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

7. Comparison Operators in Action

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

8. Excluding a particular city

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

9. Getting Users From City with name

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

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

11. Excluding a particular city (Another way)

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

12. Challenge Segmenting users for sending emails

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

14. Section Summary

3. Grouping and Segmenting Data

1. Section Introduction

2. Grouping Data Introduction

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

3. Count users citywise

4. Aggregation functions

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

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

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

6. Analyzing drivers data

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

7. Sorting drivers data

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

8. Getting top 3 earning drivers

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

9. Filtering drivers data by Fare Amount

10. Section Summary

4. Measuring User Behaviour and Engagement

1. Section Introduction

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

2. Working with Subqueries

3. User Behaviour and Engagement Metrics to Track

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

4. Load Setup Data

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

5. Calculating Feature Usage Rate

6. Understanding Retention Rate

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

7. CASE Statements Evaluating Outputs Based on Condition

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

8. Calculating Retention Rate

9. Understanding Feature Adoption

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

10. Calculating Feature Adoption

11. Understanding Churn Rate

12. What are Foreign Keys and Relationships

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

13. Creating reports

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

14. Managing Missing Data

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

15. Managing Missing Data with CASE

16. Section Summary

5. Marketing Analytics

1. Section Introduction

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

2. Understanding the how data is stored

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

3. Measuring effectiveness of campaign

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

4. Measuring effectiveness in terms of revenue generated

6. Building Funnels

1. Section Introduction

2. What are Funnels

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

3. Working with With AS

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

4. Measuring Funnels

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

5. Funnel Analytics for Monthly Pass Subscription

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

6. Challenge Funnel to Ride Request

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

7. SET Operations Introduction

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

8. Union

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

9. Intersect

10. Section Summary

7. Revenue Analytics

1. Section Introduction

2. Understanding Revenue Metrics

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

3. Calculating ARR

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

4. Calculating MRR

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

5. Calculating ARPU

6. Section Summary

8. Going from here

1. Different Database Vendors Available

2. What is a Client and Database Server

3. Getting Access to the Database

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy