Description

Oracle SQL Fundamentals Course

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables.
Course level is beginners to intermediate.

Oracle SQL Fundamentals Course Outline

Session 1: Database Concepts Revision:

What is a database? Tables, rows and columns, Indexes, primary keys, foreign keys,

Session 2:

The SQL SELECT statement: WHERE clause, Boolean operators (AND and OR), and SQL conditional operators (=,!=, smaller and bigger than, IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT TOP, Distinct

Session 3:

Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

Session 4:

SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.

Session 5:

Joins: SQL Cartesian products,

SQL Joins (Inner join, Left join, Right join, Full join)

Table aliases, Natural joins, Multi-table joins.

Union, Union All, Except, Intersect

Session 6:

Sub-queries: SQL Subqueries, Nested Subqueries,

'WITH AS',

Correlated and uncorrelated subqueries.

Session 7:

Numeric Functions,

String Functions,

Date Functions Date, time and timezone support,

Conversion and

Formatting

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,

Replacing rows,

Updating rows,

Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

Creating Databases and

Creating Tables (Create, alter and drop);

Constraints (Add, alter and drop)

Temp tables

Managing sequences and synonyms

Session 12:

Import data into SQL and Export from SQL

What is included in the Oracle SQL Course:

Oracle SQL Course Certificate on completion

Oracle SQL Course notes

Practical Oracle SQL Course exercises, Oracle SQL Code Sample

After the course, 1 free session for questions online Oracle SQL Course

Max group size, online and in classroom, on this Oracle SQL Course is 4.

Course Images

Oracle SQL Fundamentals, 3 Days

By PCWorkshops

Booking options

Highlights

Description

Dates

About The Provider

Tags

Reviews