Welcome to CS410: Advanced Databases. General Information about this course and its requirements can be found below.
Course Designer: Charles W. Lively, III
Course Description: Advanced study of topics in database systems, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML.
After familiarizing yourself with the following course syllabus, enroll in this course using the "Enroll me in this course" button located on the left hand toolbar. Once enrolled, navigate to Unit 1 of the course to read the unit introduction and then access the "Unit 1 Activities" page, which provide all links and instructions for unit specific course resources.
Earning College Credit
This course provides students the opportunity to earn actual college credit. It has been reviewed by Brandman University and can applied as credit towards a degree by students who are currently enrolled or plan to enroll at Brandman. You can read more about this special program here.
Evaluation and Minimum Passing Scores
In order to pass this course, you will need to earn a 70% or higher on the final exam. Your score on the exam will be tabulated as soon as you complete it. If you do not pass the exam on your first attempt, you may take it again as many times as needed, following a 7-day waiting period between each attempt.
You will only receive an official grade on your final exam. However, in order to adequately prepare for this exam, we recommend that you work through the materials in each unit. Throughout the course you may find practice quizzes or other assignments that will help you master material and gauge your learning. Scores on these assignments are informational only and do not contribute to your overall course grade.
If you are seeking to earn college credit at Brandman, you must take and pass the version of the exam titled "Proctored Final Exam." That exam will be password protected.
This course is delivered fully online. You will be required to have access to a computer or web-capable mobile device and have consistent access to the internet to either view or download the necessary course resources and to attempt any auto-graded course assessments and the final exam.
To access the full course including assessments and the final exam, you will need to be logged into your Saylor Academy account and enrolled in the course. If you do not already have an account, you may create one, free of charge, here. Although you can access some course resources without being logged into your account, it’s advised that you log in to maximize your course experience. For example, some of the accessibility and progress tracking features are only available when you are logged in.
For additional technical guidance check out Saylor’s tech-FAQ and the Moodle LMS tutorial.
There is no cost to access and enroll in this course. All required course resources linked throughout the course, including textbooks, videos, webpages, activities, etc are accessible for no charge. This course also contains a free final exam and course completion certificate.
This courses does contain an optional final exam that will provide students an opportunity to earn college credit. Access to the exam itself is free, though it does require the use of a proctoring service for identity verification purposes. The cost for proctoring is $25 per session.
While learning styles can vary considerably and any particular student will take more or less time to learn or read, we estimate that the "average" student will take 97 hours to complete this course. Each overall unit, resource, and activity within the course is similarly tagged with an estimated time advisory. We recommend that you work through the course at a pace that is comfortable for you and allows you to make regular (daily, or at least weekly) progress. It's a good idea to also schedule your study time in advance and try as best as you can to stick to that schedule.
It may be useful to take a look at these time advisories and to determine how much time you have over the next few weeks to complete each unit, and then to set goals for yourself. Perhaps you can sit down with your calendar and decide to complete subunits 1.1 and 1.2 (a total of 4 hours) on Monday night; subunit 1.3 (a total of 3 hours) on Tuesday night; etc.
Learning new material can be challenging, so below we've compiled a few suggested study strategies to help you succeed.
Take notes on the various terms, practices, and theories as you read. This can help you differentiate and contextualize concepts and later provide you with a refresher as you study.
As you progress through the materials, take time to test yourself on what you have retained and how well you understand the concepts. The process of reflection is important for creating a memory of the materials you learn; it will increase the probability that you ultimately retain the information.
Although you may work through this course completely independently, you may find it helpful to connect with other Saylor students through the discussion forums or study groups. You may access the discussion forums at https://discourse.saylor.org.
As noted in the Suggested Prerequisites section, CS403: Introduction to Modern Databases is a prerequisite for this course. Please ensure that you have successfully completed this course and have a strong understanding of the fundamentals of SQL. If you are having trouble with the concepts of CS410, go back and strengthen your knowledge and skills in CS403.
Be sure to focus on the tutorial exercises provided in Unit 1 to ensure a strong understanding of the SQL commands. Pay special attention to all of Unit 1, as it lays the groundwork for understanding the more advanced material presented in the latter units.
Upon successful completion of this course, you will be able to:
- write complex queries, including full outer joins, self-joins, subqueries, and set theoretic queries;
- write stored procedures and triggers;
- apply the principles of query optimization to a database schema;
- explain the various types of locking mechanisms utilized within database management systems;
- explain the different types of database failures as well as the methods used to recover from these failures;
- design queries against a distributed database management system;
- perform queries against database designed with object-relational extensions; and
- develop and query XML files.
Throughout this course, you'll also see related learning outcomes identified in each unit. You can use the learning outcomes to help you organize your learning and gauge your progress.
In order to take this course, you should:
- have read the Saylor Student Handbook;
- have access to a relational database management system. A good open-source option is MySQL (dev.mysql.com);
- have completed the following courses: