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-1001
Duration : 40 hours
Real testimonials from our Students!
I wanted to take an opportunity to provide an update on my career since deciding to take classes with Global Information Technology. As you know, after nearly 15 years with a major player in the field of IT solutions, I was laid off from my job in December of 2008. After taking stock of what [...] Read more
Robert Franklin
I wish to express my thanks and gratitude for your expert teaching and support that have helped me transition into a career in information technology. When I began taking classes in August of 2009, I had been unemployed for over a year, and job prospects in the insurance industry were slim. Your staff took the [...] Read more
Marcus Thompson
Manish – I am writing to say thank you. I thank God for Global Information Technology. I thank God for you, because you genuinely care about the direction of the student. I thank God for believing in me, for coaching me, and for helping me. I thank God for everyone at Global Information Technology for [...] Read more
Samar Gorial
First of all I would like to start out by saying a big thank you to Global Information Technology who not only provided me with my CompTIA A+ and Network+ training, however they helped me to get full time employment with benefits. The Director at Global Information Technology requested, I try and get some funding [...] Read more
Haitham Muhsin
I want to thank Global Information Technology for assisting with my job search and training needs. With the help of Michigan Works I was able to attend the Network Engineering Professional training class, consisting of CompTIA A+ and Network+, Microsoft desktop and server operating systems, Linux and Cisco CCNA. I am very impressed with all my teachers, [...] Read more
Weston Tatem
Notifications