Oracle SQL Training
Oracle SQL Course:
Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database or SQL-type databases. Application programs and Oracle tools use SQL under the hood when executing the user's request. Oracle SQL provides an easy, elegant, performant architecture for accessing, defining, and maintaining data. This SQL training starts with the very foundation of SQL and databases. As the course progresses it takes you through various concepts as well as the syntax of SQL in specific and databases in general. At the end of the course, one shall have a good understanding of how to architect, build, use and maintain a database system using SQL. The SQL course is completely hands-on. Cloud labs will be provided for every training participants. Corporate training in Oracle SQL is customized based on the requirement of the organisation. This training is delivered by our experts at Bangalore as well at client locations across India and South-East Asia in cities such as Bangalore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Singapore, Hong Kong and many more.
Oracle SQL Course Curriculum
Writing Basic SQL SELECT Statements
Basic SELECT Statement
Selecting Specific Columns
Column Heading Defaults
Using Arithmetic Operators
Using Parentheses
Null Values in Arithmetic Expressions
Using Column Aliases
Using the Concatenation Operator
Using Literal Character Strings
Eliminating Duplicate Rows
Limiting Rows Using a Selection
Using the WHERE Clause
Comparison Conditions
Other Comparison Conditions
Using the IN Condition
Using the NULL Conditions
Using the AND Operator
Using the NOT Operator
ORDER BY Clause
Sorting by Column Alias
SQL Functions
Single-Row Functions
Case Manipulation Functions
Character-Manipulation Functions
Number Functions
Using the TRUNC Function
Working with Dates
Using Arithmetic Operators with Dates
Using Date Functions
Implicit Data Type Conversion
Using the TO_CHAR Function with Dates
Using the TO_CHAR Function with Dates
Using the TO_NUMBER and TO_DATE Functions
Using the NVL Function
Using the NULLIF Function
Conditional Expressions
Using the CASE Expression
Using the DECODE Function
Obtaining Data from Multiple Tables
Generating a Cartesian Product
Joining Tables Using Oracle Syntax
Retrieving Records with Equijoins
Qualifying Ambiguous Column Names
Joining More than Two Tables
Retrieving Records with Non-Equijoins
Outer Joins Syntax
Self Joins
INNER Versus OUTER Joins
RIGHT OUTER JOIN
Types of Group Functions
Using the AVG and SUM Functions
Using the COUNT Function
Group Functions and Null Values
Creating Groups of Data
Using the GROUP BY Clause
Using the GROUP BY Clause on Multiple Columns
Excluding Group Results
Using the HAVING Clause
Using a Subquery to Solve a Problem
Using a Subquery
Types of Subqueries
Executing Single-Row Subqueries
The HAVING Clause with Subqueries
Using the ANY Operator in Multiple-Row Subqueries
Null Values in a Subquery
Data Manipulation Language
The INSERT Statement Syntax
Inserting Rows with Null Values
Inserting Specific Date Values
Copying Rows from Another Table
The UPDATE Statement Syntax
Updating Two Columns with a Subquery
Updating Rows Integrity Constraint Error
The DELETE Statement
Deleting Rows Based on Another Table
Using a Subquery in an INSERT Statement
Overview of the Explict Default Feature
The MERGE Statement
Merging Rows
Advantages of COMMIT and ROLLBACK Statements
Rolling Back Changes to a Marker
State of the Data Before COMMIT or ROLLBACK
Committing Data
Statement-Level Rollback
Database Objects
The CREATE TABLE Statement
The DEFAULT Option
Tables in the Oracle Database
Data Types
INTERVAL YEAR TO MONTH Data Type
Creating a Table by Using a Subquery
Adding a Column
Dropping a Column
Dropping a Table
Truncating a Table
Constraint Guidelines
The NOT NULL Constraint
The PRIMARY KEY Constraint
FOREIGN KEY Constraint Keywords
Adding a Constraint Syntax
Dropping a Constraint
Enabling Constraints
Viewing Constraints
Database Objects
Why use Views?
Creating a View
Querying a View
Creating a Complex View
Using the WITH CHECK OPTION Clause
Removing a View
Database Objects
The CREATE SEQUENCE Statement Syntax
Confirming Sequences
Using a Sequence
Guidelines for Modifying a Sequence
What is an Index?
Creating an Index
When Not to Create an Index
Function-Based Indexes
Synonyms
Privileges
Creating Users
Granting System Privileges
Creating and Granting Privileges to a Role
Object Privileges
Using the WITH GRANT OPTION and PUBLIC Keywords
How to Revoke Object Privileges
Frequently Asked Questions
We provide classroom-based as well as online training. Since this is a hand-on training so batches generally does not contain more than 4 people.
We will provide web services specific study material as the course progresses. You will have lifetime access to all the code and basic settings needed for these Oracle SQL training through our github account and the study material that we share with you. You can use that for quick reference.
Feel free to drop a mail to us at [email protected] and we will get back to you at the earliest for your queries on Oracle SQL course
We have tie ups with various companies and placement organizations to whom we connect our learners. Each Oracle SQL training ends with career consulting
Minimum 2-3 projects of industry standards on Oracle SQL will be provided
Yes, we provide our own course completion certificate to all students. Each Oracle SQL training in bangalore ends with training and project completion certificate
You can pay by card (debit/credit), cash, cheque and net-banking. You can pay in two installments
We take immense pride to provide post training career consulting for Oracle SQL training
More Courses
|
DevOps - Pro |
|
MySQL |
|
Machine Learning using Tensorflow |
|
Grafana |
|
Advanced JavaScript |
|
Spark with Scala |
|
Natural Language Processing for Text Mining |
|
Agile Scrum Master |
|
Oracle SQL |
Read More
Recommended Courses
MongoDB
Postman
Cucumber
Feedback