(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
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 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.
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
The Tutoring for Success policy applies to any student whose grade or performance in the course falls below a departmentally determined minimum threshold. In either of those cases, the instructor will direct the student to the appropriate tutoring service, which may be faculty-led, discipline-specific, and/or general. Under this policy, the instructor will follow specific departmental guidelines governing the use, duration, and grade component of the tutoring need.
Students who do not attend class on or prior to the census date will be administratively dropped. Effective Fall, 2016
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.
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 .
ITSE-2333-001 Implementing a Database on Microsoft SQL Server
Prerequisite: ITSE 2309
Skills development in the implementation of a database solution using MIcrosoft SQL Server client/server database management system.
Student ResourcesStudent Resources Website
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.
(3 sem hrs; 2 lec, 4 lab)
Hybrid
SQL Server Express 2019. This is a free download available online.
Instructions & installation file will be made available in your Blackboard course shell
Microsoft Visio 2016 ( or 2019. You can download this application via your Microsoft Imagine Account)
A USB flash drive
Access to a PC (personal computer) running the Windows 10 operating system.
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. In addition, we will be revisiting Database Design to reemphasize some of the concepts we learned in ITSE 2309 class
We will be working on the two subsets of the language, Data Manipulation Language (DML)and the Data Definition Language (DDL) with the primary focus on DML.
- Relational Database - Brief history, defining concepts, establishing solid relationships
- Creating a database in a SQL server
- Creating a table, setting primary key and foreign key constraints and other features
- ensuring appropriate relationships between tables in a relational database
- SQL Basics - basic SELECT statement, sorting & filtering, eliminating duplicate rows,using various types of expressions, NULL
- Working with Multiple Tables - JOINs, UNIONs, Subqueries
- Summarizing & Grouping Data - Aggregate functions, GROUP BY clause, filtering grouped data
- Modifying Sets of Data - using UPDATE, INSERT, DELETE statements
- Solving Complex Problems - using the AND & NOT criteria, conditional expressions, using Unlinked data & driver tables
- Procedures, Views, Triggers
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".
Course grades will be assigned based upon the following criteria:
Student evaluation is based upon the following assignments and weights:
PS: This is a tentative outline which is subject to change if required
The content is divided into 6 parts. Some parts may go for one week and others may be scheduled for 2 weeks
PART 1: RELATIONAL DATABASE & SQL - Chapters 1, 2 & 3 --- Week 1
PART 2: SQL BASICS - Chapters 4, 5 & 6 --- Weeks 1, 2
PART 3: WORKING WITH MULTIPLE TABLES - Chapters 7, 8, 9, 10, 11 --- Weeks 3, 4
PART 4: DATABASE CREATION - Chapters 15, 16, 17 and more --- Week 5
PART 5: MORE SELECT STATEMENTS - Chapters 12, 13, 14, 15, 19 --- Week 7
PART 6: PROCEDURES, VIEWS, FUNCTIONS - Weeks 8
August 26: Fall Courses Begin
September 2: Labor Day (Amarillo College Closed)
September 3: Census Day (Administrative Drop for Non-Attendance)
October 21-27: Fall Break
October 28: Fall 2 semester begins
November 4: Registration for Spring 2018 begins
November 26: Last Day to Withdraw from Course
November 28- December 1: Thanksgiving Holiday
December 19: Last Day of Class
10/09/20 12:25 AM
10/25/20 9:59 PM