Developing SQL queries for oracle databases

Developing SQL queries for oracle databases, available at $19.99, has an average rating of 2.58, with 55 lectures, based on 6 reviews, and has 271 subscribers.

You will learn about Build sub queries Optimize queries using indexes Leverage SQL Aggregate functions to build queries Use single row functions to build to develop SQL queries Perform analysis using analytic functions Develop complex queries through table joins This course is ideal for individuals who are SQL Aspiring developers or Aspiring Database administrators or Data Analyst It is particularly useful for SQL Aspiring developers or Aspiring Database administrators or Data Analyst.

Enroll now: Developing SQL queries for oracle databases

Summary

Title: Developing SQL queries for oracle databases

Price: $19.99

Average Rating: 2.58

Number of Lectures: 55

Number of Published Lectures: 46

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 46

Original Price: $74.99

Quality Status: approved

Status: Live

What You Will Learn

Build sub queries
Optimize queries using indexes
Leverage SQL Aggregate functions to build queries
Use single row functions to build to develop SQL queries
Perform analysis using analytic functions
Develop complex queries through table joins

Who Should Attend

SQL Aspiring developers
Aspiring Database administrators
Data Analyst

Target Audiences

SQL Aspiring developers
Aspiring Database administrators
Data Analyst

SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language.In this course, you learn to use the full potential of SQL to write simple to complex queries for Oracle databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls.

SQL Skills will greatly improve your job prospects either as a contractor
or full time employment. It is a useful skill that is always in demand due
to its usefulness. It’s everywhere there is a database. The skills you learn
on this course will be enough to confidently work as an SQL professional.

This is a practical hands on video based course with 40 lectures and 4 hours of content.

This course is designed for anyone who has some basic SQL knowledge and can write and understand simple SQL Queries. Also knowing the basics of relational database management systems (RDBMS) would be an advantage.

You will Learn how to :

Use some essential components to build queries for oracle databases
Leverage SQL Aggregate functions to build queries
Leverage the analytical functions of Oracle
Use single -row functions
Manipulate SET queries to build queries
Use temporary Tables

Course Curriculum

Chapter 1: Introduction and Oracle Database Setup

Lecture 1: Introduction

Lecture 2: Overview of Oracle SQL

Lecture 3: Basic Database concepts

Lecture 4: Oracle Installation Requirements

Lecture 5: Download Oracle 21C

Lecture 6: Install Oracle 21C

Lecture 7: Connect to Oracle with SQLPlus

Lecture 8: What is SQL Developer

Lecture 9: Download SQL Developer

Lecture 10: Download Sample Oracle 21c Schemas

Lecture 11: Unlock Sample Schema Account

Lecture 12: Unlock sample schema tables

Lecture 13: Connect to sample schema account

Lecture 14: Download TOAD

Lecture 15: Install TOAD

Lecture 16: Connect TOAD to Oracle

Chapter 2: Essentials SQL Query building components

Lecture 1: Sub Queries

Lecture 2: Query optimisation

Lecture 3: Removing duplicates

Lecture 4: Views

Chapter 3: Leveraging SQL Aggregate Functions to Build Queries

Lecture 1: AVG

Lecture 2: COUNT

Lecture 3: MAX

Lecture 4: MIN

Lecture 5: SUM

Chapter 4: Single-row functions

Lecture 1: Character

Lecture 2: Conversion

Lecture 3: Date

Lecture 4: Numeric

Chapter 5: Perform Analysis with Analytical functions

Lecture 1: Rank

Lecture 2: Dense Rank

Lecture 3: Lead

Lecture 4: ListAgg

Lecture 5: Lag

Lecture 6: Row Number

Lecture 7: First and Last

Chapter 6: Developing complex queries using Joins

Lecture 1: SELF Join

Lecture 2: EQUI Join

Lecture 3: NON -EQUI Join

Lecture 4: Cartesian Join

Lecture 5: OUTER Join

Chapter 7: Manipulating SET operators to build queries

Lecture 1: UNION

Lecture 2: UNION ALL

Lecture 3: INTERSECT

Lecture 4: MINUS

Lecture 5: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

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