What will you learn?
Who should go for this training?
The following professionals can go for this course:
What are the pre-requisites for this Course?
Basic Computer Knowledge
Brief History of SQL
- Primary Keys
- Foreign Keys
- Relational Database Management System
- Commercial Databases
- Popular Open Source Databases
- Valid Object References
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
Introduction to the Northwind Database
- Whitespace and Semi-colons
- Case Sensitivity
SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
- Sorting By a Single Column
- Sorting By Multiple Columns
- Sorting By Column Position
- Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
Using the WHERE clause to check for equality or inequality
Using the WHERE clause to check for greater or less than
Checking for NULL
Using WHERE and ORDER BY Together
The WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
More SELECTs with WHERE
Checking Multiple Conditions
- Order of Evaluation
Writing SELECTs with Multiple Conditions
- Mathematical Calculations
Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
- Selecting Distinct Records
Working with Aggregate Functions
Built-in Data Manipulation Functions
- Common Math Functions
- Common String Functions
- Common Date Functions
Data Manipulation Functions
- Table Aliases
- Multi-table Joins
- UNION ALL
- UNION Rules
Working with Unions
Conditional Processing with CASE
INSERT, UPDATE, DELETE
Student Challenges - Design your own reports
Introduction to Users and Schemas
- Definitions and Client Tools
- SQL Developer Login
About the HR Schema
- Sample Schemas
- HR Schema Entities
Creating An Application Schema
Exercise: Create a User
- Nested Subquery
- Subquery in the HAVING clause
- Inner Joins
- Outer Joins
The DECODE Function
The Case Expression
Exercise: Conditional Processing
What Are SQL Functions?
Exercise: Character Functions
- The TO_CHAR Function with numbers
- INSERT Statement Categories
- File Naming Conventions
- Variable Display
- The IF Statement
- The CASE Statement
- The LOOP Statement
- The WHILE Statement
- The FOR Statement
Salary Classification using Conditional Statements
Salary Increases using Loops
Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.
Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.
Learn through pre-recorded video sessions delivered by experts with your own pace and timing.
Live Sessions by expert trainer
30 hrs session recorded videos
Study and Practice course material
Lab practice environment (dedicated machine)
|Help for preparing lab setup in students laptop|
|Guidance for oracle certification exams|
|100% learning satisfaction guaranteed|
Duration: 20 sessions
Duration: 20 sessions
No Records Found
No Records Found
Our trainer is an OCP & OCM certified consultant and has significant amount of experience in working with the technology, having 8yrs of experience.
Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.
Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that
For practical execution, our trainer/technical team will provide server access details to the student
Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.
Live-Online training is where you can have live session with the trainer and clarify queries parallely.
Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.
You can contact our support team, or just drop an email to [email protected] with your queries.
The course material and recorded videos which are provided during the course period. You can download it anytime.
Visit our website regularly to check discount offers time to time. However, we provide discount for single participant
& special discount for 2 or more participants.
* If request for cancelation is made within 2 days of enrolment for class, 100% refunded.
* If request made after 2 days, then Refund is made after deduction of administration fee.
Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies
Recently I took Oracle Golden gate and Exadata-X6 classroom training from AKSWAVE ORACLE TRAINIGS by Mr.Akal Singh good teaching and good Lab Environment.One of the Best Institute in Hyderabad.
This institute is a very good platform to build your career. Mr Akal Singh is one of the best teacher for Oracle DBA. in this institute lab facilities is very good.it is the best institute for 12c DBA and RAC.