from62.31GBP/ 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 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from £62.31Online 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 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from £62.31Online 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
Leo
Photorealistic 3D computer graphics and modeling for amateurs, hobbyists or professionals
In this course, you will learn how to create photorealistic renderings using Blender software. This free and open-source software has seen its notoriety skyrocket in recent years, as it offers tools and results similar to what is done on standard and paid software such as 3d Studio Max or Maya, all in one interface. intuitive and ergonomic workflow.
In this course, you will be able to learn:
-The basics of 3D modeling and 3D in general
-Materials (shaders)
-The highlighting
-Renderings
-Post production
Gradually, we will solidify these skills to learn how to create entire scenes, representing environments, objects, and buildings.
It is also possible to present your projects to me and to obtain personalized help on them.
Paloma
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.
Ahmed Yassine
Hydrology, Hydraulics and numerical modeling (HEC-HMS, HEC-RAS, QGIS, ...)
This course is intended for students with a specialty in hydraulics or hydrology, or anyone interested in the fields of water. We provide assistance to students of all disciplines. This course also contains a numerical modeling component with HEC-HMS and HEC-RAS.
The course is essentially based on the student's program, and the session takes place in two parts:
- The first part is devoted to assimilate the course;
- The second is dedicated to applying the course knowledge in exercises and examples.
At the end of the hydrology course, students should be able to:
- Understand the components of the water cycle.
- Assimilate the measurements, interactions and importance of the components of the water cycle.
- Know how to analyze and evaluate hydro-climatic factors.
For any questions, you are welcome to contact us.
Martin
Blender 3.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.
Brahim
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
Zara
Power BI, data analysis, Data science and deep learning algorithms
I'm an IT engineer, with double master in software engineering ad 6 year do teaching experience. I'am found of english, french languages and IT development teanching.
Giving private courses arround the world , is what I love doing in my free time for keeping me socially active!
I love giving languages' courses in a new ways of pedagogy and for any students' age : Songs, projects, Poetry, Presentations, films etc..
As for teaching IT developement, my pedagogy is always teaching by practical projects and tutorials. Such as. developping games and usefull virtual services or application, depends of the technology we work on.
Be ready for your best english and IT experience with me , it's not like any old way of teaching methodologies!
Don't hesitate to reach out for me , if you wish to give it a try!
I'll be the very happy to give more than I can to get you to your hopes.
Julien
SketchUp 3D modeling design and architecture, decoration
I offer training for all levels up to advanced 3D rendering in Vray, D5 render Twinmotion, animation, post-production and graphic layout with Photoshop.
I am one of the first users of Sketchup when it was created and I have worked for architects, landscapers, space designers and decorators.
Aditya
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.
Yevheniia
Mathematics, Programming, 3D Modeling, and Robotics Teacher
Mathematics, Programming, 3D Modeling, and Robotics Teacher
Private Tutor
May 2018 – Present
Mathematics (Grades 5-9): Preparing students for the National Multidisciplinary Test (NMT). Developing individualized study plans for each student, leading to significant improvement in their academic performance.
Utilizing modern educational technologies and interactive teaching methods.
Conducting additional classes for struggling students, enabling them to reach the level of their peers.
Programming: Teaching the basics of programming languages such as Python, Java, and C++. Developing and implementing curricula for various levels of proficiency.
Introducing project-based learning to enhance students' practical skills.
3D Modeling: Teaching the basics and advanced methods of 3D modeling using Blender and Tinkercad.
Conducting masterclasses and workshops for different age groups.
Implementing projects that include creating models for 3D printing.
Robotics: Teaching the construction and programming of robots using Arduino and LEGO Mindstorms.
Key Achievements:
Successfully increased the average exam scores of students.
Developed and implemented innovative teaching methods that enhance student engagement and interest.
Organized and conducted intensive courses in mathematics and programming.
Shan
Software Rhino 3D modeling skill, cad 2D skil beginner, intermediate, advanced levels
2D autocad and 3D Rhino softwares are very significant to master in order to express the spatial quality in different dimensions. The class will introduce the tools, commands and quick skills from the software meanwhile will solve all your questions about these softwares and make them into practice. The teacher has 15 years experience in practice with the softwares.
Gaëlle
Metaverse, AR and VR for kids, create your digital experience
Virtual reality is going to be used widely in the years to come.
In training, remote working, socializing, discovering.
It is not meant to replace reality, but offer experiences in a safe and easy environment to spark curiosity.
In this class I'll teach children need what is and how to use Virtual reality, Augmented Reality and discover the potential these technologies have to offer.
Abdelatif
Training in business intelligence
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
Agney
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.
Ursula
Interior Architecture - AutoCAD, SketchUp, Indesign, Adobe Suite
ACCOMPANIMENT ideal for students seeking support in their artistic studies.
We build the course together, according to your desires, your projects and your level.
I give you the methodologies
during lessons then do little exercises.
So that you are faced with problems that I will clear up.
This process will make it possible to become autonomous on the software.
I offer evening classes on weekdays after 7 p.m. and on weekends from 10 a.m. to 6 p.m.
I am an interior designer, I have been teaching since my 2nd year. I did my license in Lebanon and my Masters in Paris in decorative arts. I am passionate about this job and I love to pass on all my skills and interact with the world around me with all patience and motivation.
Isàbella
3D Modeling! Italian industrial designer giving tips on Rhinoceros 3D Modeling
Hello! I'm Isabella and I am an industrial designer. I work in the jewelry industry since 2 years now and I am a 3d modeler. I can teach you the basic tool of 3d modeling or I can model a piece for you!
I am super passionate about my work so I do everything with a smile on my face always.
If you want to know more about 3d modeling don't hesitate to contact me!
Best,
Isabella