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
November 14, 2022
Duration
3 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.

Project
Apply concepts to create, manipulate, and extract information from a real-world dataset.
    Learn
    • Review: Tables Basics & Simple Queries
    • Creating a Table and Inserting Rows
    • Altering Tables - Deleting and Updating Rows
    Project
    Split a single table into multiple tables so that there is no redundancy in data, and write queries that involve working with multiple tables.
      Learn
      • Primary Keys and Foreign Keys
      • Introduction to Normalization
      • CROSS JOIN, INNER JOIN, and OUTER JOIN
      Project
      Combine all of your knowledge to complete an advanced project using skills from every module of the course.
        Learn
        • Subqueries, EXISTS, NOT EXISTS
        • Subqueries vs. Joins
        • CTE

        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 a fantastic crash course. 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 Dexter Analytics Engineer

        This course is 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.

        Frequently Asked Questions

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

        Questions? Ask us anything at hello@corise.com

        © 2021-2022 CoRise Education