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

• 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
• Sub-queries
• Insert, Update, Delete Data
• Create and Maintain Databases and Tables with SQL
• Data Types and Functions
• Views
• Scripts
• Stored Procedures, Functions, and Triggers
  

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.

Fall 2012

Dec 18 2012 10:46AM