Database Technologies Course Syllabi and Textbooks



MSCD 600 Database Architecture

Click here for Syllabus

Required Text(s):

Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, Implementation, and Management (10th ed.). New York, NY: Thompson. ISBN13: 9781111969608 or ISBN-10: 1111969604.

American Psychological Association. (2010). Publication manual of the American Psychological Association (6th ed.). Washington, DC: Author. ISBN13: 978-1-4338-0561-5 or ISBN10: 1-4338-0561-8 softcover. Companion website: http://www.apastyle.org

Optional:

Greenwald, R., Stackowiak, R., &; Stern, J. (2008). Oracle essentials: Oracle database 11g (4th ed.). Sebastopol, CA: O'Reilly & Associates. ISBN13: 978-0-596-51454-9 or ISBN10: 0-596-51454-9 softcover.


MSCD 610 Database Concepts

Click here for Syllabus

Required Text(s):

Casteel, J. (2010). Oracle 11G: SQL (2nd ed.). Boston, MA: Course Technology (Cengage Learning). ISBN13: 978-1-4390-4128-4 or ISBN10: 1-4390-4128-8 softcover

Optional Text(s):

Connolly, T. M., & Begg, C. E. (2010). Database systems: A practical approach to design, implementation and management (5th ed.). England: Addison-Wesley (Pearson). ISBN13: 978-0-321-52306-8 or ISBN10: 0-321-52306-7 softcover.

Optional Resources(s):

American Psychological Association (current edition).  APA Style, http://www.apastyle.org/.

Purdue Online Writing Lab (OWL), http://owl.english.purdue.edu/owl/resource/560/01/.

Technology Tool(s):

CPS Virtual Lab: Login to your Oracle account. Refer to the Lab Manual - Student Instructions for Static Database on a Linux (Xen) Server located in the Course Resources folder.

Minimum Technology Requirements: http://www.regis.edu/Academics/Learning-Management-System/System-Requirements.aspx



MSCD 640 Database Administration

Click here for Syllabus

Required Text(s):

American Psychological Association. (2010). Publication manual of the American Psychological Association (6th ed.). Washington, DC: Author. ISBN13: 978-1-4338-0561-5 or ISBN10: 1-4338-0561-8 softcover. Companion website: http://www.apastyle.org

Kuhn, D. (2013). Pro Oracle Database 12cAdministration. New York: Apress. ISBN13: 978-1430257288

Coronel, C., Morris, S., & Rob, P. (2011). Database systems: Design, implementation, and management (9th ed.). Boston, MA: Course Technology (Cengage Learning). ISBN13: 978-0-538-46968-5 or ISBN10: 0-538-46968-4 hardcover.

Software:

None required. Students will access an Oracle account via the Regis University Academic Research Network


MSCD 642 Database Backup and Recovery

Click here for Syllabus

Required Text(s):

Kuhn, D., Alapati, S., Nanda, A. (2013). RMAN Recipes for Oracle Database 12c: A Problem-solution Approach. New York, NY: APRESS. ISBN: 978-1430248361

American Psychological Association. (2010). Publication manual of the American Psychological Association (6th ed.). Washington, DC: Author.
ISBN: 978-1-4338-0561-5 or ISBN10: 1-4338-0561-8 softcover. http://www.apastyle.org.

Optional:

Connolly, T. M., & Begg, C. E. (2010). Database systems: A practical approach to design, implementation and management (5th ed.). England: Addison-Wesley
(Pearson Education Limited). ISBN: 978-0-321-52306-8 or ISBN10: 0-321-52306-7 softcover.

Software:

None required. Students will access an Oracle account via the Regis University Academic Research Network.


MSCD 644 Database Performance Tuning

Click here for Syllabus

Required Text(s):

Alapati, S. R., Kuhn, D., & Padfield, B. (2011). Oracle database 11g performance tuning recipes: A problem-solution approach (1st ed.). New York: Apress
(Springer). ISBN13: 978-1-4302-3662-7 or ISBN10: 1-4302-3662-0 softcover.

