Introduction to Data Analysis and Reporting with SQL
4.0 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
670 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Data Analysis and Reporting with SQL to your Wishlist.

Add to Wishlist

Introduction to Data Analysis and Reporting with SQL

Learn how to design and write simple SQL queries for data reporting and analysis
4.0 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
670 students enrolled
Last updated 10/2016
English
Current price: $12 Original price: $125 Discount: 90% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
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 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.
Compare to Other SQL Courses
Curriculum For This Course
33 Lectures
03:09:50
+
Introduction and Database Concepts
6 Lectures 34:50



Database Concepts Part 2
10:16

Basic SQL Syntax
04:28

SQL Data Types
09:37
+
Database Setup and Connectivity
6 Lectures 27:59
Oracle database 11g express download
04:58

Oracle database 11g express installation
04:47

Unlocking and using sample database schema
05:09

Toad for oracle download
03:36

Toad for oracle installation
04:08

Connecting to the database with TOAD
05:21
+
SQL and Data Reporting
5 Lectures 30:05
Filtering Data search with SQL WHERE clause
05:22

Sorting SQL query result serach with ORDER BY
05:48

Use Alias to change query results headings
07:47

Using Date functions
05:02

Using Dual Table and Views
06:06
+
Grouping Query Results Using SQL
3 Lectures 21:39
Aggregating SQL results with GROUP BY
08:10

Filtering Grouped results using HAVING clause
07:36

Avoiding duplicates in reporting with SQL DISTINCT
05:53
+
Merging Data From Multiple Tables
5 Lectures 39:38
Inner Join
09:53

Outer Join
08:14

Equi Join
07:46

Non-Equijoin
07:26

Cartesian Join
06:19
+
Group Multiple Query Results into One Result using -SET operators
4 Lectures 14:37
Introduction to SET Operators
04:36

UNION
05:23

INTERSECT
02:50

MINUS
01:48
+
Using Functions For Data Analysis
4 Lectures 21:02
Single Row
00:59

Conversion
06:48

Numeric
05:25

Character
07:50
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,780 Reviews
39,063 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.