The Complete SQL Bootcamp – Data Querying Essentials

Learn to query databases using MySQL. A must-have skill for users of data in any industry! Go from beginner to expert

Created by: Dean Taylor
Data Scientist | Instructor

What Will I Learn?

• Learn how to query data from databases using SQL on your own machine and within your own database
• Learn fundamental SQL syntax that enables you to query database tables in any way imaginable
• Learn about Data Aggregations and perform them using SQL (SUM / COUNT / MIN / MAX / AVERAGE / GROUP BY / HAVING)
• Learn how to join multiple tables in a variety of ways - (LEFT / RIGHT / INNER / FULL / UNION / UNION ALL / INSERSECT / MINUS)
• Learn database management techniques - (CREATE / REPLACE / UPDATE / DELETE)
• Learn how to work with Date information (extracting, filtering, formatting)
• Learn how to generate your own columns of data within a result set
• Learn about Arithmetic & Comparison operators
• Learn how to create Temporary Tables, Common Table Expressions, Subqueries, Derived Tables & Views
• Learn about in-built functions (String / Numeric / Date / Comparison / Window)
• Learn how to create Conditional Statements (CASE / WHEN / THEN)
• Learn how SQL can be used in other software and languages such as Tableau, Python and Alteryx
• Learn how to use MySQL Workbench to manage your data
• Learn how to use SQL to perform data analysis
• All the skills required to add SQL to your CV / Resume
• Learn how to implement Triggers & Loops using SQL
• Learn about SQL cursors with examples
• Learn how to create Stored Procedures and Stored Functions
• Learn about the differences between MySQL, PostgreSQL, SQL Server, SQLite and Oracle

Requirements

• An appetite to learn SQL and work with databases
• No other pre requisites or course requirements

Target audience

• This course is for anyone who wants to learn the Fundamental aspects of SQL
• This course is designed for any data enthusiast who wants to get more out of their data
• This course is for anybody who wants improved insights into their data
• This course is for anyone who wants to improve their breadth of SQL syntax knowledge
• This course is for anyone who wants to migrate Excel based reports to a database
• This course is for any keen data scientist who wants to leverage SQL for data analytics
• This course is for anyone who wants to open up job opportunities that involve data