Oracle, SQL and PL/SQL: From theory to practical implementation. - Private lessons

Translated by GoogleSee original

Oracle, SQL and PL/SQL: From theory to practical implementation.

From 40.69 € /h

This course is designed to equip developers with the fundamental SQL and PL/SQL skills necessary to effectively interact with, manipulate, and optimize data within an Oracle database. It is intended for beginners as well as developers wishing to formalize their Oracle knowledge.

Key Objectives
At the end of this course, participants will be able to:

Mastering SQL: Writing complex queries to query, insert, update, and delete data.

Understanding the Architecture: Grasp the basic concepts of Oracle architecture (instance, schemas, tablespaces) from a developer's perspective.

Programming with PL/SQL: Developing procedural blocks, handling exceptions, and using cursors for line-by-line processing.

Create Stored Objects (Schema): Design and implement procedures, functions, and packages to encapsulate business logic.

Automate Actions: Use triggers to automatically execute actions in response to database events (DML or DDL).

Location

Online from United States

Age

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

60 minutes

The class is taught in

French

English

Skills

Oracle database

Availability of a typical week

(GMT -05:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Computer science is the study of algorithmic processes, computational machines and computation itself. As a discipline, computer science spans a range of topics from theoretical studies of algorithms, computation and information to the practical issues of implementing computational systems in hardware and software.

Oracle developed by Oracle Corporation is the most popular relational database system (RDBMS). Not only Oracle is a RDBMS, but also provides functionality for Cloud, Document Store, Graph DBMS, Key-value storage, BLOG, and PDF Storages. Recently. Oracle just announced an autonomous feature that allows databases to be intelligent and self-managed.

Oracle database is a relational database (RDBMS). Relational databases store data in a tabular form of rows and columns. Column of a database table represents the attributes of an entity and rows of a table store records. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.

One characteristic of an RDBMS is the independence of physical data storage from logical data structures.

In Oracle Database, a database schema is a collection of logical data structures or schema objects. A database user owns a database schema, which has the same name as the user name.

Schema objects are user-created structures that directly refer to the data in the database. The database supports many types of schema objects, the most important of which are tables and indexes.

A schema object is one type of database object. Some database objects, such as profiles and roles, do not reside in schemas.

Database Rank
1 Oracle 1268.84
2 MySQL 1154.27
3 Microsoft SQL Server 1040.26
4 PostgreSQL 466.11
5 MongoDB 387.18
6 IBM Db2 179.85
7 Redis 149.01
8 Elasticsearch 143.44
9 Microsoft Access 141.62
10 SQLite 126.8
...

Teaching all computer and programming subjects
Follow-up of university students in the UAE
In computer subjects, programming, IT and computer science
Java - C++ - C - C# - Visual basic - Matlab - Python
ICDL - Oracle - SQL
Java teacher - Python teacher - Office teacher - Database teacher - Information systems teacher
Teaching web page design
HTML - Java Script
Teaching office group
Word - Power point - Excel - Access - outlook
Teaching all programming languages with years of experience
All universities and all grades
To get the highest score in an easy and simple way
Abu Dhabi University, Al Ain University, Emirates University, College of Technology, Ajman University, University of Sharjah, Ras Al Khaimah University, Dubai University
College of Technology - Higher College of Technology

Computer and programming teacher
computer teacher in UAE
Computer teacher in Sharjah, Abu Dhabi, Al Ain, Ajman and Dubai
java programming teacher
python programming teacher
sql database tutor
ICDL Instructor and Trainer
Explanation of Microsoft office suite
Follow-up of all computer, programming, information systems and IT subjects at all stages of the university

Learn about:
- Normalization
- Relation data model and its nested relations
- SQL Language, scripts and others
- Dynamic SQL
- Security and User authorization
- Object oriented data model
- Functional dependencies
- Different type of data model, such as Datalog

I am a data expert, and I offer you a complete 8-hour training course in business intelligence (Data analyst). The training will be organized as follows:
- Courses (summary slides) to master the life cycle of a business intelligence project (ETL, data integration, modeling, reporting)
- Theoretical exercises on modeling business intelligence problems (star diagram, snowflake diagram).
- practical case study using SQL server tools: SSIS, SSAS, SSRS
- reports with QlikView

This class is designed to provide students with a foundational understanding of web design principles and techniques. The course will cover a variety of topics including HTML, CSS, layout design, color theory, typography, and responsive design.

Students will learn how to create a website from scratch, starting with the basic structure of an HTML document, and then adding styling and layout using CSS. They will also explore the design principles that are essential to creating an effective and aesthetically pleasing website, such as color schemes, typography, and spacing.

The class will involve a combination of lectures, discussions, and hands-on exercises to help students develop their design skills. Students will be required to complete several projects throughout the course, including designing a simple website and creating a responsive design that works on multiple devices.

By the end of the class, students will have gained the skills and knowledge necessary to create functional and visually appealing websites that are optimized for a variety of devices and platforms. This class is ideal for anyone who wants to learn the basics of web design, including individuals interested in creating their own personal or professional websites, as well as designers and developers who want to expand their skillset.

Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views

Oracle RDBMS architecture, Oracle engine, instances, schemas, roles, privileges, users, resources, quotas, tablespaces, segments, redo logs, archive log, tables, partitions, indexes, constraints, views, materialized views, job queues, virtual data base , distributed data base, data guard, rman, compression & encryption, data types, triggers, special administration packages, PL/Sql, data pump, import/export, Sqlldr, external tables, dynamic Sql, V$ views, Enterprise manager, Sql Developer, directories, Sql tuning, execution plan, tkprof, LOB management, XML & Json drivers, dynamic Sql, Data base modeling, Star schema, Snowflake schema, integrity checks, Data quality, Data versioning.

I am a working professional and I can best teach you basics of programming with real world examples. I can also teach best industry standard principles and help to improve ur knowledge .Also help to clear technical interviews and coding practise.

Java lessons include understanding the basics of programming, control flow, handling data, objects, and exceptions. Teaches user interface development and advanced concepts in Java programming.
Oracle Database lessons provide a comprehensive and in-depth understanding of data management concepts using the Oracle Database system. The course covers topics such as database design, managing tables and indexes, and advanced SQL queries. The program also includes studying security and data protection, optimization and performance improvement using various Oracle tools. Allows students to understand how to effectively create and maintain Oracle databases, as well as learn to use graphical data management tools and SQL commands to perform basic and advanced tasks.

Information security focuses on protecting information from cyber threats. Covers topics such as securing networks and data, penetration testing, and managing digital identities to enhance digital security.

This course is designed for anyone who wants to learn practical data skills using Python, SQL, and Oracle databases. Whether you're a complete beginner or looking to strengthen your data handling skills, I’ll guide you step-by-step through core concepts and real-world projects.

You'll learn:

Python programming basics and data analysis tools for data science, data engineering and data analytics

SQL queries: SELECT, JOIN, GROUP BY, procedures, Functions and subqueries

How to work with Oracle Database: tables, indexes, stored procedures

Real-world use cases from business and data science

Best practices for clean, efficient, and scalable code

Lessons are project-based and tailored to your skill level, whether you're in school, switching careers, or preparing for a job in data or IT.

Computer science is the study of algorithmic processes, computational machines and computation itself. As a discipline, computer science spans a range of topics from theoretical studies of algorithms, computation and information to the practical issues of implementing computational systems in hardware and software.

Oracle developed by Oracle Corporation is the most popular relational database system (RDBMS). Not only Oracle is a RDBMS, but also provides functionality for Cloud, Document Store, Graph DBMS, Key-value storage, BLOG, and PDF Storages. Recently. Oracle just announced an autonomous feature that allows databases to be intelligent and self-managed.

Oracle database is a relational database (RDBMS). Relational databases store data in a tabular form of rows and columns. Column of a database table represents the attributes of an entity and rows of a table store records. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.

One characteristic of an RDBMS is the independence of physical data storage from logical data structures.

In Oracle Database, a database schema is a collection of logical data structures or schema objects. A database user owns a database schema, which has the same name as the user name.

Schema objects are user-created structures that directly refer to the data in the database. The database supports many types of schema objects, the most important of which are tables and indexes.

A schema object is one type of database object. Some database objects, such as profiles and roles, do not reside in schemas.

Database Rank
1 Oracle 1268.84
2 MySQL 1154.27
3 Microsoft SQL Server 1040.26
4 PostgreSQL 466.11
5 MongoDB 387.18
6 IBM Db2 179.85
7 Redis 149.01
8 Elasticsearch 143.44
9 Microsoft Access 141.62
10 SQLite 126.8
...

Teaching all computer and programming subjects
Follow-up of university students in the UAE
In computer subjects, programming, IT and computer science
Java - C++ - C - C# - Visual basic - Matlab - Python
ICDL - Oracle - SQL
Java teacher - Python teacher - Office teacher - Database teacher - Information systems teacher
Teaching web page design
HTML - Java Script
Teaching office group
Word - Power point - Excel - Access - outlook
Teaching all programming languages with years of experience
All universities and all grades
To get the highest score in an easy and simple way
Abu Dhabi University, Al Ain University, Emirates University, College of Technology, Ajman University, University of Sharjah, Ras Al Khaimah University, Dubai University
College of Technology - Higher College of Technology

Computer and programming teacher
computer teacher in UAE
Computer teacher in Sharjah, Abu Dhabi, Al Ain, Ajman and Dubai
java programming teacher
python programming teacher
sql database tutor
ICDL Instructor and Trainer
Explanation of Microsoft office suite
Follow-up of all computer, programming, information systems and IT subjects at all stages of the university

Learn about:
- Normalization
- Relation data model and its nested relations
- SQL Language, scripts and others
- Dynamic SQL
- Security and User authorization
- Object oriented data model
- Functional dependencies
- Different type of data model, such as Datalog

I am a data expert, and I offer you a complete 8-hour training course in business intelligence (Data analyst). The training will be organized as follows:
- Courses (summary slides) to master the life cycle of a business intelligence project (ETL, data integration, modeling, reporting)
- Theoretical exercises on modeling business intelligence problems (star diagram, snowflake diagram).
- practical case study using SQL server tools: SSIS, SSAS, SSRS
- reports with QlikView

This class is designed to provide students with a foundational understanding of web design principles and techniques. The course will cover a variety of topics including HTML, CSS, layout design, color theory, typography, and responsive design.

Students will learn how to create a website from scratch, starting with the basic structure of an HTML document, and then adding styling and layout using CSS. They will also explore the design principles that are essential to creating an effective and aesthetically pleasing website, such as color schemes, typography, and spacing.

The class will involve a combination of lectures, discussions, and hands-on exercises to help students develop their design skills. Students will be required to complete several projects throughout the course, including designing a simple website and creating a responsive design that works on multiple devices.

By the end of the class, students will have gained the skills and knowledge necessary to create functional and visually appealing websites that are optimized for a variety of devices and platforms. This class is ideal for anyone who wants to learn the basics of web design, including individuals interested in creating their own personal or professional websites, as well as designers and developers who want to expand their skillset.

Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views

Oracle RDBMS architecture, Oracle engine, instances, schemas, roles, privileges, users, resources, quotas, tablespaces, segments, redo logs, archive log, tables, partitions, indexes, constraints, views, materialized views, job queues, virtual data base , distributed data base, data guard, rman, compression & encryption, data types, triggers, special administration packages, PL/Sql, data pump, import/export, Sqlldr, external tables, dynamic Sql, V$ views, Enterprise manager, Sql Developer, directories, Sql tuning, execution plan, tkprof, LOB management, XML & Json drivers, dynamic Sql, Data base modeling, Star schema, Snowflake schema, integrity checks, Data quality, Data versioning.

I am a working professional and I can best teach you basics of programming with real world examples. I can also teach best industry standard principles and help to improve ur knowledge .Also help to clear technical interviews and coding practise.

Java lessons include understanding the basics of programming, control flow, handling data, objects, and exceptions. Teaches user interface development and advanced concepts in Java programming.
Oracle Database lessons provide a comprehensive and in-depth understanding of data management concepts using the Oracle Database system. The course covers topics such as database design, managing tables and indexes, and advanced SQL queries. The program also includes studying security and data protection, optimization and performance improvement using various Oracle tools. Allows students to understand how to effectively create and maintain Oracle databases, as well as learn to use graphical data management tools and SQL commands to perform basic and advanced tasks.

Information security focuses on protecting information from cyber threats. Covers topics such as securing networks and data, penetration testing, and managing digital identities to enhance digital security.

This course is designed for anyone who wants to learn practical data skills using Python, SQL, and Oracle databases. Whether you're a complete beginner or looking to strengthen your data handling skills, I’ll guide you step-by-step through core concepts and real-world projects.

You'll learn:

Python programming basics and data analysis tools for data science, data engineering and data analytics

SQL queries: SELECT, JOIN, GROUP BY, procedures, Functions and subqueries

How to work with Oracle Database: tables, indexes, stored procedures

Real-world use cases from business and data science

Best practices for clean, efficient, and scalable code

Lessons are project-based and tailored to your skill level, whether you're in school, switching careers, or preparing for a job in data or IT.

Good-fit Instructor Guarantee

Contact Soulemane