Oracle SQL Interview Questions Master Class

Oracle SQL Interview Questions Master Class, available at $34.99, has an average rating of 4.6, with 80 lectures, based on 60 reviews, and has 299 subscribers.

You will learn about Oracle SQL Architecture Questions SQL Tricky Queries SQL Advanced Topic Questions Questions from past 30+ Interviews Instructor is a Oracle Certified Professional (OCP) Instructor has Points: 12,975 Level: Master in Oracle Technology Network (OTN) This course is ideal for individuals who are Database Developers who are preparing for a SQL interview. or ETL Developers who are preparing for a ETL jobs interview, as SQL is also part interview. or Database Developers who want to brush-up their skills in SQL It is particularly useful for Database Developers who are preparing for a SQL interview. or ETL Developers who are preparing for a ETL jobs interview, as SQL is also part interview. or Database Developers who want to brush-up their skills in SQL.

Enroll now: Oracle SQL Interview Questions Master Class

Summary

Title: Oracle SQL Interview Questions Master Class

Price: $34.99

Average Rating: 4.6

Number of Lectures: 80

Number of Published Lectures: 80

Number of Curriculum Items: 80

Number of Published Curriculum Objects: 80

Original Price: ?4,499

Quality Status: approved

Status: Live

What You Will Learn

Oracle SQL Architecture Questions

SQL Tricky Queries

SQL Advanced Topic Questions

Questions from past 30+ Interviews

Instructor is a Oracle Certified Professional (OCP)

Instructor has Points: 12,975 Level: Master in Oracle Technology Network (OTN)

Who Should Attend

Database Developers who are preparing for a SQL interview.

ETL Developers who are preparing for a ETL jobs interview, as SQL is also part interview.

Database Developers who want to brush-up their skills in SQL

Target Audiences

Database Developers who are preparing for a SQL interview.

ETL Developers who are preparing for a ETL jobs interview, as SQL is also part interview.

Database Developers who want to brush-up their skills in SQL

I have conducted more than 100+ Interviews.

Most importantly I myself attended 30+ interviews and kept the interview questions from different Interviewers.

That will be big boast to understand how different interviewer asked questions and what are the frequently asked questions

There are some tough queries / tricks so If you learn them mostly tough queries can be answered

Approximately 3 hours of lecture dedicated to write variety of SQL queries

If you are preparing for SQL Interview or an ETL developers add punch being a ETL + SQL pro-developer and answer most of SQL questions

There are around 150+ mostly asked questions from simple to expert level are discussed. It also includes 12C

Learn SQL from an Architect who worked 19+ years in SQL.

An Oracle Certified Professions (OCP)

Oracle Technology Network (OTN) Points:12,975 Level:Master

Join the course and learn the important aspects and practical details of SQL and clear the interview with ease

I have kept related questions together so that one can easily memorize.

See you in the Class.

Course covered:

Relational Database concepts

Explaining the theoretical and physical aspects of a relational database

Relating clauses in SQL Select Statement to Components of an ERD

Explaining the relationship between a database and SQL

Restricting and Sorting Data

Applying Rules of precedence for operators in an expression

Limiting Rows Returned in a SQL Statement

Using Substitution Variables

Using the DEFINE and VERIFY commands

Sorting Data

Using Conversion Functions and Conditional Expressions

Applying the NVL, NULLIF, and COALESCE functions to data

Understanding implicit and explicit data type conversion

Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Nesting multiple functions

Displaying Data from Multiple Tables

Using Self-joins

Using Various Types of Joins

Using Non equijoins

Using OUTER joins

Understanding and Using Cartesian Products

Using SET Operators

Matching the SELECT statements

Using the ORDER BY clause in set operations

Using The INTERSECT operator

Using The MINUS operator

Using The UNION and UNION ALL operators

Managing Indexes Synonyms and Sequences

Managing Indexes

Managing Synonyms

Managing Sequences

Managing Views

Managing Views

Managing Objects with Data Dictionary Views

Using data dictionary views

Retrieving Data using the SQL SELECT Statement

Using Column aliases

Using The SQL SELECT statement

Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

Using Arithmetic expressions and NULL values in the SELECT statement

Using Single-Row Functions to Customize Output

Manipulating strings with character functions in SQL SELECT and WHERE clauses

Performing arithmetic with date data

Manipulating numbers with the ROUND, TRUNC and MOD functions

Manipulating dates with the date function

Reporting Aggregated Data Using Group Functions

Restricting Group Results

Creating Groups of Data

Using Group Functions

Using Subqueries to Solve Queries

Using Single Row Subqueries

Using Multiple Row Subqueries

Update and delete rows using correlated subqueries

Managing Tables using DML statements

Managing Database Transactions

Controlling transactions

Perform Insert, Update and Delete operations

Performing multi table Inserts

Performing Merge statements

Use DDL to manage tables and their relationships

Describing and Working with Tables

Describing and Working with Columns and Data Types

Creating tables

Dropping columns and setting column UNUSED

Truncating tables

Creating and using Temporary Tables

Creating and using external tables

Managing Constraints

