Oracle SQL təlimi

Syllabus:

Explaining the theoretical and physical aspects of a relational database

- Relating clauses in SQL Select Statement to Components of an ERD

- Explaining the relationship between a database and SQL

Retrieving Data using the SQL SELECT Statement - Using Column aliases

- Using The SQL SELECT statement

- Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

- Using Arithmetic expressions and NULL values in the SELECT statement

Restricting and Sorting Data

- 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

- Sorting Data

Using Single-Row Functions to Customize Output

- 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

- Manipulating dates with the date function

Using Conversion Functions and Conditional Expressions

- 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

- Nesting multiple functions

Reporting Aggregated Data Using Group Functions

- Restricting Group Results

- Creating Groups of Data

- Using Group Functions

Displaying Data from Multiple Tables

- Using Self-joins

- Using Various Types of Joins

- Using Non equijoins

- Using OUTER joins

- Understanding and Using Cartesian Products

Using Subqueries to Solve Queries - Using Single Row Subqueries

- Using Multiple Row Subqueries

- Update and delete rows using correlated subqueries

Using SET Operators

- Matching the SELECT statements

- Using the ORDER BY clause in set operations

- Using The INTERSECT operator

- Using The MINUS operator

- Using The UNION and UNION ALL operators

Managing Tables using DML statements

- Managing Database Transactions

- Controlling transactions

- Perform Insert, Update and Delete operations

- Performing multi table Inserts

- Performing Merge statements

Managing Indexes Synonyms and Sequences

- Managing Indexes

- Managing Synonyms

- Managing Sequences

Use DDL to manage tables and their relationships

- 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

- Managing Constraints

Managing Views

- Managing Views

Controlling User Access

- Differentiating system privileges from object privileges

- Granting privileges on tables

- Distinguishing between granting privileges and roles

Managing Objects with Data Dictionary Views

- Using data dictionary views

Managing Data in Different Time Zones

- Working with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP

- Working with INTERVAL data types