Oracle Database 19c: Introduction to SQL

This is a high-level list of topics covered in this course. Please see the detailed Agenda below  Identify the major structural components of the Oracle Database 12c  Create reports of aggregated data  Write SELECT statements that include queries  Retrieve row and column data from tables  Run data manipulation statements (DML) in Oracle Database 12c  Create tables to store data  Utilize views to display data  Control database access to specific objects  Manage schema objects  Display data from multiple tables using the ANSI SQL 99 JOIN syntax  Manage objects with data dictionary views  Write multiple-column sub-queries  Employ SQL functions to retrieve customized data  Use scalar and correlated sub-queries  Create reports of sorted and restricted data

  • No Rating
  • (0 Reviews)
  • 0 Students enrolled

Hours :

Hands on Labs

Requirements

  • Pre-Requisites: This course is intended for experienced • Administrator • Analyst • Developer • Systems Administrator

Description

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Working in a hands-on learning environment, led by our Oracle Database instructor, students will learn about and explore:  Understand the basic concepts of relational databases ensure refined code by developers.  Create reports of sorted and restricted data.  Run data manipulation statements (DML).  Control database access to specific objects.  Manage schema objects.  Manage objects with data dictionary views.  Retrieve row and column data from tables.  Control privileges at the object and system level.  Create indexes and constraints; alter existing schema objects.  Create and query external tables.

Course Content

Recent Courses

blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free

About the Instructor

instructor
About the Instructor

Ernesto Lee is an impassioned blockchain entrepreneur and technologist from the Miami/Fort Lauderdale Area. For over 25 years Ernesto has been asking hard questions and pursuing tough answers. Ernesto was an original founding member, co-owner and the CTO of Blockchain Training Alliance and former Chief Solutions Architect at TechBlue.com. Presently, Ernesto is the CEO at Ernesto.Net and Engineer at Kaiser Permanente.  Ernesto’s career illustrates a lifelong commitment to pushing the envelope on innovation and growing opportunities for all around him.

As a graduate of Old Dominion University (BS, Physics), Virginia Tech (MS, Software Engineering), and Harvard Extension School (Graduate Certificate, Business Communication), Ernesto has always had a passion for technology and teaching. It has been a cornerstone of Ernesto’s career.