Course Outline
Introduction to the database Oracle
- Database architecture Database relational model Users, schemas, sessions Tools
Introduction to the SELECT statement
- Projection and selection (filtering) Sorting Data types, operators and NULL handling Built-in scalar functions Date operations
Aggregated data analysis
- Grouping functions DISTINCT clause GROUP BY and HAVING clauses
Retrieving data from multiple tables
- Inner and outer joins (INNER JOIN, OUTER JOIN) ANSI SQL syntax and other join methods (SELF JOIN, NATURAL JOIN) Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
- Simple subqueries Correlated subqueries EXISTS and NOT EXISTS operators
Data Manipulation (DML)
- INSERT, UPDATE, DELETE statements
Concurrent work of users
- Transactions Locks Ensuring data consistency over time
Requirements
General IT knowledge
Testimonials (10)
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I liked the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.