Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
68 Videos (14h 24m)
    • Data Is A Big Deal

      18:20
    • Why Do We Need A Database?

      19:56
    • MySQL - Installed and Introduced (Mac OS X)

      7:03
    • Setting up MySQL and the Workbench (Mac OS X)

      17:32
    • MySQL Server and Workbench installed (Windows)

      6:31
    • Entities And Attributes - Things And Stuff Which Describe Them

      15:14
    • Identifying Entities Using Keys

      13:41
    • The Entity Relationship (E-R) Model - Entities And Attributes

      5:42
    • Relationships - What Connects Entities

      5:50
    • Cardinality Of Relationships

      9:10
    • The Entity Relationship (E-R) Model - Relationships

      9:50
    • Mapping E-R Theory to the world of databases

      13:26
    • Introducing The SELECT Statement

      19:52
    • Introducing The Column Data Types P2

      11:13
    • Quotes and NULLS - Avoid The Gotchas

      13:52
    • Simple Examples

      14:49
    • More Simple Examples

      13:21
    • Using the Like Operator

      8:09
    • Between, In and Not In

      18:12
    • A Multi-Column Select

      10:27
    • Working with Dates (MySQL As Example)

      11:23
    • Creating Database, Use Database and Create Table

      14:06
    • Column Subtleties: Null, Primary Key and Auto-Increment

      14:41
    • An Example - Sales Data

      12:36
    • Insert Table - Examples

      19:24
    • More Insert Table Examples

      9:13
    • Referential Integrity Introduced

      19:54
    • Creating a Database and Using It

      17:25
    • An Involved Bulk Loading Example

      14:14
    • Aggregation Operators Introduced

      18:15
    • The Group By Clause

      17:19
    • More Group By Examples

      19:46
    • Order By

      16:15
    • Having

      19:52
    • Limit

      7:12
    • Count and Count Distinct

      8:19
    • Introduction To SQL Joins

      9:53
    • Cross Joins aka Cartesian Joins

      17:02
    • Inner Joins

      19:52
    • Left Outer Joins

      15:31
    • Right, Full Outer Joins, Natural Joins, Self Joins

      16:08
    • Subqueries Introduced

      7:06
    • Union, Union All, Intersect and Except.

      19:32
    • Query-In-A-Query

      13:48
    • Inserting Via Subqueries

      9:42
    • Use A Subquery To Populate A Table

      6:49
    • Outer Join And Inner Join: A Little Test

      8:59
    • Not NULL constraints

      10:07
    • Primary Keys

      9:43
    • Foreign Key Constraints

      13:27
    • Deletes and Updates With Foreign Key Constraints

      12:05
    • Check Constraints

      1:39
    • Indices

      16:47
    • Stored Procedures

      10:26
    • Triggers

      11:38
    • Transactions

      13:07
    • Handle with Care: Update and Delete

      13:26
    • Handle with Care: Alter and Drop

      12:37
    • Views, Temporary Tables, and User Priviliges

      5:36
    • Practical Tips for Table Designs that you won't regret!

      11:58
    • More Practical Design Tips

      10:44
    • Normal Forms - Friends Once You Know Them

      10:28
    • Interfacing with Databases from Python

      6:46
    • SQLite works right out of the box

      6:26
    • Build a database of Stock Movements - I

      15:01
    • Build a database of Stock Movements - II

      13:48
    • Build a database of Stock Movements - III

      13:22
    • [For Linux/Mac OS Shell Newbies] Path and other Environment Variables

      8:25

About This Class

855b4788

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

1

Student

--

Projects

0

Reviews (0)

Janani Ravi Vitthal Srinivasan

An ex-Google, Stanford and Flipkart team

Loonycorn is us, Janani Ravi and Vitthal Srinivasan. Between us, we have studied at Stanford, been admitted to IIM Ahmedabad and have spent years working in tech, in the Bay Area, New York, Singapore, and Bangalore.

Janani: 7 years at Google (New York, Singapore); Studied at Stanford; also worked at Flipkart and Microsoft

Vitthal: Also Google (Singapore) and studied at Stanford; Flipkart, Credit Suisse and INSEAD too

We think we might have hit upon a neat way of teaching ...

See full profile