SQL Bootcamp

When:
Saturday, Jul 15, 2017 10:00a -
5:00p

Where:
GA Boston
125 Summer St 13th Floor
Boston, MA 02110

EventScheduled OfflineEventAttendanceMode

Admission:
FREE

Categories:
Business, Tech

Event website:
https://generalassemb.ly/education/sql-bootcamp/boston/36412

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 below for installation.


https://docs.google.com/document/d/1EAy1i-SMVJOViOSF5XxJltW70C5cEP77RnvwbqLk5tw/edit


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

Share this event

Add to:

Reddit
07/15/2017 10:00:00 07/15/2017 17:00:00 America/New_York SQL Bootcamp 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...

https://www.thebostoncalendar.com/events/sql-bootcamp--22 GA Boston, Boston, MA 02110 false MM/DD/YYYY

Sponsored events