Oracle Data Base (Essentials / Advanced) + Assessment on demand - Private lessons

Translated by GoogleSee original

Oracle Data Base (Essentials / Advanced) + Assessment on demand

From 612.53 CNY /h

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

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

Skills

Oracle database

Computer modeling

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

SQL - Basics / Intermediate / Advanced + Assessment on demand

612.53 CNY /h

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

Experienced Renewable Energy & Mechanical Engineer:

Renewable Energy:
- Fuel Cells/Electrolysers
- Solar PV Engineering Projects.
- Renewable Energy Projects
- Energy System Modeling
- Hybrid Power Plants with energy storage.
- Matlab coding.

I have a Masters in Sustainable Energy, specializing in Fuel Cells, Hydrogen Technology, and Solar PV. With in-depth understanding, modeling skills, and knowledge in these areas, I can provide expert guidance.
Additionally, my Mechanical Engineering degree enables me to assist with subjects like thermodynamics, heat transfer, Mechanics, Physics, and Machine Design.
Feel free to reach out for any support you need in these fields.

I specialized in Computational Chemistry for University and High School Levels. In the future, this field is promising for teachers who want to learn about visualization and chemical drawing software, such as Marvinsketch, Chemsketch, Avogadro, and so forth. The following are computational topics you may get from my lecture:
1. Basic on Linux Command
2. Basic scripting in python, R, and Fortran
3. Fundamental aspects of Computational Chemistry
4. Tutorial on computational chemistry software, e.g., DFTB+, NAMD, GROMACS, GAMESS, ORCA, Gaussian, and NWCHEM.
5. All simulations will be performed on your computer. Thus, I will guide you to install all of them.

In this course, you will learn how to scan any object using Reality Capture software. This efficient and powerful software was first used for the preservation of archaeological objects and historical monuments, but is now used for video games, VFX and virtual reality, as it offers tools and results of a impressive quality, all in an easy-to-use interface.

In this course, you will be able to learn:
-How does photogrammetry work?
-How to take suitable photos
-How to prepare these photos for their use in the software
-How to use these photos to reconstruct an object in 3D and apply a realistic texture to it
-How to optimize scans for custom use (games, movies, etc.)

Gradually, we will solidify these skills to learn how to build a library of highly realistic objects based on high resolution scans.

It is also possible to present your projects to me and to obtain personalized help on them.

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

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

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!

Explain the lessons of finite and infinite calculus with applications on calculus
Explanation of Diff & Integral.
Applications on calculus.
Are and volume calculations for solids boundaries by curves
In an easy and simplified way, with the solution of the examples mentioned in the previous exams and Assignments & Quizzes

Professor and software engineer for more than 6 years, I give development courses in C/C++, Python, Java or UML.

I am keen to pass on my knowledge and techniques to students interested in computer programming or setting up infrastructures, but also to younger people wanting an introduction to algorithms (in this case, we will use very visual platforms).

My courses can be aimed at beginners (or if you have trouble understanding your machine), as well as advanced students. I adapt to your level and the knowledge you want to acquire. Let's learn about topics that interest you (video games, servers or other), it's easier to learn with what we are passionate about!

As an advanced user of Rhino & SketchUp, I can say that I admire Rhino's crazy capabilities that revolutionize 3D modeling, especially in the organic realm, along with SketchUp's cleverness and speed in modeling. I've taught both at a university and have been using them for more than 8 years in my projects. Hence, I can teach you the best of both worlds with versatile commands, features, and tips and tricks, whether you're a beginner or just need some push.

Microsoft Power BI is a data analysis solution from Microsoft. It allows you to create custom and interactive data visualizations with an interface simple enough for end users to create their own reports and dashboards. It can point to different data sources, namely Excel, SharePoint, Oracle databases, etc.

I can teach the following elements in this course:
-Data processing and preparation with Power Query
-Creating DAX measures in the front end
-Creating interactive dashboards with key KPIs

Begin your journey into digital jewelry design with Rhinoceros 8 – no experience needed.
This course is designed for complete beginners who want to learn how to create professional 3D jewelry models using Rhino 8. Whether you're passionate about jewelry, curious about 3D design, or planning to produce pieces with 3D printing or casting, this class will give you the solid foundation you need.

You’ll learn step-by-step how to navigate Rhino’s interface, draw precise curves, build clean surfaces and solids, and design rings, earrings, pendants, and more. The lessons are clear, practical, and tailored to your pace, with real-life examples from jewelry design.

Taught by an experienced jewelry designer and Rhino user, the course combines technical skills with creative insight to help you turn your ideas into beautiful, manufacturable designs.

Passionate about teaching and with many years of experience, I offer private computer lessons adapted to all levels. Whether you are a beginner, a student, a professional, or simply curious, I will guide you step by step in your learning.

You will learn :

- The basics of computing (office automation, Internet, essential tools).

- Programming (Python, Java, C, etc.) with practical exercises.

- Web development (HTML, CSS, JavaScript, modern frameworks).

- UML, SysML modeling.

- Embedded systems and introduction to artificial intelligence.

My approach is interactive, practical and progressive in order to make you independent and confident in your skills.

You will learn the basics and advanced techniques of 3D modeling, digital animation, and creative storytelling. Lessons are tailored to your skill level, whether you are a complete beginner or looking to improve your portfolio. We use industry-standard tools like Blender, Unreal Engine, Marvelous Designer, and Substance Painter. The course focuses on practical projects, creative thinking, and real-world workflows. Lessons are conducted individually, online or in-person in Prague, and are suitable for children, teenagers, and adults.

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).

Take things to the next level with Artificial Intelligence!

Do you want to understand the challenges of AI, master new generative tools (ChatGPT and others) and learn how to manipulate real data? Take advantage of a clear and accessible 4-hour training course, delivered by an industry expert.

WHY THIS TRAINING? Unlike online tutorials, I offer a pedagogical approach based on concrete, field experience. As a speaker at international conferences (notably at UNESCO) and a developer of technological solutions with social impact, I will give you the tools to become self-reliant.

PROGRAMME (4 HOURS):
- Demystifying Data: Understanding what data is, Open Data and how it influences our daily lives.
- Generative AI: How language models work, overview of tools and data security.
- Practical "Prompt Engineering" Workshop: Learn how to write effective instructions to achieve immediate professional results.
- Ethics & Sovereignty: Understanding the challenges of the GDPR and protecting your privacy.

WHO IS THIS TRAINING FOR?
- Independent professionals, freelancers or students wishing to boost their productivity.
- Individuals curious to understand the current digital revolution.
- No technical prerequisites are required.

TERMS AND CONDITIONS:
- Duration: to be agreed
- Location: Via videoconference or in person in Paris (or internationally)
- Guaranteed seriousness: A professional training contract will be drawn up for each participant.

Experienced Renewable Energy & Mechanical Engineer:

Renewable Energy:
- Fuel Cells/Electrolysers
- Solar PV Engineering Projects.
- Renewable Energy Projects
- Energy System Modeling
- Hybrid Power Plants with energy storage.
- Matlab coding.

I have a Masters in Sustainable Energy, specializing in Fuel Cells, Hydrogen Technology, and Solar PV. With in-depth understanding, modeling skills, and knowledge in these areas, I can provide expert guidance.
Additionally, my Mechanical Engineering degree enables me to assist with subjects like thermodynamics, heat transfer, Mechanics, Physics, and Machine Design.
Feel free to reach out for any support you need in these fields.

I specialized in Computational Chemistry for University and High School Levels. In the future, this field is promising for teachers who want to learn about visualization and chemical drawing software, such as Marvinsketch, Chemsketch, Avogadro, and so forth. The following are computational topics you may get from my lecture:
1. Basic on Linux Command
2. Basic scripting in python, R, and Fortran
3. Fundamental aspects of Computational Chemistry
4. Tutorial on computational chemistry software, e.g., DFTB+, NAMD, GROMACS, GAMESS, ORCA, Gaussian, and NWCHEM.
5. All simulations will be performed on your computer. Thus, I will guide you to install all of them.

In this course, you will learn how to scan any object using Reality Capture software. This efficient and powerful software was first used for the preservation of archaeological objects and historical monuments, but is now used for video games, VFX and virtual reality, as it offers tools and results of a impressive quality, all in an easy-to-use interface.

In this course, you will be able to learn:
-How does photogrammetry work?
-How to take suitable photos
-How to prepare these photos for their use in the software
-How to use these photos to reconstruct an object in 3D and apply a realistic texture to it
-How to optimize scans for custom use (games, movies, etc.)

Gradually, we will solidify these skills to learn how to build a library of highly realistic objects based on high resolution scans.

It is also possible to present your projects to me and to obtain personalized help on them.

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

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

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!

Explain the lessons of finite and infinite calculus with applications on calculus
Explanation of Diff & Integral.
Applications on calculus.
Are and volume calculations for solids boundaries by curves
In an easy and simplified way, with the solution of the examples mentioned in the previous exams and Assignments & Quizzes

Professor and software engineer for more than 6 years, I give development courses in C/C++, Python, Java or UML.

I am keen to pass on my knowledge and techniques to students interested in computer programming or setting up infrastructures, but also to younger people wanting an introduction to algorithms (in this case, we will use very visual platforms).

My courses can be aimed at beginners (or if you have trouble understanding your machine), as well as advanced students. I adapt to your level and the knowledge you want to acquire. Let's learn about topics that interest you (video games, servers or other), it's easier to learn with what we are passionate about!

As an advanced user of Rhino & SketchUp, I can say that I admire Rhino's crazy capabilities that revolutionize 3D modeling, especially in the organic realm, along with SketchUp's cleverness and speed in modeling. I've taught both at a university and have been using them for more than 8 years in my projects. Hence, I can teach you the best of both worlds with versatile commands, features, and tips and tricks, whether you're a beginner or just need some push.

Microsoft Power BI is a data analysis solution from Microsoft. It allows you to create custom and interactive data visualizations with an interface simple enough for end users to create their own reports and dashboards. It can point to different data sources, namely Excel, SharePoint, Oracle databases, etc.

I can teach the following elements in this course:
-Data processing and preparation with Power Query
-Creating DAX measures in the front end
-Creating interactive dashboards with key KPIs

Begin your journey into digital jewelry design with Rhinoceros 8 – no experience needed.
This course is designed for complete beginners who want to learn how to create professional 3D jewelry models using Rhino 8. Whether you're passionate about jewelry, curious about 3D design, or planning to produce pieces with 3D printing or casting, this class will give you the solid foundation you need.

You’ll learn step-by-step how to navigate Rhino’s interface, draw precise curves, build clean surfaces and solids, and design rings, earrings, pendants, and more. The lessons are clear, practical, and tailored to your pace, with real-life examples from jewelry design.

Taught by an experienced jewelry designer and Rhino user, the course combines technical skills with creative insight to help you turn your ideas into beautiful, manufacturable designs.

Passionate about teaching and with many years of experience, I offer private computer lessons adapted to all levels. Whether you are a beginner, a student, a professional, or simply curious, I will guide you step by step in your learning.

You will learn :

- The basics of computing (office automation, Internet, essential tools).

- Programming (Python, Java, C, etc.) with practical exercises.

- Web development (HTML, CSS, JavaScript, modern frameworks).

- UML, SysML modeling.

- Embedded systems and introduction to artificial intelligence.

My approach is interactive, practical and progressive in order to make you independent and confident in your skills.

You will learn the basics and advanced techniques of 3D modeling, digital animation, and creative storytelling. Lessons are tailored to your skill level, whether you are a complete beginner or looking to improve your portfolio. We use industry-standard tools like Blender, Unreal Engine, Marvelous Designer, and Substance Painter. The course focuses on practical projects, creative thinking, and real-world workflows. Lessons are conducted individually, online or in-person in Prague, and are suitable for children, teenagers, and adults.

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).

Take things to the next level with Artificial Intelligence!

Do you want to understand the challenges of AI, master new generative tools (ChatGPT and others) and learn how to manipulate real data? Take advantage of a clear and accessible 4-hour training course, delivered by an industry expert.

WHY THIS TRAINING? Unlike online tutorials, I offer a pedagogical approach based on concrete, field experience. As a speaker at international conferences (notably at UNESCO) and a developer of technological solutions with social impact, I will give you the tools to become self-reliant.

PROGRAMME (4 HOURS):
- Demystifying Data: Understanding what data is, Open Data and how it influences our daily lives.
- Generative AI: How language models work, overview of tools and data security.
- Practical "Prompt Engineering" Workshop: Learn how to write effective instructions to achieve immediate professional results.
- Ethics & Sovereignty: Understanding the challenges of the GDPR and protecting your privacy.

WHO IS THIS TRAINING FOR?
- Independent professionals, freelancers or students wishing to boost their productivity.
- Individuals curious to understand the current digital revolution.
- No technical prerequisites are required.

TERMS AND CONDITIONS:
- Duration: to be agreed
- Location: Via videoconference or in person in Paris (or internationally)
- Guaranteed seriousness: A professional training contract will be drawn up for each participant.

Good-fit Instructor Guarantee

Contact Enrique