2018-2019 Pierce College Catalog 
    
    Mar 28, 2024  
2018-2019 Pierce College Catalog [ARCHIVED CATALOG]

Database Management and Design (AAS) Course Map


Return to {$returnto_text} Return to: Course Maps by Career Pathway

Created by Pierce faculty, this map outlines the initial coursework for this career field. It provides you a clear path to complete your degree by listing a specific set of courses relevant to your program and career. The map is designed with the appropriate number of credits and meets degree requirements. Courses are organized in a recommended sequence; please schedule accordingly. If a course is unavailable, select the next appropriate course within the sequence. For each course, a purpose statement explains how the content relates to your career field. On this map, there may be instances when you will be required to select a course from several options. Use these purpose statements and notes to choose the course that best aligns with your interests and needs. You will also find action items to complete to assure you progress and graduate on time. While this map is a great guide to courses required to complete the Associate of Applied Science Database Management and Design, you are responsible for fulfilling all degree requirements. Questions? Your Success Network is ready to help you!

1. College Success


  • Course purpose: A foundational course to explore and affirm a career choice and build upon the skills, knowledge, and resources that will support you at Pierce College and beyond.

2. Computer Information/Keyboarding Skills Course Recommendation


Take as advised.

3. Business Analysis


  • Course purpose: You will learn tools to analyze the business environment and define stakeholder needs in order to make recommendations for Information Technology solutions that enable the organization to achieve its goals.

Action Item: Meet with Advisor


Use your Success Network!  In your first quarter, meet with your advisor to revisit your career and transfer path, make adjustments to your goals as needed, and plan for your next steps. 

4. Spreadsheet Applications


  • Course purpose: Business data resides in spreadsheet silos around a company.  In order to import or export data for your stakeholders, you will learn basic through advanced spreadsheet design and development.

5. Introduction to Computer Programming


6. Systems Analysis and Design


7. Database Management Systems


8. Human Relations/Psychology/Sociology Course Recommendation


Choose one

9. Client-Side Web Development


10. Structured Query Language


11. Introduction to Object Oriented Programming (OOP)


12. English Composition I


Action Item: Apply for Graduation


Way to go!  It is time to apply for graduation.  Visit the Pierce College Graduation website for details.  https://www.pierce.ctc.edu/graduation

13. Public Speaking


14. Introduction to Statistics


15. Advanced SQL Programming and Tuning


  • Course purpose: You will continue to advance you Structured Query Language (SQL) skills by covering advanced topics to develop script files, stored procedures, and procedural language units, as well as diagnose and tune performance problems.

16. Server-Side Web Development


17. Database Administration Backup and Recovery


Action Item: Complete Certification Exam(s)


Please complete certification exam(s) (ex. MTA Database Fundamentals, MTA Software Fundamentals, IIBA ECBA), and begin job readiness preparation for internship and post-graduation job search. 

18. Intermediate Object Oriented Programming (OOP)


19. CCNA 1: Introduction to Networks


20. Business Analytics/Intelligence


  • Course purpose: In this course you will learn how to develop business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. BI tools are used for reporting (SSRS), integration (SSIS), and analysis (SSAS).

21. Installing and Configuring Windows Server


  • Course purpose: In order for databases and programs to work correctly you must be able to build your own development environment.  In this course you will learn how to install and configure Windows Server with Active Directory, Network Services, Local Storage, File and Print Services, Group Policy and virtualization.

22. Supervised Internship


  • Course purpose: You will gain relevant experience working in a local business environment. This requires 250 hours of supervised work including associated resume preparation, job interviews and internship documentation.

23. CIS Project Capstone


  • Course purpose: In this course you will demonstrate your proficiency of prior core course outcomes by analyzing, designing, developing, implementing and evaluating a real-life data driven application project using one or more software development life cycles.

Total Credits 106-116


Note: Due to the rapid changes in the IT industry, the Special Topics courses CIS 155 and CNE 155 may be substituted as needed into the CIS or CNE degree programs, on the advice of the CIS/CNE Faculty and program coordinator.

Program Code: 503


Return to {$returnto_text} Return to: Course Maps by Career Pathway