Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Data Analysis: Investigate with SQL

via LinkedIn Learning

Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

53 minutes
Sessions

Self-Paced
Level

Beginner

Found in

Part of

SQL Hands-On Practice

Coursera

Google, IBM & Microsoft Certificates — All in One Plan

Corporate Finance Institute

Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

Discover the top five skills to know in Microsoft SQL Server to manage data-driven insights more efficiently for your business.

Syllabus

Introduction

Why learn SQL today?
What you should know
Solving a crime with SQL

1. 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

2. 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

3. Performing Manual Data Analysis

Logical deduction by observing results
Crime-solving SQL analysis recap

4. 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

5. Conclusive Analysis for Data-Driven Action

Solving the case with data-driven insights

Conclusion

Continue enhancing your SQL data-driven skills

Taught by

Walter Shields

Reviews

4.7 rating at LinkedIn Learning based on 197 ratings

Start your review of Data Analysis: Investigate with SQL