ICT322_StudyGuide_Jul10 - ICT322 Database Systems:...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
ICT322 Database Systems: Implementation and Administration Study Guide (5CU)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Course Development Team Head of Programme : Mr V V Moorthy Course Developer(s) : BOEY Yoke Ling Production : Educational Technology & Production Team Curriculum Administration Team Copyright © SIM University, 2010 All rights reserved. No part of this material may be reproduced in any form or by any means without permission in writing from the Educational Technology & Production, SIM University. Educational Technology & Production SIM University 535A Clementi Road Singapore 599490
Background image of page 2
CONTENTS SECTION 1: COURSE GUIDE 1.1 Introduction ..................................................................................................... 1 1.2 Course Description and Aims ....................................................................... 2 1.3 Learning Outcomes ........................................................................................ 3 1.4 Overall Assessment ........................................................................................ 4 1.5 Learning Materials .......................................................................................... 5 1.6 Course Schedule for 5 CU Print Courses .................................................... 6 SECTION 2 : STUDY UNITS Chapter 1 : SQL for Database Construction and Application Processing ............................................................................. SU-1 SQL DLL, DML, and Joins SQL DML Embedding SQL in Program Code Chapter 2 : Database Redesign . ............................................................................. SU-10 The Need for Database Redesign Pitfalls in Database Redesign Database Conversion Chapter 3 : Managing Multiuser Databases. ........................................................ SU-17 Background Data and Database Administration Cursor Type Database Security Database Recovery Managing the DBMS Chapter 4 : Managing Databases with SQL SERVER 2000 . ............................... SU-26 Installing SQL Server 2000/MySQL Creating a SQL Database Application Logic Concurrency Control SQL Server Security SQL Backup Recovery
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ICT322 Database Systems: Implementation and Administration COURSE GUIDE
Background image of page 4
ICT322 DATABASE SYSTEMS: IMPLEMENTATION AND ADMINISTRATION COURSE GUIDE SIM UNIVERSITY 1 Section 1: Course Guide 1.1 Introduction Welcome to your study of ICT322 Database Systems: Implementation and Administration, a 5 credit unit (CU) course. This Study Guide is divided into two sections – the Course Guide and Study Units.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/06/2010 for the course IT ICT322 taught by Professor Tan during the Spring '10 term at Singapore Institute of Management.

Page1 / 10

ICT322_StudyGuide_Jul10 - ICT322 Database Systems:...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online