$150

Bitmaker General Assembly: SQL Bootcamp

Event Information

Share this event

Date and Time

Location

Location

Bitmaker General Assembly

220 King St W

2nd Floor

Toronto, ON M5H1K4

Canada

View Map

Event description

Description





About this workshop

SQL provides powerful but reasonably simple tools for data analysis and handling. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. We will use a combination of lecture and in-class exercises to ensure that students leave with a working grasp of SQL fundamentals.

Takeaways

Background on SQL
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


What you need to be ready for the class

  • Basic technical aptitude and orientation to computers
  • Curiosity to learn new tools
  • Willingness to learn about a text-based/principle driven analytic tool with little real GUI support, and determination to push through the natural frustration of confronting new concepts.

    Please install the latest version of SQLElectron prior to class.

[[AN]]

Share with friends

Date and Time

Location

Bitmaker General Assembly

220 King St W

2nd Floor

Toronto, ON M5H1K4

Canada

View Map

Save This Event

Event Saved