From 0 To 1: Heavy Lifting with SQL & Databases

From 0 To 1: Heavy Lifting with SQL & Databases

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

67 Lessons (14.5h)

  • Introduction To Databases
  • Going From Relations To Database Tables
  • Creating Tables And Inserting Data Into Them
  • Back To Retrieving Data - More Advanced Queries Using Group By
  • Joins - Don't Let Them Intimidate You! They're All Fuzzy And Nice
  • Subqueries: Layering The Cake
  • Constraints
  • Somewhat More Advanced Concepts
  • Table Design: Theory And Practice
  • Putting It Together: Database Programming In Python
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...