EL CENTRO COLLEGE

DIVISION OF BUSINESS/PUBLIC SERVICE/ INFORMATION TECHNOLOGY FALL, 2011

CLASS NUMBER/NAME: ITSE 2358 ORACLE DATABASE ADMINISTRATOR II

SECTION NUMBER: CLASS DAYS/HOURS:

5420/9000 MTWRFSU, TBA

ROOM NUMBER:

ONLINE

COURSE PREREQUISITE: ITSE 2356 OR INSTRUCTOR APPROVAL BASIC SKILLS REQUIREMENTS: READING

INSTRUCTOR: EMAIL: OFFICE: PHONE: LAB HOURS:

MS. JANET WARD [email protected] A422 (214) 860-2739 POSTED IN COMPUTER CENTER A435 AND ECAMPUS

Student Online Course Expectations This course is taught entirely online in an asynchronous format with the opportunity to participate in synchronous chat sessions. Your participation (through the discussion postings and chat involvement) is essential to achieve maximum reflection and interactivity with other members of the online learning community. The following represent expectations for online learners: y Orientation (Prior to Beginning of Class) 1. Schedule an orientation with instructor prior to beginning the course or view the following online orientations: http://www.elcentrocollege.edu/library/guides/videos/ecampus.html 2. Log into their course or courses during the first week. 3. Take a tour of the e-Campus course site to get acquainted with the course. 4. Update personal information on e-Campus. 5. Review thoroughly the course syllabus and outline. 6. Have a valid e-mail address. 7. Purchase textbooks, materials etc. 8. Visit the ECC Distance Learning site, http://www.elcentrocollege.edu/Program/IT/Distance/ Online Learning Environment 1. Complete readings and lab assignments as outlined in the course syllabus for meeting evaluation criteria. 2. Submit reading and lab assignments as outlined in the course calendar. 3. Complete lab objectives and skill exams as outlined in the course calendar. 4. Submit all assignments using the assignment feature to the instructor by the due date. Check the calendar or assignment page of the course for due dates. 5. Receive one opportunity to revise the assignment if the instructor determines the assignment is not comprehensively addressed or requires clarification of writing. 6. Use basic netiquette. This means respectful in your postings using good grammar, spelling, and proper capitalization. Online Attendance (Course Requirements) 1. Learners are required to take an active role in each class and graded upon the following: a. Login to e-Campus at least three times a week. Course statistics will be tracked to find out when and where you visited. Online presentations of lectures must be accessed each week. This will be tracked and counted as part of your attendance and included as part of your attendance grade. b. Participate in weekly online discussion of specific topic. Check to be sure your discussion is posted and reload if necessary. c. Email the instructor once a week to ask any questions regarding assignments, reading materials, etc. If there are no questions, learners are still required to email the instructor to indicate that there are no problems. d. Post an introduction to the discussion section in their first week of class including their name, the number of computer courses completed, their

employment history, and their goals for this course. This will help us get to know one another. e. Complete and discuss with classmates their learning styles inventory provided in the online course. Virtual/Regular Lab Hours 1. Learners are required to: a. View and adhere to the instructors virtual/regular lab hours and the semester schedule posted on e-campus, outside the instructors office, and in the Computer Lab (A435). b. E-mail the instructor to schedule an appointment for one-on-one instruction if virtual/regular lab hours conflict with instructor or student schedule. 2. Access the instructor by telephone or e-mail, as posted on e-Campus and the semester schedule as well as the course syllabus. Instructor Expectations 1. Contact student within 2 days of the start of the class. 2. Respond to e-mails within 48-72 hours from time of posting. 3. Provide and Post a Course calendar. 4. Grade and post assignments within a week of submission. 5. Provide feedback on how you are doing in the course through e-Campus gradebook and comments on assignments.

ITSE 2358 ORACLE DATABASE ADMINISTRATION II FALL, 2011

