Skip Main Navigation
Page Content

Save This Event

Event Saved

Oracle SQL Fundamentals 5-day Course, Manchester

PCWorkshops

Monday, 7 January 2019 from 11:00 to 18:00 (GMT)

Oracle SQL Fundamentals 5-day Course, Manchester
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Oracle Fundamentals, Manchester Ended £1,400.00 £0.00
Oracle Fundamentals, Manchester, Early Bird 24 Dec 2018 £1,260.00 £0.00

Share Oracle SQL Fundamentals 5-day Course, Manchester

Event Details

 

Oracle Fundamentals SQL Course


SQL Course summary 

The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts. 

After successfully completing this certification, delegates will be able to learn how to; create Oracle SQL statements to query database tables, use standard aggregate functions and related SELECT statement clauses, Implement extended SQL functions and many other useful skills. 

Other vital skills that delegates will learn include; performing flashback operations, creating and using external tables as well as controlling user access to database objects. 

The examinations are not included as a part of this course and will need to be purchased separately via Pearson Vue


Oracle SQL Course Desciption

 

 

  • Session 1: Relational database concept
  • Session 2: Using SQL developer
  • Session 3: Retrieving and filtering data with the select statement,using filter operations
  • Session 4: Expression Queries
  • Session 5: Aggregate functions, having
  • Session 6: Enhanced grouping features
  • Session 7: Joining tables
  • Session 8: Numeric Functions, String Functions
  • Session 9: Date Functions
  • Session 10: Date, time and timezone support
  • Session 11: Conversion and miscellaneous
  • Session 12: SQL Parameters
  • Session 13: SQL Stored procedures
  • Session 14: Managing tables
  • Session 15: Managing indexes and views
  • Session 16: Managing sequences and synonyms
  • Session 17: Retrieve data using subqueries
  • Session 18: Hierarchical queries
  • Session 19: Manage large data sets, Using Sub-queries, Temp tables
  • Session 20: Flashback technology
  • Session 21: Regular expression support
  • Session 22: Manage objects with the data dictionary
  • Session 23: Manage Schema Objects
  • Session 24: Access control
Do you have questions about Oracle SQL Fundamentals 5-day Course, Manchester? Contact PCWorkshops

Save This Event

Event Saved

When & Where


PC Workshops at Regus
Pall Mall Court, 61-67 King Street,
M2 4PD Manchester
United Kingdom

Monday, 7 January 2019 from 11:00 to 18:00 (GMT)


  Add to my calendar

Organiser

PCWorkshops

  • PCWorkshops  is a specialist provider of training courses in Java programming, Databases and MS Project.

More about us:

Our up-to-date training courses are designed and delivered by registered, qualified instructors with a wealth of experience in software development and training.

The maximum class-size is normally 4.

Every one gets personalised attention.

Why learn with us at PCWorkshops:

Up-to-date relevant courses for todays’ business world

Trainers with professional experience

Award Winning Trainer

21 Years In Business

Excellent Client References

Assessment-based certificate, Oracle exam vouchers

Weekdays, Evenings and Weekends

At PCWorkshops, we love out job!

We offer Training Courses in Software Packages:

MS Project Training

Database design and Data Normalisation

SQL Courses

Data Analysis and Data visualtion courses

MS Excel, data analyses with Excel. Excel VBA

Access Database Courses.

Java Programming.

MS Office Training.

Our Style:

Relaxed, Practical, Useful

Methods of instruction:

Classroom training with max class-size 4 peopl

Virtual classrooms

1-1 mentoring

Customised training

Certification:

Our PCWorkshops certificates are assessment based.
Our course outlines are in-line with Oracle courses. We assist with exam prep for the presitigeous, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of data
Software companies, testing companies,companies who employ software developers
Coders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

  Contact the Organiser

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.