Real World Oracle SQL Queries Examples

Real World Oracle SQL Queries Examples, available at $19.99, has an average rating of 1, with 36 lectures, based on 1 reviews, and has 80 subscribers.

You will learn about Create reports using SQL Add a new record into a database Delete a record from a database Perform a count operation on a table Sort data in ascending or descending order Create a new table in a schema This course is ideal for individuals who are This course is meant for students who already have a basic working knowledge of how to use sql to get information into and from a database. It is particularly useful for This course is meant for students who already have a basic working knowledge of how to use sql to get information into and from a database.

Enroll now: Real World Oracle SQL Queries Examples

Summary

Title: Real World Oracle SQL Queries Examples

Price: $19.99

Average Rating: 1

Number of Lectures: 36

Number of Published Lectures: 32

Number of Curriculum Items: 36

Number of Published Curriculum Objects: 32

Original Price: $44.99

Quality Status: approved

Status: Live

What You Will Learn

Create reports using SQL

Add a new record into a database

Delete a record from a database

Perform a count operation on a table

Sort data in ascending or descending order

Create a new table in a schema

Who Should Attend

This course is meant for students who already have a basic working knowledge of how to use sql to get information into and from a database.

Target Audiences

This course is meant for students who already have a basic working knowledge of how to use sql to get information into and from a database.

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user’s request.

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components.

Data is so vital and we interface with  it in our daily lives.

Data is stored in databases which in turn stores the data in tables that contains rows and columns.

There are several database applications available to handle the storage and management of data examples include Oracle, Microsoft SQL and MySQL. We need a way to communicate with these database applications and the language used in doing that is SQL which stands for structured query language.

This course is a hands-on practical course that will build your confidence using SQL. All the queries used in this course are from a real world live production environment except that the table’s database and schema are different.

This course is video based and under 2 hours long with easy to follow real world query examples.

The example real world queries in this course includes:

Creating various reports using SQL

Creating a new table in a schema

Performing count operations on a table

Adding new record into a database

Deleting records from a database

Sorting query results in descending or ascending order

Reading and filtering data from a database

Course Curriculum

Chapter 1: Setting up Database Environment

Lecture 1: Introduction

Lecture 2: Overview of Oracle SQL

Lecture 3: What is SQL

Lecture 4: Download Oracle 11g Database

Lecture 5: Installing Oracle 11g Database

Lecture 6: Unlocking Hr Schema

Lecture 7: Installing Oracle 18c Database

Lecture 8: SQLPlus

Lecture 9: Unlock Sample Schema on Oracle 18c

Lecture 10: Install Oracle SQL Developer

Lecture 11: Connect to Oracle with SQL Developer

Lecture 12: What are TNSNames

Lecture 13: How to create TNSNames

Chapter 2: Using real world SQL Examples queries on an Oracle Database

Lecture 1: How to get the total count of employees in a company

Lecture 2: How to update employee salaries in a company after a pay increase

Lecture 3: How to produce a report of unique salaries in a company

Lecture 4: How to produce a report of people with same job titles in a company

Lecture 5: How to produce a report with a specified criteria

Lecture 6: How to produce a salary report

Lecture 7: How to produce a report of employees with no managers

Lecture 8: Adding new record into a database

Lecture 9: Creating a new Table

Lecture 10: Deleting a record from a table

Lecture 11: How to determine number of employees

Lecture 12: How to produce a report of hire date

Lecture 13: Thank You

Chapter 3: Querying Data with Aggregate Functions

Lecture 1: What are aggregate functions

Lecture 2: AVG Aggregate function

Lecture 3: SUM Aggregate function

Lecture 4: MIN Aggregate function

Lecture 5: MAX Aggregate function

Lecture 6: COUNT Aggregate function

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 0 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!