| |
|
|
| |
EVENT DETAILS |
About This Workshop
SQL is a powerful language, & tool, for data analysis & data handling. In this bootcamp, you'll dive deep into SQL syntax & database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence.
Prereqs & Preparation
A basic technical aptitude, orientation to computers, & curiosity to learn new tools will make you successful in this bootcamp. No prior knowledge of SQL is required.
Prior to class:
Watch this Introduction to SQL video.
Download the DB Browser that is compatible with your operating system.
Takeaways
Understand SQL vocabulary such as tables, schema, functions & JOINS.
Understand the differences between different data management systems for SQL databases.
Create basic SQL queries by applying Boolean logic, sorting functions, & commenting.
Apply SQL aggregate functions [MIN, MAX, SUM, AVG, COUNT].
Use CAST to change a column's type for a query.
Use advanced SQL commands [OR, GROUP BY, HAVING] & conditional operators [ =,!=,>,<, IN, NOT IN, & BETWEEN] to filter data.
Apply string, date, & math functions to manipulate how data is presented.
Apply UNION to tables & columns for merging data.
Use JOINS to create relationships between tables to obtain data.
About the Instructor
Craig Sakuma
Data Scientist,
Euclid Analytics
Craig is a data scientist at Euclid Analytics where he applies machine learning algorithms to measure customer traffic at brick & mortar stores. Prior to working as a data scientist, Craig has been a founder of a start-up & a corporate strategy consultant. He has an MBA from Wharton & an engineering degree from Northwestern University.
|
|
|
|
|
|
