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
Real testimonials from our Students!
I would like to express why I would recommend Global Information Technology (Global-itech) to anyone who wishes to further their career in the Information Technology. I have been in the IT field for over twenty years. In July of 2010, HP made the decision to reduce their staff and subsequently gave me only two months [...] Read more
Timothy Hughes
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
Dear Manish: I wanted to also take this opportunity to thank you, and the Staff at Global IT. You and your staff all really changed my life. I know you all know my story and where I came from and where I am now. If it were not for how you conduct classes, and the [...] Read more
Bradley Freeland
My name is Tiffanie Bradley; I was a Mainframe Programmer Analyst by profession and was laid off from Compuware Corporation in 2004. I have been in the Information Technology (IT) field for over 15 years and have experienced a successful career. Upon being laid off and seeking further employment, I recognized that my skills were [...] Read more
Tiffanie Bradley
After many months of searching for training with all the criteria and professionalism that I was looking for, I was fortunate enough to have been recommended to Global Information Technology. I followed up on the recommendation given to me and went to speak to a representative, who gave me a tour of the facility and [...] Read more
Leslie McKenzie