Introduction to Database Management System Administration & Security
(GI512 S1 W04)
- Part 1: Overview of Database Theory
- Why study DBMS?
- Historical Overview
- DBMS Basics
- Relational DB Theory
- Fundamental Issues in DB Applications
- Part 2: Administration & Concurrency Control
- Database Administration
- Configuration Control
- Documentation
- Concurrency Control
- Atomic Transactions
- Resource Locking
- Consistent Transactions
- Transaction Isolation Level
- Cursor Type
- Part 3: ACID Transactions
- Atomic
- Consistent
- Isolated
- Durable
- Part 4: DB Security & Resource Management
- Database Security
- Processing Rights
- I&A
- Individuals & User Groups
- Application Security
- Database Recovery
- Transactions
- Application Logging
- Transactions and Log Files
- Backups & Log Files
- Recovery from Backups
- Recovery from Log Files
- Resource Management
- Performance
- Inflection points
- Capacity Planning
- Statistical Projections
- Packing Records by Key
- Application Evolution
Updated March 2009 for use in MSIA GI512, Seminar 1 (starting June
2009).
Narrated PPTX file in ZIP (16 MB)
Narrated PPT file (23 MB)
Non-narrated PPTX file (6 MB)
Script as PDF (350 KB)
* * *
Organizational Psychology Lecture
(GI561 W01):
- Social Dynamics of Your Group
- How are Your Colleagues Organized?
- What Kinds of Jobs Do Your Colleagues Do?
- How Much Autonomy Do Your Colleagues Have?
- Locus of Control
- Understand Your Colleagues’ Goals
- Applying Some Fundamental Concepts from Social Psychology
- Attribution Theory
- Social Cognition
- The Schema
- Judgement
- Beliefs and Attitudes
- Prejudice
- Conformity, Compliance and Obedience
- Pro-Social (Helpful) Behavior
- Group Behavior
- Social Loafing
- Group Polarization
- Groupthink
- Personality Types and Social Styles
Updated November 2008 for use in MSIA 2.0 courses (begin June
2009).
Complete PPT lecture
in ZIP file (41 MB) -- PowerPoint File for those who need to
alter slides for their own purposes
Complete PPSX lecture
in ZIP file (43 MB) -- PowerPoint Show that runs automatically
in PowerPoint.
* * *
Management Skills Lecture (GI561 W09):
- Part 1 – Understanding Management Styles
- Hawthorne Effect
- Implications of the Hawthorne Effect
- Theory X: Stick & Carrot
- Theory Y (Douglas McGregor)
- Theory Z (Abraham Maslow)
- Maslow’s Hierarchy of Needs
- Managerial Styles
- Part 2 – Good Management Style
- Involved
- Available
- Open
- Supportive
- Fair
- Competent
- Confident
- Consistent
- Realistic
- Organized
- Decisive
- Part 3 – Creating and Maintaining a Good Team
- MBO - Management by Objectives
- MBWA - Management by Walking Around
- Walk a Mile in Your Employees' Shoes
- Hire the Best People You Can Find
- Employee Career Development
- What About Losing a Well-Trained Employee?
- How Can We Keep Good Employees?
- Technical Training
- The Redundancy Rule
Complete PPT lecture in ZIP
file (12 MB) -- PowerPoint File for those who need to alter
slides for their own purposes
Complete PPS lecture in ZIP file
(12 MB) -- PowerPoint show that runs automatically in PowerPoint.
Breakdown into smaller PowerPoint (PPT) and PowerPoint Show (PPS)
files in WinZIP archives for those with slower connections:
Part 1 as PPT (Management
styles -- Hawthorne Effect, Theories X, Y, Z; Maslow's hierarchy of
needs) (2.5 MB) Part 1 as
PPS
Part 2 as PPT (Good management
style) (6.1 MB) Part 2 as
PPS
Part 3 as PPT (Creating
& maintaining a good team) (4.4 MB) Part
3 as PPS
* * *
Leadership Skills Lecture (GI561 W07):
- Leading Meetings – the Infrastructure
- Ground Rules for Meetings
- Presenting Information Effectively
- Analytical Techniques
Complete PPT lecture in ZIP
file (24 MB) -- PowerPoint File for those who need to
alter slides for their own purposes
Complete PPS lecture in ZIP file
(24 MB) -- PowerPoint Show that runs automatically in PowerPoint.
Breakdown into smaller PowerPoint (PPT) and PowerPoint Show (PPS)
files in WinZIP archives for those with slower connections:
Part 1 as PPT (Infrastructure
for good meetings) (2.7 MB) Part
1 as PPS
Part 2 as PPT (Ground
rules for meetings) (6.4 MB) Part
2 as PPS
Part 3 as PPT (Presenting information effectively) (3.4 MB) Part
3 as PPS
Part 4 as PPT (Presenting
information -- cont'd) (3.4 MB) Part
4 as PPS
Part 5 as PPT (Analytical
tools: Real-Time Notes, brainstorming, Computer-Aided Consensus, Post-It
Cluster Analysis,) (5.6 MB) Part
5 as PPS
Part 6 as PPT (Analysis
cont'd: Functional-Matrix Analysis, Computer-Aided Thematic Analysis)
(3.8 MB) Part 6 as PPS
* * *
Introduction to Cyberlaw (GI511 Lectures):
S1 W07: Introduction to cyberlaw and jurisdiction (125 MB)
PPT
in ZIP PPSX
in ZIP
S1 W08: Introduction to intellectual property law (109 MB)
PPT
in ZIP PPSX
in ZIP
Additional non-narrated lecture notes on Legal Aspects of Investigating
& Prosecuting Computer Crimes presented at 6th Annual MSIA Graduate
Security Conference in a workshop on June 10, 2009.
PPT PDF
* * *
Introduction to Cryptology (GI512 Lecture)
- Basic Concepts &
Terminology
- Types of Algorithm
- Cryptanalysis Methods
- Stronger Encryption
- Asymmetric Encryption & the Public-Key Cryptosystem
- Using PGP
Complete PPT lecture in ZIP
file (29 MB) -- PowerPoint File for those who need to alter
slides for their own purposes
Complete PPSX lecture in ZIP
file (29 MB) -- PowerPoint Show that runs automatically
in PowerPoint.
* * *
Additional Topics (all files in WinZIP archives):
Physical & Facilities Security PPT
(33 MB) and as PPSX
Identification & Authentication PPT
(45 MB) and as PPSX
Applied Ethics PPT
(29 MB) and as PPSX
Managing Employment, Hiring & Firing PPT
(80 MB) and as PPSX
E-mail and Internet Use Policies PPT
(47 MB) and as PPSX
Auditing Information Security PPT
(99 MB) and as PPSX
Working with Vendors PPT
(5 MB) and as PPSX
Solving Problems PPT
(4 MB) and as PPSX
* * *
INFOSEC UPDATE lecture notes
This workbook was used in the
two-day workshop held at the MSIA Residency in June 2006 . The PDF file
includes selected abstracts covering the previous 18 months of development
across the field of information assurance. For complete listings of
all abstracts in the INFOSEC YEAR IN REVIEW Database, see the IYIR
section of this Web site.
Copyright © 2009 M. E. Kabay. All rights
reserved.
The opinions expressed in any of the writings on
this Web site represent the author’s opinions and do not necessarily
represent the opinions or positions of his employers, associates,
colleagues, students, relatives, friends, enemies, cats, dog or plants.
Updated
2010-01-15
|