This course introduces Oracle Database 11g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the Meta data and creating database objects.
This course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones.
Introduction
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
Course Number : ODBA-6-1002
Duration : 40 hours
Real testimonials from our Students!
I got married young, had two amazing boys. At age 31 I found myself at a low paying job as an Office Assistant that wasn’t challenging me at all. So I visited Global IT and met with the Director. After looking at my background and doing a personal assessment, he suggested I become a Business [...] Read more
Shazia Rashid
It is with great enthusiasm that I write a recommendation for Global Information Technology for the MCTS 70-431- SQL Server 2005 course. In that time, I have had the opportunity to receive a thorough understanding of writing SQL statements, stored procedures, triggers, functions and views. Other topics that were very helpful were database design, replication, [...] Read more
Larry Broaddus
First I would like to thank GIT staff for all their support. Before I started at Global Information Technology (GIT). I had no IT experience and I was searching for a career that I enjoyed as well as one that would allow me to raise my two children as a single parent. At the time [...] Read more
Nicole Walker
After suffering through unemployment for over a year with a bleak outlook for future employment opportunities in the Criminal Justice field that offered no upward mobility, I made the decision to return to school for some needed updated IT skills and current certifications. I selected Global Information Technology for my updated training. I started my [...] Read more
Randy Schales
My name is Willie M. Williams, I became unemployed after nine years of service to one of the big three companies in April 2009. The majority of my department (ISS) was terminated indefinitely. I thought to myself, ok, I’ll just find another job in the IT field because I knew I had a Master’s degree [...] Read more
Willie M. Williams