facebook
favorite button
super instructor icon
Trusted teacher
This teacher has a fast response time and rate, demonstrating a high quality of service to their students.
member since icon
Since May 2023
Instructor since May 2023
Translated by GoogleSee original
Oracle Data Base (Essentials / Advanced) + Assessment on demand
course price icon
From 64.26 £ /h
arrow icon
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.
Extra information
Precisely delimit the concept to learn in Oracle database to take advantage of time effectively.
Location
location type icon
Online from Spain
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Student level
Beginner
Intermediate
Advanced
Duration
60 minutes
The class is taught in
Spanish
English
French
Availability of a typical week
(GMT -05:00)
New York
at teacher icon
Online via webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Standard language for accessing databases.
Queries, clauses, dynamic executions, traces, execution plans, inserts, updates, inserts, deletes, merges, joins, unions, intersections, complex cases, direct data loads, temporary data sets, queues, embedded queries in programming languages ( C, Python, etc.), most common SQL interfaces (SQL Developer, Toad, DBeaver, etc.).
Read more
Similar classes
arrow icon previousarrow icon next
verified badge
Brahim
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
verified badge
Mohammed
Unlock your creative potential and dive into the exciting world of 3D animation with our comprehensive "Mastering Blender 3D" class. Whether you're a beginner looking to explore the fundamentals or an intermediate student seeking to enhance your skills, this class is designed to take you on an immersive journey through the versatile capabilities of Blender.

In this course, you will learn the essential techniques of 3D modeling, shading, materials, rendering, animation, and physical simulation. Our experienced instructor, [Your Name], will guide you step-by-step, ensuring that you develop a solid foundation in each aspect of Blender's powerful toolset.

Highlights of the class:

Introduction to Blender: Familiarize yourself with the interface and navigation, and gain confidence in using Blender's powerful features.

Modeling: Learn to create stunning 3D models, from simple objects to complex scenes, using various modeling techniques and tools.

Shading and Materials: Master the art of applying textures, materials, and realistic lighting to bring your models to life.

Rendering: Explore different rendering techniques to showcase your creations in high-quality images and animations.

Animation: Dive into the world of animation and learn how to bring your models to life through keyframing, rigging, and character animation.

Physical Simulation: Discover the realm of physics-based simulations and create realistic effects such as fluid dynamics, cloth simulations, and particle systems.

By the end of this class, you will have gained a deep understanding of Blender's capabilities and developed the skills to create visually stunning 3D artwork, animations, and simulations. Join us now and unlock your creativity with Blender 3D!
verified badge
Said
Are you preparing for your Digital and Computer Science (NSI) exams and want to maximize your chances of success? "NSI Booster: Intensive Preparation to Shine in Your Exams!" is the course you need to revise effectively, fill in your gaps, and excel on the big day! This comprehensive and intensive program is specially designed for students in Première and Terminale to master all the key concepts of the NSI program and pass with flying colors.

Why choose this NSI preparation course?
Optimize revision time: Focus on the essential concepts to save time and revise efficiently.
Deep understanding of concepts: Don't just memorize, really understand the basics of computing to succeed in the most complex exercises.
Intensive practice: Practice with corrected exercises, exam questions and past papers to be fully prepared.
Exam Methodology: Learn how to manage your time, structure your answers, and avoid common NSI question pitfalls.
Confidence and serenity: Work in a progressive and structured manner to arrive calm on the day of the exam.
What you will learn:
This course covers the entire NSI program for Première and Terminale, focusing on the concepts most often covered in exams:

