Oracle SQL Fundamentals 3-day Course, Manchester, Online

Oracle SQL Fundamentals 3-day Course, Manchester, Online

Actions and Detail Panel

£750

Description

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

Share with friends