SQL Bootcamp Remote (APAC Online)

Sydney Campus

GA Sydney
1 Market Street - entry via Kent Street. The red-brick building behind the main sky-scraper, next to My Lua.
Sydney NSW 2000

Past Locations for this Workshop

SQL Bootcamp Remote (APAC Online) | Sydney

Sydney Campus

GA Sydney
1 Market Street - entry via Kent Street. The red-brick building behind the main sky-scraper, next to My Lua.
Sydney NSW 2000

Past Locations for this Workshop

About this workshop

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behaviour, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy.

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 — and start using the tool immediately.

Takeaways

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

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.

     

    What will the remote learning experience be like?

    • Ask questions and interact with peers and expert instructors — all in real time. Collaborate via live chat, voice, and video.
    • Complete hands-on coursework in an online classroom designed to keep you engaged and focused.
    • Gain accountability and guidance from your instructor and fellow classmates to help you turn skills into career success.

     

    Note

    • This bootcamp is taken completely online.
    • We will provide login information and a link to the platform on the day before the session.
    • You will need a computer and a strong internet connection.
    • If you enrol less than 24 hours before the bootcamp commences, please email sydney@generalassemb.ly for instructions.

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.