This is a fundamental course in database concepts, design and implementation involving the relational database model. Students will create, query and update relational databases using Structured Query Language (SQL).
Introduction to Structured Query Language (SQL)
Syllabus, Course Calendar, Blackboard, Google Drive & Docs, File Systems & Database Concepts
Database Models & SQL Queries
What is a database? Different database models, Becoming familiar with the SQL Server and the management studio & How to retrieve data from a relational database
SQL Queries (Cont’d)
Query two or more tables, Summary Queries
SQL Queries (Cont’d)
Subqueries
Insert, Update, Delete Data in a Table
Insert, Update, & Delete data in a table, SQL Data Types
Using SQL Functions
String, Numeric, Date/Time, ISNULL, IIF, CASE, CHOOSE
Database Design
Normalization
Database Design (Cont’d)
Entity Relationship Diagram (ERD)
Create and Maintain Tables with SQL
Final Project
Final Exam
Views, Scripts, Stored Functions, Proceedures & Triggers
ITDEV110 - Introduction to Object-Oriented Programming
ITDEV117 - Logic and Problem Solving
IT107 - Social Networking and Business
VICOM128 - Web Development with HTML/CSS
ECON201 - Principles of Microeconomics
ITDEV115 - Intermediate Object-Oriented Programming
ITDEV140 - Programming with Java
ITDEV150 - Database Management with SQL
ITDEV160 - Web Programming with Scripts JavaScript
ITDEV161 - Web Programming 1
ITDEV162 - Client/Server & E-Commerce Implementation
ITDEV177 - Systems Analysis and Design
ITDEV198 - Internship(iStream Financial Services)
ITDEV154 - Data Structures and Programming
ITDEV164 - Web Programming 2
ITDEV199 - Integrated Project
SPEECH212 - Introduction to Theater
MATH202 - Trigonometry
NATSCI184 - Plant Biology
PSYCH231 - Introductory Psychology
SOCSCI299 - Elective - UWM, ARTHIST470 - Topics in American Art: American Woman Artists
COMART103 - Creative Design & Composition
