Advanced Database Programming Syllabus for 2018-2019
Return to Syllabus List

Instructor Information

Instructor

Rashmi Pillai (Curriculum Vitae)

E-Mail

rspillai@actx.edu

Phone

<p>(806) 371-5219</p>

Office Location

<p>R. E. Byrd Business Building 323 C</p>

Office Hours

(806) 337-2116 - Cell (Call or Text)

Monday: 11:30 am - 2:30 pm
Tuesday, Thursday: 4:30 pm - 5:30 pm
Wednesday and Friday - by appointment

 

Course Information

COVID-19 Protocols

Recording Policy

Disability Statement

If you have a disability (learning, mental, physical) that affects your ability to participate effectively and have access to any program or service at Amarillo College please contact Disability Services at (806) 345-5639 . Our offices are located in the Student Service Center office 112. More information may be found at www.actx.edu/disability.
Disability Services facilitates access to all programs and services according to the ADA, Americans with Disabilities Act and Section 504 of the Rehabilitation Act, as well as other federal and state laws.

Amarillo College Web Accessibility Policy Statement

Amarillo College is committed to providing equal access to all programs and services, including all working, learning, and service environments that affect equal access for persons with disabilities. This commitment to provide equal access and opportunity for persons with disabilities is in compliance with federal and state law. Amarillo College also strives to provide Electronic and Information Resources (EIR) that are accessible to all authorized users.

If you find you are unable to access material in an accessible format please contact the Disability Services Office at (806) 345-5639 . This office will work in conjunction with other campus resources to address and accommodate your issue in a timely manner.

Statement for Mental Health and Advocacy & Resource Center:

As a student you may experience a range of issues that can cause barriers to learning, such as strained relationships, increased anxiety, alcohol/drug problems, feeling down, difficulty concentrating and/or lack of motivation. These mental health concerns or stressful events may lead to diminished academic performance or reduce a student's ability to participate in daily activities. Amarillo College offers services to assist you with addressing these and other concerns you may be experiencing. If you or someone you know are suffering from any of the aforementioned conditions, you can learn more about the broad range of confidential mental health services available on campus by calling the AC Counseling Center at 806-371-5900. The AC Counseling Center website is https://www.actx.edu/counseling/ . Also, if you are in need of social services (affordable housing, utilities, transportation, food, clothing, childcare, medical/dental/vision, legal), please call the AC Advocacy & Resource Center at 806-371-5439. The AC Advocacy & Resource Center website is https://www.actx.edu/arc

Amarillo College Tutoring for Success Policy:

Administrative Drop Policy

Students who do not attend class on or prior to the census date will be administratively dropped. Effective Fall, 2016

Student Withdrawal Procedures

Students who wish to withdraw from a course must complete all steps indicated on the Academic Withdrawal Request form by the course withdrawal deadline.

NOTE: Students who are attending Texas institutions of higher education, for the first time fall 2007 and later, may not withdraw from more than six courses during their academic career. This withdrawal limitation does not include dual credit or developmental classes (Senate Bill 1231 Rule 4.10.) For more information on Drop and Withdrawal Policies, please visit the Registrar's Office Web site.

Privacy Statement

The Amarillo College Privacy Policy is found at https://www.actx.edu/-amarillo-college-privacy-notice , and applies to all Amarillo College students.  If you have questions about this privacy statement or you believe that your personal information has been released without your consent, send email to humanresources@actx.edu .

Course

ITSE-2347-001 Advanced Database Programming

Prerequisites

<p>Prerequisite: ITSE 2309 and COSC 1330 or COSC 1315</p>

Course Description

Database development using complex database programming techniques emphasizing multiple interrelated files, menu design, security implementation and multiple access.

Student ResourcesStudent Resources Website

Department Expectations

Occupational License Disclaimer

Notice to Students enrolled in an educational program for preparation of issuance of certain occupational licenses:

Students enrolled in an educational program in preparation for obtaining certain occupational licenses are potentially ineligible for such license if the student has been convicted of an offense. For further information, please contact:

Melodie Graves
Justice Involved Advocate
Student Service Center 117
mgraves24@actx.edu
806-371-5995
Make appointment at https://melodiegraves.youcanbook.me

You can also contact the Legal Clinic, or the faculty member in charge of the educational program that you seek to enroll in. The further information you will receive will include notification to you of your right to request a criminal history evaluation letter from the licensing authority in order to clarify your particular situation.

Hours

(3 sem hrs; 2 lec, 3 lab)

Class Type

Hybrid

Syllabus Information

Textbooks

 Microsoft-SQL-Server-2012-Bundle
Content Creator: uCertify
ISBN: 978-1-61691-378-6

The Microsoft-SQL-Server-2012-Bundle includes 70-461-complete & 70-462-complete
70-461 & 70-462 are Microsoft certification exams testing different modules in SQL Server
70-461 : Querying Microsoft Server 2012
70-462 : Administering Microsoft SQL Server 2012

** The access code for the bundle is available only through the bookstore.**


 

Supplies

  1. SQL Server Express 2014. This is a free download available online.
    Instructions & installation file will be made available in your Blackboard course shell

  2. Microsoft Visio 2016 (You can download this application via your Microsoft Imagine Account)
    You will not require this application until after 3rd week of class

  3. A USB flash drive

  4. Access to a PC (personal computer) running the Windows 7 (or above) operating system. Computers are available in the CIS Computer Lab on the 2nd Floor of the Byrd Business Building (Washington Street Campus, Amarillo College).

Student Performance

In this course, we will be learning the Structured Query Language (SQL) that is designed for managing data in the Relational DBMS environment. We will be using Transact-SQL (T-SQL) with Microsoft SQL Server. We will be learning how to install SQL Server, install SQL Server Databases, querying a SQL Server DB using T-SQL, create database objects. We will also be looking at tools that will help administer a SQL Server. In addition we will be revisiting the database concepts that we looked at in the Beginning database class - Relational Database Theory, Database Design Process, ERD, Normalization etc.
 

LEARNING OUTCOMES

-  Relational Database - theory,  defining concepts, establishing solid relationships

-  SQL Basics - SQL Statement types, basic SELECT statement, sorting & filtering, eliminating duplicate rows,using various types of expressions, NULL

-  Working with Multiple Tables - JOINs, UNIONs, Subqueries

-  Summarizing & Grouping Data

-  Modifying Sets of Data - using UPDATE, INSERT, DELETE statements

-  Advanced Query Techniques

- Installing SQL Server with default or named instance

- Creating SQL Server Databases

- Administering SQL Server 2012 Databases

- Creating Indexes & Views

- Creating Triggers & Stored Procedures

Students Rights and Responsibilities

Student Rights and Responsibilities

Log in using the AC Connect Portal

In order to receive your AC Connect Email, you must log in through AC Connect at https://acconnect.actx.edu .

If you are an active staff or faculty member according to Human Resources, use "Exchange". All other students, use "AC Connect (Google) Email".

Expected Student Behavior

Students are expected to maintain a high standard of individual honor in their scholastic work. Students who are guilty of cheating, plagiarism, copying, or dishonesty may be excluded from class with a grade of F; or, in flagrant cases, may be suspended from the College.
 
The faculty of the CIS Department reserves the right to ask a student to verify any portion of a test by reproducing any specific section or all of the test in question. Any action that compromises the computer systems at Amarillo College, including but not limited to hacking or cracking, can result in a grade of "F" in this course and possible further disciplinary action.

Grading Criteria

Course grades will be assigned based upon the following criteria:

>  89.5 = A
> 79.5  = B
> 69.5 =  C
> 59.5 =  D
< 59.5  = F
 

Student evaluation is based upon the following assignments and weights:

  1. Attendance.................................................10%

  2. Chapter Quiz & Exercises..........................15%

  3. Labs/Chapter Review.................................15%

  4. Assessment ...............................................20%

  5. Semester Project........................................15%

  6. Midterm.......................................................10%

  7. Final............................................................15%

Attendance

  • Check your email daily.  The email address used by your instructor is the @amarillocollege.com email issued to each AC student. Your instructor will communicate important course updates, guidance.
  • Complete assignments by the scheduled date/time.  There is a "no late work" policy, except in extreme circumstances.
  • Attendance  will be taken during each class period. Excessive absence or lack of participation may result in failure of the course.
  • Students should plan on spending a minimum of 7-10 hours per week on this course. Actual amounts will vary depending on weekly assignments and topic complexity.
  • Your instructor, Rashmi Pillai, may be contacted by email through the course in Blackboard. If Blackboard is not available, please email rspillai@actx.edu.  In-person meetings or additional help are available if needed or desired. Please contact by email to set up a convenient day/time.
  • Emails are typically answered within 24 hours. If you do not receive a response within that timeframe, please resend your message as a reminder.

