Structured Query Language
Topic outline
-
************************************************************************************************
THIS COURSE CONTENTS ARE STILL UNDER DEVELOPMENT. SOME OF THE MATERIALS ARE NOT COMPLETED YET.
*****************************************************************************************************************************************
WHAT YOU WILL LEARN IN THIS COURSE:
Understanding the basic concepts of relational databases ensure refined code by developers.
This course helps the participants to write sub-queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions.
Controlling privileges at the object and system level are also dealt with in detail.
This course also covers statement for query and manipulate data within the database
WHAT YOU WILL ACHIEVED BY THE END OF THIS COURSE:
1.Able to distinguish the concepts and principles of Structured Query Language (SQL)
2.Able to construct Structured Query Language (SQL) for data definition, manipulation and control
3.Able to apply SQL formatting style in solving data management using SQL
==============================================================================================Materials such as notes and exercises in this course are derived from Oracle University Publication for:
Oracle Database 11g: SQL Fundamentals I Exam (Exam ID: 1Z0-051) by ORACLE UNIVERSITY at:
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-051The representation of this material is aimed to provide seekers of knowledge in SQL for ORACLE
- to get a simplified version in understanding SQL-
Forum
-
File
-