Course

Objective:

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: