ORACLE SQL_WS | Oracle Database 19c SQL Workshop
 
This course offers students an introduction to Oracle Database 19c database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
 
Learn how to
Retrieve Data using the SQL SELECT Statement
Restrict and Sort Data
Customize Output Using Single-Row Functions
Use Conversion Functions and Conditional Expressions
Report Aggregated Data Using the Group Functions
Display Data from Multiple Tables Using Joins
Manage Tables by Using DML Statements
Create Sequences, Synonyms, Indexes, Views, and Schema Objects
Manage Data by Using Subqueries and Advanced Queries
Control User Access and Manage Data in Different Time Zones
 
Role
Database Administrator
Database Developer
Developer
 
Course Outline
Module 1: Course Overview
Module 2: Introduction
Introduction
Practice 1-1: Introduction
Module 3: Retrieving Data Using the SQL SELECT Statement
Retrieving Data Using the SQL SELECT Statement
Practice 2-1: Retrieving Data Using the SQL SELECT Statement
Module 4: Retrieving Data Using the SQL SELECT Statement
Retrieving Data Using the SQL SELECT Statement
Practice 2-1: Retrieving Data Using the SQL SELECT Statement
Module 5: Restricting and Sorting Data
Restricting and Sorting Data
Practice 3-1: Restricting and Sorting Data
Module 6: Using Single-Row Functions to Customize Output
Using Single-Row Functions to Customize Output
Practice 4-1: Using Single-Row Functions to Customize Output
Module 7: Using Conversion Functions and Conditional Expressions
Using Conversion Functions and Conditional Expressions
Using the COALESCE Function
Practice 5-1: Using Conversion Functions and Conditional Expressions
Module 8: Reporting Aggregated Data Using the Group Functions
Reporting Aggregated Data Using the Group Functions
Practice 6-1: Reporting Aggregated Data by Using Group Functions
Module 9: Displaying Data from Multiple Tables Using Joins
Displaying Data from Multiple Tables Using Joins
Practice 7-1: Displaying Data from Multiple Tables by Using Joins
Module 10: Using Subqueries to Solve Queries
Using Subqueries to Solve Queries
Practice 8-1: Using Subqueries to Solve Queries    
Module 11: Using Set Operators
Using Set Operators
Practice 9-1: Using Set Operators
Module 12: Managing Tables Using DML Statements
Managing Tables Using DML Statements in Oracle
Managing Tables Using DML Statements in MySQL
Practice 10-1: Managing Tables by Using DML Statements
Module 13: Introduction to Data Definition Language
Introduction to Data Definition Language in Oracle New
Introduction to Data Definition Language in MySQL New
Practice 11-1: Introduction to Data Definition Language
Module 14: Introduction to Data Dictionary Views
Introduction to Data Dictionary Views
Practice 12-1: Introduction to Data Dictionary Views
Module 15: Creating Sequences, Synonyms, and Indexes
Creating Sequences, Synonyms, and Indexes
Practice 13-1: Creating Sequences, Synonyms, and Indexes
Module 16: Creating Views
Creating Views
Practice 14-1: Creating Views
Module 17: Managing Schema Objects
Managing Schema Objects
Practice 15-1: Managing Schema Objects
Module 18: Retrieving Data by Using Subqueries
Retrieving Data by Using Subqueries
Practice 16-1: Retrieving Data by Using Subqueries
Module 19: Manipulating Data by Using Subqueries
Manipulating Data by Using Subqueries
Practice 17-1: Manipulating Data by Using Subqueries
Module 20: Controlling User Access
Controlling User Access
Practice 18-1: Controlling User Access
Module 21: Manipulating Data Using Advanced Queries
Manipulating Data Using Advanced Queries
Practice 19-1: Manipulating Data Part 1
Practice 19-1: Manipulating Data Part 2
Module 22: Managing Data in Different Time Zones
Managing Data in Different Time Zones
Practice 20-1: Managing Data in Different Time Zones
Module 23: Conclusion
 
Descargue el temario para conocer el detalle completo de los contenidos.
 
Debido a las constantes actualizaciones de los contenidos de los cursos por parte del fabricante, el contenido de este temario puede variar con respecto al publicado en el sitio oficial, sin embargo, Netec siempre entregará la versión actualizada de éste.