Oracle Database 11g SQL Fundamentals

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises

🥇 Pass Oracle Database Exams

.Retrieving Data Using the SQL SELECT Statement

List the capabilities of SQL SELECT statements
Execute a basic SELECT statement

Restricting and Sorting Data

Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output

Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions

Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

Define subqueries
Describe the types of problems that the subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries

Using the Set Operators

Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

Manipulating Data

Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions

Using DDL Statements to Create and Manage Tables

Categorize the main database objects
Review the table structure
List the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation
Describe how schema objects work

Creating Other Schema Objects

Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms

Find Oracle DBA Jobs and Salaries (click on URL)

Oracle Job Interview Preparation

Job Interview Preparation (Soft Skills Questions & Answers)

🎥 Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

Flexible Class Options

Week End Classes For Professionals SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training

Oracle ERP | Fusion Cloud Training Services

Oracle Database 11g Admin-I DBA Training Course
Oracle Database 11g Admin-II DBA Training Course
Oracle Database 11g SQL Fundamentals
Oracle Database 11g Advanced PLSQL

Timings 10.00 am - 08.00 pm

Oracle Database 11g Admin- SQL Fundamentals