Data Analysis: Investigate with SQL

Offered By: LinkedIn Learning

Tags

Data Analysis Courses SQL Courses Microsoft SQL Server Courses Database Management Courses WHERE Clause Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX