IT Academy Networks, Servers + Operating 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
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.
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.
Introductory courses are for:
- Anyone who is looking to start or change their career
- IT Professionals who need to update their skills
- Business professionals looking to re-skill their workforce
These are foundational and fundamental courses required to achieve those goals.
Learn more about the Cisco Networking Academy - Workforce Training and Employability (YouTube video)
CCNA – Cisco Certified Networking Associate
Cisco Certified Network Associate (CCNA®) validates the ability to install, configure, operate, and troubleshoot medium-size route and switched networks, including implementation and verification of connections to remote sites in a WAN. CCNA curriculum includes basic mitigation of security threats, introduction to wireless networking concepts and terminology, and performance-based skills. This new curriculum also includes (but is not limited to) the use of these protocols: IP, Enhanced Interior Gateway Routing Protocol (EIGRP), Serial Line Interface Protocol Frame Relay, Routing Information Protocol Version 2 (RIPv2), VLANs, Ethernet, access control lists (ACLs).
Cisco Certified Network Associate Security (CCNA® Security) validates associate-level knowledge and skills required to secure Cisco networks. With a CCNA Security certification, a network professional demonstrates the skills required to develop a security infrastructure, recognize threats and vulnerabilities to networks, and mitigate security threats. The CCNA Security curriculum emphasizes core security technologies, the installation, troubleshooting and monitoring of network devices to maintain integrity, confidentiality, and availability of data and devices, and competency in the technologies that Cisco uses in its security structure.
Authorized discounts (vouchers) are available to students and instructors who receive a score of 75% or higher on the FIRST attempt of the final exam in a qualifying course: CCNA Security, CCNA R&S Routing and Switching Essentials, and CCNA R&S Connecting Networks. Vouchers for certification exam discounts must be used within three months of becoming eligible and require up to a 14-day processing time. Please request your voucher as soon as you are eligible.
Before starting, please verify that your name and email address in your NetAcad profile are accurate. Clicking on your name in the top navigation bar and select 'My Profile'. It is critical for your email address be an account you will have access to until after you take your certification exam, since this is how exam details are communicated to you.
- Log in to www.netacad.com.
- Click your name in the top navigation bar and select ‘Discount Vouchers’.
- Click the ‘Request’ button on any voucher with status Eligible.
- Enter the required information and submit the form.
- In about 8 days, you will receive a verification email and an account activation email. Please follow the instructions in these emails.
- 2-4 days after verifying your email, you will receive a Cisco exam discount information and authorization to test email.
Track the status of your voucher request by returning to the "Discount Vouchers' page at any time. For more information, please refer to the Step-by-Step Guide to Registering for a Certification Exam.
CCNA MODULE 1: INTRODUCTION TO NETWORKS WITAC 1051
This first module introduces the student to networking, configuring a network operating system, networking protocols and communications, network access, ethernet, network layers, transport layer, IP Addressing, Subnetting IP Networks, Application Layer, and keeping the network safe.
Text for course: Introduction to Networks Companion Guide v5.1 1st Edition ISBN-13: 978-1587133572.
The second module will introduce swiched networks, basic switching concepts and configuration, VLAN's, Routing Concepts, Inter-VLAN Routing, Static Routing, Routing Dynamically, Single-Area OSPF, Access Control List, DHCP, and Network Address Translation for IPv4.
This course provides a foundation for additional CISCO Academy courses and the preparation for the CCENT and CCNA Routing and Switching certifications.
Text: Routing and Switching Essentials ISBN# 978-1-58713-318-3.
CCNA MODULE 3: SCALING NETWORKS WITAC 1053
As a business grows, so do its networking requirements. Businesses reply on the network infrastructure to provide mission-critical services. Network outages can result in lost revenue and lost customers. Network designers must design and build an enterprise network that is scalable and highly available.
Effective network design implementation requires a solid understanding of the current state of recommended network models and their ability to scale as the network grows.
This course will teach the hierarchical model to enhance the design process.
Text: Scaling Networks ISBN# 978-1-58713-328-2.
CCNA MODULE 4: CONNECTING NETWORKS WITAC 1054
The fourth and final module leading to the Cisco Certified Network Associate (CCNA) certification covers Hierachical Network Designs, Connecting to the WAN, Point-to-Point Connections, Frame Relay, Network Address Translation for IPv4, Broadband Solutions, Securing Site-to-Site Connectivity, Monitoring the Network, Troubleshoot the Network.
Text: Accessing the Connecting Networks, ISBN# 978-1-58713-332-9.
CCNA SECURITY WITAC 1024
CCNA Security prepares you to design, implement, and support security for networked devices. The 70 hour course builds on the first 2 CCNA Routing & Switching courses and prepares you for Cisco Security certification. Add a security specialty to your CCNA networking skills and expand your career opportunities.
- Develop a working knowledge of network security principles, tools, and configurations.
- Study with an instructor in the classroom and access expert content online anytime.
- Practice what you learn using both real equipment and Cisco Packet Tracer, a network configuration simulation tool.
- Get immediate feedback on your work through built-in quizzes and tests.
- Prepare for the workplace with collaborative projects and presentations.
- Connect with the global Cisco Networking Academy community.
- As people, process, data, and things become more connected, the demand for security professionals is rapidly increasing. CCNA Security curriculum builds the skills you need to get hired and succeed in jobs related to network security. Recognized by the U.S. National Security Agency (NSA) and the Committee on National Security Systems (CNSS) to meet the CNSS 4011 training standard.
- Career pathways include: network security specialist, security administrator, network security engineer, information security professionals, and more.
- Certification: CCNA Security
About Instructor-led Courses
- Cisco Networking Academy partners with educational providers to deliver on-site, instructor-led learning experiences. Cisco Networking Academy is an IT skills and career building development program for learning institutions and individuals worldwide. We've prepared more than 6 million people to join the IT workforce since 1997.
- Can you think like a hacker? A security specialist has to stay up-to-date on technology and discover weak spots before someone else does. They enjoy solving complex problems, and are able to document and communicate about their work.
- Job Titles: Security Administrator (infrastructure, data, and applications), Network Security Architect, Network Security Engineer, Network Security Specialist
Total course hours: 70
Text:CCNA Security Course Booklet Version 2 (Course Booklets) 1st Edition ISBN#978-1587133510
NETWORK+ CERTIFICATION (72 HRS) WITAC 1005
Network technicians need to be certified in order to advance in the industry. A certified technician has a much better chance of finding work in the industry. Whether you're looking to upgrade your skills, advance your career, or start a career in networking, the Network+ certification course is for you. Prerequisite: Basic computer and networking knowledge including file management in a Windows environment.
This course is designed to provide you with the foundation-level skills you need to install, operate, manage, maintain, and troubleshoot a corporate network. This course will help prepare you for the CompTIA Network+ N10-006 certification exam. Remember that a course alone cannot prepare you for any CompTIA exam. It is important that you have the recommended work experience in IT networking prior to taking the exam. For the CompTIA Network+ N10-006 certification, CompTIA recommends you have CompTIA A+ certification, or equivalent experience, and 9 to 12 months of hands-on experience in IT networking.
Tuition $995 (test voucher included), Text: CompTIA Network+ N10-006 Cert Guide, ISBN# 978-0789754080
N10-006 for CompTIA Network+ Certification
Certification Information at www.comptia.org
Microsoft Windows Server 2012 Certification Courses
MCSA: Windows Server 2012 Solutions Associate
Show that you have the primary set of Windows Server 2012 skills, relevant across multiple solution areas in a business environment, to reduce IT costs and deliver more business value. (New to IT? Learn about MTA certification for new entrants.)
Earning an MCSA: Windows Server 2012 certification will qualify you for a position as a network or computer systems administrator or a computer support specialist.
- Configuring Advanced Windows Server 2012 Services