An intermediate-level course familiarizing the student with the SQL language used to retrieve and modify tables and data within a SQL Server database management system. Covers outer joins, summary queries, and subqueries. Also discusses using normalization techniques to design and create database structures, views, scripts, stored procedures, scalar functions, and triggers.
Goals, Topics, and Objectives
- An introduction to relational databases and SQL
- How to work with SQL server databases
- How to retrieve data from a single table
- How to retrieve data from two or more tables
- How to code summary queries
- How to code subqueries
- How to modify datra within a table
- SQL server data types
- How to design a database
- How to create and implement a database
- How to code scripts, views, stored procedures, tiggers, and scalar functions
- Compose SQL statements that retrieve data from one table structure using the SELECT-FROM-WHERE-ORDER BY syntax.
- Generate SQL statements that retrieve data from more than one table coding the correct join relationship within the FROM clause.
- Write SQL statements that incorporate a subquery within the SELECT list, FROM clause, or WHERE clause.
- Construct SQL statements using the UPDATE, INSERT and DELETE statement that modify data within a table structure.
- Organize, plan, and implement a database structure using normalizing techniques based on example documents used within a business entity.*
- Code SQL views, stored procedures, triggers, and scalar functions.
Assessment and Requirements
Homework assignments involving SQL queries and database design and implementation will be performed by the students, as well as lab work, team projects, and multiple-choice tests.