From 0 To 1:SQL And Databases - Heavy Lifting

Your bodyguard for when data gets too big, this course is strong but friendly, funny yet deep, animated yet thoughtful.

4.60 (189 reviews)

Udemy

platform

English

language

Data & Analytics

What you will learn

Explore large datasets and uncover insights - going far beyond the Excel, deep into the data

Model and create a database for day-to-day use

Interface with databases from a programming language such as Python

Have the comfort and confidence needed to load data and use both GUI and a command line interface for database operations

Fully understand and leverage joins, subqueries, aggregates, indices, triggers, stored procedures and other major database concepts

Why take this course?

Prerequisites: No prerequisites are needed for the SQL commands and DBMS fundamentals. Basic knowledge of programming in Python would be helpful if you want to run the source code in the course-ending project.

Taught by Stanford-educated, ex-Googlers. This team has decades of practical experience in quant trading, analytics and e-commerce.

Your bodyguard for when data gets too big, this course is strong but friendly, funny yet deep, animated yet thoughtful.

Let’s parse that.

Your bodyguard for when data gets too big: Most business folks (and quite a few engineers) use Excel as a basic tool of decision making and modeling, but when you can't fit the data you'd like into an Excel spreadsheet that you can easily open, its time to move to a database.

The course is strong but friendly: This course will help you move to a database without being intimidated by the new environment. Don't let anyone tell you that any dataset is too large or too complicated for you to understand (and people will try, most likely)

The course is funny yet deep: It goes really deep into the topics that folks often find hard to understand, such as joins, aggregate operators and interfacing with databases from a programming language. But it never takes itself too seriously:-)

The course is very visual : most of the techniques are explained with the help of animations to help you understand better.

This course is practical as well : Queries are explained in excruciating detail, indices are demystified, and potentially career-limiting traps (Drop, Alter) are marked with bright yellow tape markers so you can steer clear.

The course is also quirky. The examples are irreverent. Lots of little touches: repetition, zooming out so we remember the big picture, active learning with plenty of quizzes. There’s also a peppy soundtrack, and art - all shown by studies to improve cognition and recall.

What's Covered:

SQL In Great Depth

Database Fundamentals and Just Enough Theory

Practical Examples - Queries in MySQL and SQLite, and code in Python

Screenshots

From 0 To 1:SQL And Databases - Heavy Lifting - Screenshot_01

From 0 To 1:SQL And Databases - Heavy Lifting - Screenshot_02

From 0 To 1:SQL And Databases - Heavy Lifting - Screenshot_03

From 0 To 1:SQL And Databases - Heavy Lifting - Screenshot_04

Reviews

Krishnakumar

October 23, 2017

Awesome videos !!! Just the right pace, and very thorough course as well. Worth every paise I paid! Half way through, hope it continues the same way till completion.

Scott

August 15, 2017

First 40% is great, then it goes completely from beginner and constant concept reinforcement to absolutely nothing being explained properly. It was really jarring. The guy from that point is a very bad instructor.

July 18, 2017

great course, liked step by step breakdown of queries. think you might want to have spent just another 5 minutes on section 6 lesson 44.

Ted

May 24, 2017

In the first and second sections, many basics were covered, and it was very good to get this information. In the third section, almost all of the information was very valuable. However, the last two touched on things that I had no understanding of, and I didn't feel were well explained. More because I had no idea what it was about than because I didn't understand them. In the 4th section, a table was used that was not normalized, and it was not mentioned to be a bad table. But, it fit the examples that were given, so it ends up okay that it is used. Going through the 4th section, a mention of joins occurred. A bit randomly. But, in the 5th section, everything was mentioned that I was hoping for and all of it started to make sense. Overall, I am enjoying how detailed this series of lectures are. It has lots of wonderful information. I hope that I can learn more and get a lot of good from this.

Sushil

December 26, 2016

Excellent Course & Very Precise! If possible please add course contents resource wherever its missing. Thank You Loony Team :)

Tom

November 26, 2016

Teaches concepts clearly, but very slowly. Would be better to have challenge questions/answers associated with each lesson.

Markus

September 28, 2016

Fantastic course: comprehensive, very clear and detailed. I found the few advanced examples on 'applied sql' especially helpful (e.g. the Python db section). Would like to know also: How to best handle boolean flags in table design ?

Mathieu

September 2, 2016

Very hard to understand the male teacher I really wished it was the female very clear and easy to learn but stored procedures, populating a table with a sub query and triggers all important topics but I wasn't able to understand. Please add the female teacher on these topics I would rate 5 star if so.

Mark

July 20, 2016

The course is simply incredible. The content and its delivery stands out big time. @prospective students - I highly recommend this course as it's better in all aspects as compared to any other course on the topic of Databases/SQL by a margin. @LooneyCorn Team - Keep up the brilliant job! Keep rocking!!!

Maneesh

July 3, 2016

So far finished section 1 and 2. Basis concepts of DB are explained in very good manner , and in very organised way. Information goes into brain very smoothly. Lets see remaining sections. done with section 3 . I must say,its very well explained.concepts such as constraints , keys ,insert ,create statements are covered in great detail. What i also like is the way , author brushes up some previous sections covered , when explaining next sections that may require that information.We usually tend to forget ,or need to look up again.So like that thing too. Lets see how other section goes.

Hanif

May 31, 2016

Thank you very much for putting together an easy to understand course on DB. Exactly what I'm looking for to learn and understand DB.

Monika

April 13, 2016

They clearly put a lot of effort into creating this course - however, I was looking for less theory and general talk about data. Therefore, it was frustrating to wade through many lectures before I could start learning keystrokes. Also - at least for me - there's an issue with the sound in all of the recordings - it cuts out every few seconds for a moment which made listening hard and that was the final straw that caused me to ditch this course. (I'm not having the sound issue with any of the other classes I'm taking on Udemy.) That said, if you are looking for a very thorough course with theory and lots of talk about databases I'm sure you'll find this to be a good course for you.

Graham

April 7, 2016

This is a solid effort, and I would recommend taking the course. I do think it would be helpful if the tables in the example database were more complete and had more rows. And since most people learn SQL for on the job reasons, I found those example problems to be the most useful. Overall, the course was very insightful and you will know your way around SQL queries, including advanced concepts.

RobertoDub

March 15, 2016

Hard to understand some concepts where multiple arguments are added at the same time (e.g. lecture 19 is a nightmare). However, other lectures are clear despite explaining complex topics (e.g. table creation, date calculations etc.). So far, not bad, potentially a 4-5 star course, will get back to this review later.

Omkar

January 26, 2016

I signed up immediately and straight away watched the sections on outer joins and normal forms. Best explanation I have ever seen for these topics. Finally I understood them.

Charts

Price

Rating

Enrollment distribution

From 0 To 1:SQL And Databases - Heavy Lifting - Distribution chart