Oracle SQL Fundamentals 3-day Course, Manchester OR Online

Oracle SQL Fundamentals 3-day Course, Manchester OR Online

3 days is enough to learn all about Oracle SQL, from the basics to stored procedures DDL and more

By PCWorkshops

Select date and time

Mon, 29 Apr 2024 10:00 - 16:00 GMT+1

Location

82 King St

82 King Street Manchester M2 4WQ United Kingdom

Refund Policy

No Refunds

About this event

 

Oracle Fundamentals SQL Course

SQL Course summary The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements. 3 Consecutive days. Max 4 delegates.After successfully completing this certification, delegates will be to create advanced queries including DML and DDL statements.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

Tags

Organised by

PCWorkshops

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

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 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

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 Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

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

 

 

 

£300 – £600