Calendar

PS: This is a tentative outline which is subject to change if required

Week 1:
  • Introductions, Syllabus review,
  • Chapter 1 –  Understanding SQL Server's Role (Part 1 - 70-461)
Week 2:
  • Chapter 2 – Installing SQL Server 2012 (Part 1 - 70-461)
WEEK 3:
  • Chapter 3 – Querying SQL Server (Part 1 - 70-461)
WEEK 4:               
  • Chapter 3 – Querying SQL Server (Continued)
WEEK 5:               
  • Chapter 4 – Database Concepts and Terminology (Part 1 - 70-461)
  • Chapter 5 – ERD & Capacity Planning (Part 1 - 70-461)
WEEK 6:               
  • Chapter 6 – Normalization and Other Design Issues (Part 1 - 70-461)                                              
WEEK 7:               
  • Chapter 7 – Creating SQL Server Databases (Part 1 - 70-461)
WEEK 8:               
  • MID TERM EXAM
WEEK 9:               
  • Chapter 8 – Creating Tables (Part 1 - 70-461)                 
WEEK 10:            
  • Chapter 9 – Indexes and Views (Part 1 - 70-461)                        
WEEK 11:            
  • Chapter 10 – Triggers and Stored Procedures (Part 1 - 70-461)                      
WEEK 12:            
  • Chapter 3 – Working with the Administration Tools (Part 2 - 70-462)
WEEK 13:            
  • Chapter 4 – Server Command-Line Administration (Part 2 - 70-462)
WEEK 14:            
  • Chapter 8 – Creating Jobs, Operators, and Alerts (Part 2 - 70-462)
WEEK 15:            
  • PRACTICE TESTS - PART 1
WEEK 16:            
  • FINAL EXAM

Additional Information

IMPORTANT DATES TO REMEMBER:

August 20:             Fall Courses Begin
September 3:        Labor Day (Amarillo College Closed)
September 5:        Census Day (Administrative Drop for Non-Attendance)
October 13-21:     Fall Break
November 12:         Registration for Spring 2018 begins
November 22-25: Thanksgiving Holiday
November 20:       Last Day to Withdraw from Course
December 12:       Last Day of Class

TECHNOLOGY & COMPUTING ISSUES
  • Open Computer Labs: The Business Systems and Emerging Technology Department hosts an open computer lab on the 2nd Floor of the Byrd Business Building. Labs are open 7 days a week. Assistance with this course and/or technical assistance are available in the computer labs. Visit the Computer Information Systems (CIS) website for additional details: http://cis.actx.edu.
  • Computer Services Center: Located within the AC Bookstore, trained staff will diagnose computer-related issues and repair problems on a fee-for-service basis. Laptop rentals are also available. Visit the Computer Services Center website for additional details: https://www.actx.edu/bookstore/computer-service-center.
  • Student & Faculty Help Center: Located on the first floor of Ware Student Commons, the Help Center provides technical support to students and faculty. The Help Center offers assistance in logging into AC Connect, Blackboard, resetting passwords, and general computing and software questions. Visit the Student & Faculty Help Center website at https://www.actx.edu/ctl/helpcenter.
COURSE ASSISTANCE
PERSONAL ISSUES
  • Advocacy & Resource Center: The Advocacy & Resource Center is located on the first floor of Ware Student Commons. A variety of resources are available in the areas of social services, a food pantry, a clothing closet, and adult student programs. Visit the Advocacy & Resource Center website at http://www.actx.edu/arc/advocacy-and-resource-center.
  • Counseling Center: At the Counseling Center, student and counselor work together to develop more personal awareness and the skills needed to overcome barriers to success. All services are free and confidential. Visit the Counseling Center website at: https://www.actx.edu/counseling/index.php.
  • Legal Clinic: The Legal Clinic is a free, walk-in clinic assisting enrolled AC students on various legal issues including family law, immigration, probate, landlord-tenant issues, and general legal matters. Visit the Legal Clinic website at https://www.actx.edu/legalstudies/legal-student-intership.

Syllabus Created on:

08/19/18 2:09 AM

Last Edited on:

08/19/18 12:29 PM