SQL 2-Day Intensive Workshop | In Person | New York City
About this workshop series
The SQL 2-Day Intensive Workshop covers the curriculum of our SQL 1-Day Fundamentals Workshop and our SQL 1-Day Advanced Workshop .
SQL is a powerful language, and tool, for data analysis and data handling. In this intensive, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This course will take absolute beginners through the basics of SQL to an ability to write queries with confidence.
This 12-hour SQL 2-Day Intensive Workshop is the interactive and hands-on way to get started on learning to leverage your data. You will dive head first into SQL, skill up with exercises, and by the end of the day you'll know how to ask — and answer — the right questions of your data sets.
Takeaways
- Understand SQL vocabulary such as tables, schema, functions and JOINS.
- Understand the differences between different data management systems for SQL databases.
- Create basic SQL queries by applying Boolean logic, sorting functions, and 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] and conditional operators [ =,!=,>,
Prereqs & Preparation
A basic technical aptitude, orientation to computers, and curiosity to learn new tools will make you successful in this bootcamp. No prior knowledge of SQL is required.
Prior to class: Download the DB Browser that is compatible with your operating system.
Regulatory Information:
