Complete SQL Masterclass for Data Analytics

Abhishek Bansal, Data Science Instructor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
50 Lessons (4h 37m)
    • 1. Course Overview

      3:00
    • 2. Installation

      6:18
    • 3. CREATE

      11:39
    • 4. INSERT

      9:07
    • 5. Import data from File

      4:59
    • 6. SELECT statement

      3:45
    • 7. SELECT DISTINCT

      6:05
    • 8. WHERE

      4:02
    • 9. Logical Operators

      6:10
    • 10. UPDATE

      5:25
    • 11. DELETE

      4:11
    • 12. ALTER

      17:21
    • 13. Restore and Back-up

      7:38
    • 14. Selection commands: Filtering using IN

      4:24
    • 15. Selection commands: Filtering using BETWEEN

      5:40
    • 16. Selection commands: Filtering using LIKE

      8:52
    • 17. Side Lecture: Commenting in SQL

      1:20
    • 18. Selection commands: Ordering using ORDER BY

      7:42
    • 19. LIMIT

      3:38
    • 20. AS (Alias)

      3:33
    • 21. Aggregate Commands: COUNT

      5:13
    • 22. Aggregate Commands: SUM

      3:24
    • 23. Aggregate Commands: AVERAGE

      2:53
    • 24. Aggregate Commands: MIN & MAX

      4:17
    • 25. GROUP BY

      11:52
    • 26. HAVING

      5:04
    • 27. Introduction to Joins

      2:25
    • 28. Inner Join

      8:05
    • 29. Left join

      7:32
    • 30. Right join

      6:27
    • 31. Full join

      4:59
    • 32. Cross join

      4:21
    • 33. Except

      3:00
    • 34. Union

      3:13
    • 35. Subqueries

      14:35
    • 36. String Functions: LENGTH

      3:31
    • 37. String Functions: UPPER & LOWER

      2:10
    • 38. String Functions: REPLACE

      4:13
    • 39. String Functions: LTRIM, RTRIM & TRIM

      6:56
    • 40. String Functions: CONCATENATION

      2:56
    • 41. String Functions: SUBSTRING

      6:01
    • 42. String Functions: List Aggregation

      5:01
    • 43. Mathematical Functions: CEIL & FLOOR

      3:34
    • 44. Mathematical Functions: RANDOM

      5:06
    • 45. Mathematical Functions: SETSEED

      4:11
    • 46. Mathematical Functions: ROUND

      2:27
    • 47. Mathematical Functions: POWER

      2:25
    • 48. Date-Time Functions: CURRENT DATE & TIME

      4:31
    • 49. Date-Time Functions: AGE

      3:50
    • 50. Date-Time Functions: EXTRACT

      8:17

About This Class

Why learn SQL?

  1. SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.

  2. It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.

  3. SQL is one of the most sought-after skills by hiring employers.

  4. You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.