Oracle SQLの言語基本原則のための28のOracleの
データベースのFAQsそして
個人指導。 Learn about data
types, data literals, date and time values, data and time intervals,
converting to dates and times, NULL values, pattern matches.
Understanding
SQL DDL Statements 11 Oracle database FAQs and
tutorials for Oracle SQL DDL
statements. Find out how to
create, alter and drop tables, indexes, and views.
Understanding
SQL DML Statements 15 Oracle database FAQs and
tutorials for Oracle SQL DML
statements. Learn about
inserting, updating and deleting rows from database tables.
Understanding
SQL SELECT Query Statements 33 Oracle database FAQs
and tutorials for Oracle SQL SELECT query
statements. Learn how to
select rows and columns from tables and views, sort and count
query outputs, group outputs and apply group functions, join
tables, and use subqueries.
Understanding
SQL Transaction Management 22 Oracle database FAQs
and tutorials for Oracle SQL transaction
management. Learn about
starting and ending transactions, committing and rolling back
transactions, transaction/statement-level read consistency, read
committed isolation level, locks and dead locks.
Managing
Oracle User Accounts, Schema and Privileges 23
Oracle database FAQs and tutorials for Oracle user account,
schema and privileges. Learn about creating user accounts, granting
privileges for session
connections, granting privileges for creating tables and inserting
rows.
Managing
Oracle Database Tables 18 Oracle database FAQs and
tutorials for database tables for DBA
and developers. Understand how to create, alter and remove tables,
add, alter and remove columns, and work with recycle bin.
Managing
Oracle Table Indexes 14 Oracle database FAQs and
tutorials for Oracle DBA on
creating, dropping, rebuilding and managing indexes.
Managing
Oracle Tablespaces and Data Files 19 Oracle database
FAQs and tutorials for creating and managing
tablespaces and data files. Learn about creating and dropping
tablespaces; listing available
tablespaces; creating and dropping data files; setting tablespaces and
data files offline; removing corrupted data files.
Creating
New Database Instance Manually 15 Oracle database
FAQs and tutorials for
creating Oracle database instances manually using CREATE DATABASE
statement. These teach how to create a new database instance manually.
Introduction
to PL/SQL 17 Oracle database FAQs and tutorials to
introduce PL/SQL
language for DBA and developers. Discover how to create procedures,
executing procedures, using local
variables, controlling execution flows, passing parameters and defining
nested procedures.
Introduction
to Oracle SQL Developer 29 Oracle database FAQs and
tutorials to introduce Oracle SQL
Developer, the new free GUI client for DBA and developers. Gain
understanding on the following: SQL statement execution, data
objects management, system views and reports, stored procedure
debugging.
Understanding
PL/SQL Language Basics 22 Oracle database FAQs and
tutorials for PL/SQL language basics
for DBAs and developers. Discover how to
define variables, assign values, use "loop" statements, set
"if" conditions, and work with null values.
Creating
Your Own PL/SQL Procedures and Functions 26 Oracle
database FAQs and tutorials for PL/SQL on how to manage procedures.
Gain understanding on creating
procedures and functions, executing and dropping procedures, passing
actual parameters to formal parameters, making optional parameters.
Working
with Database Objects in PL/SQL 23 Oracle database
FAQs and tutorials for working with database
objects in PL/SQL. Learn how to run DML statements, assign table data
to variables, use the
implicit cursor, and define and use RECORDs with table rows.
Working
with Cursors in PL/SQL 19 Oracle database FAQs and
tutorials for working with database
objects in PL/SQL. Learn about defining, opening, and closing cursors,
looping through cursors,
defining and using cursor variables.
Loading
and Exporting Data 27 Oracle database FAQs and
tutorials for loading data into and
exporting data from Oracle. Understand how to
save data as flat files, load data from flat, export and
import database, schema and tables, and create external tables.
ODBC
Drivers, DSN Configuration and ASP Connection 9
Oracle database FAQs and tutorials for Oracle ODBC drivers and
connections. Learn how to
install Oracle ODBC drivers; TNS settings; defining DSN entries;
connecting MS Access or ASP pages to Oracle servers.
