Email - info@dbauniversity.com

Phone -  720 934 1260, Chicago, USA.
Google Rating
4.9
BUY - LIVE Online TrainingBUY 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 most of the topics required to pass the Oracle Database 12c SQL 1Z0-071 exam as part of their Oracle OCA and OCP certification. Once you complete this course, you can register for the Oracle PL/SQL training program to prepare for the Oracle Database 11g: Program with PL/SQL Exam 1Z0-144 exam. If you pass both these exams, you will get the Oracle OCA certification.

Course Details

1. 12 months of on demand access to all the videos on a 24*7 basis.

2. There are 20 videos in this course with each video about 1.5 hours in duration.

3. Each student receives a dedicated Remote Desktop Connection for 6 months of access. (with an option to increase the access duration to 1 year.)

4. Click HERE to download the training brochure (course topics and more details).

5. The course fee is $299.

6. 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.

7. Students can use this training as a prerequisite course for Oracle, MS SQL Server and the Hadoop framework.

8. 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 Database Client software.
Installation of Oracle SQL*Developer.
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


Course Reviews

4.8

4.8
49 ratings
  • 5 stars39
  • 4 stars10
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 5

    I have just finished taking the Oracle DBA course at DBA University and I’ve learned a ton. I found the course to be very well structured and was delivered in a way anyone can learn and develop a skill set that will make a difference. The training materials were user-friendly with a very informative text-book that is easy to read and understand. The labs were well organized with step-by step categories that are color coded for ease reference.

    My teacher was Srini Ramineni and he did an awesome job. I found him to be a very knowledgeable instructor who knows his subject matter. He was very clear and thorough in every topic and I have gained a lot of knowledge from watching and listening to his lectures. As a visual learner myself, I have benefitted greatly from his labs demonstrations and the diagrams that he draws to elaborate on the key points that should not be missed by any future DBA. Without doubt, he knows how to break down even the most seemingly complex topic and he teach it in a way anyone can understand. As a student who took the recorded version of the training, I never felt alone or forgotten. Whenever I needed help, my instructor was available without fail and in a timely fashion. He made my learning experience to be fun and indeed, I enjoyed every step of the way.

    To anyone who is looking to learn a skill set that will change your life for the better, DBA University is a great place to be. You can rest assured that you will be equipped with knowledge and ability that will lead to a very rewarding career.

    Margaret
    Worcester, Massachusetts

  2. 5

    Oracle DBA course material is very well prepared and organized. Lab practices and home works are very well timed with the topics covered during the training sessions. Most importantly, the experienced, knowledgeable and professional instructor (Srini) is excellent in teaching, training and preparing the students to achieve their future career goals in the database field. If needed, the instructor also goes beyond the training schedule to cover the material. I not only recommend the course, but also strongly recommend any courses that are offered by this instructor. And I have already registered myself for the next course (“Oracle RAC, ASM and DG”) offered by the same instructor.

    ################################

    I have taken the course “Oracle RAC, ASM and DG” at the DBA University. It’s an excellent course tought by experienced, knowledgeable and professional instructor (Srini Ramineni). 25% of training on lab machine and remaining will be on student’s PCs so that it helps student to continue to practice even after the course is completed. I also strongly recommend this course and any other courses offered by this instructor.

  3. 5

    Oracle DBA training is an excellent course to get your head around the key concepts of Oracle 11G and 12c. Srini does an excellent job explaining and teaching by real-world examples. Coming from a SQL Server background he was able to explain the similarities and differences to help me understand Oracle perfectly. I would recommend this course to anyone looking to learn Oracle and definitely sign up for the second part which is on ASM, RAC and Data Guard. I have signed up and am looking forward to it.

  4. 5

    It was a nice experience for me taking oracle DBA online training from dba university.The study material is well prepared and very clear for a beginner to follow .I really like the teaching style of our experienced instructor (Srini Ramineni) and his quick response for every student.The class is mix of theory and lab practice which makes learning more interesting.From my point of view this course is better than class room training .So i highly recommend this course .

  5. 5

    I really enjoyed this training class. Had little knowledge about rdbms, but Srini explained every step in his dba training materials and made sure ever student understood the concept and real world application.

    Very satisfied with the knowledge I gained from this training.

  6. 5

    I have recently finished Oracle DBA, training from DBA University. Srini is a very well experienced teacher with hands on industry experience. He explains the DBA concepts very well with LAB examples. This course is better than class room training. I highly recommend this course.

  7. 5

    It was a big experience for me taking this online course whith really white board ,Srini is a very good teacher who have a big understanding of the subject 9Oracle dba). I will take more course with Dba University…Highly recommended for everyone ….And the price is reasonable…

  8. 5

    Last month I finished the Oracle DBA Training and it was a great course. Srini Ramineni has a lot of experience in the industry and he explains really well. For me this course was complementary because I have experience as an Oracle DBA and I took the official course “Workshop I” by Oracle University, but there are many topics where they used GUI (Enterprise Manager) however the method used in Oracle DBA Training by DBA University is different because they work with command line (sql plus) and most of the companies required these skills.

  9. 5

    I attended Core DBA training online from DBA University. I really like Srini Ramineni teaching fashion which easily makes his student involve into the subject because his way of delivering topics are really impressing. He brings real time challenging topics that he has experienced in his career and explain it in a sweet way which give me confident to build my carrier as an Oracle DBA. LAB facility is full day during the weekend and 5 hours during week days. I always wanted to be a part of a game not to just watch a game and I achieved same in “DBA University”.

  10. 5

    I have recently finished Oracle DBA, RAC, ASM and Data Guard from DBA University. Srini is a very well experienced teacher who has lots of hands on industry experience. He explains each and every topic very well and makes learning really easy for you. You don’t really want to miss any moment of his class. He is a wonderful teacher. I am looking forward to join his Hadoop Class also.

  11. 1 2 3 4 5
67 STUDENTS ENROLLED

See what others are buying

Contact Details

DBA University
605 W Madison St Suite 1108
Chicago IL 60661
United States of America

Ph 720 934 1260
Email info@dbauniversity.com

Setup Menus in Admin Panel

X