Transcript Database Administration

DATABASE ADMINISTRATION
ITEC 450 Fall 2011
Instructor: Dr. Justin M. Wang
INTRODUCTION OF WEEK 1
Fall 2011
Course logistics
 Course overview
 Database technology
 DBA’s role and classifications
 DBA’s tasks
 DBA career path

ITEC 450
2
COURSE LOGISTICS

Instructor information: next page
Your information: Overview\Student Info Form
Materials




Mullins’ book – Database Administration
On-line documents – Oracle materials
Supplementary materials – Communications\Student
Union\Section Resources
Grading policy:



Submission: Drop Box by 11:59pm local time
Return : within a week from due date
Amended late policy:



ITEC 450

Fall 2011

Up to 1 week late: 10% deduction with approved excuse, 20% otherwise
More than 1 week late: 40% deduction
FranklinLive session structure


Lecture for 40 - 55 minutes, then Q&A
Recorded: if you can’t attend, review and write a summary
3
INSTRUCTOR - JUSTIN M. WANG
Fall 2011
Teach at Franklin
University over 10 years
 The Ohio State University,
Ph.D.

ITEC 450
Email:
[email protected]
 Home: 614-789-0329
 Work: 614-249-6270
 Course questions: Bulletin
Board (keep it structured)

4
COURSE MODULES
Fall 2011
DBA techniques and practices
 Database installation and configuration:
 Database management
 Database tuning
 Metadata, tools, and data warehousing

ITEC 450
5
COURSE OUTCOMES
Fall 2011
Database administration roles
 DBMS installation and physical database design
 Database connectivity (network), availability,
and security
 Database backup and recovery
 Database performance monitoring and
optimization
 Database administration hands-on experiences
and best practices

ITEC 450
6
MODULE 1
DATABASE ADMINISTRATION
TECHNIQUES AND PRACTICES
Section I Database Administrator
DATABASE TECHNOLOGY
Fall 2011
Database –organized store of data
 DBMS –database management system designed
to create, store, and manage databases, normally
including a Structured Query Language (SQL)
application programming interface
 SQL –Standard query language to access
database

ITEC 450
DDL -Commands to define or modify a database
structure, including creating, altering, and dropping
tables, indexes, constraints
 DML -Commands to modify and query database data

8
RDBMS TYPES AND VENDORS

RDBMS – DBMS that incorporates the relational data model.
Major DBMS and dominated platforms
 Oracle –Unix and Linux (75.8%)
 DB2 (IBM) – zSeries
 SQL Server (Microsoft) – Windows (38%)
 Other DBMS: Teradata, Sybase (SAP), Netezza, MySQL (Oracle),
Access
Market
Share (%)
DBMS
Oracle
DB2
SQL Server
2003
40.3
31.8
12.3
2004
41.3
30.6
13.4
2005
46.8
22.1
15.6
2006
47.1
21.1
17.4
2007
44.3
21.0
18.5
ITEC 450

Fall 2011

9
DATABASE ADMINISTRATOR (DBA)
ITEC 450
Focus on physical installation and performance
monitoring
 Remote DBA
Fall 2011
The DBA is responsible for designing and
maintaining an enterprise’s database
 System DBA (Production DBA) –DBMS focus,
rather than business



Application DBA (Development DBA) –database
design and ongoing support for a specific
application


An expert at writing and debugging complex SQL
Understand the best ways to incorporate database
requests into application programs
10
DATABASE ADMINISTRATION
Fall 2011
ITEC 450
Database logical design and physical
implementation
 Performance monitoring and tuning
 Database management and availability
 Database security and authorization
 Database backup and recovery
 Data integrity and loading

11
DBA CAREER PATH
DBA Certification

ITEC 450
Oracle Certified Professional (OCP)
 Microsoft Certified Database Administrator
(MCDBA)

Fall 2011

On-job development:
Database developer -> DBA
 Small company to perform all roles

12
ADDITIONAL LEARNING ON ORACLE

Types of Oracle Database Users


DBA, Application Developers, Database users
Common Oracle DBA Tasks


ITEC 450
Oracle Database Administrators Guide;
 Oracle Database 2 Day DBA

Fall 2011
Oracle – relational database
 Learning materials:

Install, create db and users, backup, implement, tune
Database Administrator Security and Privileges

Operating system, database (sys, system)
13
WRAP UP

SQL learning or reviewing
Assignment 1-3: FranklinLive! Session
Note: UNABLE to attend live
ITEC 450

Fall 2011
Assignment 1-1: Obtain a Proctor for Exams
 Assignment 1-2: SQL Review

Listen to recording
 Write a 1-page summary
 Submit in Drop Box by the end of the week

14