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!
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
I am writing this letter today in recommendation of Global Information Technology (GIT). In the spring of 2008 I learned that my employment position was being off-shored. Of course this was devastating news. Even though I possess a bachelor’s degree in Information Systems, I realized I did not specialize in any specific IT area and [...] Read more
Lynda Wilson
I was fortunate to meet Manish, the Director of Global-IT, and started to discuss classes that would assist me with Project Management, as a Training Consultant. My experience has been nothing but positive, but also, confidence building. My instructor was phenomenal who taught my PMP course. He not only is available any time, but is [...] Read more
Soraya Meri
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
8/10/2017. My experience Global Information Technology was something I wouldn’t trade for the world. When I went there looking for A+ Training, I had been jobless for eight months. I was desperate to find something, anything that would change my life. Global Information Technology did just that. After completing the training program there, I actually [...] Read more
Wesley Cicotte