Student? Switch to our Career Center Site →
Contact Us

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.
Select Class Date
Course Details

Price:

Days:

0.5

Location:

Virtual

Course Overview

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.
  • Scroll right to view Objectives, Prerequisites, and Agenda

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
Select Class Date
Class Dates & Times
Filters Sort results
Reset Apply
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.