SQL- Reporting and Analysis for beginners

SQL: Reporting and Analysis for beginners, available at $44.99, has an average rating of 4.45, with 35 lectures, based on 68 reviews, and has 3977 subscribers.

You will learn about Setup SQL Query Environment Retrieve Data using SELECT Statement Remove Duplicate Records Sort Returned Records Analyse data using subqueries Analyse data using nested subqueries Filter data using WHERE Clause Filter data using various operators Report on aggregated data Analyse data from multiple tables This course is ideal for individuals who are Beginner Data Science Analyst or Beginner Data Analyst or Beginner Data Engineer or Beginner Data Reporting Analyst It is particularly useful for Beginner Data Science Analyst or Beginner Data Analyst or Beginner Data Engineer or Beginner Data Reporting Analyst.

Enroll now: SQL: Reporting and Analysis for beginners

Summary

Title: SQL: Reporting and Analysis for beginners

Price: $44.99

Average Rating: 4.45

Number of Lectures: 35

Number of Published Lectures: 35

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will Learn

Setup SQL Query Environment

Retrieve Data using SELECT Statement

Remove Duplicate Records

Sort Returned Records

Analyse data using subqueries

Analyse data using nested subqueries

Filter data using WHERE Clause

Filter data using various operators

Report on aggregated data

Analyse data from multiple tables

Who Should Attend

Beginner Data Science Analyst

Beginner Data Analyst

Beginner Data Engineer

Beginner Data Reporting Analyst

Target Audiences

Beginner Data Science Analyst

Beginner Data Analyst

Beginner Data Engineer

Beginner Data Reporting Analyst

This introductory beginners course will help you master SQL for Data Reporting & daily data analysis by learning how to select,

filter & sort data, customize output, & how you can report aggregated data from a database!

The course, we will focus on ANSI(American National Standards Institute) SQL that works on

every database like Oracle, MySQL, Microsoft SQL Server, etc.

SQL has become a requirement for most data science jobs that include:

data analyst, BI (Business Intelligence) developer, programmer, database programmer.

SQL will let you communicate with the database and work with your data.

What You will learn include:

Writing SQL SELECT Statements

Eliminating duplicate rows using DISTINCT

Restricting and Sorting Data

WHERE clause, wildcard like IN, LIKE

Analysing data using various SQL Operators

Sorting data? using ORDER BY clause

Character Functions

Concat? ?Functions

Using LIMIT Operator

Reporting Aggregated Data Using the Group Functions

AVG, COUNT, MIN, MAX

Using GROUP BY and HAVING Clauses

Displaying Data From Multiple Tables

inner-join, right outer-join, left outer-join, self-join

Analysing data Using Subqueries

Analysing data Using nested Subqueries

Course Curriculum

Chapter 1: Setting Up SQL Environment

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is MySQL

Lecture 4: Download and Install MySQL For Windows

Lecture 5: Download and Install MySQL for Mac

Lecture 6: What is MySQL WorKbench

Lecture 7: Basic Database Concepts

Lecture 8: What is a Database Schema

Lecture 9: Basic Data Types

Chapter 2: Analysing Data with SQL

Lecture 1: Extracting data from database

Lecture 2: Removing Duplicate Records

Lecture 3: Filtering data with WHERE clause

Lecture 4: Filtering data using a range

Lecture 5: Filtering data using IN operator

Lecture 6: Analysing data based on a pattern

Lecture 7: Sorting retrieved data

Lecture 8: Limiting returned data

Lecture 9: Analysing data using subqueries

Lecture 10: Analysing data using nested subqueries

Lecture 11: Analysing data using Character Function

Lecture 12: Analysing Data Using Concat Function

Lecture 13: Analysing Data using UNION operator

Chapter 3: Reporting on Aggregated Data

Lecture 1: What are aggregate functions

Lecture 2: Reporting on COUNT Aggregate Functions

Lecture 3: Reporting on SUM Aggregate Functions

Lecture 4: Reporting on MIN Aggregate Functions

Lecture 5: Reporting on MAX Aggregate Functions

Lecture 6: Reporting on AVG Aggregate Functions

Lecture 7: Reporting using GROUP BY Clause

Lecture 8: Reporting using HAVING BY Clause

Chapter 4: Reporting and Analysing Data from Multiple Tables

Lecture 1: Extracting data using INNER JOIN

Lecture 2: Extracting data using LEFT JOIN

Lecture 3: Extracting data using RIGHT JOIN

Lecture 4: Extracting data using SELF JOIN

Lecture 5: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes

2 stars: 1 votes

3 stars: 11 votes

4 stars: 31 votes

5 stars: 22 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!