Vizuara Books
SQL Masterclass
From SELECT to window functions, then into Python and R.
A hands-on path from installing PostgreSQL to writing joins, window functions, and CTEs against a real DVD-rental database. Then connect SQL to Python and R, ship a capstone library app, and prep for interviews.
Read on your Kindle
We'll send this whole book straight to your Kindle — it opens natively, so you can resize the text, read fully offline, and it remembers where you left off. Nothing to download or manage.
Sending to Kindle is for subscribers — subscribe to read the whole library on your Kindle.
00Getting Started4 capsules
Getting Started — 4 chapters.
01Why SQL Still Runs the Worldintuitionfree13 min02What Is SQL? Declarative Queries vs Imperative Codeconcept🔒13 min03Installing PostgreSQL and pgAdmin 4code🔒13 min04Loading the DVD Rental Sample Databasecode🔒12 min01Database Foundations5 capsules
Database Foundations — 5 chapters.
05What Is a Database? Core Terminologyconcept🔒12 min06The Relational Model: Tables, Primary Keys, Foreign Keysconcept🔒14 min07Relational vs NoSQL: Two Ways to Store Dataintuition🔒13 min08ACID vs BASE: Guarantees a Database Makesdeep-dive🔒13 min09Data Types and Schema Designconcept🔒13 min02Basic SQL Commands7 capsules
Basic SQL Commands — 7 chapters.
10CREATE TABLE: Defining Your First Tablecode🔒14 min11INSERT: Putting Data Into Tablescode🔒13 min12SELECT: Reading Datacode🔒12 min13Filtering Rows with WHEREcode🔒13 min14Sorting and Limiting: ORDER BY and LIMITcode🔒11 min15UPDATE and DELETE: Changing Data Safelycode🔒13 min16Aggregation: COUNT, SUM, GROUP BY, and HAVINGcode🔒14 min03Advanced SQL: Joins and Window Functions6 capsules
Advanced SQL: Joins and Window Functions — 6 chapters.
17Joins, Intuitively: Combining Tablesintuition🔒12 min18INNER, LEFT, RIGHT, and FULL OUTER JOINcode🔒14 min19Window Functions: RANK vs DENSE_RANKdeep-dive🔒11 min20OVER and PARTITION BY: The Window Frameconcept🔒12 min21Pattern Matching with LIKE and Wildcardscode🔒13 min22Subqueries and CTEs (WITH)code🔒13 min04Solving Advanced SQL Problems4 capsules
Solving Advanced SQL Problems — 4 chapters.
23A Framework for Hard Queriesintuition🔒13 min24Worked Problem: Replace Employee ID with Its Identifierproject🔒13 min25Worked Problem: Product Sales Analysisproject🔒13 min26Worked Problem: Rank Scoresproject🔒12 min05SQL with Python and R5 capsules
SQL with Python and R — 5 chapters.
27Connecting Python to PostgreSQL with psycopg2code🔒14 min28From Query to DataFrame: Analyzing in Pandascode🔒13 min29Visualizing SQL Data in Pythonproject🔒12 min30Connecting R to PostgreSQL with DBI and RPostgrescode🔒13 min31Visualizing SQL Data in R with ggplot2project🔒13 min06Capstone and Interview Prep5 capsules
Capstone and Interview Prep — 5 chapters.
32Capstone: Designing the Library Databaseproject🔒13 min33Capstone: CRUD Operations from Pythonproject🔒13 min34Query Optimization and Indexesdeep-dive🔒12 min35SQL Interview Tips and Tricksintuition🔒14 min36Putting It All Togetherconcept🔒15 minRatings & reviews
No ratings yet. Yours would be the first.