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
4.60 (221 reviews)
950
students
11.5 hours
content
Jun 2024
last update
$74.99
regular price
What you will 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
Screenshots
Related Topics
3853170
udemy ID
2/16/2021
course created date
6/28/2021
course indexed date
Bot
course submited by