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.
Background on SQL
Basic SELECT-FROM-WHERE statements
Math operations and constant expressions in SELECT statements
Booleans and complex conditions in the WHERE clause
Pattern matching in the WHERE clause
Grouping and aggregations
ORDER BY clauses
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.
This bootcamp is taken completely online via Zoom and Slack
We will provide login information and a link to the platform on the day of the session.
You will need a computer and a strong internet connection
Each participant must have purchased a ticket
Please install the latest version of PgAdmin4 prior to class
Refund Policy Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this time frame.
General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.
What began as a co-working space in 2011 has since grown into a global learning experience with campuses in 15 cities and over 25,000 graduates worldwide.
As individuals and companies struggle to compete in an increasingly technological economy, General Assembly provides award-winning, dynamic training to close the global skills gap.