IT Systems Analysts: Job Openings on the Web | Saylor Academy

Home Specialization Programs Help

Read this summary report for an IT Systems analyst. Familiarize yourself with the knowledge, skills, abilities, and education level organizations look for when seeking to hire IT systems analysts.

Course Introduction

Course Syllabus

Unit 1: Introduction to Data Management

1.1: Data Management

Data and Databases

1.1.1: Data Lifecycle Management

Research Data Management 101

1.1.2: Value within Data Management

Data Governance

1.1.3: Research Data

Managing Research Data

Basics of Research Data Management

1.2: Data Management Plans

Data Management Planning

Data Management Plans

1.3: Data Management Careers

The Evolving Role of the Data Architect

1.3.1: Data Consultant

Data Consultants and Architects

1.3.2: Operations Analyst

Operations Analysts

1.3.3: IT Systems Analyst

IT Systems Analysts

1.3.4: Database Administrator

Database Administrator

Unit 1 Study Resources

Unit 1 Review Video

Study Guide: Unit 1

Unit 1 Assessment

Unit 1 Assessment

Unit 2: Understanding Databases and DBMSes

2.1.1: Database Design and terms

Database Systems Concepts

2.1.2: Database Software

Characteristics and Benefits of a Database

2.1.3: Data Administration

O*NET Online Summary Report for Database Administrators.

2.2.1: The Essentials

Introduction to Database Management System (DBMS)

2.2.2: How Organizations Use DBMS

Combining Data Management with Organizational Change

Unit 2 Study Resources

Unit 2 Review Video

Study Guide: Unit 2

Unit 2 Assessment

Unit 2 Assessment

Unit 3: Data Models

3.1: Types of Data Models

Data Modeling

Types of Data Models

Data Modeling and Metadata Management

3.1.1: Conceptual Models

Data Modelling

3.1.2: Logical Models

Types of Data Models

3.1.3: Physical Models

Physical Data Models

3.2: Data Model Advantages and Disadvantages

Lessons in Data Modeling

What are the Advantages of a Relationship Model?

3.3: The Enhanced E-R Model and Business Rules

The Entity-Relationship Model

Business Rules

3.3.1: Supertypes and Subtypes

The Enhanced Entity-Relationship Model

3.3.2: How Business Rules are Used

Integrity Rules and Constraints

3.4: Database Security

Database Security

Unit 3 Study Resources

Unit 3 Review Video

Study Guide: Unit 3

Unit 3 Assessment

Unit 3 Assessment

Unit 4: Big Data Processing and Cloud Computing

4.1: Big Data

Introduction to Big Data

4.1.1: Big Data Storage

Infrastructure for Big Data

4.1.2: Big Data Analytics