Download Pluralsight Oracle Database Tutorial Series - Oracle Database Training Courses

Hits: 73,306

·         Category: Education » Programming and Web Design

(10/30/93) Changes:

Oracle Database 12c Performance Tuning and Optimization was added!

Oracle is a distributed database that can work with different operating systems. This product was manufactured by Oracle Corporation. 
PL / SQL is another Oracle product that was built for SQL and communication between the database. The PL / SQL syntax is similar to that of Ada, Pascal, and is one of the three programming languages ​​that exist in the Oracle database with SQL and Java. This language has structures such as variables, conditional expressions, repetitive loops, and exception structures. It also supports the presentation structure, and when an application is stored in a database, and a MacIt will be implemented at a later time. While programmers can easily embed data manipulation language, statements directly to the PL / SQL code using explicit SQL statements require the definition of more complex "dynamic" data in PL / SQL. However, the statements The DML provides the foundation for most PL / SQL codes in applications. 
In the course of training of Pluralsight Oracle Tutorial Series offers key capabilities of Oracle PL / SQL are familiar.

Topics Education of Oracle PL / SQL Fundamentals - Part 1:
- Introduction to the course 
- Introduction to Anonymous Blocks 
- datatypes used in PL / SQL 
- a loop implemented in PL / SQL 
- implementation of conditional sentences 
- markers 
- Understanding Exceptions 
- Debugging 
- And ... 

Oracle PL / SQL Fundamentals - Part 2:
- PL / SQL overview 
- Procedures 
- Functions 
- Process Parameters and Functions 
- Below Local Programs (Local Subprograms) 
- Package Specifications 
- Package Body Concept 
- Calling SQL Functions 
- And 

more ... Training Courses:
- Oracle Database 12c Basics
- Install and upgrade Oracle Database 12c 
- Performance Tuning and Oracle Database 12c Optimization
- And ...

Oracle PL / SQL Fundamentals - Part 1:
Get coding quickly and efficiently with Oracle PL / SQL, Oracle's database development language. This course is the first of a two part series, covering the essentials and fundamentals of Oracle PL / SQL.

Topics include:
- Course Introduction    
- Anonymous Blocks     
- PL / SQL Commonly Used Datatypes     
- Loops    
- Conditional Execution     
- Cursors    
- Exceptions    
- Debugging 

Oracle PL / SQL Fundamentals - Part 2:
In this course we will take an in-depth look at Procedures , Functions, and Packages. These named program units are powerful programming constructs that can greatly enhance and optimize your code. 

Topics include:
- Overview 
- Procedures     
- Functions    
- Parameters in Procedures & Functions     
- Local Subprograms     
- Package Specification     
- Package Body    
- Calling Functions from SQL    
- Roles & Privileges With Subprograms 

Oracle Database 12c Fundamentals:
This course will get you up to speed with the Oracle Database platform in general and the Oracle Database 12c release in particular. You'll also be prepared to pass the Oracle Certified Administrator (OCA) certification exam. 

Topics include:
- Exploring Oracle Database 12c Architecture: Part 1     
- Exploring Oracle Database 12c Architecture: Part 2    
- Introducing Oracle Database 12c Instance    
- Configuring Oracle Database 12c Network Environment 
- Managing Oracle Database 12c Storage Structures    
- Creating Common Database Objects in Oracle Database 12c    
- Oracle Database 12c User Administration Basics    
- Managing Space and Undo Data in Oracle Database 12c 

Oracle Database 12c: Installation and Upgrade:
In this course we look at installing and upgrading Oracle on Windows and Linux. 

Topics include:
- Planning for Oracle Database 12c Installation     
- Installing Oracle Grid Infrastructure 12c    
- Installing Oracle Database 12c in Microsoft Windows    
- Installing Oracle Database 12c in Linux     
- Creating a Database in Oracle Database 12c     
- Installing Oracle Enterprise Manager Cloud Control 12c    
- Upgrading to Oracle Database 12c 

Oracle Database 12c Performance Tuning and Optimization:
This course will teach you how to maintain and manage performance in Oracle Database 12c, and overlaps heavily with the OCP exam objectives. 

Topics include:
- Introduction to Oracle Database 12c Performance Tuning 
- Monitoring Oracle Database 12c Performance 
- Tuning SQL in Oracle Database 12c 
- Managing Resources With Database Resource Manager 
- Automating Tasks With Oracle Database 12c Scheduler 
- Managing Oracle Database 12c Data Concurrency

More info (open / close)

Specifications

Release new release report

Manufacturer: Plurals / Pluralsight 
Language: English 
Teacher: Pankaj Jain, Tim Warner 
Education Level: 
File Size: ~ 2200 MB 
Release Date: 10:30 - 1393/10/6 | 2014.12.27 
Source: PC Download / www.p30download.ir 
Rating:  

download links

DownloadCrash ReportGuide

Oracle PL / SQL Fundamentals - Part 1 
 download - 466.6 MB 
 Oracle PL / SQL Fundamentals - Part 2 
 download - 482.7 MB 
 Oracle Database 12c Fundamentals 
 download - 493.3 MB 
 Oracle Database 12c: Installation and Upgrade 
 download - 373.4 MB 
 course Oracle Database 12c Performance Tuning and Optimization 
 download - 411.9 MB

 Oracle database management training videos (in Farsi)

File password www.p30download.com