Course Course Summary Section 1 Content Section 1 Content Left Section 1 Content Right Credit Type: Course ACE ID: UMBC-0023 Organization's ID: TCPRG0003 Organization: UMBC Training Centers, LLC Location: Classroom-based Length: 10 days (80 hours) Dates Offered: 10/1/2020 - 9/30/2023 1/1/2017 - 6/30/2020 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Lower-Division Baccalaureate 3 computer science Description Section 3 Content Section 3 Content Left Section 3 Content Right Objective: The course objective is to write Python programs that use an SQL database on the server side and provide an interface to the user using web technologies such as HTML, CSS, and JavaScript. Learning Outcomes: Use Data Definition Language (DDL) commands to create, alter, or drop tables Use Data Manipulation Language (DML) commands to select, insert, delete and update data Use the various Mathematical, String, Date , and Conversion Functions within a query Use Inner and Outer Joins to display data from related tables Use SQL group functions to obtain summaries or statistics Use SQL views and indexes to access data and improve the performance of searches Write HTML documents that can use a form to collect data from a user Use the CGI module Cookies modules in Python to send and receive HTML requests Communicate with a database with a command line interface Use Entity Relationship Diagrams to model a database Use transaction controls to commit or rollback transactions Use a standard and correlated subqueries within SQL queries Write Python Programs that use the Python Database API to communicate with a database Incorporate Cascading Style Sheets (CSS) into an HTML document Incorporate JavaScript into an HTML document to make it more dynamic Use the built-in SQL Operators within W HERE clauses of an SQL statement Design a Database based on industry best practices Use the UNION and UNION ALL Set operators within SQL queries General Topics: SQL, Python, HTML, CSS, JavaScript, and HTML processing using CGI Instruction & Assessment Section 4 Content Section 4 Content Left Section 4 Content Right Instructional Strategies: Audio Visual Materials Classroom Exercise Discussion Lectures Practical Exercises Methods of Assessment: Performance Rubrics (Checklists) Minimum Passing Score: 70% Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Page Content