Oracle SQL

by Computeraid Ltd Claim Listing

This three day Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Computeraid Ltd Logo

img Duration

3 Days

Course Details

Course Objectives

This three day Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.  Gain practical hands-on experience by completing guided exercises and examples throughout the course.

 

Oracle SQL – Course Contents

  • Creating SQL statements to query database tables
  • Using standard aggregate functions and related SELECT statement clauses
  • Joining Tables
  • Using basic subqueries and the set operators
  • Using numeric, character and date functions
  • Using conversion and other miscellaneous functions
  • Using SQL parameters
  • Using complex subqueries
  • Creating and altering tables and views
  • Inserting, updating and deleting rows in database tables
  • Managing sequences and synonyms
  • Swansea Branch

    4th Floor, 11 Wind Street, Swansea

Check out more SQL Server courses in UK

Pitman Training Logo

Database Fundamentals

In this course, you’ll learn the core concepts of relational databases, and you’ll get your feet wet with structured query language (SQL), which is used to manage data in a relational database management system.

by Pitman Training [Claim Listing ]
Wise Owl Training Logo

Introduction To SQL

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them.

by Wise Owl Training [Claim Listing ]
EQV (UK) Ltd Training Logo

SQL Programming Introduction

This SQL Introduction programming course teaches relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills.

by EQV (UK) Ltd Training [Claim Listing ]
Best Practice Training Limited Logo

Administering Microsoft SQL Server Databases

Administering Microsoft SQL Server 2014 Databases is a five day course which provides essential skills and knowledge to the participants for maintaining Microsoft SQL Server 2014 database. This course mainly focuses on teaching delegates ways to use SQL Server 2014 features

by Best Practice Training Limited [Claim Listing ]
Kalu Logo

Microsoft SQL Server Data Quality Services (DQS)

During this 2 day course, you will optimise your understanding of how to use DQS to cleanse, match, standardise, and enrich data to guarantee a result of reliable and consistent analytics. This course will equip you with up-to-date regulations and fundamental objectives to ensure the highest qualit...

by Kalu [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy