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

ALX Logo

MS SQL Server For Programmers

The course provides students with knowledge and skills to create, manage and programmatically control database on MS SQL Server platform. Basing on relational database theory students get to know Transact SQL (T-SQL) language.

by ALX [Claim Listing ]
London IT Training (LIT) Logo

Mysql 8. 0 Database Developer Oracle Certified Professional

MySQL 8.0 Database Developer Oracle Certified Professional course is offered by Oracle that evaluates your capacity to design both the Web and Console Application using MySQL, including other high-level Programming Languages.

by London IT Training (LIT)
Learning Tree Logo

SQL Server Database Administration

Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative ta...

by Learning Tree [Claim Listing ]
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 ]
Insight Logo

Microsoft SQL Fundamentals Of Querying

You will compose SQL queries to retrieve desired information from a database. You should have basic computer skills, be familiar with concepts related to database structure and terminology, and want to use SQL to query databases.

by Insight [Claim Listing ]

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