Course – SQL and PL / SQL Training

SQL part

Introduction to SQL training
Definition of a database

Definition of a Database Management System

Define a relational model

Tables and referential integrity

Practical workshop: Installing tools (wampserver and mysqlworkbench)

 

Understand modeling

Vocabulary of the relational model

Normal forms

Practical Workshop: Creating a Conceptual Data Model

 

The data definition language (LDD)

Creating tables: syntax

Data types

Types of constraints

Changing the definition of a table

Deleting a table

Introduction to views

Indexes

Transactions overview

Practical workshop: Setting up and modifying the structure of our database

 

Data manipulation language (DML)

Insertion of lines (INSERT)

Insert multiple rows

Insert from a SELECT

Updated with UPDATE

UPDATE with subqueries

Deletion of registration (DELETE)

Practical Workshop: Modifying the contents of our database

 

The data query language (LID)

Projection

Selection (or restriction)

The join

Sorting

Practical Workshop: Extraction of data meeting a defined need using restriction criteria, operations and sorting.

 

Advanced Use

GROUP BY and HAVING

Arithmetic functions

String functions

Transactions: COMMIT and ROLLBACK
Data access control: GRANT, REVOKE

 

PL / SQL part

Understand PL / SQL
Structure of a PL / SQL program block
Use the Declare Clause
Use the Begin Clause
Creating stored procedures and functions
Running Stored Procedures and Functions