Space is limited
Course logo

Intermediate SQL

This course provides a hands-on, comprehensive foundation that will leave you ready to use SQL in your daily work. You'll learn how to manipulate tables, query multiple tables, and complete complex subqueries and joins. By the end of this course your SQL skills will be ready for action on real-world projects, and you'll also be prepared to further dive into even more advanced topics.

Instructor profile photo
Srinivasan (Sesh) Seshadri
former Engineering Leader at Google, Target, Bell Labs
Real-world projects that teach you industry skills.
Learn alongside a small group of your professional peers
Part-time program with 2 live events per week:
Lecture
Monday @ 5:00 PM UTC
Project Session
Wednesday @ 4:00 PM UTC
Next Cohort
March 27, 2023
Duration
4 weeks
Price
US$ 400
or included with membership

Course taught by expert instructors

Instructor Photo
Affiliation logo

Srinivasan (Sesh) Seshadri

former Engineering Leader at Google, Target, Bell Labs

Sesh is an academician, entrepreneur and a seasoned technologist focused on Data, AI and ML. He was Founder and CEO of Strand Life Sciences (now owned by Reliance Life Sciences), Founding CTO of Kosmix (acquired by Walmart), and Founder and CEO of Zettata (acquired by Target). Sesh has been an executive at several companies including Google, Target, Yahoo and Lucent Technologies, as well as in academia at IIT Bombay and UC Berkeley. Sesh has several patents and publications in the broad areas of Data Management and Machine Learning. Sesh has a Bachelors in Computer Science from IIT Madras and an MS and PhD from University of Wisconsin, Madison.

The course

Learn and apply skills with real-world projects.

Who is it for?
  • Non-Engineers whose roles increasingly require requesting and interacting with data - including data analysts, business analysts, product and program managers.

  • Engineers who are not familiar with SQL but would benefit from querying databases. This includes data scientists, front-end engineers, and core infrastructure engineers.

Prerequisites
  • Basic SQL knowledge (as covered in SQL Crash Course) is recommended but not required.

  • Some experience with tabular data and spreadsheets is recommended but not required.

Not ready?

Try these prep courses first

Learn
  • Review: Tables Basics & Simple Queries
  • Creating a Table and Inserting Rows
  • Altering Tables - Deleting and Updating Rows
  • Group By & Having Clauses
Learn
  • NULL Values
  • Datetime Operations
  • NULLS and Aggregate Functions
  • String Operations
  • Case Statement
Learn
  • How Joins Work
  • Cross Products
  • Foreign Keys
  • Combining Joins with Other SQL Clauses
  • Going Beyond Primary Key/Foreign Key Joins
  • Joins Involving More Than Two Tables
Learn
  • Outer Joins
  • Outer Joins on More Than Two Tables
  • Union, Union All
  • Intersect, Except
  • Subquery in the From Clause

Real-world projects

Work on projects that bring your learning to life.
Made to be directly applicable in your work.

Live access to experts

Sessions and Q&As with our expert instructors, along with real-world projects.

Network & community

Core reviews a study groups. Share experiences and learn alongside a global network of professionals.

Support & accountability

We have a system in place to make sure you complete the course, and to help nudge you along the way.

Course success stories

Learn together and share experiences with other industry professionals

The CoRise SQL course was fantastic. It took me from very little SQL knowledge to being able to answer questions within my own company's database. While this is an intro course, it is a great place to start a journey into learning SQL.

Jordan M.Digital Optimization at YNAB

The structure and accountability of this course was fabulous! It pushed me to complete the course in a set amount of time, interact with other participants, and speak up in lectures and office hours. I would definitely recommend CoRise to my friends and colleagues!

Amanda G.Analyst at YNAB

I appreciated Sesh's dedication to everyone in the SQL course, and the fact that he incorporated feedback to make sure that the course was most effective.

Jason DexterAnalytics Engineer, Sr. Data Analyst

The way this course is organized is excellent! CoRise is a great learning platform with wonderful support always available.

Sara DoyenSpecialist, Trust & Safety - Community Defense, Door Dash

One of the best decisions I have made on my journey so far was becoming involved in the CoRise community. There is something here for everyone, experienced and novice! This is an awesome platform to learn on, the support is exceptional, and I never feel like I'm on my own.

Crystal BeltonMortgage Loan Originator, Interfirst Mortgage Company

Frequently Asked Questions

Still not sure?

Get in touch and we'll help you decide.

Keep in touch for updates, discounts, and new courses.

Questions? Ask us anything at hello@corise.com

© 2021-2022 CoRise Education