Oracle Fundamentals Course

At this Oracle SQL Fundamentals couse, 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 function, table variables.

Content:

• 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