Fundamentals of Oracle SQL by UP System I.T. Foundation, Inc. (UP SITF) - SpeedyCourse Philippines
We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Fundamentals of Oracle SQL

ENDED
Inquire Now
In-Person / Short Course
Ended last Jul 21, 2019
PHP  11,200.00

Details

Target Participants:
Government and Private I.T. Personnel, Members of the Academe and College Graduates of Computer Science and I.T. related courses.

Outline

Day 1: Introduction
  • Overview of Databaseo    
  • Purpose of Database
  • Database Models
Day 2:  Data Analysis and Design
  • Entity Relationship Modelingo    
  • Enhanced E-R Modeling
  • Relational Model
Day 3:  Languages and Databases
  • Introduction to Oracle Database
  • Retrieve Data using the SQL SELECT Statement
  • Learn to Restrict and Sort Data
  • Usage of Single-Row Functions to Customize Output
  • Invoke Conversion Functions and Conditional Expressions
  • Aggregate Data Using the Group Functions
  • Display Data From Multiple Tables Using Joins
  • Use Sub-queries to Solve Queries
  • The SET Operators
  • Data Manipulation Statements
Day 4:  Database Control and Management 
Day 5:  Presentation of the Case Study

Schedules

No. of Days: 5
Total Hours: 35
No. of Participants: 12
Reviews
Be the first to write a review about this course.
Write a Review

The UP System Information Technology Foundation (UPSITF) Inc. is a non-government organization focused on the application of Information and Communication Technology for development. It partners with UP Information Technology Development Center in providing various services such as, but not limited to, Education Development, IT Human Capital Development, Research & Development, Software Engineering, ICT Policy Development and Planning, and IT Project Management.

The Foundation’s flagship project Youth on Information Technology or popularly known as Y4iT is an annual event organized by UPSITF, in cooperation with UP Information Technology Development Center (UP ITDC) and Y4iT Volunteer Corps (VolCorp), that attracts at least 25,000 attendees every year.

Dr. Jaime D.L. Caro, Executive Director of UPSITF, said that for the past ten years, Y4iT has served as a hub for computer enthusiasts and technopreneurs to share ideas and talk about the latest breakthroughs in IT. Drawing thousands of attendees from all over the country, the congress, according to Caro, has inspired individuals to engage with one another and build on ideas that are both innovative and relevant to the community. ...

UP System I.T. Foundation, Inc.
Room 303 Vidal A. Tan Hall, Quirino Ave., cor. Velazquez St. UP Diliman Quezon City
02-4362217
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.