Course details
Course Objectives
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
- Employ SQL functions to generate customized data.
- Create reports of aggregated data.
- Use the SET operators to create subsets of data.
- Run data manipulation statements (DML) in Oracle Database 11g.
- Run data definition language (DDL) statements to create schema objects.
- Identify the major structural components of Oracle Database 11g.
- Retrieve data from tables.
- Create reports of sorted and restricted data
Course Topics
- Introduction
- Retrieve Data Using the SQL SELECT Statement
- Restrict and Sort Data
- Use Single-Row Functions to Customize Output
- Conversion Functions and Conditional Expressions
- Aggregated Data Using Group Functions
- Display Data From Multiple Tables Using Joins
- Use Sub-queries to Solve Queries
- SET Operators
- Data Manipulation
- Use DDL Statements to Create and Manage Tables
- Other Schema Objects
Course Location
About Computek Training Center
It is the first and largest provider of computer software and hardware training in Egypt.
We_They is fast growing training provider over 20 years of experience in the delivery of computer training.
Our organization is dedicated to provide education excellence to meet the needs of each technology, simultaneously, as customer expand designed solutions to meet his particular organization's business needs.
Also Compuek is aimed by great companies and institutions for training their human resources looking for their progress and growth, and to make HR learn this promising technology at that time. For 20 years, the center is supplying the career market by highly qualified HR members who having broad minded, acquired with high technique and capable to work on the most difficult systems by all easiness and facility.
Computek is distinguished by its remote sighted management that enjoyed advanced thinking and firmness in order to enable the trainees to get as much training as possible by easy and simple way and in fine, splendid, and very organized training halls acquired with high capability PCs that are continuously upgraded to maintain high performance.
See all Computek Training Center courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Data and Web Analytics CPD Certificate NextGen LearningEGP 2,751Duration: Upto 20 Hours
- Database Global CoursesEGP 755
EGP 7,107Duration: 2 Hours
