HOT

Learn to use SQL for Data Analysis and Reporting

Development

Learn to use SQL for Data Analysis and Reporting, available at $19.99, has an average rating of 3.4, with 56 lectures, based on 33 reviews, and has 1639 subscribers.

Rating3.4
Enroll Now

You will learn about Analyse data using Aggregate functions Analyse data using Analytic functions Analyse data using SET operators Analyse data using sub-queries Analyse data using table joins Analyse data using Single Row functions This course is ideal for individuals who are Data Analyst or Data Scientist or Enterpreneurs or Data researchers or Graduates or Students It is particularly useful for Data Analyst or Data Scientist or Enterpreneurs or Data researchers or Graduates or Students.

Enroll now: Learn to use SQL for Data Analysis and Reporting

Summary

Title: Learn to use SQL for Data Analysis and Reporting

Price: $19.99

Average Rating: 3.4

Number of Lectures: 56

Number of Published Lectures: 53

Number of Curriculum Items: 56

Number of Published Curriculum Objects: 53

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

  • Analyse data using Aggregate functions
  • Analyse data using Analytic functions
  • Analyse data using SET operators
  • Analyse data using sub-queries
  • Analyse data using table joins
  • Analyse data using Single Row functions

Who Should Attend

  • Data Analyst
  • Data Scientist
  • Enterpreneurs
  • Data researchers
  • Graduates
  • Students

Target Audiences

  • Data Analyst
  • Data Scientist
  • Enterpreneurs
  • Data researchers
  • Graduates
  • Students

There is a demand for people who can use  data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.

SQL stands for Structure Query Language. It is an internationally standard language used to communicate with various databases for data manipulation.  SQL is vital for data analysis and reporting.

Have you wondered how you get the data you need? Do you wish you could retrieve it yourself?  This course  teaches you how to get the data you want by writing a bit of SQL code. You won’t just be able to pull data out of the database; you’ll be able to manipulate it: merging it, multiplying it, grouping it, and relabeling it to get just the report you want.

You will learn how to design and write simple SQL queries for data reporting and analysis. Also you will learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results.
 Discover how to perform more complex queries, such as joining data together from different database tables. 
 
Topic you will learn include:

Setup a Database Environment
Understand Database Concepts
Write SQL Syntax
Understand SQL Data Types
Retrieve Data using SELECT
Filter Data search with SQL WHERE clause
Sort SQL query result search  with ORDER BY
Transform SQL Search results with string functions
Use Alias to change query results headings
Use various functions for data reporting and analysis

SQL can be used to help solve business problems like :

Who are the top ten sales-reps in each region?
How many employees in an organization
How many employees earn less than 45K in an organization
How many new employees joined the company in the past 18 months
What goods are flying off the supermarket shelves and so on..

Who is the target audience?
This Course is meant for newbies who are not familiar with using SQL for Data Analysis and Reporting.

Course Curriculum

Chapter 1: Introduction and Lab Setup

Lecture 1: Introduction

Lecture 2: Oracle Database Download

Lecture 3: Oracle Database Installation

Lecture 4: Unlocking Sample Database Schema

Lecture 5: Download TOAD

Lecture 6: Install TOAD

Lecture 7: Connect TOAD to Oracle Database

Lecture 8: Database Concepts -Part 1

Lecture 9: Database Concepts -Part 2

Lecture 10: Retrieving Data with SQL SELECT Statement

Lecture 11: Filtering Data using SQL WHERE Clause

Lecture 12: Sorting Data using SQL ORDER BY Clause

Lecture 13: Using Aliases

Lecture 14: Analysing Data using Sub-Queries

Lecture 15: Removing Duplicate Data

Chapter 2: Data Analysis using Analytic Functions and Windowing Clause

Lecture 1: Introduction to Analytic Functions

Lecture 2: Analytic Function Syntax

Lecture 3: Partition BY Clause

Lecture 4: Order By Clause

Lecture 5: First and Last Function

Lecture 6: Row Number Function

Lecture 7: Dense Rank Function

Lecture 8: Rank Function

Lecture 9: LIST AGG Function

Lecture 10: What is a Windowing Clause

Lecture 11: Using Default Windowing Clause

Lecture 12: Using Rows with Windowing Clause

Lecture 13: using Range with Windowing Clause

Lecture 14: Using Between with Windowing Clause

Lecture 15: Using Multiple windows for data analysis

Chapter 3: Analysing Data with Aggregate Functions

Lecture 1: Introduction

Lecture 2: Using AVG Function

Lecture 3: Using COUNT Function

Lecture 4: Using MIN Function

Lecture 5: Using MAX Function

Lecture 6: Using SUM Function

Chapter 4: Analysing Data using Table Joins

Lecture 1: Introduction

Lecture 2: SELF Join

Lecture 3: EQUI -Join

Lecture 4: NON-EQUI Join

Lecture 5: OUTER Join

Lecture 6: CARTESIAN Join

Chapter 5: Analysing Data using SET Operators

Lecture 1: Introduction

Lecture 2: UNION

Lecture 3: UNION ALL

Lecture 4: INTERSECT

Lecture 5: MINUS

Chapter 6: Analysing Data using Single Row Functions

Lecture 1: Introduction

Lecture 2: Conversion Function

Lecture 3: Character Function

Lecture 4: Date Function

Lecture 5: Numeric Function

Lecture 6: Thank You

Instructors

Rating Distribution

  • 1 stars: 3 votes
  • 2 stars: 1 votes
  • 3 stars: 6 votes
  • 4 stars: 10 votes
  • 5 stars: 13 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!

You may also like

Google Shopping Ads Digital Marketing Course

Complete Copywriting System : write to sell with ease

Product Positioning Masterclass: Unlock Market Traction