About this Course
This on site company private course is adapted at the level of the participants
Participants: From 2 to 6 people
Instructor: Oracle Certified trainer
Date: According to your availability
Audience profile
This Oracle Database 11g: SQL Fundamentals I Course is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.
Teaching Methodology
Mixed sessions of theory and practice, with description of the subjects by the trainer and experimentation in the personal computer. Exercises and role plays to practice individualized resolution.
Summary and commercial proposal
- Numbers of days: 3 days
- Software in English Version Oracle Database 11g
- Instructor: Oracle Certified trainer
- Time : 9:00 to 12:15 et 13: 45 à 17:00
- Certificates: Each participant receive a BesTeam Certificate of Achievement
- Material: Oracle Database 11g: SQL Fundamentals I Guide – Softcopy
Course Outline:
- Develop essential SQL skills that enable developers to write queries against single and multiple tables.
Manipulate data in tables. - Create database objects.
- Use single row functions to customize output.
- Work with group functions to report aggregated data.
- Use conversion functions and conditional expressions.
- Manipulate queries to return required data.
- Perform calculations on data.
- Administer database objects.
