Advanced SQL Bootcamp

Singapore Campus

General Assembly @ 79 Anson
Level 20. 79 Anson Road
Singapore

Past Locations for this Workshop

Advanced SQL Bootcamp | Singapore

21
Attend the next event on Saturday, 21 September.

Singapore Campus

General Assembly @ 79 Anson
Level 20. 79 Anson Road
Singapore

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

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