Course Section 1 Content Section 1 Content Left Section 1 Content Right Credit Type: Course ACE ID: STAT-0017 Version: 4 Organization's ID: 360 Organization: Statistics.com Location: Online Length: 4 weeks Minimum Passing Score: 73 ACE Credit Recommendation Period: 10/1/2024 - 9/30/2027 5/1/2021 - 9/30/2024 4/1/2018 - 4/30/2021 11/1/2014 - 3/31/2018 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Lower-Division Baccalaureate 3 Introduction to Relational Databases Description Section 3 Content Section 3 Content Left Section 3 Content Right Objective: The course objective is to teach students how to extract data from a relational database using SQL, so that they can perform statistical operations. The focus is on structuring queries to extract structured data. Learning Outcomes: Add filtering to queries. Load MySQL and read in .csv data. Incorporate functions in queries. Query databases to obtained desired data. Join tables. Perform subqueries. Understand the principles of efficient SQL databases. Understand the relational database file model (as contrasted with the flat file). General Topics: MySQL Basic SQL Procedures and Functions Joining Tables and Subqueries Efficient SQL Databases Instruction & Assessment Section 4 Content Section 4 Content Left Section 4 Content Right Instructional Strategies: Discussion Practical Exercises Textbook readings Methods of Assessment: Other Graded practical exercises and discussion forums Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Equivalencies Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Other offerings from Statistics.com View All Courses College Credit Opportunities Page Content