Transcript IT 163

IT 456-01
System Administration
Dr Jeffrey A Robinson
Kaplan id – DrRobinson
Email – [email protected]
AIM ID – DrJARobinson
Office Hours 8-10 Saturday (MST)…
11am-1pm EDT
Admins stuff
Syllabus
Book
Software
Grading
Lateness
Plagiarism
Overview of Course
Week 1 – Introduction
Week 2 – Installation of SQL and management Tools
Week 3 - SQL Server Configuration and Internals
Week 4 - SQL Server Security
Week 5 - Data Transfer and Task Automation
Week 6 - Disaster Recovery
Week 7 - Performance Monitoring
Week 8 - Performance Optimization
Week 9 - High Availability
Issues
XP versus Vista versus System 7
The DBMS (MySQL vs SQLServer)
SQL Express vs Enterprise Version
ORACLE vs MicroSoft
Course Details – DOC SHARE Project details
Extended Readings (e-books, help online and
many web aids available)
Recommendations
Read Ahead
– The sooner the better
Ask lots of Questions
– What you learn is in direct proportion to the questions
you ask
Collaborate
– Share problems and successes with your classmates
on the DQ board
Experiment and Play
– Learn by Doing
Look it up on the Web
– Don’t trust a single source; look up different solutions
Don’t fall behind
– It is much harder to catch up than keep up
Unit 1 assignment
200–300 word - Discuss two of the four
areas of server hardware (memory,
processor, disk, or network).
– If you were choosing hardware for these
areas, for a high-end database server, what
factors would influence your decision about
the type and/or amount for each area?
Compare the relative importance of the two
areas you choose.
Unit 2 assignment
200–300 word - Describe the requirements
of MS SQL Server 2008 and the process
you must follow prior to the installation of
MS SQL Server 2008. (Hint - Before
installing MS SQL Server 2008 an
installation plan should be created…. )
Unit 2 assignment (cont)
Project – Install a default instance of SQL
Server 2008.
– a. For directions, see Chapter 1.
– b. Create the NWTraders Database using
instructions in the file in Doc Sharing called
"Create NWTraders Database
– c. Run the scripts from the file in DocSharing
called “Create NWTraders Objects and
Data.”
Next week
Installing SQL Server and management
tools (compare notes XP versus Vista
installations)