• expired

$0 Course - SQL Masterclass: SQL for Data Analytics @ Udemy

880
SQLMASTERCLASS
This post contains affiliate links. OzBargain might earn commissions when you click through and make purchases. Please see this page for more information.

4.3 (49 ratings), 11,449 students enrolled.

What you'll learn

  • Knowledge of all the essential SQL commands
  • Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
  • Become competent in using sorting and filtering commands in SQL
  • Master SQL's most popular string, mathematical and date-time functions
  • Enhance the performance of your Database by using Views and Indexes
  • Increase your efficiency by learning the best practices while writing SQL queries
  • Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas
  • Solid understanding of SQL

Related Stores

Udemy
Udemy

closed Comments

  • Thanks OP

  • +7

    Before you sign up, watch the preview video to see if you like the subject matter and the tutors delivery. I found his accent and delivery a bit distracting, maybe after a period of time it wouldn't be an issue, but I wouldn't enjoy studying that subject with that tutor.

    • +1

      I should have read your message before I signed up.
      I'm attempting lesson one but with the strong accent I'm having problems understanding some words. The speed of delivery gives you no time to try and figure it out.
      Thanks for the heads up (belated for me but good for others).

  • Thanks OP

  • Looks good to me, will get onto it ASAP
    Thanks OP

  • +6

    As a beginner, using nest subqueries is okay. But as you become more experienced, don't be the person who nests subqueries in another, in another and so on. DON'T BE THIS PERSON!

    An experienced SQL user should know how to use temp/volatile tables or CTEs to build efficient and easy to read code.

    • +1

      Easy to read maybe, but CTEs are hell to debug (as you can nest them too) if there is an issue somewhere in the SQL query.

      • I prefer temp/volatile tables. In terms of efficiency, CTEs are just as bad as subqueries, just easier to digest/read. But I know people who swear by nesting/CTEs and say temp/volatile tables are shit, whut!?

  • does anyone know if you require specialist software to complete this course?

    • Specialist to some extent, but not enterprise/paid stuff.

    • +1

      I did not go through much of the data but you should be able to download and install a "smaller", free version of Microsoft SQL from here: https://go.microsoft.com/fwlink/?linkid=853017

      Later Edit: OK, the course is actualy on PostgreSQL, an Open Source, free implementation of SQL, not the microsoft version.
      You you should be able to download and install it from https://www.postgresql.org/

Login or Join to leave a comment