ITI584 Introduction to Oracle SQL (8)

This subject introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This subject provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the subject also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones.

Subject Outlines
Current CSU students can view Subject Outlines for recent sessions. Please note that Subject Outlines and assessment tasks are updated each session.

No offerings have been identified for this subject in 2018.

Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject Information

Grading System

SY/US

Duration

One session

School

School of Computing and Mathematics

Enrolment Restrictions

For students enrolled in only the following courses:
Master of Database Design and Management
Master of Networking and System Administration
Master of Systems Development
Master of Information Systems Security
Master of Management (IT) - MMgtInfoTech
Graduate Certificate in Management (IT) - GradCertMgtInfoTech

Prerequisites

ITI500

Learning Outcomes

Upon successful completion of this subject, students should:

be able to search data using advanced sub-queries;
be able to retrieve row and column data from tables with the SELECT statement;
be able to employ SQL functions to generate and retrieve customized data;
be able to run data manipulation statements (DML) to update data in the Oracle Database 10g;
be able to control user access and manage schema objects.

Syllabus

This subject will cover the following topics:

Retrieving Data Using the SQL SELECT Statement.

Restricting and Sorting Data.

Using Single Row Functions to Customize Reports.

Reporting Aggregated Data Using the Group Functions.

Displaying Data From Multiple Tables.

Using Sub queries to Solve Queries.

Using the SET Operators.

Manipulating Data.

Using DDL Statements to Create and Manage Tables.

Creating Other Schema Objects.

Managing Objects with Data Dictionary Views.

Controlling User Access.

Manage Schema Objects.

Manipulating Large Data Sets.

Generating Reports by Grouping Related Data.

Managing Data in Different Time Zones.

Searching Data Using Advanced Sub queries.

Hierarchical Data Retrieval.

Performing Regular Expression Support and Case Insensitive.

Contact

Current Students

For any enquiries about subject selection or course structure please contact Student Central or ask@csu.edu.au or phone on 1800 275 278.

Prospective Students

For further information about Charles Sturt University, or this course offering, please contact info.csu on 1800 275 278 (free call within Australia) or enquire online.

The information contained in the 2018 CSU Handbook was accurate at the date of publication: August 2018. The University reserves the right to vary the information at any time without notice.

Back