_ Oracle SQL Basics

software course category

This Oracle SQL course will create an introduction to SQL helps you write sub-queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Even if you use SQL from another software maker still will help you understand the concepts and daily tasks at the office. Regarding the tools all of them used in this course are vendor agnostic.

Objectives

Understand Relational Model
Understand Normal Forms
Learn Oracle SQL and how it's used
Build and run SQL scripts
Perform basic database operations using MySQL
Write basic SQL scripts for MySQL

Audience

Application Developers
System Analysts
Business Analysts
Data Warehouse Administrator
Forms Developer
Developer
PL/SQL Developer

Duration

3 days

Requirements

Basic computer skills and knowledge of set theory fundamentals
Understanding of first order logic
Understanding of search algorithms and complexity theory
Prior SQL or Oracle Sql programming experience is helpful but not required

Curriculum

DBMS
Relational Model
SQL basics
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Best practices
Exercises that will help you on daily tasks on the job

Resources

_ Classes

No classes available for this course...

Our Delivery

Online or On-site delivery

We created a personalized delivery strategy by offering blended learning​

Communities of practice

Find a bunch of people who are on the same page with you.

Engaged learning

Engaging platform with gamification for collaboration and friendly competition.

Interactive training

Interactive online trainings and live webinars available.

Learning efficiency

A special learning environment can boost learning efficiency.

Learning everywhere

Available anywhere and anytime, on your phone, computer or tablet.

Q&A

Can you organise virtual training sessions or only face to face trainings?​

Yes, you can choose an online or an offline training session. We use Knolyx, an e-learning platform, to make the process of online training and mobile learning delivery as efficient as a face-to-face training session. You can check here a complete list of features set.

Should we deliver online or
offline classes?

That’s up to you. We offer you an efficient learning environment and you can use it according to your needs: either online or offline. Nobody knows better than you and your team what you need, so we do not imposed some predefined criteria, we adapt to yours.

Can you customize courses to suit our particular requirements?​

Yes. We offer training consultancy and we establish the most appropriate courses according to the specific needs and business objectives of your company.