This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.
Course Objectives
This course will cover the fundamentals of the Oracle SQL Database. Some elements that are being covered are as follows:
- A summation of relational database principles and introduction to the Oracle Relational Database Server.
- Using the iSQL *Plus Web-Based Database interface and other traditional interfaces
- Writing simple SQL queries and moderately complex SQL queries using various join technique
- Summarizing, grouping and sorting data
- Advanced query techniques such as correlated sub-queries.
- Developing simple SQL *Plus reports
- Creating and maintaining database tables
- Taking advantage of new features such as the use of regular expressions
- Moving beyond basic table definitions, indexes, sequences, views and others.
Course Benefits
The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are:
- Application designers and developers.
- Database administrators.
- Business users and non-technical end users.