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

880

Affiliate

Go to Deal

Cashback

Taegukgi on 24/01/2019 - 07:21 udemy.com (4322 clicks)

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

• 

  ChampofAus on 24/01/2019 - 08:04

  Thanks OP

• 

  FabMan on 24/01/2019 - 08:07

  +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.

  • 

    Mikebriz on 24/01/2019 - 16:41

    +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).

• 

  Marco1993 on 24/01/2019 - 08:12

  Thanks OP

• 

  cristtos on 24/01/2019 - 08:59

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

• 

  shrewdster on 24/01/2019 - 09:52

  +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.

  • 

    Gandalf the Thrifty on 24/01/2019 - 10:26

    +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.

    • 

      shrewdster on 24/01/2019 - 10:43

      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!?

• 

  bwilso06 on 24/01/2019 - 14:50

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

  • 

    pizzaguy on 24/01/2019 - 15:12

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

  • 

    cristtos on 24/01/2019 - 15:15

    +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/