The ‘SQL Masterclass: SQL for Data Analytics’ course gives you a solid understanding of SQL. In this course you will gain knowledge of all the essential SQL commands. The course covers all the basic to advanced SQL topics for SQL Database (PostgreSQL).

The course helps you to master SQL’s most popular string, mathematical and date-time functions. The course is usually available for INR 2,799 on Udemy but you can click on the link and get the ‘SQL Masterclass: SQL for Data Analytics’ for INR 499.

Who all can opt for this course?

  • Professionals in the workforce starting their data journey
  • Everyone who is interested in learning SQL quickly from basic to advanced levels
  • Students who are about to start their first corporate career

Course Highlights

Key HighlightsDetails
Registration LinkApply Now!
PriceINR 499 (INR 2,79987% off
Duration9.5 Hours
Rating4.5/5
Student Enrollment411,875 students
InstructorStart-Tech Academy https://www.linkedin.com/in/start-techacademy
Topics CoveredSQL Commands, JOINS, String Functions, Window Functions
Course LevelBeginner
Total Student Reviews11,330

Learning Outcomes

  • Understanding of all necessary SQL commands
  • Learn how to use SQL features like JOINS, Subqueries, and GROUP BY
  • Learn how to use the SQL sorting and filtering functions
  • Learn the most used string, maths, and date/time functions in SQL
  • Use views and indexes to boost your database’s performance
  • By becoming more proficient at writing SQL queries, you can increase your productivity
  • Also, pertinent theoretical ideas are discussed to help you succeed in BI Job interviews and Vivas
  • Solid familiarity with SQL

Course Content

S.No.Module (Duration)Topics
1.Introduction (04 minutes)Introduction
2.Installation and getting started (15 minutes)Installing PostgreSQL and pgAdmin in your PC
This is a milestone!
If pgAdmin is not opening…
Course Resources
3.Case Study : Demo (10 minutes)Case Study Part 1 – Business problems
Case Study Part 2 – How SQL is Used
4.Fundamental SQL statements (01 hour 17 minutes)CREATE
Exercise 1: Create DB and Table
Solutions to all Exercises
INSERT
Import data from File
Exercise 2: Inserting and Importing
SELECT statement
SELECT DISTINCT
WHERE
Logical Operators
Exercise 3: SELECT & WHERE
UPDATE
DELETE
ALTER
Exercise 4: Updating Table
Fundamental SQL statements
5.Restore and Back-up (23 minutes)Restore and Back-up
Debugging restoration issues
Creating DB using CSV files
Debugging summary and Code for CSV files
Exercise 5: Restore and Back-up
6.Selection commands: Filtering (19 minutes)IN
BETWEEN
LIKE
Exercise 6: In, Like & Between
7.Selection commands: Ordering (13 minutes)Side Lecture: Commenting in SQL
ORDER BY
LIMIT
Exercise 7: Sorting
8.Alias (03 minutes)AS
9.Aggregate Commands (17 minutes)COUNT
SUM
AVERAGE
MIN & MAX
Exercise 8: Aggregate functions
Quiz
10.Group By Commands (18 minutes)GROUP BY
HAVING
Exercise 9: Group By
Quiz
11.Conditional Statement (05 minutes)CASE WHEN
12.JOINS (01 hour 02 minutes)Introduction to Joins
Concepts of Joining and Combining Data
Preparing the data
Inner Join
Left Join
Right Join
Full Outer Join
Cross Join
Intersect and Intersect ALL
Except
Union
Exercise 10: Joins
Quiz
13.Subqueries (15 minutes)Subqueries
Exercise 11: Subqueries
14.Views and Indexes (14 minutes)VIEWS
INDEX
Exercise 12: Views
15.String Functions (33 minutes)LENGTH
UPPER LOWER
REPLACE
TRIM, LTRIM, RTRIM
CONCATENATION
SUBSTRING
LIST AGGREGATION
Exercise 13: String Functions
16.Mathematical Functions (19 minutes)CEIL & FLOOR
RANDOM
SETSEED
ROUND
POWER
Exercise 14: Mathematical Functions
17.Date-Time Functions (18 minutes)CURRENT DATE & TIME
AGE
EXTRACT
Exercise 15: Date-time functions
18.PATTERN (STRING) MATCHING (24 minutes)PATTERN MATCHING BASICS
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
Exercise 16: Pattern Matching
19.Window Functions (01 hour 28 minutes)Introduction to Window functions
Introduction to Row number
Implementing Row number in SQL
RANK and DENSERANK
NTILE function
AVERAGE function
COUNT
SUM TOTAL
RUNNING TOTAL
LAG and LEAD
20.COALESCE function (05 minutes)COALESCE function
21.Data Type conversion functions (16 minutes)Converting Numbers/ Date to String
Converting String to Numbers/ Date
22.User Access Control Functions (13 minutes)User Access Control
23.Nail that Interview! (20 minutes)Tablespace
PRIMARY KEY & FOREIGN KEY
ACID compliance
Truncate
Practice Test 1
SQL Quiz
24.Performance tuning tips (19 minutes)TIP 1 (EXPLAIN)
TIP 2
TIP 3
TIP 4 (VACCUM)
TIP 5
TIP 6 (STRING FUNCTIONS)
TIP 7 (JOINS)
TIP 8 (SCHEMAS)
25.Final Section : Database Basics (14 minutes)What is SQL?
Tables and DBMS
Types of SQL commands
PostgreSQL
The final milestone!
Bonus Lecture

Resources Required

  • A Computer with any web browser

Featured Review

Anil Anugula (5/5) : Superb explanation , I have learned lot of things from this course

Pros

  • Jeyadevi Bathe Janardhanan (5/5) : As I am a beginner ,the pace of the course is perfect for me..
  • Aman Kabra (5/5) : Best course on SQL and the way of explanation is superb.
  • Aditya Gurjar (5/5) : Its the best course i have come up to till date.
  • Abhiraj Das (5/5) : It was an awesome journey, all aspects are covered in detail in terms of SQL required for Data Analytic.

Cons

  • Mo Elmi (1/5) : the quality of your voice is not good, please work on it
  • Tomasz Juszczak (2/5) : Voiceover hard to understand and I have to install software that is not working without admin rights
  • Ashish Shukla (1/5) : I am not sure, how udemy uploaded this course on their platform, but this guy needs lots of improvement interm of teaching skills and somany otherthing techingwise.
  • Rakesh (2/5) : Not sure yet as i have downloaded version 10.7 and the steps seem different, a bit confused.

About the Author

The instructor of this course is Start-Tech Academy who is a 3,000,000+ Enrollments | 4+ Rated | 160+ Countries. With 4.5 Instructor Rating and 80,306 Reviews on Udemy,  Start-Tech Academy offers 66 Courses and has taught 1,615,893 Students so far.

  • Start-Tech Academy is a technology-based analytics education company that seeks to connect interested learners and analytics organisations
  • Students can start their analytics adventure with the aid of top-notch training materials, internship chances, and project options
  • Abhishek Bansal and Pukhraj Parikh founded the company
  • Pukhraj has many years of expertise working with analytics tools and software and is currently employed as a project manager in an analytics consulting company
  • He is proficient in Python, SQL, Tableau, SAS, Google Analytics, and the Microsoft Office suites
  • Before learning and instructing in technologies like machine learning and artificial intelligence, Abhishek worked as the owner of the acquisition process at a major telecom firm

Comparison Table

ParametersSQL Masterclass: SQL for Data AnalyticsSQL- The Complete Introduction to SQL programmingGoogle Data Studio A-Z: Looker Studio for Data Visualization
OffersINR 499 (INR 2,799) 87% offINR 455 (INR 3,499) 87% offINR 455 (INR 3,499) 87% off
Duration9.5 hours3.5 hours4.5 hours
Rating4.5/54.1/54.5/5
Student Enrollments411,635159,143171,334
InstructorsStart-Tech AcademyYassin MarcoStart-Tech Academy
Register HereApply Now!Apply Now!Apply Now!

Leave feedback about this

  • Rating