Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
EXTREMELY USEFUL TO UNDERSTAND THE ADVANCE SQL 11g CONCEPTS
At the end of this course, you will get the knowledge of...
How to write SQL queries to access data stored in an Oracle Database schema. Learn to manipulate data and use various types of functions for customizing data output.
You will learn Oracle SQL 11g advance concepts like General functions,Views,Database Objects,Controlling User Access, Set Operators, Adv Date Time Functions,Group By Clause, Sub-queries, Hierarchical Retrieval,Oracle Extensions to DML and DDL Statements
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: General Functions|
Null Related FunctionsPreview
Encoding and Decoding Functions
Practical demo on How to use General Functions in SQL Advance
|Section 2: Views|
Introduction to Views
Practical demo on How to Use Views
|Section 3: Other Database Objects|
Practical demo on How to use other Database Objects
|Section 4: Controlling User Access|
Access Control, Users, Roles and Privileges
Granting and Revoking Privileges
Practical demo on How to Control User Access
|Section 5: Set Operators|
Working with Set Operators
Practical demo on How to work with SET Operators
|Section 6: Advanced Date Time Functions|
Basic Concepts to understand datetime functions
Practical demo on How to use Advanced date Time Functions
|Section 7: Enhancements to Group BY Clause|
Advanced Concepts - Group by Clause
Use of GROUPING Conceps
Practical demo on how to use Enhancements to Group By Clause
|Section 8: Advanced Subqueries|
Multiple-Column Subquery, Scalar Subquery
Correlated Subquery, The EXISTS Operator and the WITH Clause
Practical demo how to use Advanced Sub-Queries
|Section 9: Hierarchical Retrieval|
Fundamentals of Hierarchical Queries
Practical demo on how to use Hierarchical Retrieval
|Section 10: Oracle 9i Extensions to DML and DDL Statements|
Multitable INSERT Statements
External tables and Creating INDEX with CREATE TABLE Statement
Practical demo on how to use Oracle extensions to DML and DDL Statements
We offer courses in specialized technology domains that are well aligned with market trends, geared towards enabling gainful careers and are affordable. Parallel Branch is an interactive approach to e-learning and a perfect way to Jump Start your career.
In today’s job market, it’s important to have the skills to match current needs and to stay on par with technological advances. The flexible, affordable and high-quality online technical courses at Parallel Branch provide the opportunity for you to learn the skills you need to move ahead and stay there.