Database Concepts: SQL
SEMESTER CREDIT HOURS:
Database models, using a database system, commercial databases, database processing and procedures, and integration of database systems will be discussed. File processing techniques, administration of database structures, backup and recovery, queries, and database analysis and design will also be covered. Labs, working with SQL, will be assigned to emphasize these topics.
INFO 224 or INFO 244
COURSE OBJECTIVES / GOALS:
- Be able to list the advantages and disadvantages of Database processing.
- Be able to define and explain a Database environment.
- Understand common commercial Databases such as: MS SQL Server and Oracle
- Understand considerations which affect computer performance.
- Be able to list commonly used design tools for end users.
- Know how to succeed with Data modeling.
- Know the productivity and flexibility aspects of Database.
- Understand the improvements in productivity gained when using a Fourth Generation Language compared to traditional programming languages.
- Introduction to Relational Databases and SQL
- SQL Server Management Studio
- Designing a Database
- Retrieving Data with Queries
- Summary Queries
- Insert, Update, Delete Data
- Create and Maintain Databases and Tables with SQL
- Data Types and Functions
- Stored Procedures, Functions, and Triggers
TEXTBOOK / SPECIAL MATERIALS:
See bookstore website for current book at http://www.dacc.bkstr.com
Evaluation of the student will be based on the following: Final grades are determined through a weighted average of the final examination, quizzes, lab assignments, homework assignments, and class attendance.
Dec 18 2012 10:46AM