Welcome Letter

Course Description

Presents essentials of query and database technologies for software developers. Students learn
both SQL and NoSQL languages. Best-practices for database management and security are
defined. Principles are applied by performing exercises to create and fill tables, retrieve and
manipulate data, perform data analysis. 

Course Number: CIS 225
Course Title: CLOUD DATABASES
Instructor: Robert Sfarzo
Delivery Mode: Distance Education. Fully online, asynchronous, and no scheduled, required meetings.
Units: 2 credits
Expected Student Workload: 108 Total hours
Transfer: CSU, UC 

Instructor Contact Information

Instructor: Robert Sfarzo
Email: robert_sfarzo@cuesta.edu and Canvas Mail
Office Hours: Online only office hours on Zoom. Scheduled Thursdays 4-5 pm. One-on-one Zoom meetings can be scheduled upon request.
Best way to contact: E-mail and Canvas mail are preferred because I check them 7 days a week. My Pronto notifications are turned off and I check Pronto about 5 times per week. 

Prerequisites

Advisory: CIS 201 INTRODUCTION TO COMPUTER SCIENCE or the equivalent experience with a programming language.

Required Textbook and Training Portal

There are no required textbooks.  Students are required to access, for free, the AWS Academy Canvas training portal. 

Other Required Resources

    • Access to the Internet on a computer with one of the operating systems: Mac IOS, Windows, Chromebook
    • Zoom or ConferZoom

Student Learning Outcomes

1. Describe the designs and uses of databases.
2. Construct computer programs that access database management systems.
3. Maintain the integrity and security of databases.

Topics

• Relational Databases
  • Relational database data models
  • SQL languages
• Non-relational databases
  • Storage models for non-relational databases
  • NoSql languages
  • JSON objects
• Programmatic access
  • Security credentials
  • Database server connections
  • Query submission and retrieval
• Database Management
  • Security and authentication
  • Backup and recovery
  • Performance and monitoring
  • Scaling
  • Automation
  • Data transformation services

Course Grade Determination

• 25% AWS Academy Labs (4)
• 25% Replit Labs (3) 
• 40% Quizzes (5) 
• 10% Final Exam

Expectations of Students Policies

Students must abide by the following policy criteria. Failure to comply will result in an instructor-initiated drop from this course.

Meet the Course Census Date Criteria

Students must attend and take part in the first week of this course. Failure to demonstrate meeting the course Census Date requirement will result in being dropped from the course roster. 

Sign up for the AWS Academy Courses and Replit 

Students must register for the AWS Academy Machine Learning Foundations and AWS Academy Learner Labs courses, as well as establish a Replit account by the course census day or will be dropped from the Cuesta course.  Each of these is free of charge.  Free access links to the AWS Academy portal are provided when the course begins.

Maintain Regular Contact

Students are expected to log in to Canvas and demonstrate activity at least once per week by Friday of each week. Failure to do so without being excused by the instructor will result in a warning for the first occurrence, and an I instructor-initiated drop thereafter.

Late Policy: Maintain Timelines

Late assignments and quizzes without instructor approval will receive a 2-point deduction for each day late.

Maintain a 70% Grade Average

Students must maintain an overall grade average of 70% at all times. Failure to do so without a personal improvement plan that is approved by the instructor will result in an instructor-initiated drop from this course.

Add and Drop Policies

• Instructor-initiated drops are described in the Expectations of Students Policy section.
• Provided there is room, the instructor will distribute add codes by email upon request by the student.
• Cuesta Add policyLinks to an external site.
• Cuesta Drop policyLinks to an external site.

Accommodations

This course is designed using an accessible Learning Management System, and course materials have been created with ADA compliance in mind. If you have a disability and might need accommodation in this class such as extended time on exams or other resources. Please contact the instructor as soon as possible so you can receive appropriate accommodation promptly. You should also contact DSPS (Disabled Student Programs & Services) or at 805-546-3148.

Accessing the Course

You will see your course in Canvas on the first day of class. You can access Canvas by clicking on Canvas from the top bar of the Cuesta homepage (www.cuesta.edu), or by typing the Canvas address (https://cuesta.instructure.com/) into your browser address bar. 
If you are not familiar with logging into canvas, please refer to the Canvas Quick Reference Guide. Once logged into Canvas you will be directed on where to get started. Be sure to read all the directions on the course home page. 

Technical Support

If you are having difficulty logging into Canvas after the course start date and need assistance, please email me or technical support at this email address: support@my.cuesta.edu

Online Learning

If you have never taken an online class or this is your first experience with Canvas, please be patient with yourself. Online classes are not inherently easier, although they may be much more convenient for many students. You should expect to spend at least as much time, if not more, on this course as you would on a course that meets face to face. Since there is no lecture component, much of this time will be self-directed and there will be a substantial amount of reading, viewing, studying, and writing required. This course is completely online using Canvas; all coursework (discussions, assignments, quizzes) is submitted online. There are no face-to-face meetings. Please be prepared to spend 12 hours per week on coursework for this class.

Academic Honesty Policy

Students attending San Luis Obispo County Community College District at any district site and when representing Cuesta College in any off-campus activity, assume an obligation to conduct themselves in an acceptable manner compatible with the Student Code of conduct. Please review the Cuesta College Student Code of conduct.