Oracle SQL - Step by Step SQL

BY
Udemy

Learn the fundamental concepts and methodologies associated with Oracle SQL from the ground up.

Mode

Online

Fees

₹ 599 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The structured query language is the collection of commands that all Oracle programmes and clients use to access data in a database. Oracle SQL offers a simple, graceful, and highly functional architecture for obtaining, specifying, and monitoring data. Amarnath Reddy - Oracle Architect & Instructor designed the Oracle SQL - Step by Step SQL certification course, which is presented by Udemy for individuals looking for a quick refresher on SQL and some important database concepts before beginning their professional journey as SQL developers.

Oracle SQL - Step-by-Step SQL online classes offer more than 5.5 hours of prereo=corded lessons accompanied by articles and 5 downloadable study materials that teach individuals everything they require to understand structured query language, from studying various database concepts to writing SQL to communicating with the database. Oracle SQL - Step by Step SQL online course covers SQL query, SQL keywords, database objects, logical operators, arithmetic operators, aggregate functions, DDL, DML, retrieving data, grouping data, filtering data, and more.

The highlights

  • Certificate of completion
  • Self-paced course
  • 5.5 hours of pre-recorded video content
  • 1 article
  • 5 downloadable resources

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 599  ₹3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Database knowledge Sql knowledge

After completing the Oracle SQL - Step by Step SQL online certification, individuals will obtain a better understanding of the principles of SQL using the concepts involved with Oracle SQL. In this Oracle SQL certification, individuals will explore the functionalities of SQL queries, subqueries, tables, joins, indexes, SQL keywords, aggregate functions, Group By, database objects, logical operators, arithmetic operators, data definition language, and data manipulation language. In this Oracle SQL course, individuals will also acquire a solid understanding of several database terminologies including grouping data, filtering data, and retrieving data.

The syllabus

Closed Captions/Sub Titles for the course

  • Closed Captions/Sub Titles for the course
  • Welcome!!
  • How to make best use of the program

Software Installation

  • Installing Oracle
  • Installing Java SDK
  • Installing SQL Developer
  • Running scripts necessary for the course
  • Scripts for our Lab Exercises

Database Concepts

  • What is a Table?
  • What is a Database?
  • What is a Relational Database (RDBMS)?
  • What is a Transaction?
  • What is ACID??
  • RDBMS Vendors

Enter the Dragon (Database)

  • Building SQL Template...
  • How do you talk with a Database?
  • What are the most common commands?
  • What type of Data can we store?
  • Data Model for our Course

Lets see the Data...

  • What data can I see?
  • How do I see data (SELECT) ?
  • How do I see a part of the data (SELECT) ?
  • Lab 1 (Exercises with Answers)

Lets limit the data we see (Filtering)

  • Filtering Data (WHERE command)
  • Comparison Operators
  • Filtering Data (More Examples...)
  • Filters on Character and Date values...
  • Filtering based on a column in a table...
  • Lab 2 (Exercises with Answers)

Logical Operators

  • BETWEEN and NOT BETWEEN
  • IN and NOT IN
  • LIKE operator
  • ALL and ANY
  • Lets learn about NULL...
  • IS NULL and IS NOT NULL
  • AND and OR
  • Lab 3 (Exercises with Answers)

Arithmetic operators

  • They are simple!!! (10 + 20 = 30)
  • Lab 4 (Exercises with Answers)

Lets sort the data we see (Sorting)

  • ORDER BY clause
  • How are NULL values treated while Sorting Data?
  • Lab 5 (Exercises with Answers)

How do we combine data from 2 tables?

  • SET Operators
  • UNION operator
  • UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Lab 6 (Exercises with Answers)

Lets group the data...

  • Aggregate/Summary Functions
  • GROUP BY clause
  • GROUP BY with multiple columns
  • GROUP BY with HAVING clause
  • Lab 7 (Exercises with Answers)

Joining data from 2 or more tables (JOINS)

  • Why Joins?
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join
  • Natural Join
  • Joining the 3rd table
  • Joining the 4th table and so on...
  • Adding filters to Joins
  • Lab 8 (Exercises with Answers)

Functions available for us to use...

  • DUAL (What is this?)
  • Why do we need functions?
  • NUMBER related functions
  • CHARACTER related functions
  • DATE related functions
  • Lab 9 (Exercises with Answers)

Interesting THINGS!!!

  • IF THEN ELSE (CASE statement)
  • Alternative Name (ALIAS name)
  • DISTINCT values
  • PSEUDO Columns

Data Definition Language (DDL)

  • Let's create a table (CREATE)
  • Let's change the structure of a table (ALTER)
  • Let's delete the table (DROP)
  • Create Table AS - CTAS
  • Lab 11 (Exercises with Answers)

Data Manipulation Language (DML)

  • COMMIT and ROLLBACK
  • Insert data into a table (INSERT)
  • Delete data from a table (DELETE)
  • Modify existing data in a table (UPDATE)
  • Delete all the data from a table (TRUNCATE)
  • Lab 12 (Exercises with Answers)

Lets put some restrictions on a table (Constraints)

  • Why constraints?
  • No empty data allowed (NOT NULL)
  • No Duplicate data (UNIQUE)
  • What is NOT NULL + UNIQUE = PRIMARY KEY
  • Accept only few values (CHECK)
  • Check data in other table before inserting/deleting (FOREIGN KEY)
  • Constraints on multiple columns
  • Adding constraints to an existing table
  • More operations on Constraints...
  • Lab 13 (Exercises with Answers)

Views

  • Why Views?
  • Lets modify an existing view
  • Lets update View Data
  • Create View from more than 1 Table
  • Lab 14 (Exercises with Answers)

Other Database Objects

  • Alternative name for Objects (SYNONYMS)
  • Series of Numbers (SEQUENCE)

Giving Permissions to other users (GRANT)

  • I like him (GRANT)
  • I don't like him (REVOKE)
  • List of all GRANT's

SUB Queries

  • What is a Subquery?
  • Sub queries on multiple columns (Pairwise Comparison)
  • Sub queries on multiple columns (Non-Pairwise Comparison)
  • Subqueries in the FROM clause
  • Subqueries in the WITH clause
  • Scalar Subqueries
  • Correlated Subquery

Advanced Topics - Index

  • Book Index??
  • Lets create an Index...
  • UNIQUE Index
  • Dropping and Renaming an Index

Bonus: Lets Recap with a 5 Step Process

  • Scripts for this Section
  • Business Requirement
  • Step 1: Let's Select all the columns needed...
  • Step 2: Let's add the necessary Filters...
  • Step 3: Let's perform the Grouping...
  • Step 4: Let's perform Filtering at Group level...
  • Step 5: Lets Sort the data...
  • Recap the 10 things we have done...

Where to Go From Here

  • Project Work
  • Advanced Database concepts you can explore!!!

Instructors

Mr Amarnath Reddy

Mr Amarnath Reddy
Instructor
Freelancer

Other Masters

Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books