Oracle SQL Fundamentals
Description
Oracle Fundamental - Advanced Queries, Including DDL and DML statments. 3-Consecutive days.
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