What you'll learn
Use SQL to query any relational database
Perform data analysis with SQL in the real-world situations
Write complex queries across multiple tables
Work with real-life database and learn everything that you need to create your own SQL reports
Learn how to work with SQL for real with this course!
.jpg "SQL - MySQL for Data Analytics and Business Intelligence")
In recent years the data area has grown a lot and has been in great demand, the SQL language has been one of the requirements in several professional areas outside the technological scope, for example in some companies in the areas of marketing, finance, HR, they use SQL to carry out analyzes and make decisions! Learning SQL nowadays is essential to increase your chances in the job market.
You will learn with an effective method, from basic to advanced and understand SQL by applying it in practice with practical examples, and you will be ready to apply it immediately in the real world. In this course we will use the PostgreSQL database to execute our queries, but this knowledge can be applied to any database that uses SQL, such as MySQL, Oracle, SQL Server, Redshift...
What will you learn:
Concepts about Databases, schemes and tables
Basic and Intermediate SQL (WHERE command, ORDER BY command, Logical Operators, Conditionals)
Group data with aggregate functions using the GROUP BY command
Filter aggregated data with HAVING command
Perform all types of SQL JOINs (Inner, Left, Right, Cross, Full...)
String functions
Date and Time functions
Mathematical functions
Subqueries
CTEs (Common Table Expressions)
Window Functions
SQL Advanced Topics
Performance Improvements on Queries
Let's learn together, from basic to advanced of SQL! Check out the free preview videos for more information about the complete guide!
Who this course is for:
- People who want to start running their own queries with SQL
- People who want to increase their earning potential
- Professionals who work with data analysis on a relational basis, from programmers to financial areas, marketing, etc...
- Data Engineers and Data Scientists
- Technology students learning about SQL
- SQL enthusiasts :)
Post a Comment