SQL Bootcamp
When:
Saturday, Apr 28, 2018 10:00a -
5:00p
Saturday, Apr 28, 2018 10:00a -
5:00p
Where:
General Assembly
125 Summer Street, 13th Floor
Boston, Massachusetts 02110
Admission:
$299
Categories:
Business, Innovation, Lectures & Conferences, Tech
Event website:
https://generalassemb.ly/education/sql-bootcamp/boston/45860
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.
Important Note: Prior to class, you must have PostgreSQL and PGadmin installed. To do so, please follow the instructions for installation on our website.
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
-
SponsoredWBUR Earth Week Events
Tuesday, Apr 23, 2024 goes until 04/26
WBUR CitySpace at The Lavine Broadcast Center
-
SponsoredAffordable Spanish Classes in Boston (in-person and online courses) | BASE
Monday, May 06, 2024 goes until 05/25
Boston Area Spanish Exchange (BASE)
