1 / 14

Database Administration

Database Administration. ITEC 450 Fall 2012 Instructor: Dr. Rama Gudhe. Introduction of Week 1. Course overview Database technology DBA’s role and classifications DBA’s tasks DBA career path. Course Modules. DBA techniques and practices Database installation and configuration:

kiley
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 Fall2012 Instructor: Dr. Rama Gudhe

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

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

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

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

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

  7. Advantages of DBMS • Advantages of DBMS - Control of data redundancy - Economy of scale - Data consistency - Balance of conflicting requirements - More information from the same amount of data - Sharing of data - Improved data accessibility and responsiveness - Improved data integrity - Increased productivity - Improved security - Improved maintenance through data independence - Enforcement of standards - Increased concurrency - Improved backup and recovery services • Disadvantages of DBMS - Complexity, Size, Cost of DBMSs, Additional H/W costs - Cost of conversion, Performance, Higher impact of a failure ITEC 450

  8. RDBMS Types and Vendors • RDBMS – DBMS that incorporates the relational data model. • Major DBMS and dominated platforms • Oracle –Unix and Linux • DB2 (IBM) – zSeries and LUW • SQL Server (Microsoft) – Windows • Other DBMS: Teradata, Sybase, MySQL (Oracle), Access ITEC 450

  9. Database Administrator (DBA) • The DBA is responsible for designing and maintaining an enterprise’s database • A DBA ensures the ongoing operational functionality and efficiency of an organization's databases and applications. • A good DBA needs to enjoy challenges and be a good problem solver • 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

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

  11. Database Administration Functions • Selection of hardware and software • Installing/upgrading DBMS • Tuning database performance • Improving query processing performance • Managing data security, privacy, and integrity • Data backup and recovery ITEC 450

  12. Data Administration Functions • Data policies, procedures, standards • Planning • Data conflict (ownership) resolution • Internal marketing of DA concepts • Managing the data repository ITEC 450

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

  14. Additional Learning on Oracle • Oracle – relational database • Learning materials: • Oracle Database Administrators Guide; • Oracle Database 2 Day DBA • Types of Oracle Database Users • DBA, Data Administrators, 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

More Related