| 1 - Advanced SQL Quiz.html | 0 B | ||
| 1 - Introduction English.vtt | 2.4 KB | ||
| 1 - Introduction.mp4 | 4 MB | ||
| 10 - Toad For Oracle Installation English.vtt | 4.1 KB | ||
| 10 - Toad For Oracle Installation.mp4 | 29.2 MB | ||
| 11 - Toad for Oracle quick tour English.vtt | 6 KB | ||
| 11 - Toad for Oracle quick tour.mp4 | 39.2 MB | ||
| 12 - Connecting Toad For Oracle to Database English.vtt | 4.8 KB | ||
| 12 - Connecting Toad For Oracle to Database.mp4 | 33.1 MB | ||
| 13 - What are Analytic Functions English.vtt | 6.2 KB | ||
| 13 - What are Analytic Functions.mp4 | 36.6 MB | ||
| 14 - Syntax For Using Analytic Functions English.vtt | 3.9 KB | ||
| 14 - Syntax For Using Analytic Functions.mp4 | 15.8 MB | ||
| 15 - Using the PARTITION BY Clause English.vtt | 7.6 KB | ||
| 15 - Using the PARTITION BY Clause.mp4 | 48.2 MB | ||
| 16 - Using the ORDER BY Clause English.vtt | 5.5 KB | ||
| 16 - Using the ORDER BY Clause.mp4 | 30.8 MB | ||
| 17 - Using the Windowing Clause English.vtt | 1.8 KB | ||
| 17 - Using the Windowing Clause.mp4 | 5.2 MB | ||
| 18 - ROWNUMBER FUNCTION English.vtt | 9.8 KB | ||
| 18 - ROWNUMBER FUNCTION.mp4 | 75.2 MB | ||
| 19 - RANK FUNCTION English.vtt | 5.3 KB | ||
| 19 - RANK FUNCTION.mp4 | 32.3 MB | ||
| 2 - Oracle 11g Express Download English.vtt | 4.8 KB | ||
| 2 - Oracle 11g Express Download.mp4 | 32.5 MB | ||
| 20 - DENSERANK FUNCTION English.vtt | 5.6 KB | ||
| 20 - DENSERANK FUNCTION.mp4 | 37 MB | ||
| 21 - LEAD FUNCTION English.vtt | 6.8 KB | ||
| 21 - LEAD FUNCTION.mp4 | 39.6 MB | ||
| 22 - LAG FUNCTION English.vtt | 3.4 KB | ||
| 22 - LAG FUNCTION.mp4 | 18 MB | ||
| 23 - FIRST AND LAST FUNCTIONS English.vtt | 7.8 KB | ||
| 23 - FIRST AND LAST FUNCTIONS.mp4 | 55.5 MB | ||
| 24 - LISTAGG FUNCTION English.vtt | 5.9 KB | ||
| 24 - LISTAGG FUNCTION.mp4 | 38.3 MB | ||
| 25 - Viewing data and returning Minimum value English.vtt | 8.7 KB | ||
| 25 - Viewing data and returning Minimum value.mp4 | 69.4 MB | ||
| 26 - View data and create a report using SQL English.vtt | 10.8 KB | ||
| 26 - View data and create a report using SQL.mp4 | 96.2 MB | ||
| 27 - Using SET Operators English.vtt | 4 KB | ||
| 27 - Using SET Operators.mp4 | 11.1 MB | ||
| 28 - UNION SET Operator English.vtt | 4.9 KB | ||
| 28 - UNION SET Operator.mp4 | 38.4 MB | ||
| 29 - UNION ALL SET Operator English.vtt | 2.6 KB | ||
| 29 - UNION ALL SET Operator.mp4 | 16.9 MB | ||
| 3 - Oracle 11g Installation English.vtt | 4.1 KB | ||
| 3 - Oracle 11g Installation.mp4 | 26.7 MB | ||
| 30 - INTERSECT SET Operator English.vtt | 2.4 KB | ||
| 30 - INTERSECT SET Operator.mp4 | 17.9 MB | ||
| 31 - MINUS SET Operator English.vtt | 1.5 KB | ||
| 31 - MINUS SET Operator.mp4 | 10.2 MB | ||
| 32 - SET Operators Summary English.vtt | 3 KB | ||
| 32 - SET Operators Summary.mp4 | 20.2 MB | ||
| 33 - Flashback Query English.vtt | 5 KB | ||
| 33 - Flashback Query.mp4 | 9.2 MB | ||
| 34 - Undo Parameters English.vtt | 5.1 KB | ||
| 34 - Undo Parameters.mp4 | 19.3 MB | ||
| 35 - Viewing data using statement level flashback English.vtt | 8.9 KB | ||
| 35 - Viewing data using statement level flashback.mp4 | 57 MB | ||
| 36 - Rolling Back Data Part 1 English.vtt | 5.5 KB | ||
| 36 - Rolling Back Data Part 1.mp4 | 51 MB | ||
| 37 - Rolling Back Data Part 2 English.vtt | 11.1 KB | ||
| 37 - Rolling Back Data Part 2.mp4 | 92.7 MB | ||
| 38 - Session level flashback English.vtt | 6.6 KB | ||
| 38 - Session level flashback.mp4 | 36.9 MB | ||
| 39 - Describe Command English.vtt | 3 KB | ||
| 39 - Describe Command.mp4 | 22.1 MB | ||
| 4 - Unlocking Sample HR Schema Account English.vtt | 4 KB | ||
| 4 - Unlocking Sample HR Schema Account.mp4 | 26.5 MB | ||
| 40 - Sequences English.vtt | 6.4 KB | ||
| 40 - Sequences.mp4 | 42.7 MB | ||
| 41 - Syntax for Creating Sequences English.vtt | 4.5 KB | ||
| 41 - Syntax for Creating Sequences.mp4 | 39.4 MB | ||
| 42 - How to use a sequence English.vtt | 7.8 KB | ||
| 42 - How to use a sequence.mp4 | 63.5 MB | ||
| 43 - views English.vtt | 9.3 KB | ||
| 43 - views.mp4 | 70.6 MB | ||
| 44 - Synonyms English.vtt | 4.6 KB | ||
| 44 - Synonyms.mp4 | 31.8 MB | ||
| 45 - QUIZ English.vtt | 512 B | ||
| 45 - QUIZ.mp4 | 310.6 KB | ||
| 47 - Thank You.html | 204.8 B | ||
| 5 - Java Development Kit Jdk 8 Download and Installation English.vtt | 4.4 KB | ||
| 5 - Java Development Kit Jdk 8 Download and Installation.mp4 | 41 MB | ||
| 6 - Oracle SQL Developer Download English.vtt | 4.5 KB | ||
| 6 - Oracle SQL Developer Download.mp4 | 30.1 MB | ||
| 7 - Oracle SQL Developer Installation English.vtt | 5.4 KB | ||
| 7 - Oracle SQL Developer Installation.mp4 | 46.6 MB | ||
| 8 - Launching Oracle SQL Developer English.vtt | 3.8 KB | ||
| 8 - Launching Oracle SQL Developer.mp4 | 18 MB | ||
| 9 - Toad For Oracle Download English.vtt | 3.4 KB | ||
| 9 - Toad For Oracle Download.mp4 | 34.7 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 94 total files | |||
Advanced Oracle Sql: Learn Advanced Sql Skills
https://DevCourseWeb.com
Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: 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
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.1 GB | freecoursewb | 6 days | 16 | 9 | |
|
Udemy - Huawei HCIE Datacom Labs - Advanced IGP, BGP, MPLS VPN, EVPN Posted by
freecoursewb in Other
|
3.8 GB | freecoursewb | 1 week | 8 | 9 |
| 271.8 MB | freecoursewb | 1 week | 12 | 6 | |
| 4 GB | freecoursewb | 1 week | 0 | 0 | |
| 2.7 GB | freecoursewb | 3 weeks | 2 | 1 |
All Comments