Second Year Computing (Level 6) Course Overview

Project Management
• Understanding Project Management Process Groups and the Project Management Life Cycle
• Time Management
• Cost Management
• Scope Management
• Quality Management
• Risk Management
• Preparing a Business Case
• Creating a Work Breakdown Structure
• Creating a Gantt Chart
• Managing Project Changes
Data Analysis
• Analysing system data requirements
• Analysing System processes
• Object Oriented System Analysis
• Use Cases
• Sequence Diagrams
Database Management (SQL Server 2005)
• Installing SQL Server
• Configuring SQL Server
o Configuring Log and Data Files
o Specifying a Recovery Model
o Configuring Server Security Principals
o Configuring Database Securables
• Creating Database objects such as Tables, Constraints, and User-Defined Data Types.
• Creating Indexes
• Working with T-SQL
• Creating Functions, Stored procedures and Triggers
• Implementing Views
• Backing up, Restoring, and Transferring Data
• Using T-SQL to Manage a Database
• Working with SQL Server Agent Jobs
• Optimizing Databases (Indexes, Index design and Index Maintenance and File Groups)
• Capacity Planning
• Managing XML Data
• SQL Server Performance Monitoring
ASP.NET Programming (.NET 2.0)
• Programming with Objects
o Custom Classes
o Working with Objects
o Interfaces and Delegates
• Database Programming
o Visual Database Tools
o Programming ADO.NET Objects
• Intro/History ,HTML revision
• Cascading Style sheets
• Building a Web Application
o Designing Web Forms
o Maintaining State
• ASP.NET Objects
o Response Object, Request Object, Server Object, Session and Application Objects, Page and previous Page Objects
• ASP.NET Web Controls
• Using Cookies
• Developing Data-Driven Web Applications
• XML Web Services
Advanced Windows Administration (Windows Server 2003)
• Understanding TCP/IP
• DFS
• Monitoring Microsoft Windows Server
• Create A Disaster Recovery Plan
• Backup And Restore
• Setting File And Object Auditing
• Assessing Security Needs Of An Organization
• Analyzing Security Risks
• Reducing The Risk Of Software Vulnerabilities
• Designing A Management Infrastructure
• Designing Active Directory Security
• Protecting Data
• Hardening Services
• Hardening Client Computers
• Designing A Public Key Infrastructure
• Protecting Intranet Communications
• Protecting Extranet Communications
• Hardening Web Services.