Database Technologies Course Syllabi and Textbooks



MSCD 600 Database Architecture

(Cross-listed with MCT 613)

Click here for Syllabus

Required Text(s):

Coronel, C. & Morris, S. (2014). Database systems design, implementation, and management (11th ed.). Stamford, CT: Course Technology (Cengage Learning)

Optional:

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

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


MSCD 610 Database Concepts

(Cross-listed with MCT 614)

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

Optional 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 soft.

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):

The web-based Citrix technical environment for lab work canbe found at this URL: http//myregisapp.regis.edu/Citrix/StoreWeb/



MSCD 640 Database Administration

(Cross-listed with MCT 615)

Click here for Syllabus

Required Text(s):

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

Optional Text(s):

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.

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):

The web-based Citrix technical environment for lab work canbe found at this URL: http//myregisapp.regis.edu/Citrix/StoreWeb/



MSCD 642 Database Backup and Recovery

(Cross-listed with MCT 629)

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

Optional Text(s):

Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). New York, NY: Thompson. ISBN13: 9781111969608. 

Optional Resources for explaining the APA Guidelines:

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):

The web-based Citrix technical environment for lab work canbe found at this URL: http//myregisapp.regis.edu/Citrix/StoreWeb/


MSCD 644 Database Performance Tuning

(Cross-listed with MCT 630)

Click here for Syllabus

Required Text(s):

Alapati, Sam; Kuhn, Darl; Padfield, Bill (2011). Oracle Database 11g Performance Tuning Recipes. Apress. ISBN- 978-1-4302-3662-7.

Optional Resources for explaining the APA Guidelines:

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):

The web-based Citrix technical environment for lab work canbe found at this URL: http//myregisapp.regis.edu/Citrix/StoreWeb/


MSCD 650 PL/SQL Programming

(Cross-listed with MCT 631)

Click here for Syllabus

Required Text(s):

Casteel, J. (2013). Oracle 11g: PL/SQL Programming (2nd ed.). Boston, MA: Course Technology (Cengage Learning). ISBN13: 978-1-133-94736-3. ©2013.

Optional Text:

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

Optional Resources for explaining the APA Guidelines:

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):

The web-based Citrix technical environment for lab work canbe found at this URL: http//myregisapp.regis.edu/Citrix/StoreWeb/


MSCD 661 Business Intelligence

Click here for Syllabus

Required Text(s):

Sharda, R., Delen, D., & Turban, E. (2015).  Business Intelligence and Analytics:  Systems for Decision Support (10th ed.).  Upper Saddle River, NJ:  Pearson.  ISBN-13: 978-0-13-305090-5.

Additional Required Reading(s):

Power, D. J. (2014) What is ACID and BASE in database theory? Sheldon, R. (2014).  Oracle gets away from relational DB with NoSQL database architecture

Optional Resource(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):

CC&IS Virtual Lab: Login to your Citrix account using your Regisnet ID and password with the URL shown below.  The browser that we recommend is Google Chrome or Firefox (avoid IE).  The BI labs will provide detailed instructions for using the various tools that you will use during this course:   http://myregisapp.regis.edu/Citrix/StoreWeb/


MSCD 670 Middleware Architecture and Database Applications

(Cross-listed with MCT 616)

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.

Supplemental Text(s):

Shafii, R, Lee, S., & Konduri, G. (2011). Oracle Fusion Middleware 11g Architecture and Management (1st ed.). McGraw-Hill. ISBN: 978-0-07-175417-0 soft.

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 soft.

Optional Resources for explaining the APA Guidelines:

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):

The web-based Citrix technical environment for lab work canbe found at this URL: http//myregisapp.regis.edu/Citrix/StoreWeb/


MSCD 675 Database Technologies and SOA

(Cross-listed with MCT 627)

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