Syllabus Information |
Fall 2024
Nov 13, 2024 |
|
 |
||
 | Use this page to maintain syllabus information, learning objectives, required materials, and technical requirements for the course. |
| INTD 4012P - Flex: SQL Fund 2 Perking |
|---|
|
Associated Term:
Fall 2024
Learning Objectives: Creation of indices to improve database performance and optimize queries Analysis and application of normalization to create efficient data storage Preparation of stored procedures and triggers to easily perform and automate more complex database tasks Identification of scenarios where denormalization of data can improve database performance Construction of database transactions to provide more structure and prevent failures of database operations Ability to survey various methods to create new tables from existing data Preparation of common table expressions to allow repeated use of a subquery within a transaction Database management system (DBMS) installation, including setting up a database and administration tasks for granting user access and analyzing database performance SQL data types and appropriate data conversions to prevent information loss Differences between SQL and NoSQL databases to determine the best storage method based on application requirements Required Materials: Familiarity with using a computer and adequate typing ability. Completion of "FlexStack: SQL Fundamentals 1 – Pulling Up to the Database Table." A Windows or Mac laptop with a webcam is required to participate in the course. Tablets or other devices are not supported. Technical Requirements: |
| Return to Previous | New Search |
|