SQL The Complete Guide: SQL from Beginner to Advanced

Partner: Udemy
Affiliate Name:
Area:
Description: 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 tablesBasic and Intermediate SQL (WHERE command, ORDER BY command, Logical Operators, Conditionals)Group data with aggregate functions using the GROUP BY commandFilter aggregated data with HAVING commandPerform all types of SQL JOINs (Inner, Left, Right, Cross, Full...)String functionsDate and Time functionsMathematical functionsSubqueriesCTEs (Common Table Expressions)Window FunctionsSQL Advanced TopicsPerformance Improvements on QueriesLet's learn together, from basic to advanced of SQL! Check out the free preview videos for more information about the complete guide!
Category: Business > Business Analytics & Intelligence > SQL
Partner ID:
Price: 109.99
Commission:
Source: Impact
Go to Course