COURSE DESCRIPTION Prerequisites: ITSE2356 Oracle Database Administration I or instructorapproval. This is the third course leading to preparation for the Oracle 11g Certification. The class is a continuation of Oracle Database Administration I. Topics include recovery procedures, logical backups, standby database capabilities and performance tuning of the Oracle Server. Common performance problems and the use of diagnostics tools to troubleshoot and optimize throughput will be discussed. This course may be repeated if topics and learning outcomes vary. This is a 3 credit hour course. (2 lec., 4 lab.) WECM END-OF-COURSE OUTCOMES: List the Oracle backup and recovery components; formulate a backup and recovery strategy; practice backup and recovery operations; use Oracle tools to diagnose performance problems; and optimize and troubleshoot Oracle database performance. STUDENT LEARNING OUTCOMES: By the end of ITSE 2358 Oracle Database Administration II, students will be able to: y y Acquire higher level database administration skills and knowledge needed to advance their careers. Evaluate database performance utilizing tools and advanced features of Oracle including backup and recovery, problem diagnosis, block corruption, resource, space, memory and storage management and globalization support. Reinforce skills by using Oracle tools to optimize and troubleshoot Oracle database performance and formulate a backup and recovery strategy based on assignment criteria. Demonstrate advanced knowledge of database administration needed to pass the Oracle Database Administration II certification exam by practicing backup and recovery operations, utilize diagnostic tools to recover from user errors, log and trace files and employ the Oracle Listener.

y y

