SQL Tutorials for dbOrchestra - Oracle

Self-paced Tutorials 

Please note that these tutorials are part of the dbOrchestra installation. There may be some tutorials here that are new.

Installing dbOrchestra 

Setting up the training schema 

This is the schema we use for the tutorials.

Data access part one 

Designed to get you up to speed quickly on the core functionality like: Basic navigation,  generating SQL Select, Execute SQL query show results in form view, Execute SQL Query results to delimited output file, Using the SQL notepad, Creating a SQL insert, update, or delete from a SQL select statement,  stopping execution of a SQL query, creating complex joins, adding and using custom tabs for frequently run queries, executing multiple and single sql scripts.

Data access part two 

Continues with the following topics: Using the SQL table data editor, Comparing SQL table data, Saving data to Excel for analysis, Creating custom SQL queries, Building SQL update, insert, delete scripts using existing rows as a template.

SQL schema basics 

Contain the following topics: Using the table schema editor to add a column check constraint, create a column default, and add a column;  Creating an index, creating a foreign key constraint, comparing two schemas, determining table dependencies, creating scripts for multiple schema builds, creating duplicate schemas.

Importing and exporting data 

Importing data from a directory, Exporting data from a directory.

SQL Server Stored Procedure 

Creating an select stored procedure, Creating an insert stored procedure, Testing stored procedures within the dbOrchestra framework, Building stored procedures in the table manager.

More with the SQL Notepad 

Using multiple instances of the SQL Notepad, basic SQL Notepad edit functions, stopping query execution within the SQL Notepad, showing a query execution plan.

Using the SQL File Manager 

Setting up custom tabs in the SQL File Manager, Working with SQL files, Exploring misc SQL File Manager functionality.