Skip Main Navigation
Page Content

Save This Event

Event Saved

Oracle SQL Fundamentals 5-day Course, Manchester

PCWorkshops

Monday, 4 February 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 3d 16h 42m £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, 4 February 2019 from 11:00 to 18:00 (GMT)


  Add to my calendar

Organiser

PCWorkshops

At PCWorkshops, we do courses in Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Courses well developed 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:

  • Excellent, up-to-date courses, following latest trends and tecnologies.
  • Excellent trainers with professional experience.
  • We offer stress free training: we start at 11am, giving you an inexpensive, stress free, off peak travel to maximise your training experience. You could alsp if necessary still attend to the necessary emails etc before starting.

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:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and Data visualization courses
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training
  • Tableau, MS Power BI, MS Excel Dashboards

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 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.