CyberSAFE: End User Security

Welcome to CyberSAFE: Exam CBS-410. Regardless of your computer experience, this class will help you become more aware of technology-related risks and what you can do to protect yourself and your organization from them.

Course Details

Price:

Days:

0.5

Location:

Virtual

Course Overview

Identify security compliance measures. Address social engineering attempts. Secure devices like desktops, laptops, smartphones, and more. Use the Internet securely.

To ensure your success in this course, you should have experience with the basic use of conventional computing technology, including desktop, laptop, or tablet computers; mobile phones; and basic Internet functions, such as web browsing and email.

Module 1: SSIS Overview

Import/Export Wizard and Exporting Data
Common Import Concerns and Quality Checking Data

Module 2: Working with Solutions and Projects

SQL Server Data Tools Overview
Understanding Solutions, Projects, and Visual Studio Interface

Module 3: Basic Control Flow

Working with Tasks, Precedence Constraints, and Connection Managers
Annotating, Grouping, and Managing Package/Task Properties
Favorite Tasks for Common Scenarios

Module 4: Common Tasks

Analysis Services Processing and Data Profiling
Execute Package/Process Tasks and Expression Tasks
File System, FTP, and Hadoop Tasks
Script Task Basics, Send Mail, Web Service, and XML Tasks

Module 5: Data Flow Sources, Destinations, and Transformations

Data Flow Task and SSIS Toolbox Overview
Working with Data Sources and Destinations (Databases, Flat Files, Excel)
Configuring Transformations to cleanse and shape data

Module 6: Making Packages Dynamic

Parameters (Package, Project, SQL) and Variables
Using Expressions in Tasks and Connection Managers
Post-Deployment Dynamic Configurations

Module 7: Containers

Sequence Containers, For Loops, and Foreach Loops

Module 8: Troubleshooting and Package Reliability

Error Handling: Redirecting Rows, Logging, Event Handlers
Using Breakpoints, Checkpoints, and Transactions
Managing MaximumErrorCount for Stability

Module 9: Deploying to the SSIS Catalog

Understanding the SSIS Catalog and Deployment Models
Deploying Projects, Managing Environments, and Executing Packages (SSMS, Command Line)

Module 10: Installing and Administering SSIS

Installing and Upgrading SSIS
Managing the Catalog, Built-in Reports, Logging, and Operation Histories
Automating Package Execution

Module 11: Securing the SSIS Catalog

Principals, Securables, and Permissions Management
Granting Permissions and Configuring Proxy Accounts

Class Dates & Times

No results found. Clear filters and try again?

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →