from623.04CNY/ h
Oracle Data Base (Essentials / Advanced) + Assessment on demand
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 via webcam
General info
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 |
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.).
Ask a question
Send a message explaining your needs and Enrique will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | Monday at 4:00 | Tuesday at 4:00 | Wednesday at 4:00 | Thursday at 4:00 | Friday at 4:00 | ||
5 | Monday at 5:00 | Tuesday at 5:00 | Wednesday at 5:00 | Thursday at 5:00 | Friday at 5:00 | ||
6 | Monday at 6:00 | Tuesday at 6:00 | Wednesday at 6:00 | Thursday at 6:00 | Friday at 6:00 | ||
7 | Monday at 7:00 | Tuesday at 7:00 | Wednesday at 7:00 | Thursday at 7:00 | Friday at 7:00 | ||
8 | |||||||
9 | |||||||
10 | Monday at 10:00 | Tuesday at 10:00 | Wednesday at 10:00 | Thursday at 10:00 | |||
11 | Monday at 11:00 | Tuesday at 11:00 | Wednesday at 11:00 | Thursday at 11:00 | |||
12 | Monday at 12:00 | Tuesday at 12:00 | Wednesday at 12:00 | Thursday at 12:00 | |||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 623.05 CNYOnline via webcam
100% Satisfaction Guarantee
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since May 2023
- Google connected
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | Monday at 4:00 | Tuesday at 4:00 | Wednesday at 4:00 | Thursday at 4:00 | Friday at 4:00 | ||
5 | Monday at 5:00 | Tuesday at 5:00 | Wednesday at 5:00 | Thursday at 5:00 | Friday at 5:00 | ||
6 | Monday at 6:00 | Tuesday at 6:00 | Wednesday at 6:00 | Thursday at 6:00 | Friday at 6:00 | ||
7 | Monday at 7:00 | Tuesday at 7:00 | Wednesday at 7:00 | Thursday at 7:00 | Friday at 7:00 | ||
8 | |||||||
9 | |||||||
10 | Monday at 10:00 | Tuesday at 10:00 | Wednesday at 10:00 | Thursday at 10:00 | |||
11 | Monday at 11:00 | Tuesday at 11:00 | Wednesday at 11:00 | Thursday at 11:00 | |||
12 | Monday at 12:00 | Tuesday at 12:00 | Wednesday at 12:00 | Thursday at 12:00 | |||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 623.05 CNYOnline via webcam
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Share
You are here
Private lessons
online via webcam
Similar classes
Rendering of your designs, with sketchup and lumion consult
The amount of time required to book on the platform for rendering your ideas depends on the scale and level of detail of the render
-------------------------------------------------- -----------
Depending on the needs of the student, the number of hours that must be booked by the platform to carry out the renderings and 3d modeling is calculated.
Photogrammetry (3D scanning) for amateurs, hobbyists and professionals
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.
Learn how to design parts efficiently using computer-aided design software
As a design engineer and CAD software trainer, I want to pass on my experiences acquired throughout my professional career by putting them into practice on real-life cases to trainees.
Passionate about complex tools and technical challenges.
I provide training on the following software:
- CATIA V5
- SOLIDWORKS
- FUSION 360
- AUTOCAD 2D
Introduction to Relational Database and SQL Language by practise
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
Blender 4.x, by Linkedin learning trusted instructor.
Whether you are a beginner, a designer or just curious to learn, go for it. Being self-taught is great to start with, but I learned that you also develop bad habits very easily.
As a trainer, I'll give you access to Blender 3.x essentials training so we can focus on honing your skills in private lessons.
My methodology is simple, it wants to be accessible and adapted to the learner, that's the whole point of a private course.
Let's explore Blender 3.x together through an introductory or advanced course.
Hands-on Data Skills: Python Programming, SQL Queries & Oracle Database
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.
Rhinoceros 8 for Jewelry Design – Beginner Course.
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.
🚀 NSI Booster – 📚 Intensive Preparation to 🌟 Shine in Your Exams!
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!
Into to 3D Art and Design using Blender, a Free Software
In this class you will learn basic to intermediate 3D modeling skills in Blender or basic to intermediate skills in Plasticity 3D. Blender is a free software used by professionals in all fields of 3D. Be it film, games, movies or just hobbies, like 3D printing, Blender is great!
In my Blender course the student will be using the basic version of Blender 4.2 with some extensions.
If a paid extension is needed, it will be provided free of charge via Dropbox.
Plasticity is a easy to learn CAD like software, geared towards artists. Although not currently adopted by the industry, Plasticity has a bright and promising future and currently is great for hard surface modeling, for things like weapons and vehicles. (plasticity is a paid software and is optional if desired)
Students will begin their first lesson by downloading and preparing the software they choose for tutoring.
In the second lesson and onward, students will be guided at a customized pace through the process of making their very own assets. This course will build confidence and allow the student to build skills in 3D modeling, sculpting, texturing and animation. As an optional bonus the student may also choose to learn 3D printing.
Excel modeling in the fields of economic analysis
This course aims to train students in the advanced use of Microsoft Excel as a modeling tool in the fields of economic, financial, and budgetary analysis. Through practical cases, participants will learn how to build dynamic models, perform simulations, analyze economic data, and develop interactive dashboards. The course will focus on the practical application of Excel functions, database management, formula automation, and an introduction to the use of macros and Visual Basic for Applications (VBA). This training is ideal for students wishing to acquire operational skills sought after in the professional world.
Learning objectives: i) Master the advanced functions of Excel ii) Build dynamic economic and financial models iii) Apply data analysis tools (Pivot tables, Solver, Scenario analysis) iv) Create graphs, dashboards and automated reports v) Introduce the use of VBA for modeling and automation.
Target Audience: Undergraduate students, young professionals, or anyone wishing to develop technical skills in economic and financial modeling.
Counselling in Math and Statistics for Analytical Professionals
Personalized counseling in mathematics, statistics, algorithms and economic theory, tailored specifically for programming, data analysis, finance, banking, and informatics. Strengthen your theoretical foundations to write better code, optimize financial and economic models, improve analytical precision, and confidently navigate complex problem-solving tasks.
We will identify your specific theoretical gaps and tackle them directly, using intuitive explanations, guided problem-solving, and focused discussions. My goal is to help you confidently apply mathematical and theoretical concepts in your daily work, projects, or analyses. Reach out to discuss your particular needs, challenges, or topics of interest—together, we’ll develop a customized plan to strengthen your skills and enhance your professional performance.
Calculus calculus for students of the faculties of computers and information and faculties of artificial intelligence
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
Mastering Blender 3D: From Beginner to Intermediate"
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!
Online Engineering Tutoring and Help with Assignments> Mechanical/Renewable Energy/Electrochemistry
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.
Computational Chemistry and Chemical Visualization Related Tutorials
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.