1 Outline DBA

DownLoad Link at the Last:

Youtube Video Link: 

pg. 1 University of Gujrat Department Information Technology Course Code: IT-445 Course Title: Database Administration Credit Hours: 3 Lecture Duration: 1.5 hours Pre-requisite: Database Systems Text Books: Oracle 10 g Hand-outs. Reference Books: Ruth Baylis. “Oracle Database Administrator’s Guide”, 10g Release, 2006. Instructor: Rai Jazib Raijazib5@gmail.com Course Introduction & Description: Oracle DBAs manage the industries most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. The lesson topics are reinforced with structured hands-on practices. Course Objectives: After completing this course, you should be able to do the following:  Identify various components of the Oracle architecture  Start up and shut down an Oracle database  Create an operational database  Manage Oracle control files, redo log files, datafiles, tablespaces, segments, extents, and blocks  Manage users, privileges, and resources Class Policies:  Attendance for lectures is compulsory. Attendance for less than 70% of the lectures will result in students being barred from taking the Final Exam.  If you are absent from the lecture due to: Sickness – Medical Certificate is required, in case of emergency – letter of guardian is required.  There will be no makeup quiz.  There will be no retake of mid now on.  Cheating and Plagiarism will not be tolerated and will be penalized accordingly.  There will be 4-7 assignments besides on class exercises. Assignments need to be submitted before the deadline. If you have questions or doubts contact us in our offices during visiting hours or use our email address. pg. 2 Course Outline: Week Topics description 01 Course Introduction:  Course Policies/Overview/Course Contents/Course Objectives  Introduction to DBA  Assignment 1 02 Oracle Architectural Components  Oracle Server  Oracle Instance  Establishing a Connection and Creating a Session  Oracle Database  Physical Structure  Memory Structure 03 Oracle Architectural Components  Components of Memory Structure  User Process  Server Process  Background Processes  Quiz 1 04 Managing an Oracle Instance  Initialization Parameter Files  PFILE initSID.ora  Creating a PFILE  PFILE Example  SPFILE spfileSID.ora  Creating an SPFILE  SPFILE Example  STARTUP Command Behavior  Modifying Parameters in SPFILE  Starting Up a Database NOMOUNT  Starting Up a Database MOUNT  Starting Up a Database OPEN  STARTUP Command 05 Managing an Oracle Instance  ALTER DATABASE Command  Opening a Database in Restricted Mode  Opening a Database in Read-Only Mode  Shutting Down the Database  Shutdown Options  Monitoring an Instance Using Diagnostic Files  Alert Log File  Background Trace Files  User Trace File  Enabling or Disabling User Tracing  Assignment 2 pg. 3 06 Managing Users  Users and Security  Database Schema  Checklist for Creating Users  Creating a New User: Database Authentication  Creating a New User: Operating System Authentication  Changing User Quota on Tablespaces  Dropping a User  Obtaining User Information 07 Managing Privileges  Managing Privileges  System Privileges  System Privileges: Examples  Granting System Privileges  SYSDBA and SYSOPER Privileges  System Privilege Restrictions  Revoking System Privileges  Revoking System Privileges with the ADMIN OPTION  Object Privileges  Granting Object Privileges  Revoking Object Privileges  Revoking Object Privileges WITH GRANT OPTION  Obtaining Privileges Information  Quiz 2 08 Managing Roles  Roles  Benefits of Roles  Creating Roles  Predefined Roles  Modifying Roles  Assigning Roles  Establishing Default Roles  Application Roles  Enabling and Disabling Roles  Revoking Roles from Users  Removing Roles  Guidelines for Creating Roles  Guidelines for Using Passwords and Default Roles  Obtaining Role Information  Assignment 3 09 Mid Term Week 10 Managing Tablespaces and Datafiles  Tablespaces and Datafiles  Types of Tablespaces  Creating Tablespaces  Space Management in Tablespaces  Locally Managed Tablespaces  Dictionary-Managed Tablespaces  Undo Tablespace  Temporary Tablespaces pg. 4  Default Temporary Tablespace  Creating a Default Temporary Tablespace  Restrictions on Default Temporary Tablespace 11 Managing Tablespaces and Datafiles  Read Only Tablespaces  Taking a Tablespace Offline  Changing Storage Settings  Resizing a Tablespace  Enabling Automatic Extension of Datafiles  Manually Resizing a Datafile  Adding Datafiles to a Tablespace  Methods for Moving Datafiles  Dropping Tablespaces  Managing Tablespaces Using OMF  Managing Tablespaces with OMF  Obtaining Tablespace Information  Quiz 3 12 Managing Tables  Storing User Data  Oracle Built-in Data Types  ROWID Format  Structure of a Row  Creating a Table  Creating a Table: Guidelines  Creating Temporary Tables 13 Managing Tables  Setting PCTFREE and PCTUSED  Row Migration and Chaining  Changing Storage and Block Utilization Parameters  Manually Allocating Extents  Nonpartitioned Table Reorganization  Truncating a Table  Dropping a Table  Dropping a Column  Using the UNUSED Option  Assignment 4 14 Maintaining Data Integrity  Data Integrity  Types of Constraints  Constraint States  Constraint Checking  Defining Constraints Immediate or Deferred  Primary and Unique Key Enforcement  Foreign Key Considerations  Defining Constraints While Creating a Table  Guidelines for Defining Constraints  Enabling Constraints  Using the EXCEPTIONS Table  Obtaining Constraint Information pg. 5 15 Presentations  Quiz 4 16 Presentations Final Examination Grading Policy: Important notes: 4-5 numbers of quizzes will take place in the class to measure the learning progress of the students. These quizzes will be announced or unannounced. Plagiarism Policy: During this course a strict no tolerance plagiarism policy will be adopted. While collaboration in this course is highly encouraged, you must ensure that you do claim other people’s work/idea as your own. Plagiarism occurs when the words, ideas, assertion, theories, figures, images, programming code of others is presented as your own work. Failing to comply with plagiarism policy will lead to strict penalties including zero marks in assignments. 1 Assignments 10% 2 Quizzes 5% 3 Presentations 10% 3 Mid term 25% 4 Final Exam 50%

Download Link:  

Click Here To Download Lecture 9