ORACLE DATABASE 19C: SQL WORKSHOP

Categoria:
Tecnologie

Database

Ruolo

Database Administrator

Vendor

Oracle

Durata

5 Giorni

Edizioni del corso

2,885.00

Dettagli

1: Introduction

  • Introduction
  • Entity Relationship Model
  • Practice 1-1: Introduction

 

2: Retrieving Data Using the SQL SELECT Statement

  • Retrieving Data Using the SQL SELECT Statement
  • Practice 2-1: Retrieving Data Using the SQL SELECT Statement

 

3: Restricting and Sorting Data

  • Restricting and Sorting Data
  • Practice 3-1: Restricting and Sorting Data

 

4: Using Single-Row Functions to Customize Output

  • Using Single-Row Functions to Customize Output
  • Number Functions
  • Practice 4-1: Using Single-Row Functions to Customize Output

 

5: Using Conversion Functions and Conditional Expressions

  • Using Conversion Functions and Conditional Expressions
  • General Functions
  • Practice 5-1: Using Conversion Functions and Conditional Expressions

 

6: Reporting Aggregated Data Using the Group Functions

  • Reporting Aggregated Data Using the Group Functions
  • Practice 6-1: Reporting Aggregated Data by Using Group Functions

 

7: 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

 

8: Using Subqueries to Solve Queries

  • Using Subqueries to Solve Queries
  • Practice 8-1: Using Subqueries to Solve Queries

 

9: Using Set Operators

  • Using Set Operators
  • Practice 9-1: Using Set Operators

 

10: Managing Tables Using DML Statements in Oracle

  • Managing Tables Using DML Statements in Oracle
  • State of Data
  • Practice 10-1: Managing Tables by Using DML Statements
  • Practice 10-1: Managing Tables by Using DML Statements….Cntd

 

11: Introduction to Data Definition Language in Oracle

  • Introduction to Data Definition Language in Oracle
  • FOREIGN KEY Constraint
  • Practice 11-1: Introduction to Data Definition Language

 

12: Introduction to Data Dictionary Views

  • Introduction to Data Dictionary Views
  • Before you Begin Practice 12: Using SQL Developer
  • Practice 12-1: Introduction to Data Dictionary Views

 

13: Creating Sequences, Synonyms, and Indexes

  • Creating Sequences, Synonyms, and Indexes
  • Sequence Information
  • Practice 13-1: Creating Sequences, Synonyms, and Indexes

 

14: Creating Views

  • Creating Views
  • Practice 14-1: Creating Views

 

15: Managing Schema Objects

  • Managing Schema Objects
  • DROP TABLE
  • Practice 15-1: Managing Schema Objects
  • Practice 15-1: Managing Schema Objects….Cntd

 

16: Retrieving Data by Using Subqueries

  • Retrieving Data by Using Subqueries
  • Practice 16-1: Retrieving Data by Using Subqueries

 

17: Manipulating Data by Using Subqueries

  • Manipulating Data by Using Subqueries
  • Practice 17-1: Manipulating Data by Using Subqueries

 

18: Controlling User Access

  • Controlling User Access
  • Practice 18-1: Controlling User Access

 

19: Manipulating Data Using Advanced Queries

  • Manipulating Data Using Advanced Queries
  • MERGE Statement
  • Practice 19-1: Manipulating Data
  • Practice 19-1: Manipulating Data…Cntd

 

20: Managing Data in Different Time Zones

  • Managing Data in Different Time Zones
  • Practice 20-1: Managing Data in Different Time Zones

 

21: Conclusion

  • Conclusion
  • Q&A Sessions

EDU.Labs by Computer Gross
Via del Pino 1 - 50053 Empoli (FI) - Italia - P. I. 04801490485 - C.F. 02500250168
info@edulabs.it | 0571 9977