Last updated 6/2021MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.57 GB | Duration: 4h 18m

Oracle SQL is packed with advanced functions and features that provides powerful capabilities to build advanced querries

What you'll learn
Describe a tables's structure
Build advanced sql querries
Combine multiple querries into one
Create Business reports from SQL querries
Create Schema Objects like views
Recover data from database using flashback querries
Understand and build comples SQL querries
Know how to use Oracle SQL Developer
Manipulate data in a relational database
Write reports using SQL Statements
Build knowledge through Hands-on Exercises
Requirements
Familliarity with data processing concepts and techniques
Basic knowledge of SQL Language
Basic knowlege of relational database e,g Oracle
Description
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

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Oracle 11g Express

Lecture 3 Oracle 11g Installation

Lecture 4 Unlocking Sample HR Schema Account

Lecture 5 Java Development Kit (Jdk) 8 and Installation

Lecture 6 Oracle SQL Developer

Lecture 7 Oracle SQL Developer Installation

Lecture 8 Launching Oracle SQL Developer

Lecture 9 Toad For Oracle

Lecture 10 Toad For Oracle Installation

Lecture 11 Toad for Oracle quick tour

Lecture 12 Connecting Toad For Oracle to Database

Section 2: Oracle SQL Analytic Functions

Lecture 13 What are Analytic Functions

Lecture 14 Syntax For Using Analytic Functions

Lecture 15 Using the PARTITION BY Clause

Lecture 16 Using the ORDER BY Clause

Lecture 17 Using the Windowing Clause

Lecture 18 ROW_NUMBER FUNCTION

Lecture 19 RANK FUNCTION

Lecture 20 DENSE_RANK FUNCTION

Lecture 21 LEAD FUNCTION

Lecture 22 LAG FUNCTION

Lecture 23 FIRST AND LAST FUNCTIONS

Lecture 24 LISTAGG FUNCTION

Section 3: Viewing and Manipulating Data Using SQL

Lecture 25 Viewing data and returning Minimum value

Lecture 26 View data and create a report using SQL

Lecture 27 Using SET Operators

Lecture 28 UNION SET Operator

Lecture 29 UNION ALL SET Operator

Lecture 30 INTERSECT SET Operator

Lecture 31 MINUS SET Operator

Lecture 32 SET Operators Summary

Section 4: Viewing and Rolling Back Data with Flash Query

Lecture 33 Flashback Query

Lecture 34 Undo Parameters

Lecture 35 Viewing data using statement level flashback

Lecture 36 Rolling Back Data Part 1

Lecture 37 Rolling Back Data Part 2

Lecture 38 Session level flashback

Section 5: Useful SQL COMMANDS

Lecture 39 Describe Command

Lecture 40 Sequences

Lecture 41 Syntax for Creating Sequences

Lecture 42 How to use a sequence

Lecture 43 views

Lecture 44 Synonyms

Lecture 45 QUIZ

Lecture 46 Conclusion

Lecture 47 Thank You

System Analyst,Application Developers,PL /SQL Developers,Business Analysts,Developers,Data Warehouse Administrator,Form Developer,Functional Implementer,IT Professionals,Technology Hobbyist

HomePage:

Https://anonymz.com/https://www.udemy.com/course/advanced-oracle-sql-building-database-applications/