facebook
    Enrique
    member icon
    Trusted teacher
    favorite buttonAdd to Wish List
    favorite buttonAdd to Wish List
    member icon
    Trusted teacher
    from116.40CAD/ 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 -04: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 C$116.40Online 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 -04: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 C$116.40Online 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


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

    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.

    Ismail
    Microsoft Power BI Desktop for creating visualizations
    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

    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

    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.

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

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

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

    Issam
    Advanced Rhinoceros 3D: Experimenting with Rhino's 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 guide you from getting to know the basics till being able to model complex advanced structures.

    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.

    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

    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.

    Kinan
    3d modeling for architects and designers using Rhino 3d and grasshopper
    Are you ready to unlock a world of creative possibilities and boost your career prospects? As a seasoned instructor with a proven track record of teaching 3D modeling using Rhino 3D, I bring extensive experience gained from years of instructing at three universities. Rhino 3D isn't just another software; it's a gateway to innovation across various industries, including architecture, product design, engineering, and it even offers exciting opportunities for DIY enthusiasts. Learning this powerful tool can not only enhance your skill set but also open doors to exciting career opportunities, allowing you to bring your imaginative designs to life. Join my classes, and let's embark on a transformative journey of skill development and professional growth together. Your career's next chapter starts here!

    Kamal
    Blender lessons, 3D Modeling section, 3D modeling
    You will learn the basics of modeling in a professional and scientific manner that will enable you to build three-dimensional models with ease and skill, such as: Buildings, aircraft, cars, furniture and various products for companies. And the consequences of this, including lighting, colors, and rendering (export), all of this in gradual, thoughtful, and scientific steps that put your foot firmly on the path to professionalism and mastery. These lessons feature continuous supervision and practical work that we will work on so that you can generalize these skills and tools to everything that comes to your mind. Due to my long experience, I can confirm that, through the first lessons, you will relate to modeling and the program on your next professional path.

    MiRa
    Computer courses taught by a doctor of computer science
    Are you looking for a qualified teacher to help you improve your computer skills? Do not search anymore ! I am a PhD in computer science and I offer courses in different computer science subjects including databases, UML, algorithms, and much more. Whether you're in college or higher, I'm here to guide you and help you deepen your understanding of these complex topics. With a solid background in the IT field and a passion for teaching, I strive to make IT concepts clear, accessible and interesting for my students. My lessons are adapted to your level and your pace of learning. Whether you want to strengthen your computer basics or prepare for important exams, I am here to accompany you throughout the process. Don't wait any longer, contact me now to book your personalized computer course. Together we will explore the fascinating world of IT and you will successfully achieve your learning goals!