SQL Bootcamp

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and 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.

Takeaways

 - Understand the differences between different data management systems for SQL databases 
 - Understand SQL vocabulary such as tables, schema, and functions 
 - Create basic SQL queries by applying Boolean logic, sorting functions, and commenting: 

• Basic SELECT-FROM-WHERE statements 
• LIMIT clauses 
• Math operations and constant expressions in SELECT statements 
• Booleans and complex conditions in the WHERE clause 
• Pattern matching in the WHERE clause 
• NULL values 
• JOIN operations
  Grouping and aggregations 
• HAVING clauses
• ORDER BY clauses 
• Subqueries

Preparations:

This bootcamp is designed for anyone interested in learning SQL. A basic technical aptitude and curiosity to learn new tools will make you successful. No prior knowledge of SQL is required.  

What to bring to class: 

All participants must bring their own laptops. Please also download and install Sqlectron.  

Note on installing Sqlectron: 

Mac users may need to allow installation of non-app-store programs in their System Preferences