From 0 To 1: Heavy Lifting with SQL & Databases

From 0 To 1: Heavy Lifting with SQL & Databases

14.5 Hours
Deal Price$19.00
Suggested Price
$49.00
You save 61%
From 0 To 1: Heavy Lifting with SQL & Databases
$19.00$49.0061% OFF
From 0 To 1: Heavy Lifting with SQL & Databases

67 Lessons (14.5h)

  • Introduction To Databases
    Data Is A Big Deal
    Why Do We Need A Database?
    MySQL - Installed and Introduced (Mac OS X)
    Setting up MySQL and the Workbench (Mac OS X)12:47
    MySQL Server and Workbench installed (Windows)6:31
    Entities And Attributes - Things And Stuff Which Describe Them
    Identifying Entities Using Keys
    The Entity Relationship (E-R) Model - Entities And Attributes
    Relationships - What Connects Entities
    Cardinality Of Relationships
    The Entity Relationship (E-R) Model - Relationships
    Mapping E-R Theory to the world of databases
  • Going From Relations To Database Tables
    Introducing The SELECT Statement
    Columns Have Data Types
    Quotes and NULLS - Avoid The Gotchas
    Simple Examples
    More Simple Examples
    Using the Like Operator
    Between, In and Not In
    A Multi-Column Select
    Working with Dates (MySQL As Example)
  • Creating Tables And Inserting Data Into Them
    Creating Database, Use Database and Create Table
    Column Subtleties: Null, Primary Key and Auto-Increment
    An Example - Sales Data
    Insert Table - Examples
    More Insert Table Examples
    Referential Integrity Introduced
    Creating a Database and Using It
    An Involved Bulk Loading Example
  • Back To Retrieving Data - More Advanced Queries Using Group By
    Aggregation Operators Introduced
    The Group By Clause
    More Group By Examples
    Order By
    Limit
    Count and Count Distinct
  • Joins - Don't Let Them Intimidate You! They're All Fuzzy And Nice
    Introduction To SQL Joins
    Cross Joins aka Cartesian Joins
    Inner Joins
    Left Outer Joins
    Right, Full Outer Joins, Natural Joins, Self Joins
    Having
  • Subqueries: Layering The Cake
    Subqueries Introduced
    Union, Union All, Intersect and Except.
    Query-In-A-Query13:53
    Inserting Via Subqueries
    Use A Subquery To Populate A Table
    Outer Join And Inner Join: A Little Test
  • Constraints
    Not NULL constraints
    Primary Keys9:43
    Foreign Key Constraints
    Deletes and Updates With Foreign Key Constraints
    Check Constraints
  • Somewhat More Advanced Concepts
    Indices
    Stored Procedures
    Triggers
    Transactions
    Handle with Care: Update and Delete
    Handle with Care: Alter and Drop
    Views, Temporary Tables, and User Priviliges
  • Table Design: Theory And Practice
    Practical Tips for Table Designs that you won't regret!
    More Practical Design Tips
    Normal Forms - Friends Once You Know Them
  • Putting It Together: Database Programming In Python
    Interfacing with Databases from Python
    SQLite works right out of the box
    Build a database of Stock Movements - I
    Build a database of Stock Movements - II
    Build a database of Stock Movements - III
From 0 To 1: Heavy Lifting with SQL & Databases
$19.00$49.0061% OFF
View similar items
DescriptionInstructorImportant DetailsRelated Products

Become a SQL Pro -- Conduct Exercises Using MySQL & SQLite

LC
Loony CornLoonycorn is comprised of four individuals—Janani Ravi, Vitthal Srinivasan, Swetha Kolalapudi, and Navdeep Singh—who have honed their tech expertise at Google and Flipkart. The team believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students. For more details on this course and instructor, click here.

Description

Most businesses use Excel as a basic tool for decision making and modeling, but what happens when you have too much data to use an Excel spreadsheet? It's time to move to a database. This course will help you make the move without being intimidated by the new environment. You'll dive deep into seemingly complex topics like joins, aggregate operators, and interfacing with databases.
  • Study SQL in depth w/ 67 lectures & 14 hours of content
  • Learn queries in detail & steer clear of career-limiting mistakes
  • Get help from quirky learning tools: repetition, zooming out to remember the big picture, quizzes, a peppy soundtrack & art
  • Study database fundamentals & "just enough" theory
  • Explore large datasets & uncover insights
  • Model & create a database for day-to-day use
  • Interface with databases from a programming language such as Python
  • Load data & use both GUI and a command line interface for database operations

Specs

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...