Course details
Introduction
This five-day instructor-led course consists of Fundamentals I (3 days) and Fundamentals II (2 days) and introduces participants to the fundamentals of SQL using Oracle Database 11g database technology. In this course participants learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow consumers and developers to write queries against relational database tables, manipulate data in… + Read More
Course details
Introduction
This five-day instructor-led course consists of Fundamentals I (3 days) and Fundamentals II (2 days) and introduces participants to the fundamentals of SQL using Oracle Database 11g database technology. In this course participants learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow consumers and developers to write queries against relational database tables, manipulate data in tables, create database objects, and use built-in functions to customize output, convert data, use conditional expressions, perform aggregate calculations, manipulate large data sets, manage data in different time zones and make use of the powerful regular expressions.
This course will teach participants how to make use of Oracle SQL Developer as the main tool (with SQLPlus optionally available) for hands-on practice to reinforce the fundamental concepts and new skills acquired.
Course Content
SQL FUNDAMENTALS I
- Lesson 1: Introduction
- Lesson 2: Retrieving Data Using the SQL SELECT Statement
- Lesson 3: Restricting and Sorting Data
- Lesson 4: Using Single-Row Functions to Customize Output
- Lesson 5: Using Conversion Functions and Conditional Expressions
- Lesson 6: Reporting Aggregated Data Using the Group Functions
- Lesson 7: Displaying Data from Multiple Tables Using Joins
- Lesson 8: Using Subqueries to Solve Queries
- Lesson 9: Using the Set Operators
- Lesson 10: Manipulating Data
- Lesson 11: Using DDL Statements to Create and Manage Tables
SQL FUNDAMENTALS II
- Lesson 1: Introduction
- Lesson 2: Introduction to Data Dictionary Views
- Lesson 3: Creating Sequences, Synonyms and Indexes
- Lesson 4: Creating Views
- Lesson 5: Managing Schema Objects
- Lesson 6: Retrieving Data by Using Subqueries
- Lesson 7: Manipulating Data by using Subqueries
- Lesson 8: Controlling User Access
- Lesson 9: Manipulating Data
- Lesson 10: Managing Data in Different Time Zones
Updated on 05 September, 2016 - Read LessAbout Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses