Introduction To Data Analysis And Reporting With Sql
Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 473.99 MB | Duration: 3h 9m

Learn how to design and write simple SQL queries for data reporting and analysis
What you'll learn
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 qiery result seach 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
Requirements
Download and install Database test environment. We'll cover this in section 2
Description
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 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 EnvironmentUnderstand Database ConceptsWrite SQL SyntaxUnderstand SQL Data TypesRetrieve Data using SELECTFilter Data search with SQL WHERE clauseSort SQL query result search with ORDER BY Transform SQL Search results with string functionsUse Alias to change query results headingsUse various functions for data reporting and analysisSQL can be used to help solve business problems like :Who are the top ten sales-reps in each region?How many employees in an organizationHow many employees earn less than 45K in an organizationHow many new employees joined the company in the past 18 monthsWhat goods are flying off the supermarket shelves and so on..
Overview
Section 1: Introduction and Database Concepts
Lecture 1 Introduction
Lecture 2 What is SQL
Lecture 3 Database Concepts Part 1
Lecture 4 Database Concepts Part 2
Lecture 5 Basic SQL Syntax
Lecture 6 SQL Data Types
Section 2: Database Setup and Connectivity
Lecture 7 Oracle database 11g express download
Lecture 8 Oracle database 11g express installation
Lecture 9 Unlocking and using sample database schema
Lecture 10 Toad for oracle download
Lecture 11 Toad for oracle installation
Lecture 12 Connecting to the database with TOAD
Section 3: SQL and Data Reporting
Lecture 13 Filtering Data search with SQL WHERE clause
Lecture 14 Sorting SQL query result serach with ORDER BY
Lecture 15 Use Alias to change query results headings
Lecture 16 Using Date functions
Lecture 17 Using Dual Table and Views
Section 4: Grouping Query Results Using SQL
Lecture 18 Aggregating SQL results with GROUP BY
Lecture 19 Filtering Grouped results using HAVING clause
Lecture 20 Avoiding duplicates in reporting with SQL DISTINCT
Section 5: Merging Data From Multiple Tables
Lecture 21 Inner Join
Lecture 22 Outer Join
Lecture 23 Equi Join
Lecture 24 Non-Equijoin
Lecture 25 Cartesian Join
Section 6: Group Multiple Query Results into One Result using -SET operators
Lecture 26 Introduction to SET Operators
Lecture 27 UNION
Lecture 28 INTERSECT
Lecture 29 MINUS
Section 7: Using Functions For Data Analysis
Lecture 30 Single Row
Lecture 31 Conversion
Lecture 32 Numeric
Lecture 33 Character
Lecture 34 Thank You
This Course is meant for newbies who are not familiar with using SQL for Data Analysis and Reporting.
Screenshots