Introduction to using SQL for Reporting

Introduction to using SQL for Reporting, available at $44.99, has an average rating of 4.55, with 39 lectures, based on 10 reviews, and has 2079 subscribers.

You will learn about Install database Install TOAD Install SQL Developer Connect TOAD to Oracle Order reporting data output Limit reporting data output Filter data with WHERE clause Filter with various operators and WHERE clause Generate output from sub -queries Understand views and dual tables Understand character functions Understand conversion functions Understand date functions Understand numeric functions Understand and use Aggregate functions Eliminate duplicates from reporting output. This course is ideal for individuals who are Beginning database analysts or Developers who want to keep their knowledge of SQL current or Students taking classes in relational databases or Anyone who wants to learn SQL Reporting It is particularly useful for Beginning database analysts or Developers who want to keep their knowledge of SQL current or Students taking classes in relational databases or Anyone who wants to learn SQL Reporting.

Enroll now: Introduction to using SQL for Reporting

Summary

Title: Introduction to using SQL for Reporting

Price: $44.99

Average Rating: 4.55

Number of Lectures: 39

Number of Published Lectures: 39

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: $94.99

Quality Status: approved

Status: Live

What You Will Learn

Install database
Install TOAD
Install SQL Developer
Connect TOAD to Oracle
Order reporting data output
Limit reporting data output
Filter data with WHERE clause
Filter with various operators and WHERE clause
Generate output from sub -queries
Understand views and dual tables
Understand character functions
Understand conversion functions
Understand date functions
Understand numeric functions
Understand and use Aggregate functions
Eliminate duplicates from reporting output.

Who Should Attend

Beginning database analysts
Developers who want to keep their knowledge of SQL current
Students taking classes in relational databases
Anyone who wants to learn SQL Reporting

Target Audiences

Beginning database analysts
Developers who want to keep their knowledge of SQL current
Students taking classes in relational databases
Anyone who wants to learn SQL Reporting

SQL can be used to generate reports and present information on websites. This course covers SQL features in helping you answer more interesting questions about your data.

The most popular business problems can be solved with SQL . What is the revenue growth month over month and running total revenue? Can we trust the metric, or does the data have some accidental duplicates that affect it? What are the top N orders for every month? What is the repeat purchase behaviour? All these questions can bee translated from the database using SQL into useful reports for the business.

Topics covered includes:

Installing Oracle database
Installing TOAD
Installing SQL developer
Connecting TOAD and SQL Developer to Oracle Database
Ordering and Limiting results
Filtering data using the WHERE clause
Using multiple operators with the WHERE clause
How to use Views and Dual Tables
Using Like operators with wild cards to achieve search patterns
Removing duplicates records
Using sub-queries�
Using character functions
Using conversion functions
Using numeric functions
Using date functions
Grouping results
Aggregate functions
Some real world SQL reporting

What Am I Going To Get from This SQL Reporting Course?

You’ll discover how to use various built in features of SQL to generate useful for reports that can help a business make important decisions.

Who Should Take This Course?

Beginning database analysts
Developers who want to keep their knowledge of SQL current
Students taking classes in relational databases
Anyone who wants to learn SQL Reporting

Course Curriculum

Chapter 1: Setting Up Database and Query Tools

Lecture 1: Introduction

Lecture 2: Tools the professionals use

Lecture 3: Install Oracle

Lecture 4: Unlock Sample Oracle HR Schema

Lecture 5: Install TOAD

Lecture 6: Connecting TOAD to Oracle

Lecture 7: Install SQL Developer

Lecture 8: Connect SQL Developer to Oracle

Chapter 2: Ordering and Limiting Results

Lecture 1: Specifying the table with FROM clause

Lecture 2: Using WHERE clause to filter records

Lecture 3: Some Operators used with WHERE clause – Part 1

Lecture 4: Some Operators used with WHERE clause – Part 2

Lecture 5: View and DUAL tables

Lecture 6: Using LIKE to filter results

Lecture 7: Finding out empty values.

Lecture 8: Ordering with the ORDER BY clause

Lecture 9: Retrieving results from single column

Lecture 10: Retrieving results from multiple columns

Lecture 11: Removing duplicates from results

Lecture 12: Limiting the number of results

Lecture 13: Using SUB-Queries

Chapter 3: Working with single Row Functions

Lecture 1: What are single Row functions

Lecture 2: Character Functions

Lecture 3: Conversion Functions

Lecture 4: Numeric Functions

Lecture 5: Date Functions

Chapter 4: Aggregating Results

Lecture 1: Counting Results

Lecture 2: Summing Values

Lecture 3: Calculating averages

Lecture 4: Getting Maximum Values

Lecture 5: Getting Minimum Values

Lecture 6: Grouping Results

Chapter 5: Some Real – World SQL Reporting Examples

Lecture 1: Generating a report for employee count

Lecture 2: Generating a report for distinct salaries

Lecture 3: Generating a report showing people with same job titles

Lecture 4: Produce a report with a specified criteria

Lecture 5: Generating a salary report

Lecture 6: Generating a report showing hire date

Lecture 7: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

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

Menu