Introduction to Data Analysis and Reporting with SQL

Learn how to design and write simple SQL queries for data reporting and analysis

Beginner 4.4(25 Ratings) 792 Students enrolled
Created by Bluelime Learning Last updated 10/2016 English ["English [Auto-generated]"]
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

Curriculum for this course
33 Lectures 03:09:50
Introduction and Database Concepts
6 Lectures 00:34:50
  • Introduction 00:04:01
  • What is SQL 00:01:57
  • Database Concepts Part 1 00:04:31
  • Database Concepts Part 2 00:10:16
  • Basic SQL Syntax 00:04:28
  • SQL Data Types 00:09:37
  • Oracle database 11g express download 00:04:58
  • Oracle database 11g express installation 00:04:47
  • Unlocking and using sample database schema 00:05:09
  • Toad for oracle download 00:03:36
  • Toad for oracle installation 00:04:08
  • Connecting to the database with TOAD 00:05:21
  • Filtering Data search with SQL WHERE clause 00:05:22
  • Sorting SQL query result serach with ORDER BY 00:05:48
  • Use Alias to change query results headings 00:07:47
  • Using Date functions 00:05:02
  • Using Dual Table and Views 00:06:06
  • Aggregating SQL results with GROUP BY 00:08:10
  • Filtering Grouped results using HAVING clause 00:07:36
  • Avoiding duplicates in reporting with SQL DISTINCT 00:05:53
  • Inner Join 00:09:53
  • Outer Join 00:08:14
  • Equi Join 00:07:46
  • Non-Equijoin 00:07:26
  • Cartesian Join 00:06:19
  • Introduction to SET Operators 00:04:36
  • UNION 00:05:23
  • INTERSECT 00:02:50
  • MINUS 00:01:48
  • Single Row 00:00:59
  • Conversion 00:06:48
  • Numeric 00:05:25
  • Character 00:07:50
Requirements
  • Download and install Database test environment. We'll cover this in section 2
+ View more
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..


+ View more
Other related courses
08:21:37
Updated Thu, 30-Apr-2015
4.2 88,363 Free
07:48:19
4.6 8,707 $99.99 Free
01:01:46
Updated Fri, 24-May-2019
4.5 1,866 Free
00:58:08
Updated Sun, 07-Jun-2020
4.3 10,314 Free
01:03:59
Updated Wed, 29-Jan-2020
3.9 6,902 Free
00:43:06
Updated Sun, 01-Jun-2014
4.1 146,858 Free
03:12:13
4.2 76,954 $194.99 Free
14:18:39
4.5 2,687 $199.99 Free
03:20:33
3.4 2,683 $19.99 Free
04:42:14
Updated Sat, 02-Dec-2017
4 6,323 Free
03:25:07
4.4 52,604 Free
05:37:42
3.9 11,911 Free
10:11:26
Updated Wed, 25-Mar-2015
4 59,299 Free
02:16:25
Updated Thu, 16-Jan-2020
3.7 327 Free
00:50:32
4.7 1,682 $34.99 Free
00:33:51
0 2,650 Free
19:48:09
4.6 187,958 $179.99 Free
01:48:02
4.1 4,435 $19.99 Free
02:41:15
Updated Wed, 01-Jun-2016
4.2 62,236 Free
08:32:17
4 5,642 $19.99 Free
02:37:36
Updated Tue, 31-Oct-2017
4.1 8,674 $19.99 Free
01:47:14
4.6 14,732 Free
00:32:54
Updated Wed, 13-Sep-2017
4.2 13,637 Free
03:31:30
5 1,956 $19.99 Free
02:19:11
4.3 13,216 Free
35:04:57
4.3 3,511 $59.99 Free
18:49:14
3.6 2,400 $59.99 Free
00:40:32
Updated Sat, 11-Jan-2020
4 5,205 Free
15:11:13
4.5 2,627 $109.99 Free
00:44:33
4.1 4,938 $19.99 Free
02:38:15
4.1 10,520 $19.99 Free
01:27:31
3.9 3,896 $29.99 Free
18:06:28
4.4 25,119 $169.99 Free
21:15:27
4.2 19,162 $144.99 Free
02:59:08
4.1 94,280 $194.99 Free
07:48:47
4.7 9,541 $19.99 Free
About the instructor
  • 72 Students
  • 3 Courses
+ View more
Learning made simple
Student feedback
4.4
Average rating
  • 8%
  • 16%
  • 16%
  • 72%
  • 88%
Comments
Free $124.99
Includes:
  • 03:09:50 On demand videos
  • 33 Lessons
  • Full lifetime access
  • Access on mobile and tv