22 yrs exp
Reading and LAB guide
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
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
Lives 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 timings
This Course Includes:
11 % OFF ₹ 18,000/- $204 ₹16,000/-
SELF-PACED LEARNINGThis Course Includes:
No Video 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
I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.
I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.
Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.