SQL Bootcamp

SQL Bootcamp

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.

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:

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.
Please bring your laptop. Instructions on how to install PGAdmin III will be sent prior to the bootcamp.

About the Instructor: Matthew Morris

I love answering tough questions. Researching and finding impossible answers is a thrill for me. I have been working with data for 16 years in many roles revolving around the same thing; Make the data meaningful and consumable for the client; Show them something cool. I believe nobody knows the business better than the business and am I an advocate for the business community being trained, listened to and guided into the world of advanced analytics.

  • Languages: SQL(Expert), PigLatin(Intermediate level), Python(Basic level)
  • Applications: Cloudera, Tableau, Essbase Application Manager, Showcase, Captivate, Articulate
  • Learning: Python, JavaScript, Predictive Analytics, R
  • Experience: Advanced Analytics, Business Intelligence, Technical Training, Business Liaison
  • Areas of Business: Merchandising, Human Resources, Accounting, Marketing

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

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.

More classes from General Assembly

  • Class schedule to be determined soon - please enter your email if you wish to be contacted when the schedule is released.

Reviews of General Assembly

(3 Reviews)
Cody B.
I went to GA Seattle WDI (Web Development Immersive) course. It changed my life. Within 1 1/2 months of graduation, I was offered a great job at a company that's considered one of the top 5 to work for in the pacific NW. Starting next week I'll be a Software Engineer making more than twice what I made in my previous career, and I enjoy the work much more. I can't heap enough praise onto the General Assembly Web Development program. Like I said, it's changed my life in ways I didn't think possible.
Daren Y.
GA WDI has been a great decision, not only was I able to learn such an extensive knowledge of multiple languages and frameworks to build web apps, but also being a part of an awesome ever growing family. I would highly recommend GA WDI to anyone.
Samantha B.
I loved taking the FEWD class with General Assembly. My teachers were the head developers at Nordstrom and such cool guys! In just a 10 weeks I learned how to code HTML, CSS, and intermediate JavaScript. I wish we had spent more time with GitHub but apparently all future classes are using it for every homework assignment so that's good to hear. I would recommend GA to anyone serious about learning a difficult 21st century skill like web development or user experience or digital marketing. I got so much more out of it than I feel I would have with any online course.