12 months video access
6 months lab accessBUY RECORDED TRAINING
12 months video access
6 months lab accessBUY TRAINING
Oracle SQL Training
We are currently offering a top quality oracle SQL training program for interested students and professionals. Registration for our Oracle SQL classes is open for anyone in the world because it is an online course. Also there is no prerequisite required for this course.
Students can use this training to prepare for the topics required to pass the Oracle Database SQL Exam Number: 1Z0-071 exam as part of becoming an Oracle Database SQL Certified Associate. After this course, students can register for the Oracle PL/SQL training program to prepare for the Oracle Database 11g: Program with PL/SQL Exam 1Z0-144 exam. Passing these examinations will help in getting the Oracle OCA certification.
Course Details
1. Taught by Srini Ramineni. Srini is also the founder of DBA University. His profile can be read here.
2. 12 months of on demand access to all the videos on a 24*7 basis.
3. There are 20 videos in this course with each video about 1.5 hours in duration.
4. Each student receives a dedicated Remote Desktop Connection for 6 months of access. (with an option to increase the access duration to 1 year.)
5. Click HERE to download the training brochure (course topics and more details).
6. The course fee is $499.
7. The training starts with fundamentals of SQL language and goes all the way to expert level SQL topics. The training also contains topics on how to perform a comprehensive relational database design.
8. Students can use this training as a prerequisite course for Oracle, MS SQL Server and Big Data.
9. The lab exercises contain sample tables developed by DBA University with custom data records.
Overview
Oracle SQL skills are a must for any Information Technology job today. Furthermore, because of the standard nature of the SQL language syntax, one can use these skills even for working with a MS SQL Server database and working with Hadoop for Big Data analysis as well.
Additionally, there is a huge demand for Oracle SQL skills in any Oracle related software development position. One any given day one can find 20,000+ new job vacancies that require SQL language skills.
These skills are also mandatory for varied IT positions such as QA Engineer, Business Analyst, Project Manager and Big Data analyst roles.
Course Topics
Relational database design
Computer Database Concepts
Relational Database Design. An interactive practical example.
Optimization of database design by using Normalization.
Installation of Oracle 19c Database Client software.
Setting up Oracle database connections using netca tool.
How to obtain Entity Relationship Diagram of existing database from SQL*Developer.
Role of SQL in RDBMS.
Simple SQL statements
Basic SQL construct
Column naming conventions
Importance of NULL
Concatenation operator
Arithmetic operators and expressions
Operator precedence and Parenthesis
Character strings
Tables and Table Joins
Need for joins
Cartesian products
Column aliases
Types of joins
ANSI Syntax and Oracle Syntax for writing Join statements.
Filtering and Sorting data
Limiting rows retrieved
Using LIKE for pattern matching
Using logical operators AND, OR & NOT
Using BETWEEN & IN operators
Sorting data using ORDER BY clause
Oracle SQL Functions part 1
SQL Functions overview
What are single row functions?
Using Character functions
Using Number functions
Using Date functions
Using CASE and DECODE
Nested functions
Data type conversion functions
Format masks
Oracle SQL Functions part 2
What are multi row functions?
Various multi row functions
Grouping data with GROUP BY clause
Using the HAVING clause
Sorting GROUP BY data
SQLPlus queries, formatting and reports
Logging into SQLPlus
Writing queries in SQLPlus
Substitution variables using single ampersand and double ampersand
Using DEFINE & UNDEFINE commands
Using SET command
Setting COLUMN format
Editing data from buffer
Creating and running reports
Nested SQL queries
Need for nested queries
Types of nested queries
USING EXISTS, ALL & ANY operators
Database Definition Language DDL
Creating tables
Modifying tables
Dropping tables
Creating and replacing views
Creating and dropping synonyms
Creating modifying and dropping sequences
Database Manipulation Language DML
What is data manipulation in a database
Need for data manipulation
INSERT statement
UPDATE statement
DELETE statement
MERGE statement
Database Control Language DCL
Definition of Transaction
COMMIT & ROLLBACK statements
Using the SAVEPOINT statement
Automatic COMMIT behavior in SQL*Developer and SQL*Plus utilities.
Indexes and Index types
What are Indexes?
Need for Indexes
Types of Indexes
Composite Indexes
Function based Indexes
Analyzing and rebuilding Indexes
Privileges, Users, Roles & Grants
System privileges
Object privileges
Creating and managing users
Creating and assigning roles
Granting Roles
Last but not the least
Set operators in SQL
RANK() function
ROWID & ROWNUM
Analytic functions
Data dictionary views
SQL Course
Great Course that goes into detail and gives plenty of hands on lab.
Practical Knowledge
I would recommend the SQL course as an economical way to obtain good SQL knowledge and how it is used in the real world. Srini’s explanation of the terms and examples is well rounded and he presents well. As an instructor he provides good support for the on demand version of the course and works with the student to make sure they are able to be successful in completing the course.
I am a social anthropologist with a passion to understand data from a data base scientist perspective. Despite the passion, I dreaded the technology jargons out there in the field of IT and thought joining such schools would be intimidating for those who never had IT background. Thanks to DBA university and the instructor Mr.Srini Ramineni. His seminars are very easy for a reasonable person to understand with his words ‘the sky is the limit’ and the secret is but to follow logic , stick to rules and practice!!!!!! I am encouraged as never. I am now able to understand a lot within SQL in a very short time and I feel more confident to go further. I encourage more people to Join
I took 2 courses (oracle DBA training and SQL training ) at DBA university. Both courses were well presented and had a good number of labs. SRINI is a great instructor and has a lot of experience. He has great knowledge on database administration.He is very engaging and patient.He provided very good and clear explanations of very difficult concepts and made sure every student was on the same page.I learned a lot of valuable information from him and was able to pass my exams.I can only say job well done and money well spent. I am currently taking my 3rd course( Oracle RAC ,ASM and DATA GUARD ) and so far i am having a wonderful experience.
I underwent training in this DBA university and the faculty is amazing…I didnt expect this much of information to be acquired out of this training. The faculty uses white board and instant lab sessions, so you will feel like typical classroom training and since the lab sessions are completed then and there, you dont need to work hard after the session gets over. You just need to be focused and follow instruction of the faculty to become a expert DBA either in core concepts or in RAC,ASM and DG. The training is truly amazing and enhanced my knowledge multi fold.
I felt its worth spending time and money on Oracle DBA training session provided by srini , am from different background and never felt its difficult in shifting my career towards oracle DBA it was that smooth and clean training provided by srini.
Am looking forward to take RAC DBA training session.
It was really great to be a part of ORACLE SQL class. Teacher was very cooperative and helpful. I am planning to do more classes with them in future.
DBA training was very good , dedicated and gave us the most important topics that we need as an oracle DBA .My advice to all is to be prepared for this course study day by day as you could and keep searching about more details to get the full benefit from this training .
Thanks to Srini he was very helpful ,patient and friendly.
Very few trainers spend time explaining every detail of a course. I have had the chance to do just one course (Oracle DBA) at DBA university, but will not hesitate one moment taking up another course. The trainer summarized his tremendous experience in the IT sector, and passed it on to the students, addressing every concept that matters with practical exercises! At the beginning it was not that easy, but thanks to the trainer for making it possible to enjoy an entirely new domain.
Beside the skills, the platform is amazing. The sound quality is excellent!
I could not differentiate from a traditional 4-wall classroom…GREAT JOB!
I took the Oracle RAC ASM DG course and thoroughly enjoyed it. This was my second course with DBA University (the first being the Oracle DBA Training course), and both were well worth it.
Srini is a pretty knowledgeable instructor. Not only did he explain things clearly but he related the course material to real-life situations as well.
I wish such advanced topics as encryption, data masking, Virtual Private Databases, etc. had been covered. Maybe something for the future or possibly even a new course altogether!
I strongly recommend these courses for anyone thinking about going into Oracle database administration, and I won’t hesitate to take future courses with DBA University.