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?

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
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.