Intro to SQL
4 weeks β€” US$ 400
Not ready? for new sessions.
Space is limited
Course logo

Intro to SQL

This course provides an introduction to SQL, a programming language that will unleash your ability to explore data. We'll cover all the fundamentals of SQL, and you'll leave knowing how to issue SQL queries and interact with databases, as well as how to translate English queries to SQL correctly and quickly. We'll approach SQL in a hands-on manner with real-life examples and we'll build complexity in our SQL queries week over week.

Instructor profile photo
Srinivasan (Sesh) Seshadri
former Engineering Leader at Google, Target, Bell Labs
Price
US$ 400
Course Duration
4 weeks
Start Date
July 25
Registration By
July 22
Lecture
Monday @ 4:00 PM UTC
Project Sessions
Wednesday @ 4:00 PM UTC or
Thursday @ 12:00 AM UTC
Learn alongside a small group of your professional peers
Connect with experts through live sessions and office hours
Real-world projects that teach you industry skills.
Created and taught by
Instructor Photo
Link to an instructor's LinkedIn profile

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. Sesh has been a part of several startups - he was the founder and CEO of Strand Life Sciences (now owned by Reliance Life Sciences), founding CTO of Kosmix (acquired by Walmart), founder and CEO of Zettata (acquired by Target). Sesh has been an executive at several companies such as Google, Target,Yahoo and Lucent Technologies and at IIT Bombay, Bell Labs as well as UC Berkeley as a researcher. Sesh has several patents and publications in the broad areas of Data Management and Machine Learning.

Sesh got his undergraduate degree in Computer Science from IIT Madras and his MS and Phd from University of Wisconsin, Madison.

Affiliation logo
The course

As data has exploded, there has been a rise in visualization tools that make data available to business analysts, data analysts, product managers, program managers, and data scientists. Despite these advances, there are always ad-hoc questions that cannot be answered without the ability to manipulate and retrieve data. People who are able to self-serve their data curiosity needs by formulating their own SQL queries are going to be far more effective in organizations than those who don't have these skills.

This course is intended for anyone in a function where quick access to data will make them much more productive, which is almost everyone today! Specifically, people whose job it is to collate, analyze, and present data such as business and data analysts, data scientists and statisticians, and product and program managers. There are no prerequisites for this course other than a desire to dig into data.

The course will cover the most important aspects of SQL that you'll need on a daily basis, and will leave you well equipped to learn some of the more advanced SQL concepts and functionality. We'll cover the fundamentals of SQL including how to filter, aggregate, and join rows of tables as well as how to create and update your own tables. The course will be largely hands-on and example-driven -- we'll learn by actively participating and collaborating together.

1
Week 1
Basics of SQL on a Single Table
Learn
  • Introduction to a table, row, column, schema and data types
  • Creating a table and inserting rows into a table
  • Filtering
  • NULL Values
Project
Write SQL queries in which you learn how to filter, aggregate, and deal with NULL values. Come up with your own queries based on tables provided, and modify the data in the table so queries have certain properties. Come up with your own table for an application of choice and develop queries to run on that table.
    2
    Week 2
    Complex Queries on a Single Table
    Learn
    • Operators and Functions
    • GROUP BY clause
    • HAVING clause
    Project
    Write SQL queries using the topics covered this week (Operators and Functions, GROUP BY, HAVING). Come up with queries and your own data that satisfies certain properties.
      3
      Week 3
      Queries on Multiple Tables
      Learn
      • Primary Keys and Foreign Keys
      • Introduction to Normalization
      • Cross Join, Inner Join and Outer Join
      Project
      Take a table and split it into multiple tables so there is no redundancy in the data. Write SQL queries that involve multiple tables.
        4
        Week 4
        Complex SQL Queries
        Learn
        • Subqueries, EXISTS, NOT EXISTS
        • Subqueries vs Joins
        • Altering Tables, Deleting, and Updating Rows
        Project
        Write complex SQL queries that involve multiple tables and subqueries. Write the same English query as a subquery as well as a single query with a Join.
          This course is for...

          Non Engineers who want to play with data and are curious about data, including data analysts, business analysts, product and program managers.

          Engineers who are not familiar with SQL, but would greatly benefit from quick interactive ad-hoc querying of databases. This could include data scientists, front end engineers, and core infrastructure engineers.

          Prerequisites

          None other than data curiosity

          Some experience with tabular data and spreadsheets is nice to have

          Please note: if you use SQL regularly, this course may be too introductory for you.

          We will not cover core database concepts such as query performance that would require you to understand secondary indexes, query plans and how query optimizers typically behave.

          Course experience

          Live Sessions with Experts

          Top industry leaders teach you everything you need in only 4 weeks

          Interactive Learning

          Real-world projects put your learning into immediate action

          Professional Communities

          Grow your network by learning with an intimate cohort of peers from top companies
          ?
          Frequently Asked Questions
          Stay in the loop
          Keep in touch for updates, discounts, and new course sessions.
          Backed by top VCs, including
          VCs
          Teach
          Share your unique expertise with the world.
          Enterprise
          Receive best-in-class skills training for your teams and organization.
          Careers
          Join us as we change the future of online education.
          Β© 2021 - 2022 Corise Education. Terms of Service. Privacy Policy.
          Questions? Email us atΒ hello@corise.com