Syllabus for DSI-530
SQL - Introduction to Database Queries
Most data are stored in relational database management systems, which are organized as a number of related tables. To perform common statistical analyses, the data must typically be merged into a single dataframe.
The SQL (structured query language) programming language is often used to pull data from the various tables in a database and to assemble the data in a format amenable to statistical analysis or review. SQL can also be used for basic calculations, but it’s not meant for heavy-duty statistical programming.
The purpose of this online course, "SQL - Introduction to Database Queries" is to teach you how to extract data from a relational database using SQL, so that you can perform statistical operations. The focus is on structuring queries to extract structured data (not on building databases or methods of handling big data).
After completing this course, you should be able to:
CO1 Understand the relational database file model (as contrasted with the flat file)
CO2 Load MySQL and read in .csv data
CO3 Query databases to obtained desired data
CO4 Incorporate functions in queries
CO5 Add filtering to queries
CO6 Join tables
CO7 Perform subqueries
CO8 Understand the principles of efficient SQL databases
You will need the following materials to complete your coursework. Some course materials may be free, open source, or available from other providers. You can access free or open-source materials by clicking the links provided below or in the module details documents. To purchase course materials, please visit the University's textbook supplier.
ISBN: 978-1498724487
SQL-Introduction to Database Queries is a three-credit online course, consisting of six modules. Modules include an overview, topics, learning objectives, study materials, and activities. Module titles are listed below.
For your formal work in the course, you are required to participate in online discussion forums, complete written assignments, take a proctored midterm examination, and complete a final project. See below for details.
Consult the Course Calendar for due dates.
One or more of your course activities may utilize a tool designed to promote original work and evaluate your submissions for plagiarism. More information about this tool is available in this document.
In addition to an ungraded Introductions Forum, you are required to participate in four graded online class discussions.
Communication with your mentor and among fellow students is a critical component of online learning. Participation in online class discussions involves two distinct activities: an initial response to a discussion question and at least two subsequent comments on classmates' responses.
All of these responses must be substantial. Meaningful participation is relevant to the content, adds value, and advances the discussion. Comments such as "I agree" and "ditto" are not considered value-adding participation. Therefore, when you agree or disagree with a classmate or your mentor, state and support your position.
You will be evaluated on the quality and quantity of your participation, including your use of relevant course information to support your point of view, and your awareness of and responses to the postings of your classmates. Remember, these are discussions: responses and comments should be properly proofread and edited, mature, and respectful.
You are required to complete four assignments. The written assignments are on a variety of topics associated with the course modules.
You are required to complete a final project that incorporates concepts and skills from throughout the course. There will be several weeks leading up to the submission of the final project where you are expected to work on the project and receive feedback from your mentor.
Assemble the data needed to work on the project, formulate a strategy for completing the project, make sure you understand the questions, and address questions to your mentor. The last point is essential—even if you think you understand exactly how you are to proceed, you need to outline your strategy with your mentor.
Prepare an initial submission with your analysis that is substantially complete. You may raise additional questions with your mentor at this point to seek guidance. You must in any case share your work with your mentor.
Incorporate guidance and complete final submission. Taking the guidance from your mentor into account, prepare and submit your final submission.
Your grade in the course will be determined as follows:
All activities will receive a numerical grade of 0–100. You will receive a score of 0 for any work not submitted. Your final grade in the course will be a letter grade. Letter grade equivalents for numerical grades are as follows:
A | = | 93–100 | B | = | 83–87 | |
A– | = | 90–92 | C | = | 73–82 | |
B+ | = | 88–89 | F | = | Below 73 |
To receive credit for the course, you must earn a letter grade of C or higher on the weighted average of all assigned course work (e.g., assignments, discussion postings, projects, etc.). Graduate students must maintain a B average overall to remain in good academic standing.
To succeed in this course, take the following first steps:
Consider the following study tips for success:
To ensure success in all your academic endeavors and coursework at Thomas Edison State University, familiarize yourself with all administrative and academic policies including those related to academic integrity, course late submissions, course extensions, and grading policies.
For more, see:
Copyright © 2019 by Thomas Edison State University. All rights reserved.
