Introduction to SQL and Data Analytics

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. Also, this workshop will teach you advanced concepts of databases as well as how to write effective SQL queries you can use in your everyday work. Going over the major topics a data scientist should know when working with databases. As well as all parts of the CRUD functions of data. The course will be highly interactive and engaging - questions are encouraged!

What to expect from this course

This workshop is for beginners. We will start with basic examples and gradually move toward more complex SQL queries. By the end of this workshop, you’ll know how to write SQL and work with databases to solve business problems and produce management reports.

What you will learn

• What databases are and why they are important
• The different “flavors” of databases.
• Statistical functions in SQL
• The four operations you can perform on data
• The fundamental parts of a SQL query
• Analytical queries: GROUP BY
• Subqueries and Joins

Things To Remember

• Please bring your own laptop to class.
• We will help you to install all the programs you need in class.
• If you withdraw one day before the course start date, any deposit paid will be refunded in full.
• If you cannot attend classes for which you were charged, you could join next cohort and make up the missed classes.