SQL for Business People Course

Self-Paced Online Training Course

The course covers 60 topics
Total Lecture runtime 135 minutes
Total Practice runtime 280 minutes

24/7 - One Year Access
Free Access to a Practice Instance

Learn Oracle SQL the Smart Way

So you’re interested in learning the database concepts and SQL queries? Awesome. The process of getting started, and even finding the right training can feel daunting. What SQL course is the one to take? How do I find a system on which to practice what I’ve learned? How does everything fit together in the big picture? What specifically do I need to know in order to do my job?

Are you curious about SQL and how it works? Are you new to database and SQL? if YES, then this course is for you…

SQL stands for Structured Query Language, and usually pronounced “sequel”. Why learn SQL? SQL is often is the backbone of many business and financial systems like Oracle EBS, Oracle Cloud ERP, and many others.

When you understand the language of SQL, you can easily create reports, do financial analyses, and find answers that help you make better business decisions. You can almost make data dance by using simple SQL commands and statements. You can be in control of how your financial and managerial reports can do and YOU can direct your IT team on how best to produce a report that makes good business sense.

By the end of this course, you will be able to:

Understand how relational databases work
Learn how to prepare SQL statements to retrieve data from the database tables
Learn simple SQL statements to find answers to business problems.
Create database objects such as table
Find data from the database in order to review data and build reports that make business sense.

Course Information

Here is what’s included with your registration.

This course was built with the busy business person in mind. If you’re exploring Oracle SQL for the first time and you’re looking for help with each step along the way, this is the course for you.

24/7 Self-Paced Online Training Course: Watch the course material videos any time and on any device. You can watch the course from your mobile device, computer, or tablet, anytime for an entire year.
Course Material. The course materials is developed in bite-size videos, with high quality production and annotations. The course covers 60 topic of SQL for beginners; each topic is covered in two videos, the first video covers the concepts and the second video shows how to build the SQL query from scratch
Course Runtime. The total runtime of the conceptual videos is 135 minutes, and the total runtime of the practice videos is 280 minutes.
Course Structure. The course content is organized in a logical order to make easy for trainees to follow.
Sample Lectures. Feel free to try the sample lectures in the Review Section of the course
24/7 Access to a practice instance. Even after the course ends, you get more than just our valuable training. You get a practice Oracle database to practice your SQL skills for an entire year.
Practice Scripts: The SQL statements used in the videos are attached to each lecture for you to copy and paste in your practice environment.
Help. Should you have questions, please feel free to email us @info@tutorally.com

What You'll Learn

Across over 46 lectures, you’ll learn all about:

Database Overview: We’ll explain and teach you how database works and how data is stored in the database tables.
Select Statements: You’ll learn the different Select Statement syntax and how to retrieve data from the database tables, including sorting the retrieved data, filtering the data and applying different conditions.
Group Functions: You’ll learn about the different aggregate functions such as sum, average, minimum, maximum, and count functions
Data Sets: This section covers how to build a data set using UNION, INTERSECTION, MINUS commands
SQL Joins: We’ll teach you how data can be sourced from more than one table and how to link the source tables together using the different join types such as Inner Join, Full Join, Left Join, Right Join, Self Join.
Conversion Functions: In this section you’ll learn how data can be converted from one format to another i.e. convert a text to date format, convert number to text, and text to number.
Sub-queries: You’ll learn how the different sub-queries in Oracle SQL and how to use them in the data extract criteria
Data Manipulation Statements: You’ll learn how to manipulate data in the database tables using Insert command to add new records, Update statement to modify existing records, and Delete statement to delete records.
Data Definition Statements: We’ll teach you how create new database users and grant the required roles and privileges.

Who This Course is for

This is for business users (as opposed to techies):

Are you an accountant or business analyst who is curious about reporting and how data works?
Do you want to finally be free from your I.T. department and dictating how your managerial reports should look like?
Do you want to learn how to find answers in the data; how to put the create meaningful analyses perfect for making financial, operational, and strategic business decisions?
Are you new to SQL? People new to database and SQL will need to learn SQL to enrich their database understanding, build applications, and generate data extracts and reports.

SQL for Business People is designed for people whose new to database and SQL, and for the people who wants to learn how data is stored in database table and how data can be extracted out of the database tables.

We get that you’re busy. You stretched thin as it is. But you need to invest in yourself. That’s why we distilled the important stuff in this foundational course. Once you take this course, you’ll be solid in Oracle SQL. Then you can level up as you need.

What They're Saying

The videos are so clear and easy to understand!

Paul G.

Corporate controller

They're so engaging and easy to understand!

Lori S.

technologies dispatch

Learning SQL Doesn't have to be Hard

Stop thinking about how mysterious SQL is. In this course, you will learn how to build your own SQL statements to retrieve data from database tables, manipulate data and create database tables.

Course Curriculum

Course Content

Expand All | Collapse All

Sections Status

Preview Sample Lectures of This Course

Sample Lecture: Database Overview (4:20 min)

Sample Lecture: Order By Clause-(1:01)

Sample Lecture: SQL join type-(2:51)

Sample Lecture: Create Table (3:38 min)

Section 1: Overview

Course Instructions

How to Get the Most out of This Course

Database Overview (4:20 min)

Section 2: Data Retrieval (Select Statement)

Basic SELECT Statement (SELECT … FROM)-(1:56)

Distinct Keyboard-(0:34)

Order By Clause-(1:01)

WHERE Clause- Comparison Operators-(3:46)

WHERE Clause – NULL and NOT NULL Operators-(1:06)

Where Clause – Between Operator-(0:34)

Where Clause – Logical Operators-(2:57)

Where Clause – IN and NOT IN Operators-(1:20)

Where Clause – Like Keyword-(1:42)

Group Function-(4:08)

Having Clause-(1:26)

Aliases-(1:02)

Arithmetic Operators(1:47)

Set Operators Union, Union all, Intersection, Minus-(1:46)

Case Statement-(1:46)

Top-N Analysis-(1:06)

String Functions-(8:48)

Numeric Functions-(4:33)

Date Functions-(7:36)

Arithmetic Operations With Dates-(1:22)

Section 3: SQL Joins

SQL join type-(2:51)

inner join-(2:20)

left join-(1:16)

Right Join-(1:25)

Full Join-(1:39)

Self Join-(1:29)

Section 4: Conversion Functions

TO_CHAR Conversion Function-(3:23)

TO_NUMBER Conversion Function-(0:49)

TO_DATE Conversion Function-(2:08)

Section 5: SQL Sub-queries

Sub-query in the WHERE Clause-(7:30)

Sub-query in the FROM Clause-(1:26)

Sub-query in the SELECT Clause-(0:46)

EXISTS Condition-(1:07)

Section 6: Data Manipulation Language (DML)

Data Manipulation Language (DML) Overview(0:49)

INSERT Statement(2:31)

Copy Data between Tables Using INSERT Statement(1:57)

UPDATE Statement(1:49)

DELETE Statement(2:03)

Section 7: Data Definition Language (DDL)

Data Definition Language (DDL) Overview (1:10 min)

Create Table (3:38 min)

Create Table as Select Statement (1:43 min)

Alter Table Add Column (1:33 min)

Alter Table Drop Column (0:34 min)

Alter Table Modify Column (0:57 min)

Alter Table Rename Column (0:31 min)

Drop Table (1:18 min)

Rename Table (0:42 min)

Truncate Table (0:55 min)

Create Database View (3:25 min)

Drop Database View (0:36 min)

Table Constraints Overview (2:06 min)

NOT NULL Constraint (3:15 min)

UNIQUE Constraint (3:16 min)

PRIMARY KEY Constraint (2:54 min)

FOREIGN KEY Constraint (3:34 min)

CHECK Constraint (3:16 min)

DROP/DISABLE/ENABLE Constraints (2:33 min)

Section 8: Data Control Language (DCL)

CREATE USER (2:22 min)

Section 9: Practice Demo Database

Demo Database Credentials

Create the Practice Tables in You Own DB (9:23 min)

QuizzesStatus

SQL for Business Users Quiz

Frequently Asked Questions

When the course become available?

The course will be available immediately after the purchase process is complete.

Login to the website and go to my courses. the enrolled courses will be listed and ready for you to start your learning journey.

How long is the course?

The course covers over 60 topics. Each topic is covered in two videos, the first video covers the concepts and the second video shows how to build the SQL query from scratch.

The total runtime of the conceptual videos is 135 minutes, and the total runtime of the practice videos is 280 minutes.

The SQL topics are covered in bite-size videos.

What equipment/tools will I need to complete the course?

You’ll need a computer with access to the internet. The course is published on TutorAlly website and would be available 24/7

How long do I have access to the course?

You’ll have a full year access. The one year access comes with FREE practice instance and practice scripts.

What do I do if I need help?

Should you have any questions, please feel free to email us at info@tutorally.com.

Can I pay with PayPal?

Yes. On the checkout page select PayPal to be directed to the PayPal checkout.

Are there sample lectures?

Yes. There are FREE sample lectures in the Review Section of the course to try out before you make the purchase.

Become Familiar with Oracle SQL Now

People who work in directly and indirectly with Database and Systems

Learning SQL would help you understanding how the data is stored in the systems you are dealing. Understanding SQL will help you in crafting you reporting requirements.

If you are new to IT and database, the SQL helps you in building a better understanding of the database concepts and how to deal with the data stored in the database tables.

This SQL course walks you through the SQL structure, syntax, and examples of the different SQL statements or queries