140 likes | 317 Views
Database Administration. ITEC 450 Fall 2011 Instructor: Dr. Justin M. Wang. Introduction of Week 1. Course logistics Course overview Database technology DBA’s role and classifications DBA’s tasks DBA career path. Course Logistics. Instructor information: next page
E N D
Database Administration ITEC 450 Fall 2011 Instructor: Dr. Justin M. Wang
Introduction of Week 1 • Course logistics • Course overview • Database technology • DBA’s role and classifications • DBA’s tasks • DBA career path ITEC 450
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: • 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 ITEC 450
Instructor - Justin M. Wang • Teach at Franklin University over 10 years • The Ohio State University, Ph.D. • Email: wangm@franklin.edu • Home: 614-789-0329 • Work: 614-249-6270 • Course questions: Bulletin Board (keep it structured) ITEC 450
Course Modules • DBA techniques and practices • Database installation and configuration: • Database management • Database tuning • Metadata, tools, and data warehousing ITEC 450
Course Outcomes • 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
Module 1 Database Administration Techniques and Practices Section I Database Administrator
Database Technology • 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 • 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 ITEC 450
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 (%) ITEC 450
Database Administrator (DBA) • The DBA is responsible for designing and maintaining an enterprise’s database • System DBA (Production DBA) –DBMS focus, rather than business • Focus on physical installation and performance monitoring • Remote DBA • 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 ITEC 450
Database Administration • 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 ITEC 450
DBA Career Path • DBA Certification • Oracle Certified Professional (OCP) • Microsoft Certified Database Administrator (MCDBA) • On-job development: • Database developer -> DBA • Small company to perform all roles ITEC 450
Additional Learning on Oracle • Oracle – relational database • Learning materials: • Oracle Database Administrators Guide; • Oracle Database 2 Day DBA • Types of Oracle Database Users • DBA, Application Developers, Database users • Common Oracle DBA Tasks • Install, create db and users, backup, implement, tune • Database Administrator Security and Privileges • Operating system, database (sys, system) ITEC 450
Wrap Up • Assignment 1-1: Obtain a Proctor for Exams • Assignment 1-2: SQL Review • SQL learning or reviewing • Assignment 1-3: FranklinLive! SessionNote: UNABLE to attend live • Listen to recording • Write a 1-page summary • Submit in Drop Box by the end of the week ITEC 450