WeCours > Development > Database Design & Development > Le Bootcamp PL/SQL complet : “PL/SQL débutant à avancé”
4.49 sur 5
4.49

Le Bootcamp PL/SQL complet : “PL/SQL débutant à avancé”

Un guide complet pour faire de vous un développeur PL/SQL prêt à l'emploi. Couvre également les sujets d'examen Oracle 1Z0-144 et 1Z0-149 PL SQL
Instructeur :
Mahefa Abel
French
Réussissez l'Oracle 1Z0-149 : programme avec examen de certification PL/SQL - dès votre premier essai !
Réussissez l'examen de certification Oracle 1Z0-148 : Advanced PL/SQL - du premier coup !
Tout ce dont vous avez besoin pour coder PL/SQL du niveau débutant au niveau avancé
Chaque sujet est expliqué du plus facile au plus avancé.
Exemples du monde réel pour chaque section
Quelques techniques SQL avancées
Utilisez SQL Developer efficacement pour PL/SQL
Apprendre très bien l'architecture PL/SQL
Améliorer les performances des codes SQL et PL/SQL
Créez vos requêtes dynamiques SQL & PL/SQL
Apprendre la programmation orientée objet PL/SQL
Apprendre le réglage PL/SQL pour les performances
Apprenez et maîtrisez PL/SQL en codant avec des centaines d'exemples pratiques !
Devenez un professionnel certifié Oracle PL/SQL Developer prêt à l'emploi !

Dernières mises à jour du cours :

  • (Fév 2023) : La section “Oracle-Supplied PL/SQL Packages” a été ajoutée !
  • (janvier 2023) : la section “Utilisation de SQL dynamique et PL/SQL dans PL/SQL” a été ajoutée !
  • (novembre 2022) : les sous-titres sont ajoutés !
  • (sept. 2022) : de nouvelles questions de quiz sont ajoutées !

Devenez un professionnel certifié Oracle Database PL/SQL Developer !

Ce bootcamp de programmation PL/SQL complet est créé pour les sujets PL/SQL débutants à avancés avec des centaines d’exemples concrets. Chaque sujet commence du plus simple pour les non-programmeurs et va jusqu’aux parties les plus avancées pour les étudiants qui connaissent déjà PL/SQL. Chaque étudiant qui veut apprendre ou Devenir un héros en PL/SQL trouvera tout ce qu’il recherche.

Les élèves apprendront et amélioreront :

  • Compétences en codage PL/SQL
  • SQL & Performances PL/SQL
  • Évolutivité PL/SQL
  • Portabilité et sécurité des bases de données et programmation PL/SQL

Et nos étudiants seront également préparés pour :

  • Numéro d’examen : 1Z0-149 Oracle Database 19c : Programme avec PL/SQL  ; Examen de certification Oracle
  • Numéro d’examen : 1Z0-148 Oracle Database 12c : PL/SQL avancé  ;       | Examen de certification Oracle
  • Numéro d’examen : 1Z0-144 Oracle Database 12c : Programme avec PL/SQL | Examen de certification Oracle
  • Numéro d’examen : 1Z0-144 Oracle Database 11g : Programme avec PL/SQL | Examen de certification Oracle

Notre bootcamp de programmation PL/SQL couvre :

  • Terminologies PL/SQL
  • Architecture PL/SQL
  • Variables PL/SQL
  • Structures de contrôle PL/SQL
    • Structure Si-Alors-Sinon
    • Expressions de casse
    • Boucles
      • Boucle While
      • Boucle For
      • Boucle imbriquée
      • Étiquetage de boucle
      • Continuer la déclaration
      • Instruction GOTO
  • Utiliser SQL dans PL/SQL
  • Curseurs PL/SQL
  • Utilisation des unités de programme PL/SQL (fonctions et procédures)
  • Packages PL/SQL
  • Exceptions PL/SQL et gestion des exceptions
  • Débogage PL/SQL
  • SQL dynamique et amp ; PL/SQL
  • Types de données composites PL/SQL (collections)
    • Tableaux associatifs
    • Tableaux imbriqués
    • Varrays
    • Enregistrements
  • Déclencheurs PL/SQL
  • Packages fournis par Oracle
  • Utilisation des grands objets en PL/SQL (LOBs)
  • Utilisation de PL/SQL orienté objet
  • Utilisation du compilateur PL/SQL
  • PL/SQL Performances et optimisation
  • Mise en cache PL/SQL
  • Sécurité PL/SQL
  • PL/SQL Contrôle d’accès précis (VPD)
  • Conseils PL/SQL
  • Dépendances d’objets PL/SQL
  • Concevoir un meilleur PL/SQL
  • Utiliser Java/C en PL/SQL
  • Gestion des dépendances

 

Remarque importante : ce cours sera continuellement mis à jour avec plus de conférences, de quiz et d’évaluations pour améliorer vos connaissances d’Oracle PL/SQL

Rendez-vous dans le cours !

What is PL/SQL ?

1
Course Introductory Video
2
How to Use WeCours? +Some Useful Tips

This lecture is about how to use the WeCours platform. And also includes some useful tips to get most of out the course.

3
What is PL/SQL and Why to Use?

This lesson explains you about what is PL/SQL and Why you should choose PL/SQL as a Programming Language.

4
PL/SQL Architecture
5
What is Pluggable Database?

In this lecture, students are going to learn what the pluggable database, in other words, multitenant architecture is in Oracle Database.

6
The Sample (HR) Schema Used in This Course
7
Welcoming Gifts: Course Material & PL/SQL Cheatsheet
8
Quiz 1

This Quiz is about the first lecture. What is PL/SQL and Why to Use it and PL/SQL Architecture.

Software Installation

1
About the Database Installation
2
The Ways to Get a Database

In this SQL tutorial, the participants will learn how to get a database to proceed with The Complete PL/SQL Bootcamp: "Beginner to Advanced PL/SQL" course.

3
Option 1: Installing VMware and VirtualBox on Windows

In this SQL tutorial, the participants will learn how to download and install two virtualization software programs which are VMware and VirtualBox step by step.

4
Option 1: How to Install the Virtual Box on Mac OS X?
5
Option 1: Downloading Virtual Machine Image

In this tutorial, the participants will learn how to download the virtual machine image.

6
Option 1: Configuring the VMware Virtualization Software

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the VMware virtualization software as well as how to configure the virtual machine to get the most out of it.

7
Option 1: Configuring the Oracle VirtualBox Virtualization Software

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the Oracle VirtualBox virtualization software as well as how to configure the virtual machine to get the most out of it.

8
Option 1: Configuring SQL Developer inside of the Virtual Machine

In this SQL tutorial, the participants will learn how to configure Oracle SQL Developer inside of the Virtual Machine image that they downloaded step by step.

9
Important Note

For the students who could succeed to complete the Option-1

10
Option 2: Downloading and Installing the Oracle Database

In this lecture, students are going to learn the oracle database 19c installation.


Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".

11
Option 2: Unlocking the HR Schema

In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.

12
Option 2: Configuring and Using the SQL Developer

This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.

13
Option 2: Installing Sample Schemas in Oracle Database

In this tutorial, the course participants will learn about the easiest way how to install Oracle Sample Schemas to be able to work with many database sample schemas provided by Oracle.

14
Option 2: HR Schema Create Code (if you could not get the HR user in other ways)

This code includes the required SQL script to generate the HR schema with all its data.

Note 1: You can use this script if you could not have the HR schema properly.

Note 2: Just select all of the scripts and execute them in one step when connected as the SYS or SYSTEM user.

15
Option 3: Using Oracle Live SQL
16
Option 3: About Oracle Live SQL Restrictions

Let's Start Coding!

1
Anonymous Blocks
2
PL/SQL Outputs
3
Quiz 2

This Quiz is about the anonymous blocks and PL/SQL Outputs

PL/SQL Variables

1
What are Variables and Why to Use Them?
2
Naming Rules & Naming Conventions
3
Declaring & Initializing & Using Variables - Part 1

In this lecture you will learn how to use variables with different ways.

4
Declaring & Initializing & Using Variables - Part 2

In this lecture you will learn how to use variables with different ways.

5
Declaring & Initializing & Using Variables (Code Samples)
6
Using %TYPE Attribute

In this lecture, you will learn how to use %TYPE operator to automatically assign the datatype.

7
Using %Type Attribute (Code Samples)
8
PL/SQL Delimiters and Commenting Your Code

In this lesson you will learn how to use delimiters and how to write comments and why to use them.

9
PL/SQL Delimiters and Commenting (Code Samples)
10
PL SQL Variable Scope

This lecture is about the scopes of variables in the blocks.

11
PL SQL Variable Scope (Code Samples)
12
Using Bind Variables

In this lesson you will learn a performance variable, bind variables.

13
Using Bind Variables (Code Samples)

These are the codes that we used in Using Bind Variables Lesson

14
Quiz 3 - Variables

In this quiz, you will find multiple choice questions about the PL/SQL Variables.

Control Structures

1
What are Control Structures & IF Statements
2
What are Control Structures & IF Statements (Code Samples)
3
Case Expressions

In this lecture you will learn how to use case expressions and case statements in PL/SQL. These are the control structures like If statements.

4
Case Expressions (Code Samples)
5
What are Loops - Basic Loops

In this lecture you will learn the loops terminology and how to use basic loops in PL/SQL..

6
Basic Loops (Code Samples)
7
While Loops

In this lecture you will learn how to use while loops of PL/SQL..

8
While Loops (Code Samples)
9
For Loops
10
For Loops (Code Samples)
11
Nested Loops & Loop Labeling

In this lecture you will learn how to use a loop inside another one and exiting the outer loop with using labels in PL/SQL.

12
Nested Loops & Loop Labeling (Code Samples)
13
Continue Statement

In this lecture you will learn how to use continue statement in PL/SQL Loops

14
Continue Statement (Code Samples)
15
GOTO Statement
16
GOTO Statement (Code Samples)

Here you will find the codes of the examples that we did in our GOTO Statement lecture..

17
Quiz 4 - Control Structures

In this quiz you will find multiple choice quiz questions about the control strucures like if clause, loops, etc.

Using SQL in PL/SQL

1
Operating with Selected Database Data..

In this lecture you will learn how to operate data that you queried from a table.

2
Operating With Selected Queries (Code Samples)
3
DML Operations in PL/SQL

In this lecture, you will see how to insert, update and delete data in your tables with the help of PL/SQL.

4
DML Operations in PL/SQL (Code Samples)
5
Using Sequences in PL/SQL

You will learn how to use sequence objects in PL/SQL

6
Using Sequences in PL/SQL (Code Samples)

In this lecture you will learn how to use sequences in PL/SQL with different ways.

7
Extra - Enabling Server Outputs by Default

In this lecture you will learn how to make set serveroutput on command run automatically to enable server output.

8
Quiz 5 - Using SQL in PL/SQL

Composite Data Types

1
Simple Data Types vs Composite Data Types

In this lecture you will learn the difference between scalar data types and complex data types.

2
PL/SQL Records - Part 1
3
PL/SQL Records - Part 2

In this lecture, you will learn how to create a complext type and a real-world like example about PL/SQL Records

4
PL/SQL Records (Code Samples)
5
Easy DML With Records

With this lecture, you will learn how to insert or update the data in your table with using records, easily.

6
Easy DML With Records (Code Samples)
7
What Are Collections?

In this lecture you will learn what are PL/SQL collections and a brief explanation about the types of the collections.

8
Varrays & Collection Methods
9
Varrays (Code Samples)
10
Nested Tables
11
Nested Tables (Code Samples)
12
PL&SQL Associative Arrays (Part 1)
13
PL&SQL Associative Arrays (Part 2)
14
Associative Arrays (Code Samples)
15
Storing Collections in Tables - (Part 1)
16
Storing Collections in Tables - (Part 2)
17
Storing Collections in Tables (Code Samples)

Here is the code samples that we used in composite data types section.

18
Quiz 6 - Composite Data Types

PL/SQL Cursors

1
What are Cursors and Cursor Types in PL SQL?
2
Using Explicit Cursors
3
Using Explicit Cursors (Code Samples)
4
Using Cursors with Records

In this lecture you will learn how to use PL SQL records with cursors including cursor type records.

5
Cursors with Records (Code Samples)
6
Looping with Cursors

In this lecture you will learn how to loop with PL SQL cursors in many different ways. 

7
Looping with Cursors (Code Samples)

In this article you will find the sample codes that we did in "Looping with Cursors" lecture

8
PL SQL Cursors with Parameters

In this lecture you will learn how to use parameters with cursors. So you will use the same cursor with different parameters and you will get different results from the same cursor.

9
PL SQL Cursors with Parameters (Code Samples)

In this article you will find the sample codes that we did in "Cursors with Parameters" lecture

10
PL SQL Cursor Attributes
11
PL SQL Cursor Attributes (Code Samples)

In this article you will find the sample codes that we did in "Cursor Attributes" lecture

12
For Update Clause

In this lecture you will learn how to use the for update clause to lock the related rows

13
For Update Clause (Code Samples)
14
Where Current Of Clause

In this lecture you will learn how to update and delete the rows faster with using the wehre current of clause

15
Where Current Of Clause (Code Samples)
16
Reference Cursors

This lecture will be online today. It is processing and it takes some time.

17
Reference Cursors - (Code Samples)

Here are the codes that we did in our lecture

PL/SQL Exceptions

1
What are the Exceptions?
2
What are the Exceptions (Code Sample)
3
Handling the Exceptions!
4
Handling the Exceptions (Code Samples)
5
Handling the Nonpredefined Exceptions
6
Handling Nonpredefined Exceptions (Code Sample)
7
Handling & Raising User-Defined Exceptions

In this lecture you will learn how to handle the user-defined exceptions and raise an exception to its caller

8
Handling & Raising User-Defined Exceptions (Code Samples)
9
Using RAISE_APPLICATION_ERROR() Procedure

In this lecture you will learn how to raise an exception to the caller application with using pl sql raise_application_error procedure

10
Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)

PL/SQL Functions & Procedures

1
What are Functions & Procedures and Why We Use?

A brief description of the functions and procedures, and the difference between them and the anonymous blocks

2
What are Functions & Procedures and Why We Use (Code Samples)
3
Creating and Using Stored Procedures
4
Creating and Using Stored Procedures (Code Samples)
5
Using IN & OUT Parameters

In this lecture you will learn how to pass parameters to your procedures

6
Using IN & OUT Parameters (Code Samples)
7
Named & Mixed Notations and Default Option
8
Named & Mixed Notations and Default Option (Code Samples)
9
Creating and Using Functions (Part 1)
10
Creating and Using Functions (Part 2)
11
Creating and Using PL/SQL Functions (Code Samples)
12
Local Subprograms

In this PL/SQL tutorial, the Complete PL/SQL Bootcamp course participants will learn why and how to create local functions and local procedures of PL SQL.

13
Local Subprograms (Code Samples)
14
Overloading the Subprograms

In this lecture you will learn how to overload the functions and procedures

15
Overloading the Subprograms (Code Samples)
16
Handling the Exceptions in Subprograms
17
Handling the Exceptions in Subprograms (Code Samples)
18
Finding & Removing the Subprograms

In this lecture you will learn how to find your subprograms and how to drop the functions & procedures

19
Regular & Pipelined Table Functions

In this lecture you will learn how to query a function just like a table.

20
Regular & Pipelined Table Functions (Code Samples)

PL/SQL Packages

1
What Are Packages?

In this lecture you will learn the concept of the package and why you should create PL/SQL packages.

2
Creating & Using & Modifying & Removing the Packages

In this lecture you will learn how to create a package, how to use it, how to modify body and spec of a package and how to remove a package or a package body.

3
Creating & Using & Modifying & Removing the Packages (Code Samples)
4
Visibility of Package Objects

In this lecture you will learn the usage of public, private, global, local objects.

5
Visibility of Package Objects (Code Samples)
6
Illegal Object Reference & Forward Declaration

In this lecture you will learn when you will have the illegal object reference error and how to solve it with forward declaration

7
Package Initialization
8
Persistent State of Packages - Part 1

In this lecture you will learn how the package objects are stored in the memory and how long do they live in there.

9
Persistent State of Packages - Part 2

In this lecture you will learn how the package objects are stored in the memory and how long do they live in there.

10
Persistent State of Packages (Code Samples)
11
Using Collections in PL/SQL Packages - Part 1
12
Using Collections in PL/SQL Packages - Part 2
13
Using Collections in PL/SQL Packages (Code Samples)
14
How Can I Find the Packages?

In this lecture you will learn how to find the packages with using the SQL Developer tool and data dictionary views.

PL/SQL Triggers

1
What are Triggers & Trigger Types

In this lecture, you will learn the main concepts of triggers and brief explanations for the trigger types.

2
Understanding DML Triggers

This lecture will show you the full picture of the DML Triggers

3
Specifying the Timing of Triggers
4
Specifying the Timing of Triggers (Code Samples)
5
Statement & Row Level Triggers

In this lecture, you will learn the difference of statement and row level triggers, and see some examples about them.

6
Statement & Row Level Triggers (Code Samples)
7
Using New & Old Qualifiers in Triggers
8
Using New & Old Qualifiers in Triggers (Code Samples)
9
Using Conditional Predicates
10
Using Conditional Predicates (Code Samples)
11
Using RAISE_APPLICATION_ERROR Procedure in Triggers
12
Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
13
Using Update Of Event in Triggers
14
Using Update Of Event in Triggers (Code Samples)
15
Using WHEN Clause in Triggers
16
Using When Clause in Triggers (Code Samples)
17
INSTEAD OF Triggers
18
Instead of Triggers (Code Samples)
19
Exploring & Managing the Triggers
20
Creating Disabled Triggers
21
Creating Disabled Triggers (Code Samples)
22
Additional Real-World Examples for DML Triggers
23
Additional Real-World Examples for DML Triggers (Code Samples)
24
Compound Triggers

In this PL/SQL tutorial, the  PL/SQL Bootcamp course participants  will learn about what the Compound Triggers are and how to use Compound Triggers in PL/SQL with hands-on examples.

25
Compound Triggers (Code Samples)
26
Handling Mutating Table Errors
27
Handling Mutating Table Errors (Code Samples)

PL/SQL Debugging: Debugging Your Codes & Subprograms

1
PL/SQL Debugging: Debugging Your Subprograms - (Part 1)

This lecture explains PL/SQL Debugging and how to debug PL SQL procedures and PL SQL functions step by step using PL SQL debugging feature.


2
PL/SQL Debugging: Debugging Your Subprograms - (Part 2)
3
PL/SQL Debugging: Debugging Your Subprograms - (Part 3)
4
Granting Debug Privileges to a User
5
PL/SQL Debugging: Debugging the Anonymous Blocks
6
Source Code: Debugging the Anonymous Blocks

Using Dynamic SQL & PL/SQL in PL/SQL!

1
Introduction to Dynamic SQL and Dynamic PL/SQL

In this PL/SQL tutorial, we will demonstrate an introductory PL/SQL lecture about using the Dynamic SQL and Dynamic PLSQL.

2
Native Dynamic SQL, PL/SQL

In this PL/SQL tutorial, the students will learn the use of Native Dynamic SQL and Native Dynamic PL/SQL with several examples.

3
EXECUTE IMMEDIATE Statement

In this PL/SQL tutorial, students are going to learn how to use the EXECUTE IMMEDIATE statement without using the USING and INTO clauses in Oracle PL/SQL programming with its various examples.

4
Execute Immediate Statement (Code Samples)

The source codes used in the Execute Immediate Statement lecture

5
EXECUTE IMMEDIATE STATEMENT with the USING Clause

In this PL/SQL tutorial, students will learn the second method of the EXECUTE IMMEDIATE statement which is the execute immediate with the USING clause with its several examples.

6
EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples)

Includes the codes about how to use the execute immediate command with the USING clause

7
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses

In this PL/SQL tutorial, students will learn the third method of the EXECUTE IMMEDIATE statement which is the execute immediate with the USING and the INTO clauses with its examples.

8
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples)

Inludes the codes we used in the Execute Immediate Statement with the USING and INTO clauses

9
EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause

In this PL/SQL tutorial, students are going to learn how to use the EXECUTE IMMEDIATE statement with the BULK COLLECT INTO clause in Oracle PL/SQL programming with its examples.

10
Execute Immediate with Bulk Collect (Code Samples)

Inludes the codes we used with the Execute Immediate Statement with Bulk Collect

11
Dynamic PL/SQL Blocks

In this PL SQL tutorial, students will learn how to write Dynamic PL SQL with examples.

12
Dynamic PL/SQL Blocks (Code Sample)

The step by step code samples that we used in the DYNAMIC PL/SQL BLOCKS lesson

13
OPEN - FOR, FETCH Statements

In this PL/SQL tutorial, students will learn the Oracle OPEN FOR FETCH statements with various examples.

14
OPEN - FOR, FETCH Statements (Code Sample)

Includes step by step executions of the code lines we used in the OPEN-FOR, FETCH Statements lecture

15
Using the DMBS_SQL Package (The Method 4)

In this PL SQL tutorial, the course participants will learn how to use the DMBS_SQL package or also known as "the Method 4" while using Dynamic SQL & PL/SQL in Oracle.

16
Using the DBMS_SQL Package (Code Samples)

Includes step by step executions of the code lines we used in the USING THE DBMS_SQL PACKAGE lecture

Using Oracle-Supplied Packages

1
What are Oracle Supplied Packages?

This PL/SQL tutorial explains what the Oracle Supplied Packages are and why we need to use Oracle Supplied PL/SQL Packages.

2
Using the DBMS_OUTPUT Package

In this PL SQL tutorial, participants will learn one of the most frequently used Oracle Supplied PL/SQL packages, which is the DBMS_OUTPUT package, either to display PL/SQL debugging information or to send text messages from PL SQL procedures and functions with various examples.

3
Using the DBMS_OUTPUT Package (Code Samples)

This lecture covers step by step executions of the code lines we used in the "Using the DBMS_OUTPUT PACKAGE" lecture.

4
Using the UTL_FILE Package (Part 1)

This PL SQL tutorial contains how to use the UTL_FILE package to let your PL/SQL programs read and write operating system (OS) text files.

5
Using the UTL_FILE Package (Part 2)

This PL SQL tutorial contains how to use the UTL_FILE package to let your PL/SQL programs read and write operating system (OS) text files.

6
Using the UTL_FILE Package (Part 3)

This PL SQL tutorial contains how to use the UTL_FILE package to let your PL/SQL programs read and write operating system (OS) text files.

7
Using the UTL_FILE Package (Code Samples)

Includes step by step execution of the codes we used in the UTL_FILE package lecture

8
Using the UTL_MAIL Package (Part 1)

In this PL SQL tutorial, students will learn how to use the UTL_MAIL package which is a utility for managing email that includes commonly used email features, such as attachments, CC, and BCC with its examples.

9
Using the UTL_MAIL Package (Part 2)

In this part of the PL SQL UTL Mail Package tutorial lecture, students will continue to learn how to use the UTL_MAIL package which is a utility for managing email that includes commonly used email features, such as attachments, CC, and BCC with its examples.

10
Using the UTL_MAIL Package (Code Samples)

Includes step by step execution of the codes we used in the UTL_MAIL package lecture

Miscellaneous PL/SQL Topics & Concepts

1
Managing Security for Definer's Rights and Invoker's Rights (Part 1)

In the Definer's and Invoker's Rights (Part 1) lecture, the Complete Oracle PL/SQL Bootcamp course participants will learn about what the Definer's and Invoker's Rights in Oracle are and how they work to control access to database objects like tables, procedures, etc. to manage the database security with hands-on examples.

2
Managing Security for Definer's Rights and Invoker's Rights (Part 2)

In the Definer's and Invoker's Rights (Part 2) lecture, the Complete Oracle PL/SQL Bootcamp course participants will continue to learn about what the Definer's and Invoker's Rights in Oracle are and how they work to control access to database objects like tables, procedures, etc. to manage the database security with hands-on examples.

3
Managing Security for Definer's Rights and Invoker's Rights (Code Samples)

This lecture includes the source code of the SQL & PL/SQL statements we used in the Definer's Rights and Invoker's Rights lectures.

Appendix

1
Appendix 1: Oracle Database 12c Installation into Your Computer

This lecture explains how to download and install Oracle Database 12c, from my first course.

I added this video again into my this course, since some of my students my not get the first course, but they confuse how to install the software.

2
Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?
3
Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c
4
How to remove the database?

Bonus

1
Bonus Lecture
Vous pouvez afficher et ru00e9viser les supports de cours indu00e9finiment, comme une chau00eene u00e0 la demande.
Absolumentu00a0! Si vous disposez d'une connexion Internet, les cours sur WeCours sont disponibles u00e0 tout moment sur n'importe quel appareil. Si vous n'avez pas de connexion Internet, certains instructeurs permettent u00e9galement u00e0 leurs u00e9tudiants de tu00e9lu00e9charger les cours. instructeur, alors assurez-vous d'u00eatre du bon cu00f4tu00e9u00a0!
4.5
4.5 sur 5
Notes11392

Détails des Notes

Étoiles 5
5636
Étoiles 4
4254
Étoiles 3
1211
Étoiles 2
181
Étoiles 1
124
Suivre un cours
Paiement unique S'inscrire avec l'adhésion
Garantie de remboursement de 30 jours

Inclut

25 heures de vidéo à la demande
Accès complet à vie
Accès sur le mobile et la télévision
Certificat d'achèvement

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed