Data Analysis: Investigate with SQL
53mBeginner2023-04-25
Authors
Walter Shields
Tech Educator and Best-Selling Author
Course details
Are you looking to enhance your skills in data analysis and become a valuable asset in today's data-driven business world? Learning SQL, the widely used language for managing relational databases, can be a game changer for you.
In this course, you will learn the fundamental skills needed to navigate and analyze data effectively. Discover the basic structure of relational databases, how they work, and their importance to businesses. You'll also explore the top SQL queries, including the WHERE clause and operators such as IN, BETWEEN, AND, and OR, and how and when to use them for efficient data analysis. By the end of the course, you'll have the knowledge and skills to access, warehouse, and analyze data efficiently. You'll be able to make better decisions and gain valuable insights into the data that matters most. Don't miss out on the chance to enhance your skills and become a valuable asset in today's data-driven world.
In this course, you will learn the fundamental skills needed to navigate and analyze data effectively. Discover the basic structure of relational databases, how they work, and their importance to businesses. You'll also explore the top SQL queries, including the WHERE clause and operators such as IN, BETWEEN, AND, and OR, and how and when to use them for efficient data analysis. By the end of the course, you'll have the knowledge and skills to access, warehouse, and analyze data efficiently. You'll be able to make better decisions and gain valuable insights into the data that matters most. Don't miss out on the chance to enhance your skills and become a valuable asset in today's data-driven world.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
Introduction
- Why learn SQL today
- What you should know
- Solving a crime with SQL
Starting the Investigation with SQL Query
- Data analysis - First steps
- SQL core concepts - Data types, tables, columns, and records
- First query - Comments, aliases, and sorting
Filter Data for Refined Results
- Adding criteria to SQL queries
- Second query - WHERE clause, operators, date, and texts
- Query composition - More operators for refining results
- Third query - Operators and context understanding
Performing Manual Data Analysis
- Logical deduction by observing results
- Crime-solving SQL analysis recap
Exploring Related Table Data
- Examining the evidence in related tables
- Fourth query breakdown - BETWEEN operator and date ranges
- Finding supporting evidence to align objectives
- Fifth query breakdown - Using the IN and AND operators
Conclusive Analysis for Data-Driven Action
- Solving the case with data-driven insights
Conclusion
- Continue enhancing your SQL data-driven skills