Learn how to work with SQL for real with this course!

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 🙂