When:
Saturday, Nov 03, 2018 10:00a -
5:00p

Where:
General Assembly Boston
125 Summer Street
Boston, MA

EventScheduled OfflineEventAttendanceMode

Admission:
$299

Categories:
Business, Innovation, Lectures & Conferences, Tech

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

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 these instructions for installation.


Interested in seeing this class held privately at your organization?
Email us at bospartnerships@ga.co to request more info.


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
Prereqs & Preparation
Prior to class, please install PostgreSQL and PGadmin. Instructions for installation can be found here. There are multiple ways to install SQL. However, please follow the instructions found in the link to be prepared for the start of class.


Basic technical aptitude and orientation to computers, and 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.

Share this event

Add to:

Reddit
03/11/2018 10:00:00 03/11/2018 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 qu... General Assembly Boston, Boston, MA false DD/MM/YYYY