Controlling User Access

Differentiating system privileges from object privileges

Granting privileges on tables

Distinguishing between granting privileges and roles

Managing Data in Different Time Zones

Working with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP

Working with INTERVAL data types

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Oracle Basic (17 Questions)

Lecture 1: Oracle Basic set 1 – Beginners

Lecture 2: Oracle Basic set 2 – Beginners

Lecture 3: Oracle Basic set 3 – Expert

Lecture 4: Oracle Basic set 4 – Expert

Lecture 5: Oracle Basic set 5 – Expert

Lecture 6: Oracle Basic set 6 – Beginners

Lecture 7: Oracle Basic set 7 – Beginners

Lecture 8: Oracle Basic set 8 – Beginners

Lecture 9: Oracle Basic set 9 – Beginners

Chapter 3: SQL Query

Lecture 1: Basic SQL 01 – Beginner

Lecture 2: Basic SQL 02 – Beginner

Lecture 3: Top-N Queries 01 – Expert

Lecture 4: Operators 01 – Beginner

Lecture 5: Operators 02 – Beginner

Lecture 6: Operators 03 – Beginner

Lecture 7: Single row functions 01 – Expert

Lecture 8: Single row functions 02 – Expert

Lecture 9: Single row functions 04 – Expert

Lecture 10: Single row functions 05 – Beginner

Lecture 11: Single row functions 06 – Expert

Lecture 12: Single row functions 07 – Beginner

Lecture 13: Group or aggregate functions 01 – Expert

Lecture 14: Group or aggregate functions 02 – Beginner

Lecture 15: Group or aggregate functions 03 – Beginner

Lecture 16: Group or aggregate functions 04 – Beginner

Lecture 17: Group or aggregate functions 05 – Expert

Lecture 18: Hierarchical queries 01 – Intermediate

Lecture 19: Hierarchical queries 02 – Expert

Lecture 20: Hierarchical queries 03 – Expert

Lecture 21: Hierarchical queries 04 – Expert

Lecture 22: Hierarchical queries 05 – Expert

Lecture 23: Hierarchical queries 06 – Expert

Lecture 24: Query Types 01 – Beginners

Lecture 25: Query Types 02 – Beginners

Lecture 26: CASE and DECODE Statement 01 – Beginners

Lecture 27: CASE and DECODE Statement 02 – Beginners

Lecture 28: Analytical Queries 01 – Expert

Lecture 29: Analytical Queries 02 – Beginner

Lecture 30: Analytical Queries 03 – Expert

Lecture 31: Analytical Queries 04 – Expert

Lecture 32: Analytical Queries 05 – Expert

Chapter 4: Displaying Data from Multiple Tables

Lecture 1: Join Types – Beginners

Lecture 2: Outer Join Types – Beginners

Lecture 3: Tricky SQL query on Join – Expert

Chapter 5: Table

Lecture 1: Table 01 – Beginners

Lecture 2: Table 02 – Beginners

Lecture 3: Table 03 – Expert

Lecture 4: Table 04 – Expert

Lecture 5: Table 05 – Beginners

Lecture 6: Table 06 – Beginners

Chapter 6: Constraints

Lecture 1: Constraints Types – Beginners

Chapter 7: SQL Command Types

Lecture 1: SQL Command Types 01 – Beginners

Lecture 2: SQL Command Types 02 – Beginners

Lecture 3: SQL Command Types 03 – Beginners

Chapter 8: Index

Lecture 1: Index 01 – Beginners

Lecture 2: Index 02 – Beginners

Lecture 3: Index 03 – Beginners

Lecture 4: Index 04 – Expert

Lecture 5: Index 05 – Beginners

Lecture 6: Index 06 – Expert

Chapter 9: View

Lecture 1: View 01 – Beginners

Lecture 2: View 02 – Beginners

Chapter 10: Sequence

Lecture 1: Sequence 01 – Beginners

Lecture 2: Sequence 02 – Beginners

Chapter 11: Others Objects

Lecture 1: Synonyms – Beginners

Lecture 2: Managing Objects with Data Dictionary Views – Beginners

Lecture 3: System privileges and Object privileges – Beginners

Lecture 4: Role – Beginners

Chapter 12: Oracle Database concepts (21 Questions)

Lecture 1: Oracle Database concepts 1 – Expert

Lecture 2: Oracle Database concepts 2 – Expert

Lecture 3: Oracle Database concepts 3 – Expert

Lecture 4: Oracle Database concepts 4 – Expert

Lecture 5: Oracle Database concepts 5 – Expert

Lecture 6: Oracle Database concepts 6 – Expert

Lecture 7: Oracle Database concepts 7 – Expert

Chapter 13: Flashback Table and Query

Lecture 1: Flashback table – Expert

Lecture 2: Flashback query – Expert

Chapter 14: Managing Data in Different Time Zones

Lecture 1: Managing Data in Different Time Zones 01 – Expert

Lecture 2: Managing Data in Different Time Zones 02 – Expert

Instructors

Global Trainers
Technical Architect

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 2 votes

4 stars: 12 votes

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