Articles Index
MS Access 2007 Step by Step
Access writes SQL Statement behind the Scene
Example: Creating computer_schools1 Table
What is Primary & Foreign Key?
Five Different Queries in Focus
Append Query -MS Access Queries
Add Grouping Levels If Required
Selecting Layout of Report - MS Access Reports
Writing Report Name & Click Finish - MS Access Reports
Select Table/Query & Fields for Form - MS Access Forms
Write Form Name and Click Finish - MS Access Forms
Save & Exit Visual Basic window - MS Access Module
How to get into Module Design View? - MS Access Modules & Macros
MS Access Data Import/Export Feature
Start the Export process - MS Access
Select File Location, Format & Name to Export the Data - MS Access 2007
Verify the Exported Data - MS Access 2007
MS Access Data Import/Export Feature
Import Spreadsheet Wizard - MS Access 2007
Change field attributes - MS Access Import Wizard
Write Name for Table & Click Finish - MS Access Import Wizard
Verify the Import Process - MS Access 2007
Building Formula/Expression field - MS Access 2007
List of MS Access built-in function
Example: Finding Years of Service
MS Access 2003 Step by Step
Example: Creating computer_schools Table
What is Primary & Foreign Key?
Five Different Queries In Focus
Creating Forms Using Form Wizard
Select Table/Query & Fields for Form
Write Form Name and Click Finish
Select Table/Query & Fields for Report
Add Grouping Levels If Required
Write Report Name & Click Finish
Save & Exit Visual Basic window
MS Access Data Import/Export Feature
First Row Contains Heading Check Box
Import in New or Existing Table
If Necessary, Specify Each Field Info
Write Name for Table & Click Finish
Exporting Data - Click File & Then Export
Select File Location, Format & Name - Exporting Data
Verify by Opening Exported File
MS Access 2003 Data Import/Export Feature
MS Access 2003 Data Import Feature
Select Type, File Name & Click Import - MS Access 2003 Data Import
Right Click on Empty Column & Click ‘Build’ - Expression Builder
Select the Function You Need - List of Built-in Functions
MS Access Built-In Functions - YOS (Years of Service) Calculation
Oracle SQL in 10 Minutes
What is SQL? Why can't we live without in Database world?
Eliminating the confusion behind three terms: SQL, PL/SQL & SQL*Plus
What is DQL, DML, DDL, TCL and DCL in SQL jargon?
CREATE USER / ALTER USER & GRANT / REVOKE Statements
SQL Statements for Database Security
Object Privileges and System Privileges
CREATE USER & ALTER USER Statements
CREATE PROFILE & ALTER PROFILE Statements
SQL Operators: Comparison, Arithmetic, Logical & Other
SQL Operators, Order of precedence
SQL Functions: Single Row & Group Functions
Different types Oracle SQL Joins
What's so special about "Outer Joins"?
UPDATE, INSERT & DELETE Statements
CREATE, ALTER & DROP Statement
Oracle Data Types - A Quick Overview
CREATE TABLE ... AS SELECT Statement
Data integrity constraints or simply constraints
How Data Integrity & Data Consistency is achieved in Oracle (or any RDBMS)?
Difference between Linking & Joining Tables
SQL Statements for Other Database Objects
Oracle 9i Database Administration in 10 Minutes
Understanding the complete Oracle Environment
Background Process, Event & User Trace Files
MAX_DUMP_FILE_SIZE init.ora parameter
Dynamic Performance Views (V$) & Data Dictionary Views
V$SESSION, DBA_TABLES, DBA_DATA_FILES
Understanding the Oracle Instance
Understanding Oracle Instance’s Memory Architecture
Understanding Oracle Instance’s Background Processes
Understanding the working of Oracle Instance
Oracle Instance background processes; dedicated server mode
Restaurant Running Under Shared Waitress Mode
Shared Server or Dedicated Server?
Oracle physical files and their purpose
Physical & logical architecture relationship
Relationship between logical and physical architecture of database
Segments (database objects) can lie in more than one data file
How Oracle Instance Uses Redo Log Files?
Oracle software for free from oracle website (www.oracle.com)
Oracle 9i Software Installation
Oracle Universal Installer (OUI)
Before using DBCA we have to set certain OS environment variables
Location of all Oracle physical files
ORACLE_BASE, ORALCE_HOME, DB_NAME and SID
Set the maximum number of datafiles, redo log groups etc.
Save the settings for your database in a template
Use Oracle Enterprise Manager (OEM) to test connection
DBCA (Database Configuration Assistant)
Using DBCA you can create a new database
Oracle 9i Database Design using DBCA
Decide on Global Database Name & Domain
Dedicated Server or Shared Server Mode
Oracle Net needs to be configured on server as well as on each client
Service name will be Global Database Name of Oracle Database Server
Service Name & Net Service Name is not same
Net Service Name or tnsnames.ora file
Oracle Net Manager showing no Service Name
Assign the name to the listener process
“Add Address” of newly added listener process to tree
Save network configuration and start the Listener
Listener process can be activated under the “Services”
Enabling Other Computers to Access Oracle Server
Select locally managed or Dictionary managed extents
Manage data files using Oracle Enterprise Manager (OEM)
Manage redo log files & groups using Oracle Enterprise Manager (OEM)
Complete users management using Oracle Enterprise Manager
Oracle Instance management using Oracle Enterprise Manger
Memory tab gives you full control over Oracle Instance memory architecture components
Oracle Enterprise Manger -A SQL-Less DB Mgmt Software
User-Managed Complete Recovery in NOARCHIVELOG Mode
User-Managed Complete Recovery in ARCHIVELOG Mode
Difference between Recovery in ARCHIVELOG mode & NOARCHIVELOG mode
Share with others: