Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Note: This course is a subset of our much longer course 'From 0 to 1: SQL and Databases' so please don't sign up for both:-)
All too often, we write queries by copy-pasting from other queries that some friend or colleague copy-pasted from somewhere. We often don't appreciate the nitty-gritty, and are left with vaguely uncomfortable each time we try to change our query - and clueless when our queries don't run, or when they return unexpected results.
Joins are probably the most useful type of queries out there. They are the glue that bind together tables in a database, that connect the dots.
Once we understand - really understand - joins, even very complex queries start to make sense. And that's why this course is all about joins, with examples in MySQL to drive home the theory.
Mail us about anything - anything! - and we will always reply :-)
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Joins: Connecting the Dots!|
You, This Course, and Us!Preview
|The full power of databases emerges when we link tables - and Joins are the way to accomplish this|
|Cross Joins are conceptually simple, which is great, because they are the underpinning of Inner Joins|
|Inner Joins are your best friend. Understand them for what they are: cross joins with a filter condition.|
Outer Joins are really useful if used right. They are a little tricky though - understand how they work, and why you should not be surprised to see NULLs in the result of an outer join.
|Once we've understand Inner and Outer joins, Natural Joins are easy-peasey|
|MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition|
|Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it.|
|Let's get our feet wet - create a database, use that database, create a simple table, and bulk load a file into that table|
|That first table was a bit simplistic - no constraints. Now let's do a more involved example, and harness the full power of the Bulk Uploader.|
Let's create a new table, this time using the Inner Join operator to seed it.
|Let's create a table twice - once using Inner Join, and once using Outer Join. Guess what the difference is?|
Loonycorn is us, Janani Ravi, Vitthal Srinivasan, Swetha Kolalapudi and Navdeep Singh. Between the four of us, we have studied at Stanford, IIM Ahmedabad, the IITs and have spent years (decades, actually) 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
Swetha: Early Flipkart employee, IIM Ahmedabad and IIT Madras alum
Navdeep: longtime Flipkart employee too, and IIT Guwahati alum
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 :-)