1. Algorithms and Programming:
Advanced algorithms: Algorithmic complexity, recursion, sorting and searching (quick sort, dichotomous sort).
Programming in Python:
Advanced syntax: list comprehension, lambda, decorators.
Data structures: lists, tuples, dictionaries, sets.
Functions and modularity: Decomposition of the problem, reuse of code.
File Management: Reading and writing files to process real data.
Object-oriented programming: Classes, objects, inheritance, polymorphism in Python.
Practical projects: Development of complete programs to apply the concepts covered.
2. Data Structures and Algorithms:
Lists, Stacks, Queues, and Trees: Implementation, Manipulation, and Use in Problem Solving.
Graphs: Representation (adjacency matrix, neighbor list), breadth-first (BFS) and depth-first (DFS) traversal.
Sorting and searching algorithms: Merge sort, quick sort, binary search.
Algorithmic complexity: Big-O notation, analysis of algorithm performance.
3. Databases and SQL:
Data modeling: Relational model, database design with the Entity-Relationship model.
SQL:
Select, insert, update and delete queries.
Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN).
Aggregate functions and subqueries.
Optimizing queries for better performance.
Practical projects: Creation and management of databases for concrete applications.
4. Computer and Network Architecture:
Hardware architecture: Processor, memory (RAM, cache), input/output devices.
Computer operation: Instruction cycle, execution of programs in memory.
Computer networks:
OSI model and TCP/IP.
IP addressing, routing, protocols (HTTP, FTP, SMTP).
Network security: firewall, encryption, VPN.
5. Web and Front-End Development:
HTML/CSS: Structure and formatting of web pages.
JavaScript: Dynamics of web pages, manipulation of the DOM, events.
Practical projects: Creation of interactive websites to apply the skills acquired.
Methodology and educational approach:
Targeted and structured revisions: Each module is designed to cover the key concepts of the NSI program while adapting to your level and your needs.
Practical exercises and exam questions: Practice with targeted exercises and past exam questions to familiarize yourself with the exam format.
Detailed correction and personalized feedback: Each exercise is corrected in detail with a thorough explanation of the solutions.
Exam methodology: Advice on how to read and understand the statements, structure your answers and manage your time on the day of the test.
Interactive Online Classes: Classes are conducted online with the use of audio and screen sharing, ensuring seamless communication and interactive learning.
For who ?
This course is aimed at:

NSI students in their first and final year of high school who want to pass their exams with intensive and targeted preparation.
Computer science students wanting to strengthen their foundations in programming and algorithms.
Self-taught people passionate about programming and computer science looking to deepen their knowledge.
Parents who wish to support their children in their academic success in computer science.
Why choose this course?
An experienced teacher: The course is led by a computer engineer with a perfect command of the NSI program, with a clear and motivating teaching approach.
An intensive and comprehensive program: Each concept is covered in depth, with varied exercises to practice all types of questions.
Personalized support: The content and pace of the course are adapted to your level and your objectives.
Flexibility and accessibility: Learn from home at your own pace, with additional resources to deepen your knowledge.
How does it work?
Initial assessment: A personalized assessment to identify your objectives and your starting level.
Interactive online courses: Learn from home with live explanations, demonstrations and practical exercises.
Intensive training: Series of exercises and past papers to prepare you for written and practical tests.
Personalized monitoring: Receive regular feedback on your progress and advice to continuously improve.
Register now !
Don't leave anything to chance when it comes to your NSI exams. Join "NSI Booster" for intensive and targeted preparation, and give yourself every chance of excelling in your exams!
message icon
Contact Enrique
repeat students icon
1st lesson is backed
by our
Good-fit Instructor Guarantee
Similar classes
arrow icon previousarrow icon next
verified badge
Brahim
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
verified badge
Mohammed
Unlock your creative potential and dive into the exciting world of 3D animation with our comprehensive "Mastering Blender 3D" class. Whether you're a beginner looking to explore the fundamentals or an intermediate student seeking to enhance your skills, this class is designed to take you on an immersive journey through the versatile capabilities of Blender.

In this course, you will learn the essential techniques of 3D modeling, shading, materials, rendering, animation, and physical simulation. Our experienced instructor, [Your Name], will guide you step-by-step, ensuring that you develop a solid foundation in each aspect of Blender's powerful toolset.

Highlights of the class:

Introduction to Blender: Familiarize yourself with the interface and navigation, and gain confidence in using Blender's powerful features.

Modeling: Learn to create stunning 3D models, from simple objects to complex scenes, using various modeling techniques and tools.

Shading and Materials: Master the art of applying textures, materials, and realistic lighting to bring your models to life.

Rendering: Explore different rendering techniques to showcase your creations in high-quality images and animations.

Animation: Dive into the world of animation and learn how to bring your models to life through keyframing, rigging, and character animation.

Physical Simulation: Discover the realm of physics-based simulations and create realistic effects such as fluid dynamics, cloth simulations, and particle systems.

By the end of this class, you will have gained a deep understanding of Blender's capabilities and developed the skills to create visually stunning 3D artwork, animations, and simulations. Join us now and unlock your creativity with Blender 3D!
verified badge
Said
Are you preparing for your Digital and Computer Science (NSI) exams and want to maximize your chances of success? "NSI Booster: Intensive Preparation to Shine in Your Exams!" is the course you need to revise effectively, fill in your gaps, and excel on the big day! This comprehensive and intensive program is specially designed for students in Première and Terminale to master all the key concepts of the NSI program and pass with flying colors.

Why choose this NSI preparation course?
Optimize revision time: Focus on the essential concepts to save time and revise efficiently.
Deep understanding of concepts: Don't just memorize, really understand the basics of computing to succeed in the most complex exercises.
Intensive practice: Practice with corrected exercises, exam questions and past papers to be fully prepared.
Exam Methodology: Learn how to manage your time, structure your answers, and avoid common NSI question pitfalls.
Confidence and serenity: Work in a progressive and structured manner to arrive calm on the day of the exam.
What you will learn:
This course covers the entire NSI program for Première and Terminale, focusing on the concepts most often covered in exams:

1. Algorithms and Programming:
Advanced algorithms: Algorithmic complexity, recursion, sorting and searching (quick sort, dichotomous sort).
Programming in Python:
Advanced syntax: list comprehension, lambda, decorators.
Data structures: lists, tuples, dictionaries, sets.
Functions and modularity: Decomposition of the problem, reuse of code.
File Management: Reading and writing files to process real data.
Object-oriented programming: Classes, objects, inheritance, polymorphism in Python.
Practical projects: Development of complete programs to apply the concepts covered.
2. Data Structures and Algorithms:
Lists, Stacks, Queues, and Trees: Implementation, Manipulation, and Use in Problem Solving.
Graphs: Representation (adjacency matrix, neighbor list), breadth-first (BFS) and depth-first (DFS) traversal.
Sorting and searching algorithms: Merge sort, quick sort, binary search.
Algorithmic complexity: Big-O notation, analysis of algorithm performance.
3. Databases and SQL:
Data modeling: Relational model, database design with the Entity-Relationship model.
SQL:
Select, insert, update and delete queries.
Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN).
Aggregate functions and subqueries.
Optimizing queries for better performance.
Practical projects: Creation and management of databases for concrete applications.
4. Computer and Network Architecture:
Hardware architecture: Processor, memory (RAM, cache), input/output devices.
Computer operation: Instruction cycle, execution of programs in memory.
Computer networks:
OSI model and TCP/IP.
IP addressing, routing, protocols (HTTP, FTP, SMTP).
Network security: firewall, encryption, VPN.
5. Web and Front-End Development:
HTML/CSS: Structure and formatting of web pages.
JavaScript: Dynamics of web pages, manipulation of the DOM, events.
Practical projects: Creation of interactive websites to apply the skills acquired.
Methodology and educational approach:
Targeted and structured revisions: Each module is designed to cover the key concepts of the NSI program while adapting to your level and your needs.
Practical exercises and exam questions: Practice with targeted exercises and past exam questions to familiarize yourself with the exam format.
Detailed correction and personalized feedback: Each exercise is corrected in detail with a thorough explanation of the solutions.
Exam methodology: Advice on how to read and understand the statements, structure your answers and manage your time on the day of the test.
Interactive Online Classes: Classes are conducted online with the use of audio and screen sharing, ensuring seamless communication and interactive learning.
For who ?
This course is aimed at:

NSI students in their first and final year of high school who want to pass their exams with intensive and targeted preparation.
Computer science students wanting to strengthen their foundations in programming and algorithms.
Self-taught people passionate about programming and computer science looking to deepen their knowledge.
Parents who wish to support their children in their academic success in computer science.
Why choose this course?
An experienced teacher: The course is led by a computer engineer with a perfect command of the NSI program, with a clear and motivating teaching approach.
An intensive and comprehensive program: Each concept is covered in depth, with varied exercises to practice all types of questions.
Personalized support: The content and pace of the course are adapted to your level and your objectives.
Flexibility and accessibility: Learn from home at your own pace, with additional resources to deepen your knowledge.
How does it work?
Initial assessment: A personalized assessment to identify your objectives and your starting level.
Interactive online courses: Learn from home with live explanations, demonstrations and practical exercises.
Intensive training: Series of exercises and past papers to prepare you for written and practical tests.
Personalized monitoring: Receive regular feedback on your progress and advice to continuously improve.
Register now !
Don't leave anything to chance when it comes to your NSI exams. Join "NSI Booster" for intensive and targeted preparation, and give yourself every chance of excelling in your exams!
Good-fit Instructor Guarantee
favorite button
message icon
Contact Enrique