IT Academy Enterprise Systems
IBM AIX BASICS (40 Hours) WITAC 3065
This course will cover the basics of the AIX operating system. After completion students should be able to use common AIX commands and utilities, manage files and directories, write simple shell scripts and customize the AIX environment.
- Intro to AIX
- Using the system
- AIX documentation
- Working with files and directories
- Using files
- File permissions
- The vi editor
- Shell basics
- Using shell variables
- Controlling processes
- Customizing the environment
- AIX utilities
- Additional shell features
- Graphical User Interface
SERVER+ CERTIFICATION (40 HRS) WITAC 2017
This course is for IT Professionals such as PC, desktop, and helpdesk technicians who have experience supporting PC hardware who wish to make the transition to become server hardware and support specialists. This course is also designed for existing server managers who are preparing to take the CompTIA Server + Exam SK0-004.
Tuition $750 (test voucher included), Text: Logical Operations, CompTIA Server + (Exam SK0-004), ISBN# 093007S (Rev 0.95)
SK0-004 for CompTIA Server+ Certification
Certification Information at www.comptia.org
LINUX+ CERTIFICATION (72 HRS) WITAC 2600
CompTIA Linux+ validates the fundamental knowledge and skills required of a Linux Administrator. The course will cover system architecture, GNU and UNIX commands, user interfaces and desktops, Linux installation and package management. Students who take this course and the certification test will also attain the LPIC-1 certification. Prerequisite: Basic computer and networking knowledge including file management in a Windows environment.
This course provides a comprehensive guide to common tasks performed by system administrators, including installation, customization, and troubleshooting. Expanded coverage of networking and security provide everything you need to hit the ground running. This course maps to the LX0-103 and LX0-104 Linux+ Powered by LPI exams.
Tuition $995 (test vouchers included), Text: CompTIA Linux+ Powered by LPI (Exams LX0-103 and LX0-104) 093005S (Rev 1.01)
LX0-103 covers system architecture; Linux Installation and package management; GNU and Unix commands; devices, Linux file systems, and file system hierarchy standards.
LX0-104 covers shells, scripting and data management; user interfaces and desktops; administrative tasks; essential system services; networking fundamentals and security.
Certification Information at www.comptia.org
The student will gain knowledge and skills of an Oracle Database Administrator. Participants will learn to install, create and administer an Oracle 11g database. You will learn to configure the database for an application, employ basic monitoring procedures, implement backup and recovery strategy and move data between databases and files. Students should have knowledge in reading and writing simple and complex SQL statements and techniques. This course prepares students for jobs in which database administration will be their main area of responsibility, or work in environments in which databases are central to their job roles. The course will help prepare the student for Oracle Certification.
- Oracle Database Architecture.
- Installing and creating Oracle Databases.
- Managing an Oracle Instance & Storage Structures.
- Administering User Security.
- Managing Schema Objects, Data & Concurrency.
- Introduction to Performance Management.
- Introduction to Flashback & SQL Loader.
- Introduction to Backup & Recovery procedures.
Textbook: OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052)
This course will introduce students to the Information Technology Infrastructure Library (ITIL); cover the history of service strategy and frameworks; and review the ITIL five core publications.
Students who successfully complete this course will be able to, at a minimum:
- Identify and use the common terminology introduced in ITIL
- Develop processes using ITIL concepts
- Implement and/or improve a service management process
- Will be able to successfully design and implement a service catalog
- Understand and document the life-cycle of a service
SECTION 1 - INTRODUCTION
- Introduction to best practices and operational frameworks: ITIL, Cobit, MOF, CMMI, etc.
- Concepts of IT service management
- The service lifecycle
- The five core publications/concepts
- Key concepts, terms and definitions
SECTION 2 – SERVICE STRATEGY
- Value creation
- Resources and Capabilities
- Developing a strategy
- Service Portfolio
- Financial Management
- Business Relationship
SECTION 3 – SERVICE DESIGN
- Design Process – the 4 P’s
- Service Catalog
- Capacity, Availability, Expectations
- Vendor Relationships
SECTION 4 – SERVICE TRANSITION
- Transition Concepts
- Transition Process
- Change Management
- Configuration Management
- Release and Deployment Management
- Retiring a service
SECTION 5 – SERVICE OPERATION
- Incidents, Events, Problems
- Help Desk/Tickets/Reporting
- Issues vs Requests
- New vs existing
- Knowledge Management
SECTION 6 – CONTINUOUS SERVICE IMPROVEMENT
- Models and Strategies
- Measurements and Metrics
- Risk management
- Continual Improvement
- After Action Reviews
SECTION 7 – PUTTING IT ALL TOGETHER
- The big picture
- Theory vs real world
- What’s Next
Text: The Visible Ops Handbook: Implementing ITIL in 4 Practical and Auditable Steps, ISBN-13: 978-0975568613 and Itil® Foundation Complete Certification Kit - Study Book and eLearning Program - 4th edition, ISBN-13: 978-1743331361.
RED HAT LINUX WITAC 2601
This class is devoted to the Red Hat Enterprise Linux operating system and the Red Hat Certified System Administrator certification test. The course will cover the various topics associated with the Red Hat Linux Operating System. Testing objectives including but not limited to Linux commands, configuration of users & groups, file system management & rights, deploy virtual machines, operating system security, manage firewall settings, package installation & management, networking, and troubleshooting. Upon completion of this course students the will be prepared to take the RHCSA certification test.
Text: Red Hat RHCSA/RHCE 7 Cert Guide: Red Hat Enterprise Linux 7 (EX200 and EX300) (Certification Guide) 1st Edition, ISBN# 978-0789754059
VMWARE CERTIFIED PROFESSIONAL (72 HOURS) WITAC 2201
This course provides the knowledge and skills needed to build and operate multiple VMware ESXi servers in a VMware cluster environment. Topics covered include: Virtualization Concepts, Server Configuration, Virtual Machine Management, Networking, Performance Monitoring, and more. This course also includes interactive simulations designed to reinforce many of the lessons learned.
As the demand for IT professionals with datacenter virtualization skills increases, it is essential to distinguish yourself in the market with a certification that validates your technical capabilities. Becoming a VMware Certified Professional does just that.
This industry-recognized certification requires completion of a VMware-authorized training course and hands-on experience with VMware technologies. Achieving the VCP certification confirms that you have the education needed to successfully install, deploy, scale and manage VMware vSphere environments, as well as the skills obtained by a minimum of six months experience with VMware infrastructure technologies.
IN THIS VMWARE-AUTHORIZED COURSE YOU WILL LEARN:
- Virtualization Concepts
- Virtualization Host Configuration
- VMWare Cluster configuration and operation
- Virtual Machine Management, Networking, Performance Monitoring, and more.
- Configure and manage ESXi networking and storage
- Using vCenter Server
- Deploy and manage virtual machines
- Install and configure ESXi
- Install and configure vCenter Server
- Monitor resource usage using vCenter Server
- Apply patches using VMware vCenter Update Manager
- Manage user access to the VMware infrastructure
- Increase scalability using vCenter Server
- Manage higher availability and data protection using vCenter Server
This course also includes interactive simulations designed to reinforce many of the lessons learned.
The course will present the configuration and management of a robust / full HA/Drs ESXi cluster with SAN technology.
For more information VMware Certified Professional Certification click on the link below:
Textbook: Sets are only available at the College Book Store and are subject to change by VMware. VMware IT Academy vSphere: Install, Configure, Manage [V6] - English eKit. Current Student Kit Part # EDU-EN-VSICM6-SE-KIT.
AFTER COMPLETING THIS COURSE, STUDENTS WILL BE ABLE TO
- Plan and install SQL Server.
- Describes the system databases, the physical structure of databases and the most common configuration options related to them.
- Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
- Create SQL Server Backups.
- Restore SQL Server databases.
- Use the import/export wizards and explain how they relate to SSIS.
- Work with SQL Server security models, logins and users.
- Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
- Work with permissions and the assignment of permissions.
- Work with SQL Server Audit.
- Work with SQL Server Agent, jobs and job history.
- Implement SQL Server agent security, proxy accounts and credentials.
- Configure database mail, alerts and notifications.
- Create database maintenance plans.
- Work with SQL Profiler and SQL Trace stored procedures.
- Introduce DMVs and the configuration of data collection.
- Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
- Troubleshoot SQL Server databases.
Text: Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases (Microsoft Press Training Kit), ISBN 978-0-73566607-8.
PLAN BUSINESS INTELLIGENCE (BI) INFRASTRUCTURE
- Plan for performance
- Optimize batch procedures: extract, transform, load (ETL) in SQL Server Integration Services (SSIS)/SQL and processing phase in Analysis Services; configure Proactive Caching within SQL Server Analysis Services (SSAS) for different scenarios; understand performance consequences of Unified Dimension Model (UDM) and Data Warehouse (DWH) design; analyze and optimize performances of Multidimensional Expression (MDX) and Data Analysis Expression (DAX) queries; optimize queries for huge data sets; understand the difference between partitioning for load performance versus query performance in SSAS; appropriately index a fact table; optimize Analysis Services cubes in UDM; create aggregations using Usaged Based Optimizations
- Plan for scalability
- Multidimensional OLAP (MOLAP); Relational OLAP (ROLAP); Hybrid OLAP (HOLAP)
- Plan and manage upgrades
- Plan change management for a BI solution
- Maintain server health
- Design an automation strategy
DESIGN BI INFRASTRUCTURE
- Design a security strategy
- Configure security and impersonation between database, analysis services and frontend; implement Dynamic Dimension Security within a cube; configure security for an extranet environment; configure Kerberos security; skills in authentication mechanisms, ability to build secure solutions end to end; design security roles for calculated measures; understand the tradeoffs between regular SSAS security and dynamic security; plan and implement security requirements of a BI solution
- Design a SQL partitioning strategy
- Choose the proper partitioning strategy for the data warehouse and cube; implement a parallel load to fact tables by using partition switching; use data compression in fact tables
- Design a backup strategy
- Design a High Availability (HA) and Disaster Recovery (DR) trategy; proactively prevent issues
- Design a logging and auditing strategy
- Design a new SSIS logging infrastructure (for example, information available through the catalog views); validate data is balancing and reconciling correctly
DESIGN A REPORTING SOLUTION
- Design a Reporting Services dataset
- Data query parameters; creating appropriate SQL queries for an application (MDX queries); managing data rights and security; extracting data from analysis services; balancing query-based processing versus filter-based processing; managing data sets through the use of stored procedures
- Manage Excel Services/reporting for SharePoint
- Configure data refresh schedules for PowerPivot published to SharePoint; publish BI info to SharePoint; use SharePoint to accomplish BI administrative tasks
- Design a data acquisition strategy
- Identify the data sources that need to be used to pull in the data; determine the changes (incremental data) in the data source (time window); identify the relationship and dependencies between the data sources; determine who can access which data; what data can be retained for how long (regulatory compliance, data archiving, aging); design a data movement strategy; profile source data
- Plan and manage reporting services configuration
- Native mode
- Design BI reporting solution architecture
- Linked reports, drill-down reports, drill-through reports, migration strategies, access report services API, sub reports, code-behind strategies; identify when to use Reporting Services, Report Builder, or Crescent; design/implement context transfer when interlinking all types of reports (RS, RB, Crescent, Excel, PowerPivot); implement BI tools for reporting in SharePoint (Excel Services versus Performance Point versus Reporting Services); select a subscription strategy
DESIGN BI DATA MODELS
- Design the data warehouse
- Design a data model that is optimized for reporting; design and build a cube on top; design enterprise data warehouse (EDW) and OLAP cubes; choose between natural keys and surrogate keys when designing the data warehouse; use the facilities available in SQL Server to design, implement and maintain a data warehouse (partitioning, slowly changing dimensions (SCD), change data capture (CDC), Clustered Index Views, etc.); identify design best practices; implement a many to many relationship in an OLAP cube; design a data mart/warehouse in reverse from an Analysis Services cube (or empty Analysis Services cube that was created referring requirements); use rowstamp in the data warehouse; choose between performing aggregation operations in the SSIS pipeline or the relational engine; select surround architecture
- Design a schema
- Multidimensional modeling starting from a star schema; relational modeling for a Data Mart; choose or create a topology
- Design cube architecture
- Produce efficient aggregated cubes; partition cubes and build aggregation strategies for the separate partitions; design a data model; choose the proper partitioning strategy for the data warehouse and cube; design the data file layout for a data warehouse keeping maximum performance in mind; given a requirement, identify the aggregation method that should be selected for a measure in a MOLAP cube; design cube aggregations to maintain a balance between storage and performance; performance tune a MOLAP cube using aggregations; design a data source view; cube drill-through and write back actions
- Design fact tables
- Design a data warehouse that supports many to many dimensions with factless fact tables
- Design BI semantic models
- Plan for a multidimensional cube; write a UDM model with many to many (this is related to MDX/BISM code, but it is a good example for exercises); choose between UDM and BISM depending on the type of data and workload
- Design and create MDX calculations
- MDX authoring; identify the structures of MDX and the common functions (tuples, sets, topcount, SCOPE etc.); identify which MDX statement would return the required result (single result and multiple MDX options provided to test taker); implement a custom MDX or logical solution for a pre-prepared case task
DESIGN AN ETL SOLUTION
- Design SSIS package execution
- Using new project deployment model; passing values at execution time; share parameters between packages
- Plan to deploy SSIS solutions
- Deploy the package to another server with different security requirements; secure integration services packages that are deployed at the file system; demonstrate awareness of SSIS packages/projects and how they interact with environments; decide between performing aggregation operations in the SSIS pipeline or the relational engine
- Design package configurations for SSIS packages
- Avoid repeating configuration information entered in SSIS packages and use configuration files
Pro SQL Server 2012 BI Solutions Paperback by Randal Root (Author), Caryn Mason (Author)
ISBN-13: 978-1430234883 ISBN-10: 1430234881 Edition: 1st
Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This instructor-led course focuses on teaching you how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps you to prepare for exam 70-463.
- Implementing a data warehouse.
- Developing SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL).
- Enforcing data integrity by using Master Data Services.
- Cleansing data by using Data Quality Services.
AFTER COMPLETING THIS COURSE, STUDENTS WILL BE ABLE TO
- Describe data warehouse concepts and architecture considerations.
- Select an appropriate hardware platform for a data warehouse.
- Design and implement a data warehouse.
- Implement Data Flow in an SSIS Package.
- Implement Control Flow in an SSIS Package.
- Debug and Troubleshoot SSIS packages.
- Implement an SSIS solution that supports incremental data warehouse loads and changing data.
- Integrate cloud data into a data warehouse ecosystem infrastructure.
- Implement data cleansing by using Microsoft Data Quality Services.
- Implement Master Data Services to enforce data integrity.
- Extend SSIS with custom scripts and components.
- Deploy and Configure SSIS packages.
- Describe how information workers can consume data from the data warehouse.
Text: Implementing a Data Warehouse with Microsoft SQL Server 2012 (Microsoft Press Training Kit), ISBN# 978-0-7356-6609-2.
Introduction to SQL - T-SQL Fundamentals WITAC 2500
This course is designed to introduce the student to the concepts involved in designing and using a database management system. Topics to be considered in the course will include discussion of various types of database structures, manipulations of a database structure through applications, query techniques, and an investigation into a database SQL language. The SQL language, querying and modifying data, indexing, optimization of data, joins and user defined functions (UDF) will be explored.
You will be introduced to the concepts involved in designing and using a database management system. Learn key concepts – the basics structures of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques.
- Course Overview
- A Brief History of SQL
- SQL and Database Management
- Relational Databases
- Compare MS Access and SQL Server
- Overview of Structured Query Language (SQL) / T-SQL
- Overview Microsoft SQL Server 2008 database
- Lab I - Install and configure Microsoft SQL Server 2008
- SQL Basics
- Retrieving Data – Simple Queries
- Lab II – Simple Queries (SELECT, DISTINCT, WHERE, etc…)
- Multi-Table Queries – JOINS
- Summary Queries
- Sub-queries and Query Expressions
- Lab III – Retrieving Data
- Data Manipulation Language (DML)
- Adding Data to the Database (INSERT)
- Deleting Data from the Database (DELETE)
- Modifying Data in the Database (UPDATE)
- Lab IV – Data Manipulation Language
- Data Integrity
- Entity Integrity
- Referential Integrity
- Advanced Constraints
- Business Rules
- Lab V – Integrity Management
- Transaction Management
- Transaction and Multi-user processing
- Lab VI – Transaction Management
- Creating Database – Microsoft SQL Server
- Data Definition Language (DDL)
- Lab VII – Data Definition Language
- SQL Security concepts
- Views and SQL Security (GRANT / REVOKE)
- Lab VIII – Views and SQL Security
- Data Control Language (DCL)
- User Defined Functions – UDF
- Lab IX – DCL and Managing other database objects
- System Catalog
- Table / Column / View Information
- Relationship / User / Privileges Information
- Other catalog information
- Lab X – System catalog
- Dynamic SQL
- Limitations of Static SQL
- Dynamic SQL Concepts
- SQL Today
- Database processing and Stored procedures
- SQL and Data Warehousing
- SQL Networking and Distributed Databases
- SQL and Objects
- SQL Future
- Microsoft Transact SQL specifics and next steps
- Course Review - Open Discussion
Textbook: Microsoft SQL Server 2012 T-SQL Fundamentals, ISBN # 978-0-7356-58141
Querying Microsoft SQL Server 2012 WITAC 2513
This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare students for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
AFTER COMPLETING THIS COURSE, YOU WILL BE ABLE TO:
- Write SELECT queries
- Query multiple tables
- Use built-in functions
- Use subqueries
- Execute stored procedures
- Use set operators
- Implement error handling
- Implement transactions
- Use table expressions
- Sort and filter data
- Use window ranking, offset and aggregate functions
- Query SQL Server metadata
- Program with T-SQL
- Improve query performance
Textbook: Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (Microsoft Press Training Kit), ISBN #978-0-7356-6605-4.