Brief Introduction
Learn how to use SQL to generate reports that can be helpful to a business.Description
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
Requirements
- Requirements
- Basic knowledge of SQL
- Basic knowledge of relational database
Knowledge
- 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.
Bluelime Learning Solutions
4.4 Raiting
SAS Programming Complete: Learn SAS and Become a Data Ninja
- 4.4
-
![]()
![]()
![]()
![]()
![]()
SAS Data Step. SQL STEP. Macros. SAS Predictive Analytics. Course Updated in 2021. *This course uses a commercial license from WPS....
MySQL and Database Management: From beginner to Expert
- 4
-
![]()
![]()
![]()
![]()
![]()
Learn how to properly manage and analyze complex databases using SQL! No previous knowledge required. Almost every job in the world now relies on Data Analytics....
Learn Bioinformatics in 6 Days
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Kickstart Your Journey to be a Bioinformatician! It's WORTH your money! This program runs through 6 chapters. This is a self-paced course that suits to...
Foundations of marketing analytics
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Who is this course for? This course is designed for students, business analysts, and data scientists who want to apply statistical knowledge and techniques to business contexts....
