• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Oracle SQL Fundamentals, 3 Days

Oracle SQL Fundamentals, 3 Days

By PCWorkshops

4.6(12)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online or In-Person

  • Intermediate level

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.

Location

Golden Cross House, 8 Duncannon St, WC2N 4JF, United Kingdom, London

About The Provider

PCWorkshops
PCWorkshops
London
4.6(12)
At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.
Read more about PCWorkshops

Tags

Reviews