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!