CERTIFICATES

This module explains the overview of theoretical and physical aspects of a relational database, Relating clauses in SQL Select Statement to Components of an ERD and Explaining the relationship between a database and SQL.

This module explores Using Column aliases, Using The SQL SELECT statement, Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword and Using Arithmetic expressions and NULL values in the SELECT statement.

This module covers Applying Rules of precedence for operators in an expression, Limiting Rows Returned in a SQL Statement, Using Substitution Variables, Using the DEFINE and VERIFY commands and Sorting Data.

This module explores Manipulating strings with character functions in SQL SELECT and WHERE clauses, Performing arithmetic with date data, Manipulating numbers with the ROUND, TRUNC and MOD functions and Manipulating dates with the date function.

This module explores Applying the NVL, NULLIF, and COALESCE functions to data, Understanding implicit and explicit data type conversion, Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions and Nesting multiple functions.

This module makes you familiar with Restricting Group Results, Creating Groups of Data and Using Group Functions.

This module is about one of the core concpets of the SQL like Using Self-joins, Using Various Types of Joins, Using Non equijoins, Using OUTER joins and Understanding and Using Cartesian Products.

This module identifies you with Using Single Row Subqueries, Using Multiple Row Subqueries and Update and delete rows using correlated subqueries.

This module is about matching the SELECT statements, Using the ORDER BY clause in set operations, Using The INTERSECT operator, Using The MINUS operator and Using The UNION and UNION ALL operators.

This module makes you familier with Managing Database Transactions, Controlling transactions, Perform Insert, Update and Delete operations, Performing multi table Inserts and Performing Merge statements

This module makes you to gain knowledge about Managing Indexes, Managing Synonyms and Managing Sequences.

This module makes you to work with Describing and Working with Tables, Describing and Working with Columns and Data Types, Creating tables, Dropping columns and setting column UNUSED, Truncating tables, Creating and using Temporary Tables, Creating and using external tables and Managing Constraints

This module presents idea about the views and Differentiating system privileges from object privileges, Granting privileges on tables and distinguishing between granting privileges and roles.

This module makes you familier with using data dictionary views, Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP and Working with INTERVAL data types