Short course name:

Database Management Systems 3

Module number:

COM 305

Course Syllabus:

Networking Oracle Database:

Oracle server and client protocol stacks

The role of Net8 and TNS items in client-server connection

TCP, SPX, Named Pipes and other transport schemes for Oracle database connectivity

MTS (Multi-threaded Server) schemes for Oracle

Interaction of slave and dispatcher processes

Characteristics of prime configuration files e.g.
TNSNAMES.ORA and LISTENER.ORA

Creating and configuring Oracle Server domains

Using Oracle Names Servers for centralised name resolution

Oracle networking utilities – LSTNRCTL, NAMESCTL etc

Distributed database snapshots and snapshot replication mechanisms

Writing distributed SQL queries

Managing Oracle networks with the OEM

Publishing Oracle databases on the internet

Web-access tools for Oracle databases, and thin-client/Oracle web applications server configuration


Administration and Architecture of SQL Server Database Engines:

SQL Server N-tier schemes

Using SQL Server native, operating system and mixed-mode logins

Built-in server and fixed database roles

Creating databases, tables and other objects using the Enterprise Manager (EM) and Transact SQL (T-SQL)

Role of master, model, MS DB and Tempdb system databases

Creating and assigning SQL Server and application roles

Using Query Analyzer and Query Designer tools

Estimating table space requirements based on column datatypes, sizes and indexing

Using TSQL local & global cursors, triggers and stored procedures

Creating SQL Server file groups and clusters

Configuring SQL Server replication – publisher, subscriber and distributor roles; using push/pull, transactional and snapshot replication; role of replication agents

Carrying out SQL Server database backup and recovery operations; full, differential, incremental and log backups

Creating and configuring scheduled SQL Server jobs and alerts

Using SQL Server data transformation tools e.g. DTS

Using the SQL Server Profiler and Monitor utilities


Networking SQL Server Databases:

SQL Server Network library and protocol components

Core SQL Server services that impact the network – MSSQLSERVER, SQLAGENT and MS-DTC

ODBC, OLE-DB and DB-library programmatic connections to remote databases; ADO record sets and connections

Writing distributed database queries for linked with T-SQL

Publishing SQL Server databases on the internet; Web Assistant wizard & templates

Installing and configuring SQL Mail

Accessing remote SQL Server data via FTP

Building SQL Server data warehouses