This course Covers the SQL Server database management system. In this advanced course, students will gain the knowledge and skills to install, configure and maintain SQL Server and manage the day-to-day administration of a client/server database in an enterprise network environment.

Basic Info:

• Instructor Name: Ali Asghary Karahroudy

• Instructor eMail: AKarahroudy@ccsf.edu

• Course code# CNIT 415

• Current Section# 79626-001

Student Learning Outcomes:

Upon completion of this course, a student will be able to:

1. Describe and demonstrate installation of SQL Server.

2. Identify and categorize the main components of SQL Server.

3. Differentiate the types of SQL Server objects.

4. Manage and configure SQL Server.

5. Select and apply appropriate levels of security in SQL server management.

6. Choose the tools required for import and export of data with SQL Server.

Course Requirements

Text Book:

Optional: Exam Ref 70-764 Administering a SQL Database Infrastructure ISBN-13: 978-1-5093-0383-0 find it at amazon.

Mandatory: Introducing Microsoft SQL Server 2016 ISBN: 978-1-5093-0195-9 (will be provided by Instructor through canvas course)

Accommodation

Those who are in need of accommodations should contact DSPS center (DISABLED STUDENTS PROGRAMS & SERVICES) to get their request processed. Do not forward your request directly to the instructor. If you need immediate assistance or need to make an appointment with a DSPS counselor, contact the DSPS main office at:

• 415-452-5481 (Voice)

• 415-452-5451 (Telecommunication Device for the Deaf) or use California Relay Service

• dspsacom@ccsf.edu

Review the Contact Information page for our locations and other phone numbers.

Evaluation

• Discussions - One original post and two responses per week are required. (10 points per week)

• Quizzes - Depending on the subject covered in each module, A quiz will follow ( between 10 to 60 points - non essay format)

• Lab/Activity - each module is followed by a Lab or activity ( 20 to 40 points based on the activity)

• There is no mid-term exam for this course

• Final Exam will be held at the last day of the course (400 points)

Extra Credit and Late work

• There are no Extra Credit activities offered in this course.

• Late work is NOT acceptable in this course.

Academic Integrity

True learning can take place only when students do their own work honestly, without copying from other students or other sources. CCSF enforces the highest standards of academic integrity, both to preserve the value of the education offered and to prepare students to become productive members of the workforce and society. At CCSF, it is considered a breach of academic honesty for students to employ any form of deception in the completion of academic work, including but not limited to:

• Copying work, ideas, or projects from any other person or media

• Allowing another person to copy or borrow original work in any form

• Allowing another person to copy answers on a quiz or test or to communicate with another person during a quiz or a test

• Representing the work of another team member as one’s own

• Stopping or delaying another student in the completion of any work

• Plagiarism in any form, including failing to give credit to the source of thoughts, words, ideas, or work from any other person, printed material, or website

When a violation of this policy occurs, disciplinary action will be taken. Subject to the severity of the violation or repeated/multiple occurrences, academic dishonesty may result in an “F” grade for an assignment, project, assessment, or the course itself, or may result in dismissal from the College. All violations of the Academic Integrity Policy are documented and made a permanent part of a student’s record. Further information is available from the Academic Affairs Department.

Software in use in the lab and printed resource materials are copyrighted with all rights reserved except when explicitly described as public domain. Under copyright laws, these items may not be copied, photocopied, reproduced or reduced to any electronic medium, in whole or in part. Any violation or attempt to violate copyright laws may result in disciplinary action.

Office Hours

Check Canvas for updated office hours.

Contents:

Overview of SQL Server and its main components

1. What is SQL Server

   1. SQL Server Services and Software

   2. SQL Server architecture

2. SQL Server environment

   1. SQL Server integration with Windows

   2. Configuration Management

3. Security and integrity issue

   1. SQL Server Security

   2. Login authentication

   3. Database user accounts

   4. Data validation rules

Types of SQL Server Objects

1. Database objects

   1. Master database

   2. msdb database

   3. Transaction log files

2. Metadata retrieval

Installing and configuring SQL Server

1. Minimum hardware and software requirements

2. Set up of SQL Server

   1. Licensing modes

   2. Installation path

   3. Character set and sort order

   4. Network Support

   5. SQL Server login account

3. Implementation

   1. Verifying installation

   2. Preparing to use SQL Server

   3. Troubleshooting

Managing security

1. Windows security

   1. Account policies

   2. Logins and passwords

   3. Account lockout

2. SQL Server security

   1. System administrator level security

   2. Database user level security

3. Database security

   1. Guest accounts

   2. Ownership rights

   3. Roles

4. Creating login accounts

Creating and managing database files

1. Database creation

   1. Tables.

   2. Database options

   3. Capacity planning

2. Database backup and restoration

3. When to backup databases

4. System and user database backup process

5. The recovery (restore) process

Administrative tasks

1. Introduction to SQL Server administration

2. Automating routine maintenance tasks

3. Creating jobs

   1. Verifying permissions

   2. Defining job steps

   3. Determining action flow logic for each job step

   4. Scheduling jobs

Transferring data

1. Introduction to importing and exporting data

   1. Reasons to import, export and transform data

   2. Tools for importing and exporting data

Replication

1. Introduction to distributed data

2. Introduction to SQL Server replication

   1. The publisher subscriber metaphor

   2. Filtering data

3. SQL Server Replication types

4. Managing and monitoring replication

5. Using replication scripts