Introduction To SQL And Data Analysis

This is a past event

Needs a location

Details

This workshop meets 3 times, total - 9hrs, Paid course for complete beginners.

Wed, July 31st, 6:00 p.m. - 9:00 p.m.
Wed, August 7th, 6:00 p.m. - 9:00 p.m.
Wed, August 14th, 6:00 p.m. - 9:00 p.m.

Learn More and RSVP Here http://bit.ly/IntroductionSQL

ABOUT THE COURSE

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 WILL YOU 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