SQL Bootcamp
9

Saturday, 9 March

10 am – 4 pm EST

GA D.C.

1133 15th Street NW, 8th Floor
Washington, D.C. 20005
$200 USD
Regular Ticket
$200 USD
Total

Questions? Read our FAQs

SQL Bootcamp

Anna Gilbert Photo


Owner / Data & Analytics Consultant, Marion Street Strategies

9

Saturday, 9 March

10 am – 4 pm EST

GA D.C.

1133 15th Street NW, 8th Floor
Washington, D.C. 20005
$200 USD
Regular Ticket
$200 USD
Total

Questions? Read our FAQs

About This Workshop

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence.

Takeaways

  • Understand the differences between different data management systems for SQL databases
  • Understand SQL vocabulary such as tables, schema, and functions
  • Create basic SQL queries by applying Boolean logic, sorting functions, and commenting:
    • 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

Preparation

This bootcamp is designed for anyone interested in learning SQL. A basic technical aptitude and curiosity to learn new tools will make you successful. No prior knowledge of SQL is required.

What to bring to class: All participants must bring their own laptops. Please also download and install Sqlectron.

Note on installing Sqlectron: Mac users may need to allow installation of non-app-store programs in their System Preferences

About the Instructor

Anna Gilbert Photo

Owner / Data & Analytics Consultant,
Marion Street Strategies

Anna Gilbert brings 8 years of Data and Analytics experience to the table, along with an MBA from the University of Maryland. Anna combines her business knowledge with technical skills to help newsrooms, political campaigns, and other nimble organizations best utilize their data and achieve their long-term goals. She has been dubbed a “data evangelist” and “analytics interpreter” for her ability to bring Data and Analytics to diverse audiences. Most recently, Anna Gilbert is owner and lead Data & Analytics consultant at Marion Street Strategies, a consulting firm specializing in building reports, visualizing data and creating smart, sustainable workflows. In her free time, Anna enjoys traveling, gardening, and spending time with friends in family. Anna lives in Baltimore, Maryland.

In recognition of her exemplary service in the classroom, Anna has been selected as a member of General Assembly's Distinguished Faculty program.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.