Oracle Database : Introduction to SQL

  Oracle Database : Introduction to SQL

Screen Shot 2016-09-05 at 1.49.02 PM

What you will learn In this course :

students learn the concepts of relational databases. 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. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL. This course is a combination of Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II courses.

In this course, students use Oracle SQL Developer as the main development tool. This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement. This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features. Learn To:Create reports of sorted and restricted dataRun data manipulation statements (DML) to update dataControl database access to specific objectsManage schema objectsManage objects with data dictionary views Retrieve row and column data from tables .

Audience :
 
Application Developers
Business Analysts
Data Warehouse Administrator
Developer
Forms Developer
PL/SQL Developer
System Analysts
 
Prerequisites :

Suggested Prerequisites
Familiarity with data processing concepts and techniques
Data processing
 
Course Objectives :
 
Employ SQL functions to generate and retrieve customized data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Identify the major structural components of the Oracle Database 11g
Create reports of aggregated data
Write SELECT statements that include queries
Retrieve row and column data from tables with the SELECT statement
Run data manipulation statements (DML) to update data in the Oracle Database 11g
Create tables to store data
Utilize views to display and retrieve data
Control database access to specific objects
Manage schema objects
Manage objects with data dictionary views
Write multiple-column sub-queries
Use scalar and correlated sub-queries
Use the regular expression support in SQL
Create reports of sorted and restricted data
  
Course Topics :

Introducing Oracle Database 11g
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
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
Controlling User Access
Managing Schema Objects
Managing Objects with Data Dictionary Views
Manipulating Large Data Sets
Managing Data in Different Time Zones
Retrieving Data Using Sub-queries
Regular Expression Support
 
 
 


All Rights Reseved © Computekeg.com