facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from568.55CNY/ 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?"

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
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 568.56 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.

Online reputation

  • Instructor since May 2023
  • Google connected

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
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 568.56 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


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.

Andrea
Digital Fabrication in Architecture & Sustainability
Tailored for architects, designers, and sustainability enthusiasts who want to make an impact through responsible design. What You’ll Learn: - Digital Fabrication Tools: Hands-on training with laser cutters, CNC milling machines, and 3D printers for prototyping sustainable designs. - Software Skills: Master key software tools like Rhino and Grasshopper to translate ideas into precise digital models. - Sustainable Materials & Techniques: Discover eco-friendly materials and processes that minimize waste and lower carbon footprints in construction projects. You’ll learn industry-leading fabrication methods that allow for sustainable experimentation and creativity in real-world applications.

Khaldoun
Learn Structural Analysis Software from an Experienced Freelancer & University Project Expert!
Are you interested in mastering structural analysis software like ETABS and Robot Structural Analysis? Whether you're a student, a recent graduate, or a professional looking to enhance your skills, my classes are designed for you! About Me: I am a freelance structural engineer with extensive experience in analyzing and designing various projects, including both concrete and steel structures. I have successfully collaborated on university projects, bridging the gap between theoretical knowledge and practical application. My goal is to empower you with the skills and knowledge needed to excel in the field of structural engineering. Course Outline: Introduction to Structural Analysis: Fundamentals of structural engineering Overview of software applications in design ETABS: • ETABS is one of the premier software applications for structural analysis and design, tailored specifically for building systems. In our ETABS module, you'll gain a comprehensive understanding of its powerful capabilities. We will cover the essential features, including how to create complex models of multi-story buildings, apply various loads, and analyze their responses to dynamic forces such as wind and earthquakes. You will learn best practices for reinforcing concrete structures and optimizing designs for both strength and serviceability. Through hands-on projects, you will become proficient in interpreting analytical results, generating design reports, and ensuring compliance with international design codes. By the end of this segment, you will have the ability to confidently utilize ETABS for real-world engineering challenges. Robot Structural Analysis: • Robot Structural Analysis is a robust software solution that provides advanced simulation capabilities for structural engineers tackling intricate design challenges. In our Robot module, you'll explore the software's extensive tools for analyzing a wide range of structures, from simple beams to complex frames and trusses. We will delve into advanced analysis methods, including linear and non-linear static analysis, dynamic response analysis, and more. You will learn how to effectively use load combinations, perform detailed design checks for both concrete and steel structures, and evaluate the structural integrity under various loading conditions. This module emphasizes the importance of optimal performance and efficiency in design, equipping you with the knowledge to use Robot Structural Analysis for sophisticated project requirements. Real-life case studies will provide valuable context and enhance your practical skills. Concrete and Steel Design: Principles of design for both materials Practical case studies and projects Freelancing Tips: Managing client projects Best practices for successful freelancing in structural engineering Course Goals and Outcomes Within just 10 sessions, you will develop the necessary skills to work with either ETABS or Robot Structural Analysis, enabling you to take on real-world projects confidently. By the end of the course, you will be well-prepared to apply your knowledge and expertise in practical engineering scenarios Why Choose My Classes? Hands-on experience with real-world projects Interactive learning environment Personalized guidance tailored to your learning pace

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

Issam
Rhinoceros for Beginners: Experimenting with Rhino's Basic 3D Modeling Tools
Rhinoceros has become a major 3D Modeling tool in the architectural and design market. As an advanced user of Rhino who has been using it for more than 7 years, I enjoy its amazing capabilities that revolutionize previous 3D modeling tools by incorporating advanced tools and excelling in the organic realm. I've used it during my bachelor and master's university years to model my projects because of its speed and enormous capability. It excels in linear and curvy forms and combines the best of both worlds with its versatile commands and features. This class introduces you to this fascinating software step by step. I'll make sure to guide you from getting to know the interface to being able to model elementary structures.

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.

Zora
Data science, Deep learning, Business intelligence, Data analysis, Visualisation des données
Je propose des cours complets en Power BI, analyse de données, science des données et algorithmes d'apprentissage profond, adaptés à tous les niveaux d'expérience. Mon approche pédagogique se concentre sur l'acquisition de compétences pratiques, vous permettant d'appliquer directement ce que vous apprenez dans des projets réels. Dans le cadre de mes cours de gestion de données, vous apprendrez à transformer vos données en visualisations interactives et informatives, en maîtrisant les techniques de création de tableaux de bord, de rapports et d'analyses visuelles. Vous découvrirez également comment connecter différentes sources de données et optimiser vos modèles pour des insights pertinents. En ce qui concerne l’analyse de données, vous développerez une compréhension approfondie des méthodes statistiques et analytiques, vous permettant de tirer des conclusions significatives à partir de vos données. Vous serez initié aux outils et aux techniques de manipulation des données, y compris l'utilisation de langages de programmation tels que Python, R, PowerBI ou TABLEAU. Dans le domaine de la science des données, nous explorerons les étapes clés du processus de data science, de la collecte et le nettoyage des données à la modélisation et à la validation des résultats. Vous serez également introduit aux algorithmes d’apprentissage profond, apprenant à construire et à entraîner des modèles neuronaux pour des applications variées, allant de la reconnaissance d'image à la prévision. Chaque cours est structuré autour de projets pratiques et de cas d’étude, afin de vous préparer à relever des défis réels en matière d’analyse et d’interprétation des données. Si vous êtes prêt à développer vos compétences en Power BI, analyse de données, science des données et apprentissage profond.

Abubakar
3D Modelling for CAD designers, Students and Professionals.
3D Modelling Tutoring: Learn to Create in 3D Take your first steps into the world of 3D design or sharpen your skills with our personalised 3D Modelling Tutoring. Whether you're a beginner or looking to improve, we'll guide you through leading software like Onshape, Fusion360, or SOLIDWORKS. What you’ll learn: 3D geometry, texturing, lighting, and shading. Rendering and exporting models for 3D printing. Who’s it for: Beginners, students, or professionals in design, animation, or architecture. Flexible scheduling with tailored, one-on-one lessons to fit your needs.

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.

Mohamed
N+, Linux, Java, C/C++, Dart, Database, CEH, Security
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.

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.

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.

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.

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.