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!
“This was, by far, the best class experience I have had since high school. I took the COMPTA+ and Networking+ classes at Global Information Technology, and within a few months of completing these classes, I had a Level II Technical support position. The instructors were fantastic and really cared about my learning. If I had [...] Read more
Jonathan Nimene
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
I’d just like to thank you and Global Information Technology for getting my career back on the right track. I had been unemployed for nearly 2 years after being laid off from ACCESS and I have been trying to find the right job. Couple months after applying to the unemployment, Michigan Works office approved me [...] Read more
Racha Ramdan
I want to take this opportunity to tell how pleased I am with having selected Global Information Technology for my training. About six months ago I requested information from several schools in the Detroit area. After speaking with each of them I chose Global Information Technology. I found your staff very friendly and professional. Your [...] Read more
Mike McCain
I’d just like to thank Global IT for getting my career back on track. Before joining your school I was at a major crossroads in my life; I had depleted my unemployment benefits and was deciding on which direction to take my career. The economy was making companies close their doors and companies which did [...] Read more
Daniel Vitale