Oracle SQL Fundamentals 3-day Course, Manchester, Online
Schedule
Mon Sep 03 2018 at 11:00 am to Mon Dec 13 2021 at 06:00 pm
Location
Online | Online, 0
Advertisement
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
Advertisement
Where is it happening?
Online
Tickets
GBP 300.00 to GBP 600.00