Using SQL for Data Analysis
|
Learn to use SQL for querying and analyzing data from databases.
SQL is one of the most versatile tools available when it comes to extracting insights from stored data. Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands and apply the results from queries to address business problems.
User Reviews
Be the first to review “Using SQL for Data Analysis”
Related Products
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Learn Intermediate SQL for Marketers and Product Managers
Perform data analysis on funnels, churn, and attribution. This course contains advanced SQL content for new Marketers and Product Managers.
Data Manipulation in SQL
Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
Business Intelligence Data Analyst
BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings.
Learn SQL: Aggregate Functions
Perform calculations inside SQL queries to answer specific data questions.
Data Scientist: Analytics Specialist
Data Analysts and Analytics Data Scientists use Python and SQL to query, analyze, and visualize data — and communicate findings.
There are no reviews yet.