Instructor-led, Online

Oracle SQL Fundamentals, 3 Days

Oracle SQL Fundamentals Course Summary

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 funtions, 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 SQL Advanced Course:
    • SQL Advanced Course Certificate on completion
    • SQL Advanced Course notes
    • Practical SQL Course exercises, SQL Code Sample
    • After the course, 1 free session for questions online SQL Course via Gotomeeting.com.
    • Max group size, online and in classroom, on this SQL Course is 4.
    Special Offers
    PCWorkshops London
    Special Offer on the 'Visual Data with Power BI' Webinar
    Read More
    PCWorkshops Manchester
    Special Offer: Python 3-weeks online Boot Camp
    Read More
    PCWorkshops Birmingham
    Special Offer on the 'SQL Queries in 1-Day' webinar
    Read More
    PCWorkshops Southend-on-Sea
    Special Offer on the 'Java Cross-Over for Coders' Webinar
    Read More

    Request a Free Webinar Demo

    Try a 30 minutes webinar free. Choose you own topic from our course list.