SQL Bootcamp
16

Saturday, 16 March

9:30 am – 5 pm GMT

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London
£190 GBP
Regular Ticket
£190 GBP
Total

Questions? Read our FAQs

SQL Bootcamp

16

Saturday, 16 March

9:30 am – 5 pm GMT

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London
£190 GBP
Regular Ticket
£190 GBP
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.

Chart your own career path. Pick up where this workshop leaves off. Learn the fundamentals of data tools like Excel, SQL, and Tableau in 10 weeks in our part-time, on-campus Data Analytics course or online in our mentor-driven Data Analysis Circuit.

Students must bring a laptop with http://sqlitebrowser.org/ (or their preferred DB browser) pre-installed.

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 CAST to change a column’s type for a query
  • Use advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter data
  • Apply string, date, and math functions to manipulate how data is presented
  • Apply UNION to tables and columns for merging data
  • Use JOINS to create relationships between tables to obtain data

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.

Students must bring a laptop with http://sqlitebrowser.org/ (or their preferred DB browser) pre-installed.

About the Instructor

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.