Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 14.5 hours on-demand video
  • 136 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence SQL

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.
Rating: 4.3 out of 54.3 (178 ratings)
4,604 students
Created by Loony Corn
Last updated 11/2017
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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

Requirements

  • This course will cover generic (non-system-specific) SQL, but will also conduct exercises using 2 different database technologies: MySQL and SQLite. Installation and use of both these will be explained in-depth

Description

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

Who this course is for:

  • Yep! Data analysts who would like to really get down and dirty with the data
  • Yep! Business folks and executives looking to make their decision making more data-driven, and seeking the technical knowledge to do so.
  • Yep! Students of Computer Science and Computer Engineering looking to understand database concepts for the first time
  • Yep! Software engineers who need to understand and interface with databases from programming languages in their work

Course content

11 sections • 68 lectures • 14h 24m total length

  • Preview18:20
  • Preview19:56
  • MySQL - Installed and Introduced (Mac OS X)
    07:03
  • Setting up MySQL and the Workbench (Mac OS X)
    17:32
  • MySQL Server and Workbench installed (Windows)
    06:31
  • Preview15:14
  • Identifying Entities Using Keys
    13:41
  • The Entity Relationship (E-R) Model - Entities And Attributes
    05:43
  • Relationships - What Connects Entities
    05:51
  • Cardinality Of Relationships
    09:10
  • The Entity Relationship (E-R) Model - Relationships
    09:50
  • Mapping E-R Theory to the world of databases
    13:26

  • Preview19:52
  • Introducing The SELECT Statement
    11:13
  • Quotes and NULLS - Avoid The Gotchas
    13:52
  • Simple Examples
    14:49
  • More Simple Examples
    13:21
  • Using the Like Operator
    08:09
  • Between, In and Not In
    18:12
  • A Multi-Column Select
    10:27
  • Working with Dates (MySQL As Example)
    11:23

  • Preview14:06
  • Column Subtleties: Null, Primary Key and Auto-Increment
    14:42
  • An Example - Sales Data
    12:36
  • Insert Table - Examples
    19:24
  • More Insert Table Examples
    09:13
  • Referential Integrity Introduced
    19:54
  • Creating a Database and Using It
    17:25
  • An Involved Bulk Loading Example
    14:14

  • Preview18:15
  • The Group By Clause
    17:19
  • More Group By Examples
    19:46
  • Order By
    16:15
  • Having
    19:52
  • Limit
    07:12
  • Count and Count Distinct
    08:19

  • Preview09:54
  • 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

  • Preview07:06
  • Union, Union All, Intersect and Except.
    19:32
  • Query-In-A-Query
    13:53
  • Inserting Via Subqueries
    09:42
  • Use A Subquery To Populate A Table
    06:49
  • Outer Join And Inner Join: A Little Test
    08:59

  • Not NULL constraints
    10:07
  • Primary Keys
    09:43
  • Foreign Key Constraints
    13:27
  • Deletes and Updates With Foreign Key Constraints
    12:05
  • Check Constraints
    01: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
    05:36

  • Preview11:58
  • More Practical Design Tips
    10:44
  • Normal Forms - Friends Once You Know Them
    10:28

  • Preview06:46
  • SQLite works right out of the box
    06:27
  • 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

Instructor

Loony Corn
An ex-Google, Stanford and Flipkart team
Loony Corn
  • 4.2 Instructor Rating
  • 21,351 Reviews
  • 127,149 Students
  • 73 Courses

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 complicated tech courses in a funny, practical, engaging way, which is why we are so excited to be here on Udemy!

We hope you will try our offerings, and think you'll like them :-)

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.