Supplemental (Optional):

Rossiter, J. (2007).The APA pocket handbook: APA rules for format and documentation (1st ed.). Port Saint Lucie, FL: DW Publishing (Mulberry Copy Center).
ISBN13: 978-1-93387813-3 or ISBN10: 1-93387813-4 softcover.

American Psychological Association. (2010). Publication manual of the American Psychological Association (6th ed.). Washington, DC: Author. ISBN13: 978-1-4338-0561-5 or ISBN10: 1-4338-0561-8 softcover. Companion website: http://www.apastyle.org

Required Text(s):

None required. Students will access an Oracle account via the Regis University Academic Research Network.


MSCD 650 PL/SQL Programming

Click here for Syllabus

Required Text(s):

Casteel, J. (2010). Oracle 11G: SQL (2nd ed.). Boston, MA: Course Technology (Cengage Learning). ISBN13: 978-1-4390-4128-4 or ISBN10: 1-4390-4128-8 softcover

Recommended:

Connolly, T. M., &; Begg, C. E. (2010). Database systems: A practical approach to design, implementation and management (5th ed.). England: Addison-Wesley (Pearson Education Limited). ISBN13: 978-0-321-52306-8 or ISBN10: 0-321-52306-7 softcover.

Software:

None required. Students will access an Oracle account via the Regis University Academic Research Network.


MSCD 670 Middleware Architecture and Database Applications

Click here for Syllabus

Required Text(s):

Britton, C., & Bye, P. (2004). IT Architectures and Middleware: Strategies for Building Large, Integrated Systems (2nd ed.). Boston, MA: Addison-Wesley (Pearson Education). ISBN13: 978-0-321-24694-3 or ISBN10: 0-321-24694-2 softcover.

American Psychological Association. (2010). Publication manual of the American Psychological Association (6th ed.). Washington, DC: Author.
ISBN13: 978-1-4338-0561-5 or ISBN10: 1-4338-0561-8 softcover. Companion website: http://www.apastyle.org

Required Text(s):

Connolly, T. M., & Begg, C. E. (2009). Database systems: A practical approach to design, implementation and management (5th ed.). Reading, MA: Addison-Wesley (Pearson). ISBN13: 978-0-321-52306-8 or ISBN10: 0-321-52306-7 softcover.

Required Text(s):

None required. Students will access an Oracle account via the Regis University Academic Research Network.


MSCD 675 Database Technologies and SOA

Click here for Syllabus

Required Text(s):

Erl, T. (2005). Service-oriented architecture: Concepts, technology, and design (1st ed.). Boston, MA: Prentice Hall (Pearson). ISBN: 978-0-13-185858-9 or
ISBN10: 0-13-185858-0 hardcover.

There may also additional be readings for this course listed in the course overview grid. The course facilitator/instructor will provide instructions
to access these articles


MSCD 681 Data Warehouse Design

Click here for Syllabus

Required Text(s):

Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., & Becker, B. (2008). The data warehouse lifecycle toolkit (2nd ed.). Indianapolis, IN: Wiley Publishing, Inc. ISBN: 978-0-470-14977-5 or ISBN10: 0-470-14977-9 softcover.

American Psychological Association. (2010). Publication manual of the American Psychological Association (6th ed.). Washington, DC: Author.
ISBN: 978-1-4338-0561-5 or ISBN10: 1-4338-0561-8 softcover. Companion website: http://www.apastyle.org

Recommended:

Connolly, T. M., & Begg, C. E. (2010). Database systems: A practical approach to design, implementation and management (5th ed.). England: Addison-Wesley (Pearson Education Limited). ISBN13: 978-0-321-52306-8 or ISBN10: 0-321-52306-7 softcover.

Software:

None required. Students will access an Oracle account via the Regis University Academic Research Network