400 Oracle Database FAQs and Tutorials
This is a great library of over 400 Frequently Answered Questions (FAQs), Tips, and Tutorials for Oracle Database Administrators (DBA) and developers. These Oracle learning materials and tutorials provide easy to understand explanations, and demonstrate how to use the SQL scripts given, which are easy to understand and apply. Many also offer tutorial exercises. These cover Oracle knowledge and understanding for both the beginner and advanced Oracle DBA or developer. They can assist with improving your Oracle skills and help you with deploying database related solutions.
400
Oracle Database FAQs and Tutorials
Oracle
Basic Concepts
17 Oracle datbase FAQs and tutorial
for the Oracle DBA covering fundamental concepts.
Introduction
to Oracle Database 10g Express Edition
21 Oracle
database FAQs and tutorials for Oracle DBAs on
the Oracle 10g Express Edition, including installation.
Introduction
to Command-Line SQL*Plus Client Tool
25 Oracle
database FAQs and tutorials for the Oracle command-line
SQL Plus client tool. Using tutorial exercises, learn how to create
tnsnames.ora and connect to an Oracle server database. Also covers
SQL Plus settings and environment variables, saving query output to
files, and getting query performance reports.
Understanding
SQL Basics
28 Oracle database FAQs and tutorials for
Oracle SQL language
basics. 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.
Technorati Tags: oracle faqs, oracle tutorials, oracle tips
Popularity: 21% [?]
Related Posts: