The Complete SQL Bootcamp 2023 - Data Querying Essentials

The Complete SQL Bootcamp 2023 – 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

Welcome to The Complete SQL Bootcamp 2023 – Data Querying Essentials! In this course we will be using one of the most popular databases in the world called MySQL and it is no doubt one of the most highly in-demand skills in the business sector today. With huge companies such as Twitter, Udemy, Airbnb, Uber and Dropbox using MySQL, you are learning SQL with a very powerful database option that you will install on your own machine. Furthermore, the skills you learn are highly transferable to other database platforms with a whole section dedicated to showcase the high level differences. You will no doubt become an SQL pro.

Best Seller CourseComplete SQL + Databases Bootcamp: Zero to Mastery [2023]

What you’ll 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

You may Also Need This CourseSQL for Tech and Data Science Interviews

Udemy screenshot
success 100%

Udemy Coupons - February 2023

New customer offer! Top courses from $14.99 when you first visit Udemy

Promotion Dates: 02/01/2023 - 02/28/2023

Clicks to Redeems Coupons

Get Certified! IT Certification courses starting from $12.99.