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!
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
Having stagnated as an IT professional, as well as finding the demands in the market are for later technologies, it became evident that I had to re-tool to remain, indeed become, marketable. I needed a training venue that offered a breadth of curriculums, that was affordable, that was convenient and that was geared to the [...] Read more
Ray Hodge
I was faced with a layoff from my previous employer. Being in the auto industry really made me stop and think about my future. I have always enjoyed working with computers, so I started exploring my options. I was browsing the internet one evening and found Global Information Technology. My biggest concern was going back [...] Read more
Michael Kurtser
Through this letter I want to thank Mr. Manish Modi and Global information Technology ( GIT) for helping me restart my career. I was working in the IT field and took a break for family reasons. After being a full time mom for 11 years, I recently decided to restart my career and wanted to [...] Read more
Sonal Shirodkar
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