COURSE MATERIALS Textbook: Exam 1Z0-053 Guide: OCP Oracle Database 11g Administration Exam Guide, OBryla, Bob, Oracle Press, Copyright 2009 by The McGraw-Hill Companies, Inc., (ISBN# 978-0-07-164379-5) PDF copy available in eCampus. .

Email address (i.e. ECC Webmail, Yahoo, Hotmail, etc.)

This is an online class. All course work will be posted on eCampus. It is your responsibility to get the course notes, handouts, and laboratory assignments from eCampus. Your instructor will respond to all emails within 24 hours. FINANCIAL AID STATEMENT Students who are receiving any form of financial aid should check with the Financial Aid Office prior to withdrawing from classes. Withdrawals may affect your eligibility to receive further aid and could cause you to be in a position of repayment for the current semester. Students who fail to attend or participate after the drop date are also subject to this policy. DROP PROCEDURE/ATTENDANCE If you are unable to complete the course or courses for which you have registered, it is your responsibility to withdraw formally from the course. You need to speak with and obtain the signature of the course instructor to drop the course. If the instructor is not available, a counselor, advisor, or dean may sign the drop form. Failure to drop will result in a performance grade, usually a grade of "F." If you drop a class or withdraw from the college before the official drop/withdrawal deadline, you will receive a W (Withdraw) in each class dropped. For more information about drop deadlines, refer to the current printed Credit Class Schedule, contact the Admissions office at 214860-2484 (A169), or contact the division office. THE LAST DAY TO DROP BY 7 P.M. IS TUESDAY, NOVEMBER 17, 2011. Students sometimes drop courses when help is available that would enable them to continue. I hope you will discuss your plans with me if you do feel the need to withdraw. STOP BEFORE YOU DROP For students who enrolled in college level courses for the first time in the fall of 2007, Texas Education Code 51.907 limits the number of courses a student may drop. You may drop no more than six (6) courses during your entire undergraduate career, unless the drop qualifies as an exception. Your campus counseling/advising center will give you more information on the allowable exceptions. Remember that once you have accumulated six non-exempt drops, you cannot drop any other courses with a W. Therefore, please exercise caution when dropping courses in any Texas public institution of higher learning, including all seven of the Dallas County Community Colleges. For more information, you may access https://www1.dcccd.edu/6drop.

REPEATING A COURSE

Effective for Fall Semester 2005, the Dallas County Community Colleges will charge additional tuition to students registering the third or subsequent time for a course. All third and subsequent attempts of the majority of credit and Continuing Education/Workforce Training courses will result in additional tuition to be charged. Developmental Studies and some other courses will not be charged a higher tuition rate. Third attempts include courses taken at any of the Dallas County Community Colleges since the Fall 2002 Semester. See Third Attempt to Enroll in a Course at http://www.dcccd.edu/thirdcourseattempt/ ACADEMIC ETHICS Any violation of the Student Code of Conduct (as printed in the El Centro College Catalog and available at http://www1.dcccd.edu/catalog/about/standard.cfm) will be penalized accordingly. All matters of academic dishonesty (plagiarism, collusion, fabrication, cheating, etc.) will result in a failing grade for the assignment in question. All violations will be forwarded to the proper college authorities for review. The college may, at its discretion, impose additional penalties on the student including academic probation, suspension, or expulsion. ANY form of disruptive behavior will not be tolerated. COMPUTATION OF FINAL GRADE Student progress will be evaluated by the following means: Attendance/Participation 15Lesson Hands-One Assignments Case Study 15Lesson Quizzes averaged together give you one exam grade Midterm Exam Selftest Final Exam Final Grade 45 pts 1500 pts 100 pts 875 pts 10% 40% 10% 40% Grade Evaluation: A= 90-100 B= 80-89 C= 70-79 D= 60-69 F= 59-Below APROX PTS 2720-2448 pts 2447-2176 pts 2175-1904 pts 1903-1632 pts 1631-0 pts

100 pts 100 pts 2720 pts

100%

Note: There will be 15Lesson quizzes, a midterm and the final. The textbook, lab exercises and the project review material are possible sources for tests. Because we are preparing students to pass an industry-recognized standard with the Oracle Certification, the ability to produce hands-on work quickly and efficiently is critical. There will be benchmarks to aid you in completing assignments in a timely manner. CONTINUING EDUCATION STUDENTS MUST COMPLETE ALL LABS, HANDS-ON, QUIZZES, CASE STUDY AND EXAMS IN ORDER TO RECEIVE A CEU AWARD. Grading Scale for ITSE-2358 Lab Work All work is to be turned in to the lab assignment area in

eCampus. No homework will be accepted that is not in this format. The file must be submitted to the instructor no later than the scheduled due date. Partial credit will be issued for labs. Labs may not be repeated. All lab work must be completed by Thursday December 15, 2011 at 5 p.m. There is no specific lab time assigned for this class. There is no support for Oracle other than your instructors lab time. Refer to your instructors lab schedule for the posted lab times. Plan to spend at least four hours per week working on lab assignments. Your instructor is providing a suggested completion date for submission of all labs assignments, and test dates. In the event of unforeseen circumstances, some assignments may change. The student will be notified in lecture of any changes in assignments or due dates. In order to insure that you have the correct assignments and due dates, it is your responsibility to consult with your instructor if you are absent from lecture. Preparing for Examinations View lecture on eCampus and read the Lessons. Complete the fourteen end of Lesson quizzes. They are worth 875 credit points and count as one exam grade. All exam questions are taken directly from Lesson quizzes. INCOMPLETE GRADE STATEMENT Incomplete grades are given only in case of extreme emergency and at least 50% of the course requirements must have been completed. Request for an incomplete grade must be justified through a written statement and presented before the drop date to your instructor who will decide if your request can be approved. COMPUTER CENTER HOURS OF OPERATION The El Centro Computer Center, Room A435, is open to all students from: 8:00 a.m. to 9:00 p.m. Monday through Thursday 8:00 a.m. to 5:00 p.m. Friday 8:00 a.m. to 1:00 p.m. Saturday CLOSED. Sunday Room A431 is open to all students from: 5:00 p.m. 9:00 p.m. Friday

WE DO NOT PROVIDE TUTORING SERVICES IN THE 4TH FLOORCOMPUTERCENTER. GRIEVANCE PROCEDURES Students are expected to follow established procedures of the appropriate division in handling academic issues, such as grade appeals. El CentroCollege requires that other complaints and disputes (that cannot be resolved by the persons directly involved) be referred initially to the Ombudsman Office for informal, confidential resolution. Additional grievance procedures and the Student Code of

conduct are outlined in the El Centro College Catalog, available in hard copy in advisement or on the web at www.elcentrocollege.edu. RELIGIOUS HOLY DAYS STATEMENT A student who is absent from classes for the observance of a religious holy day shall be allowed to take an examination or complete an assignment scheduled for that day within a reasonable time after the absence if, not later than the fifteenth day after the first day of the semester, the student notified the instructor of each class scheduled on the date that the student would be absent for a religious holy day. A religious holy day means a holy day observed by a religion whose places of worship are exempt from property taxation under Section 11.20, Tax Code. The notice shall be in writing and shall be delivered by the student personally to the instructor, with receipt acknowledged and dated by the instructor or by certified mail, return receipt requested, addressed to the instructor. A student who is excused under this section may not be penalized for the absence, but the instructor may appropriately respond if the student fails to satisfactorily complete the assignment or examination. CHILDREN ON CAMPUS El CentroCollege strives to protect an environment most conducive to teaching and learning for all enrolled students. Minor children may not be brought to classrooms, labs, testing areas or study areas of the college. This practice is disruptive to the learning process. Children who are taking part in organized scheduled activities, or who are enrolled in specific classes, are welcomed. For reasons of security and child welfare, the college will not permit unattended children to be left anywhere on the premises. Students/Parents who have problems with childcare should visit the advisement/counseling center or the AdultResourceCenter to receive referrals to childcare services in the area. COMPUTER USE POLICY This class will not require you to utilize campus computers. If you need to use the campus computers, please see the computer use policy for the district under the student code of conduct at https://www1.dcccd.edu/cat0910/ss/computer.cfm?loc=DCCCD SOFTWARE COPYING POLICY Copying computer software without the expressed written permission of the copyright holder may be unlawful and subject to civil and criminal penalties. To protect you, the college and the copyright holder. DISABILITY ACCOMMODATIONS Any student who may need accommodations due to a disability and/or special needs should contact the Disability Services Office, Room A110, phone number (214) 860-2411. (Voice/TTY), visit A110, or go to http://www.elcentrocollege.edu/Student_Services/Disability/ CAMPUS EMERGENCY OPERATION PLAN

El Centro College and the Dallas County Community College District have developed policies and procedures for dealing with emergencies that may occur on campus. To familiarize yourself with these procedures, please take time to watch the overview video: http://video.dcccd.edu/rtv/DO/emergency_dcccd.wmv Why Should You Seek ORACLE Certification? The need for Oracle technical professionals has never been so great. Oracles own certification program recently grew by 100 percent in just eight months and continues to grow at an incredible pace. Even with all these new OCP members, businesses using Oracle technologies still have a large amount of open job orders for OCPs. There just are not enough OCPs! What this really means is that should you choose to earn an Oracle certification, your opportunities will increase greatly, and recent metrics support this. A study published by Computer World magazine found that of all the IT skills that are most highly sought after, Oracle was on top with an astounding 24 percent of IT managers surveyed stating that they had open jobs for Oracle professionals. An additional 10 percent stated that they also had needs for database administration expertise in a variety of areas, including Oracle.

Oracle Certification Program

Oracle Database 11g Administrator Oracle Database 11g is Oracles largest introduction of new functionality and is Oracles most innovative release, leading the database industry into new ground in clustering, automation, high availability and more. Oracle Database 11g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industrys most advanced database management system.

http://www.certmag.com/ This site will have up to date salary information in the next couple of months so check it out often. Lecture, Laboratory, and Examination Schedule The lecture, laboratory, and examination schedule is shown on the next page. You are expected to read each assigned project prior to the lecture. Lectures will be short, to the point, and will discuss

the highlights of the Project for that week. Most of the class time will be spent working on your Laboratory assignments. COURSE OUTLINE These dates may vary slightly; however, this outline provides you with target dates so that you can plan your semester to meet assignment deadlines. A more detailed lab assignment sheet follows. The instructor may alter this course outline at any time due to time constraints, loss of school days, or unforeseen problems with computer equipment, labs, etc. ITSE 2358 ORACLE DATABASE ADMINISTRATION II Reading/Lab Assignments Outline Week Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14 Week 15 Week 15 December 15 Lesson 1 Database Architecture and ASM 2 Configuring Database Recoverability 3 Creating and Maintaining an RMAN Catalog 4 Creating RMAN Backups 5 Recovering Using RMAN Backups 215 6 User-Managed Backup and Recovery 7 Miscellaneous RMAN Features 8 Monitoring and Tuning RMAN Midterm Exam 9 Configuring and Using Flashback 10 Memory Management Techniques 11 Using Database Tuning Advisors 12 Disk Space and Resource Management 13 Configuring Database Diagnostics 14 Using the Scheduler for Task Automation 15 Database Globalization Final Exam Pages 1 67 105 159 215 261 311 343 369 427 457 491 555 593 635

10

COURSE OUTCOME: The student will be able to list the Oracle backup and recovery components; formulate a backup and recovery strategy; practice backup and recovery operations; use Oracle tools to diagnose performance problems; and optimize and troubleshoot Oracle database performance. LEARNING OUTCOMES EVALUATION Classroom Procedure and Outcome Lesson 1 Database Architecture and ASM 2A, 3A, 4C, 6A, 6B, 6D, 7D Understanding Database Architecture Individual Projects and ASM 2A, 3D, 5A, 5B, 6A, 6D, 7A Describe ASM Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Set Up Initialization Parameter Files for Individual Projects ASM and Database Instances 2A, 3D, 5A, 5B, 6A, 6D, 7A Start Up and Shut Down ASM Instances Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Administer ASM Disk Groups Individual Projects Lesson 2 Configuring Database Recoverability 3C, 5A, 3D, 6A, 7A Configuring for Database Recoverability Individual Projects 3A, 5B, 5C, 6A, 7D, 7E, 7F Configure Multiple Archive Log File Individual Projects Destinations to Increase Availability 3A, 5B, 5C, 6A, 7D, 7E, 7F Define, Apply, and Use a Retention Policy Individual Projects 3A, 5B, 5C, 6A, 7D, 7E, 7F Configure the Flash Recovery Area Use Individual Projects the Flash Recovery Area Lesson 3 Creating and Maintaining an RMAN Catalog 3C, 5A, 3D, 6A, 7A Identify Situations that Require RMAN Individual Projects Recovery Catalog 3A, 3B, 3C, 3D, 4B, 5B, 6A, Create and Configure a Recovery Individual Projects 6B, 6C, 6E, 7A, 7B, 7C, 7D, Catalog 2A, 3D, 5A, 5B, 6A, 6D, 7A Synchronize the Recovery Catalog Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Create and Use RMAN Stored Scripts Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Back Up the Recovery Catalog Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Create and Use a Virtual Private Catalog Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Configure Backup Settings Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Allocate Channels to Use in Backing Up Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Configure Backup Optimization Individual Projects Lesson 4 Creating RMAN Backups 3C, 5A, 3D, 6A, 7A Using RMAN to Create Backups Individual Projects 3B, 3C, 3D, 5A, 5B, 6A, 7D, Create Image File Backups Individual Projects 3A, 3B, 3C, 3D, 4B, 5B, 7A, Create a Whole Database Backup Individual Projects 3A, 3D, 5B, 6A, 7D, 7E, 7F Enable Fast Incremental Backup Individual Projects 3A, 3D, 5B, 6A, 7D, 7E, 7F Create Duplex Backup and Back Up Individual Projects Backupsets 1C, 3A, 3B, 5A, 6A, 7A Create an Archival Backup for Long-term Individual Projects Retention SCANS

11

SCANS 3A, 3B, 3C, 3D, 5B, 6C, 7D

LEARNING OUTCOMES EVALUATION Create a Multisection, Compressed, and Individual Projects Encrypted Backup 3A, 3B, 3C, 3D, 5B, 6C, 7D Report On and Maintain Backups Individual Projects Lesson 5 Recovering Using RMAN Backups 3A, 3B, 3C, 3D, 4B, 5B, 7A Perform Complete Recovery from a Individual Projects Critical or Noncritical Data File Loss Using RMAN 3A, 3B, 3C, D, 4A, 4B, 4C, Perform Incomplete Recovery Using Individual Projects RMAN 2A, 3A, 3B, 3C, D, 4A, 4B Recover Using Incrementally Updated Individual Projects Backups 3A, 3B, 3C, 3D, 5B, 6C, 7D Switch to Image Copies for Fast Individual Projects Recovery 2A, 3B, 3C, 3D, 6A Restore a Database onto a New Host Individual Projects 3A, 5B, 5C, 6A, 7D, 7E, 7F Recover Using a Backup Control File Individual Projects 3A, 5B, 5C, 6A, 7D, 7E, 7F Perform Disaster Recovery Individual Projects Lesson 6 User-Managed Backup and Recovery 3A, 3D, 5B, 6A, 7D, 7E, 7F Recover from a Lost Tempfile Individual Projects 1C, 3A, 3B, 5A, 6A, 7A Recover from a Lost Redo Log Group Individual Projects 3A, 5B, 5C, 6A, 7D, 7E, 7 Recover from the Loss of the Password Individual Projects File 3A, 5B, 5C, 6A, 7D, 7E, 7F Perform User-Managed Complete Individual Projects Database RecoveryF 3A, 5B, 5C, 6A, 7D, 7E, 7F Perform User-Managed Incomplete Individual Projects Database Recovery 3A, 5B, 5C, 6A, 7D, 7E, 7F Perform User-Managed and ServerIndividual Projects Managed Backups 3A, 5B, 5C, 6A, 7D, 7E, 7F Identify the Need for Backup Mode Individual Projects 3A, 5B, 5C, 6A, 7D, 7E, 7F Back up and Recover a Control File Individual Projects Lesson 7 Miscellaneous RMAN Features 3C, 5A, 3D, 6A, 7A Creating a Duplicate Database Using Individual Projects RMAN 1A, 3B, 7B, 7E, 8A, 8D Using a Duplicate Database Individual Project 1C, 3B, 3D, 4A, 8A, 8D Identify the Situations that Require Individual Project TSPITR 2A, 3A, 4C, 6A, 6B, 6D, 7D Perform Automated TSPITR Individual Project Lesson 8 Monitoring and Tuning RMAN 3C, 5A, 3D, 6A, 7A Monitoring RMAN Sessions and Jobs Individual Projects 3A, 5B, 5C, 6A, 7D, 7E, 7F Tuning RMAN Individual Projects 2A, 3B, 3C, 3D, 6A Configure RMAN for Asynchronous I/O Individual Projects Lesson 9 Configuring and Using Flashback 3C, 5A, 3D, 6A, 7A Restore Dropped Tables from the Recycle Discussion Board Bin

12

SCANS 2A, 3D, 5A, 5B, 6A, 6D, 7A 2A, 3D, 5A, 5B, 6A, 6D, 7A 2A, 3D, 5A, 5B, 6A, 6D, 7A 2A, 3D, 5A, 5B, 6A, 6D, 7A 2A, 3D, 5A, 5B, 6A, 6D, 7A

LEARNING OUTCOMES EVALUATION Perform Flashback Query Individual Projects Use Flashback Transaction Individual Projects Perform Flashback Table Operations Individual Projects Set Up and Use a Flashback Data Archive Individual Projects Configure, Monitor Flashback Database Individual Projects and Perform Flashback Database Operations Lesson 10 Memory Management Techniques 3A, 3B, 3C, 3D, 4B, 5B, 7A Implement Automatic Memory Individual Projects Management 3A, 3B, 3C, 3D, 4B, 4C, 5B, Manually Configure SGA Parameters Individual Projects 3A, 3B,3C, 4C,5A,5C,6A, Configure Automatic PGA Memory Individual Projects Management Lesson 11 Using Database Tuning Advisors 3A, 3B, 3C, 3D, 4B, 5B, 7A Use the SQL Tuning Advisor Individual Projects 3A, 3D, 5B, 6A, 7D, 7E, 7F Use the SQL Access Advisor to Tune a Individual Projects Workload 1C, 3A, 3B, 5A, 6A, 7A Understand Database Replay Individual Projects Lesson 12 Disk Space and Resource Management 3A, 3B, 3C, 3D, 4B, 5B, 7A Manage Resumable Space Allocation Individual Projects 2A, 3D, 5A, 5B, 6A, 6D, 7A Describe the Concepts of Transportable Individual Projects Tablespaces and Databases 2A, 3D, 5A, 5B, 6A, 6D, 7A Reclaim Wasted Space from Tables and Individual Projects Indexes by Using the Segment Shrink Functionality 2A, 3D, 5A, 5B, 6A, 6D, 7A Understand the Database Resource Individual Projects Manager 2A, 3D, 5A, 5B, 6A, 6D, 7A Create and Use Database Resource Individual Projects Manager Components Lesson 13 Configuring Database Diagnostics 3C, 5A, 3D, 6A, 7A Set Up Automatic Diagnostic Repository Individual Projects 3A, 3B, 3C, 3D, 4B, 5B, 6A, Using Support Workbench Individual Projects 3B, 3D, 6A, 7E, 7F Perform Block Media Recovery Individual Projects Lesson 14 Using the Scheduler for Task Automation 3A, 3B, 3C, 3D, 4B, 5B, 7A Create a Job, Program, and Schedule Individual Projects 3B, 3C, 3D, 5A, 5B, 6A, 7D, Use a Time-based or Event-based Individual Projects 7F Schedule for Executing Scheduler Jobs Instructor Observation 1C, 3A, 3B, 5A, 6A, 7A Create Lightweight Jobs Individual Projects 3A, 3B, 3C, 3D, 5B, 6C, 7D Use Job Chains to Perform a Series of Individual Projects Related Tasks 3A, 3B, 3C, 3D, 4B, 5B, Create Windows and Job Classes Individual Projects 3A, 3B, 3C, 3D, 4B, 5B, Use Advanced Scheduler Concepts to Individual Projects 6A, Prioritize Jobs

13

LEARNING OUTCOMES EVALUATION Lesson 15 -- Database Globalization 3A, 3B, 3C, 3D, 4B, 5B, 6A, Customize Language-Dependent Individual Projects Behavior for the Database and Individual Sessions 3A, 3B, 3C, 3D, 4B, 5B, 6A, Work with Database and NLS Character Individual Projects Sets

SCANS

14

Accessing eCampus (Accessing your course on the internet - Students)

To Login y Start your internet browser (you need Firefox 3.5 (preferred) or Internet Explorer 7 or 8(in compatibility mode) y Go to http://ecampus.dcccd.edu/ y Input your student ID number with an e in front of student ID number. This is the Username. (ie. e1253407) y Tab over to the Password slot y Input your student ID number with an e in front of the student ID number. This is used for the Password also (ie. e1253407). y Click on the Login button This will get you to your Homepage tab on eCampus called "My DCCCD". Under the Tools area, you can check your grades for your eCampus courses, read the course announcements, send email to your instructor, change your password, input your email address and your personal information on eCampus. To Access Your Course: y Click on the Courses Tab or y Click on the underlined title of your course You may then click on the tabs on the left side of your screen to access specific areas within your course. To Input Your E-mail Address y Click on the Personal Information (in the Tools area) y Input your E-mail address y Scroll down to the bottom and click Submit (on the bottom left side of your screen) To Change Your Password y Click on the Personal Information (in the Tools area) y Click on Change Password y Input your new password y Input the new password again to confirm it y Click Submit (on the bottom left side of your screen) Once you change your password, you will have to use your new password to login in the future. To Check Your Grades y Click on My Grades (in the Tools area) y Then click on underlined title of the course To E-mail Your Instructor (or Classmate) y Click Send E-mail (in the Tools area) y Select the appropriate course y Select one of the options that are listed (e.g. All Instructors, Select Users, All Groups, etc.) y Type in the Subject and the message y Select Add if you want to add alternates, Click Browser button, Locate file to be attached. y Scroll down and click Submit If you have any questions or need assistance, you may contact email the Tech Support [email protected] or call (972)669-6402.

EL CENTRO COLLEGE COMPUTER CENTER, ROOM A435 LAB RULES FOR ALL ECC FACULTY, STAFF & CURRENTLY ENROLLED STUDENTS

General Rules
1. 2. 3. 4. 5. 6. Food, drinks and the use of cellular phones, or web phones will notbe permitted in the lab. Children may not be present in the lab at anytime. Computer gamesare not to be played on the computers. Walkmans, CD/MP3 players, radios, or music CDs are permitted, but must be used with headphones, ear buds, etc. and cannot be heard by the next person in the area you are seating in. If you cant abide, you will be asked to leave. No downloading of music or playing musical tones from websites. No personal software may be installed or downloadedfrom the Internet onto the hard drive of the computer by faculty, staff or students.

Lab Specific Rules

1. 2. 3. 4. 5. 6. 7. During peak times of the day, there is an enforceable computer usage time limit. Internet usage will be limited to a 15-minute session. Ask one of the lab assistants for further clarification. Files may not be saved to the hard drive. Software that comes with student books may not be downloaded onto the computer. (Advanced level CIT students only) Configuration files may be modified only in the presence of your instructor on designated computers. Hardware components may be exchanged only by authorized lab personnel. Internet users are not to leave set bookmarks at the end of each individual session. In order to print, you must have a print account with your 7-digit student/faculty/staff ID number, a 4 digit numerical password, and at least $1 in paper currency at the Add Value Station station at front of Computer Center. There is a $.10 charge to print or photocopy in black & white and there is a $.50 charge to print or photocopy in color. See lab personnel should you have questions.

Check-in and out at Front Counter/Sign-on and out procedures with AccuTrack on computers
1. All students are required to provide his/her current student ID throughout the entire semester. If you should lose or misplace your student ID, a copy of your paid fee receipt can be obtained from the Cashier's Window on the second floor of Building A, window A244, or Admissions, A158, on the first floor of Building A. This will be acceptable for that visit only and with proper photo ID. Your student ID can be made for you in the SPAR office, B270, second floor of Building B. All faculty and staff members wanting to use a computer must provide his/her staff ID in order to be assigned a computer. It is recommended that you have a jump/flash drive or some other type of storage medium for saving your class assignments. At the computer you have been assigned, type in your 7-digit student ID number at the AccuTrack welcoming screen and press ENTER. Upon completing your computing session, click on START,SHUTDOWN, and RESTART to re-boot the computer. Prior to leaving the Computer Center, return the computer placard to the front counter.

2. 3. 4.

Service Provided by Lab Assistants (Identified by badges) 1. 2. 3. 4. 5. Explain how to properly sign-in to AccuTrack Explain printer and copier operations and re-stock paper for each Assist user with accessing software Solve minor software and hardware problems requiring further assistance Service reports of equipment malfunction

IMPORTANT REMINDERS: Lab assistants are not expected to know how to use all lab software or be familiar with you class assignments. Instructors should be consulted for assignment content questions and associated problems.

El Centro College Scans Statement What Are Scans Skills?

These are the skills that employers need the most from their workers. SCANS skills are the predictors in the workplace.
Who Defined these Skills? In 1989, the U.S. Departments of Labor and Education jointly surveyed U.S. employers to find out the most important skills and competencies needed by workers. The results of the survey identified SCANS (Secretarys Commission on Achieving Necessary Skills). ECC Students and SCANS

El CentroCollege is committed to the preparation of our students for success in the workplace.
All El CentroCollege courses provide learning outcomes which result in the mastery of SCANS skills. Although each course will not include every SCANS skill, each course syllabus will identify the specific SCANS skills and competencies taught in that course. Throughout a formal program of study (Certificate, Degree or Transfer Program) a student will have the opportunity to master all SCANS skills and competencies.

SCANS Workplace Competencies 1 Managing Resources 1.a. Manage Time 1.b. Manage Money 1.c. Manage Materials 1.d Manage Space 1.e. Manage Human Resources 2 Interpersonal Skills 2.a. Work on Teams 2.b. Teach Others 3 Information Skills 3.a. Acquire and evaluate data 3.b. Organize and maintain data 3.c. Interpret and Communicate data 3.d. Process data with computer 4 Systems Knowledge 4.a. Work in social systems 4.b. Work in technological systems 4.c. Monitor and correct systems 4.d. Design and improve systems 5 Using Technology 5.a. Select equipment and tools 5.b. Apply technology to tasks 5.c. Maintain and troubleshoot technologies

2.c. Serve Customers 2.d. Lead Others 2.e. Negotiate Conflict 2.f. Work with Diversity

SCANS Foundation Skills 6 Basic Skills 6.a. 6.b. 6.c. 6.d. 6.e. Reading Writing Arithmetic/Math Speaking Listening 7 Thinking Skills 7.a. Creative thinking 7.b. Decision making 7.c. Problem Solving 7.d. Thinking logically 7.e. Seeing things in the minds eye 7.f. Reasoning 8.a. 8.b. 8.c. 8.d. 8.e. 8 Personal Qualities Responsibility Self-esteem Sociability Self-Management Integrity