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.
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.
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.
- Introduction to a table, row, column, schema and data types
- Creating a table and inserting rows into a table
- Filtering
- NULL Values
- Operators and Functions
- GROUP BY clause
- HAVING clause
- Primary Keys and Foreign Keys
- Introduction to Normalization
- Cross Join, Inner Join and Outer Join
- Subqueries, EXISTS, NOT EXISTS
- Subqueries vs Joins
- Altering Tables, Deleting, and Updating Rows
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.
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.
