Advanced SQL Bootcamp

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

Advanced SQL Bootcamp | Online

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

About this workshop

If you’ve got a base knowledge of SQL and are looking to expand your skills, this workshop will provide you with the opportunity to build upon what you already know. You’ll dive into more advanced SQL and focus on the creation of new structures, design principles, and developing skills that can be transferred into areas requiring SQL skills on a day to day basis.

Takeaways

Revisit some SQL basics

  • Tables, Schemas, Functions and Joins
  • Basic SQL queries
  • Apply SQL aggregate functions [MIN, MAX, SUM, AVG, COUNT]
  • Use advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter data
  • Advanced SQL Functions

  • Window Functions
  • Subqueries
  • Complex Calculations
  • SQL Stored Procedures

  • SQL Report Creation
  • Stored Proecedures
  • Prereqs & Preparation

    Please bring a laptop.

    This class is suitable for people with basic knowledge of SQL or people that attended this bootcamp: https://generalassemb.ly/education/bootcamp-deep-dive-into-sql/singapore/78808

    Coming up near you

    Let’s Keep You Updated

    Enter your email to start following

    I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.