1 / 14

Database Administration

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

tavia
Download Presentation

Database Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Administration ITEC 450 Fall 2011 Instructor: Dr. Justin M. Wang

  2. Introduction of Week 1 • Course logistics • Course overview • Database technology • DBA’s role and classifications • DBA’s tasks • DBA career path ITEC 450

  3. 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

  4. 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

  5. Course Modules • DBA techniques and practices • Database installation and configuration: • Database management • Database tuning • Metadata, tools, and data warehousing ITEC 450

  6. 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

  7. Module 1 Database Administration Techniques and Practices Section I Database Administrator

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

More Related