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.
Oracle SQL is one of the world's most powerful version of the standard SQL language. The advanced capabilities of Oracle SQL will enable you to build advanced SQL statements or queries that can be stored on the database.
Oracle SQL is packed with advanced functions and features that gives the language powerful capabilities. Using these powerful features makes it easier to solve complex query related issues.
This course will give you the knowledge and understanding to confidently build complex queries to solve database related problems faster .
This course will teach you working examples of how to leverage Oracle SQL's powerful built-in functions for fast extraction of complex data and how to use native SQL for procedural processing. Every developer needs to know how to use Oracle SQL to summarize and aggregate data from large tables and how to use powerful features such as the "model" clause to make SQL act as a procedural language.
This course will teach you how the techniques for retrieving Oracle data faster and more elegantly .
This course is designed for those that have some basic knowledge of oracle SQL and Oracle Databases.
Some of the topic covered in this course includes:
• Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Retrieve row and column data from tables.
• Control privileges at the object and system level.
• Create indexes and constraints; alter existing schema objects.
• Write SELECT statements that include queries
• Create Business reports from SQL Statements
• Retrieve row and column data from tables
• Create tables to store data
• Run data manipulation statements (DML)
• Create reports of aggregated data
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Oracle 11g Express DownloadPreview
Oracle 11g InstallationPreview
Unlocking Sample HR Schema Account
Java Development Kit (Jdk) 8 Download and Installation
Oracle SQL Developer Download
Oracle SQL Developer Installation
Launching Oracle SQL Developer
Toad For Oracle Download
Toad For Oracle Installation
Toad for Oracle quick tour
Connecting Toad For Oracle to Database
|Section 2: Oracle SQL Analytic Functions|
What are Analytic Functions
Syntax For Using Analytic Functions
Using the PARTITION BY Clause
Using the ORDER BY Clause
Using the Windowing Clause
FIRST AND LAST FUNCTIONS
|Section 3: Viewing and Manipulating Data Using SQL|
Viewing data and returning Minimum value
View data and create a report using SQL
Using SET Operators
UNION SET Operator
UNION ALL SET Operator
INTERSECT SET Operator
MINUS SET Operator
SET Operators Summary
|Section 4: Viewing and Rolling Back Data with Flash Query|
Viewing data using statement level flashback
Rolling Back Data Part 1
Rolling Back Data Part 2
Session level flashback
|Section 5: Useful SQL COMMANDS|
Syntax for Creating Sequences
How to use a sequence
|Quiz 1||20 questions|
Test what you have learnt with this SQL Quiz
We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.