Udemy - Oracle Database For Beginners
- Type:
- Other > Other
- Files:
- 60
- Size:
- 3.21 GiB (3441886339 Bytes)
- Uploaded:
- 2020-12-11 05:44:56 GMT
- By:
- tuts756
- Seeders:
- 7
- Leechers:
- 2
- Comments
- 0
- Info Hash: DC49CBD2C6D3243536FC2F7FEACC4C24965A9470
(Problems with magnets links are fixed by upgrading your torrent client!)
Description
Learn how to use Oracle Database to store, manipulate and query data. It takes you from fundamentals of databases to creating program units to implement business logic and rules using PL/SQL.
The following are major topics covered:
What is DBMS and RDBMS
How to get started with Oracle Database 18c XE and Oracle SQL Developer
How to use SQL to retrieve, manipulate and create data
How to group data using GROUP BY and HAVING clauses
How to use different types of joins to get data from multiple tables
How to use subquery and correlated subquery to write complex queries
What is a view, advantages of view and how to manipulate base table through view
What is index and how index improves performance
Implementing object-level security using object privileges
How to create and use regular expressions
Writing PL/SQL blocks to process data
Various control structures in PL/SQL
Handling exceptions
Explicit and Implicit cursors
Creating procedures and functions to implement business logic
Creating database triggers to implement business rules
Dynamic SQL and collections
Who this course is for:
Anyone interested in Oracle Database, SQL and PL/SQL
Requirements
Working knowledge of Computers. Knowledge of programming is a plus.
Last Updated 11/2019
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/007 Number Functions and Date Functions.mp4 | 206.73 MiB |
| TutsNode.com.txt | 63 B |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/001 Introduction To Course.mp4 | 11.6 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/001 lecture1-assignments.pdf | 248.86 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/002 Introduction To DBMS and Oracle Database.mp4 | 84.05 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/002 lecture2-assignments.pdf | 252.59 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/003 Installing Oracle Database 18c Express Edition (XE) on Windows.mp4 | 92.42 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/003 lecture3-assignments.pdf | 255.3 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/004 Installing SQL Developer and connecting to Oracle Database.mp4 | 79.13 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/01 Getting Started/004 lecture4-assignments.pdf | 250.56 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/005 lecture5-assignments.pdf | 256.92 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/005 SELECT Command.mp4 | 142.75 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/006 lecture6-assignments.pdf | 254.5 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/006 Manipulating Data using DML commands.mp4 | 74.25 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/007 lecture7-assignments.pdf | 253.99 KiB |
| [TGx]Downloaded from torrentgalaxy.to .txt | 585 B |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/008 lecture8-assignments.pdf | 251.35 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/008 String Functions.mp4 | 108.92 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/009 Conversion Functions and Miscellaneous Functions.mp4 | 127.41 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/009 lecture9-assignments.pdf | 254.58 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/010 Creating Tables.mp4 | 150.78 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/010 lecture10-assignments.pdf | 251.73 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/011 Altering structure of table and dropping table.mp4 | 82.99 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/011 lecture11-assignments.pdf | 247.85 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/012 Grouping Data using Group By and Group Functions.mp4 | 100.86 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/012 lecture12-assignments.pdf | 251.67 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/013 Joining Tables.mp4 | 201.55 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/013 lecture13-assignments.pdf | 254.6 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/014 lecture14-assignments.pdf | 254.2 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/02 SQL/014 Subqueries.mp4 | 177.89 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/015 lecture15-assignments.pdf | 256.33 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/015 Views.mp4 | 170.64 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/016 Indexes and Sequences.mp4 | 125.2 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/016 lecture16-assignments.pdf | 254.1 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/017 lecture17-assignments.pdf | 254.72 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/017 Security - Granting and Revoking Privileges.mp4 | 71.22 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/018 lecture18-assignments.pdf | 249.42 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/03 Oracle Database Objects - Views, Indexes, Sequences and Security/018 Regular Expressions.mp4 | 75.38 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/019 Introduction to PL_SQL.mp4 | 77.3 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/019 lecture19-assignments.pdf | 252.93 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/020 Control Structures in PL_SQL.mp4 | 85.97 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/020 lecture20-assignments.pdf | 251.78 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/021 lecture21-assignments.pdf | 248.09 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/021 Looping Structures.mp4 | 79.14 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/022 Exception Handling.mp4 | 134.91 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/022 lecture22-assignments.pdf | 249.9 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/023 Cursor Handling.mp4 | 101.47 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/023 lecture23-assignments.pdf | 250.73 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/024 lecture24-assignments.pdf | 250.96 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/024 Program Units - Part 1.mp4 | 148.63 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/025 lecture25-assignments.pdf | 248.97 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/025 Programs Units - Part 2.mp4 | 152.09 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/026 Database Triggers - Part 1.mp4 | 144.8 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/026 lecture26-assignments.pdf | 250.69 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/027 Database Triggers - Part 2.mp4 | 103.52 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/027 lecture27-assignments.pdf | 250.88 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/028 Collections and Dynamic SQL.mp4 | 163.95 MiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/04 PL_SQL/028 lecture28-assignments.pdf | 247.78 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/05 Advanced SQL/029 Top-N Analysis.html | 3.31 KiB |
| [TutsNode.com] - Oracle Database For Beginners 2020/05 Advanced SQL/external-assets-links.txt | 72 B |
