hands on, instructor-led it courses across colorado · colorado it training • 978-250-4983 hands...

Colorado IT Training • 978-250-4983 www.software-skills-training.com

Hands On, Instructor-Led IT Courses Across Colorado

Offering instructor-led courses in:

● Java, Java EE and OOAD ● SQL Programming and SQL Server ● UNIX, Linux Administration ● .NET Programming ● Web Programming ● Microsoft Windows Administration ● XML Programming

2 Colorado IT Training • 978-250-4983

We offer IT training to technology professionals in nine cities across Colorado. Our concentrated training programs pack all the critical material you need to become competent in a week or less. Classroom-based training and hands-onlabs provide the foundation for a successful training experience.

What makes our training experience successful? ● Our classroom size is kept small to provide individual attention.

● Our instructors are experts within the industry as well as in the classroom.

● Our learning environment focuses on learn-by-doing through in-depth labs.

● We provide a frequent training schedule and convenient training locations.

Effective Hands On Training

PerspectiveTask-Oriented, Cross-Platform TrainingOur courses emphasize task-oriented, not product-oriented training. Because our instructors have cross-platform knowledge and experience, you’ll get the full picture – not just how to use a particular tool, but the issues involved in using multiple tools in today’s open environments, including practical design, architecture, and coding issues.

SubstanceSmall Class Sizes, Exceptional Curriculum and CoursewareClass sizes are kept small in order to provide you with more personalized attention, more focused content, and greater access to instructors for problems and questions. We’ve built our materials and curriculum to reflect the needs of our students as they have communicated them to us.

SelectionMany Training Programs to Choose FromOur extensive offerings include introductory and advanced courses in Object Oriented Analysis and Design, .NET, Java, SQL Server, UNIX/Linux, Windows Administration, Web Programming, and more. Because we focus on advanced programming skills, you’ll find a greater selection of advanced training than at most other training centers.

QualitySkilled Instructors Who Are Professionals in Their FieldsIn addition to being seasoned professional trainers, our instructors also have many years of training and industry experience working in their respective fields. Practiced developers, software engineers, and system administrators, they understand the challenges you face in your job and have first-hand knowledge of the skills you need to succeed.

3Colorado IT Training • 978-250-4983


Discount Options

Our multi-faceted discounted training programs are designed to provide significant savings in ways that are beneficial to both IT professionals and IT departments.

For IT Training DepartmentsA team of three or four IT professionals attending the same class on the same date will receive a 10% discount. Five or more are eligible for a 15% discount.

For IT ProfessionalsNeed to take multiple courses? IT professionals who sign up for two training programs immediately receive a 23% discount. Take more training and achieve deeper discounts – up to 43% savings!

Total Savings

# of Courses Total Cost Cost Per Course Total Savings

2 $4,090 $2,045 22%

3 $5,490 $1,830 30%

4 $6,690 $1,672 36%

5 $7,790 $1,558 40%

6 $8,890 $1,482 43%


Locations

We offer a public schedule of two dozen IT training programs in nine cit-ies across Colorado. We are here to help with your training needs!

● Arvada, CO ● Aurora, CO ● Boulder, CO ● Broomfield, CO ● Colorado Springs, CO

● Englewood, CO ● Fort Collins, CO ● Lakewood, CO ● Pueblo, CO


Effective Hands On Training ��2Discount Options ��4Locations ��5Introduction to Programming ��8Learning to Program with C# ...................................................................................................................9Learning to Program with Java ...............................................................................................................10Learning to Program with VB.NET .........................................................................................................11�NET Programming ��12ASP.NET 4.5 Web Forms Programming Using C# ................................................................................13ASP.NET 4.5 Web Forms Programming Using Visual Basic.NET ........................................................14ASP.NET 4.0 Web Forms Programming Using C# ................................................................................15ASP.NET 4.0 Web Forms Programming Using Visual Basic.NET ........................................................16ASP.NET MVC Programming Using C# ..................................................................................................17ASP.NET MVC Programming Using VB.NET ..........................................................................................18Advanced MVC: Building Web Applications Using the ASP.NET Web API with C# ...........................19Advanced MVC: Building Web Applications Using the ASP.NET Web API with VB.NET ...................21Windows Forms 4.5 Programming Using C# ........................................................................................23Windows Forms 4.5 Programming Using Visual Basic.NET ................................................................24Windows Forms 4.0 Programming Using C# ........................................................................................25Windows Forms 4.0 Programming Using Visual Basic.NET ................................................................26Windows Presentation Foundation Programming Using C# .............................................................27Windows Presentation Foundation Programming Using Visual Basic.NET ......................................28WCF Programming Using C# ..................................................................................................................29WCF Programming Using VB.NET ..........................................................................................................30Advanced .NET Programming ��31Advanced .NET Framework Programming Using C# ...........................................................................32Advanced .NET Framework Programming Using VB.NET ...................................................................34Advanced Web Application Development Using ASP.NET Web Forms, C# and AJAX ......................36Advanced Web Application Development Using ASP.NET Web Forms, VB.NET and AJAX ..............37Advanced MVC: Building Web Applications Using the ASP.NET Web API with C# ...........................38Advanced MVC: Building Web Applications Using the ASP.NET Web API with VB.NET ...................40Mobile Programming - Android, iOS, Objective-C, Swift, jQuery Mobile ��42Android™ Application Development .....................................................................................................43iOS Programming for iPhone® and iPad® Applications Using Objective-C .....................................45Advanced iOS Programming for iPhone® and iPad® Applications Using Objective-C ...................46Swift Programming for iPhone and iPad Applications ........................................................................47SQL Programming, SQL Server Administration ��49SQL Programming ....................................................................................................................................50Microsoft Transact-SQL Programming ..................................................................................................51Microsoft SQL Server 2012 Administration ..........................................................................................52SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS) .....................53

Table of Contents


SQL Server 2012 Business Intelligence: Integration Services and Analysis Services .......................55Microsoft SQL Server 2014 Administration ..........................................................................................57SQL Server 2012 Business Intelligence: Integration Services and Analysis Services .......................58SQL Server 2014 Business Intelligence: Integration Services and Analysis Services .......................60SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS) .....................62SQL Server 2016 Business Intelligence: Integration Services and Analysis Services .......................64Java™, Java EE, OOAD ��65Java™ Programming.................................................................................................................................66Web Application Development Using JEE, Enterprise JavaBeans and JPA ........................................67Web Application Development Using JEE, Frameworks, Web Services and AJAX ............................69Web Application Development Using Spring, Hibernate and JPA ......................................................70Introduction to Spring 4, Spring MVC and Spring REST ......................................................................71Introduction to the Spring 4 Framework ..............................................................................................73Object Oriented Analysis & Design with UML ......................................................................................74Web Development ��75Web Site Development with HTML5/JavaScript ...................................................................................76Website Development with HTML5, CSS and Bootstrap .....................................................................77Exploiting ECMAScript 6: ........................................................................................................................79New JavaScript Features .........................................................................................................................79Developing Rich Internet Applications Using HTML5, CSS3 and jQuery ...........................................80Developing Mobile Websites with Responsive Web Design and jQuery Mobile ..............................82Developing Web Applications Using AngularJS ....................................................................................83Developing Web Applications Using Angular 2 ....................................................................................84PHP Programming ...................................................................................................................................85Node.js Web Application Development ................................................................................................86Python Programming ��87Python Programming ..............................................................................................................................88XML Programming ��89XML Programming ...................................................................................................................................90UNIX/Linux ��91UNIX/Linux Fundamentals ......................................................................................................................92Linux System Administration .................................................................................................................93SharePoint Administration and Power User ��94SharePoint 2013 Customization and Administration ..........................................................................95SharePoint 2013 Power User..................................................................................................................97Windows Administration ��98Windows Server 2012 R2 System Administration ................................................................................99Designing and Implementing Windows Server 2012 Network Infrastructure and Security ........ 100Exchange Server ��101Exchange Server 2010 System Administration ................................................................................. 102Exchange Server 2013 System Administration ................................................................................. 103Contact Us ��104


Introduction to Programming



Learning to Program with C#

Length: 5 Days • Price: $2595

Course Description: This hands on C# programming course provides an introduction to programming using the C# language. Students are introduced to the application development cycle, structure of programs, and specific language syntax. The course also contains “Thinking Like a Programmer” sections that provide students insight on how to develop common algorithms. The course covers console and file I/O, string and character manipulation, managing data using collections and fundamental object-oriented programming concepts. Error handling techniques are also emphasized. The course also introduces how to access databases using ADO.NET and illustrates how to build user interfaces using Windows Forms. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

This class is intended for non-programmers. Students who already understand fundamental structured programming and object-oriented techniques should attend either Windows Forms 4.5 Programming Using C#, ASP.NET 4.5 Programming Using C# or Windows Presentation Foundation Programming Using C# instead of this more introductory course.

Course Prerequisites: Familiarity with computers.

● Overview of Programming Concepts ● Understanding the Structure of a C#

Program ● Conditional Constructs ● Looping Constructs ● Working with Data ● Defining and Calling Subroutines ● Defining and Calling Functions ● Understanding Variable Scope ● Understanding Object-Oriented

Concepts ● Designing Classes ● Coding Properties and Methods ● Understanding the Role of Namespaces

● Understanding .NET Namespaces ● Understanding Arrays ● Declaring and Instantiating Arrays ● Passing Arrays to Methods ● Working with LINQ ● Making LINQ Queries ● Understanding the ADO.NET Object

Model ● Understanding Exception Handling ● Understanding Streams ● Working with Directories ● Working with the String Class ● Working with String Literals and Escape

Sequences

Course Overview



Course Description: This hands on Java Programming course provides an introduction to programming using the Java language. Students are introduced to the application development cycle, structure of programs, and specific language syntax. The course introduces important algorithmic constructs, string and character manipulation, dynamic memory allocation, standard I/O, and fundamental object-oriented programming concepts. The course explains the use of inheritance and polymorphism early on so the students can practice extensively in the hands on labs. Structured programming techniques and error handling are emphasized. The course includes the processing of command line arguments and environment variables so students will be able to write flexible, user-friendly programs. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

This class is intended for non-programmers. Students who already understand fundamental structured programming and object-oriented techniques should attend the Java Programming course instead of this more introductory course.


● Classes, Objects and Methods ● Conditional Constructs ● Looping Constructs ● Structured Programming Best Practices ● Purpose of Arrays ● Declaring and Instantiating Arrays ● Passing Arrays to Methods ● Controlling Access to Class Members ● Default and No-Argument Constructors ● Composition of Classes

● Superclasses and Subclasses ● Advantages of Using Inheritance ● Abstract Classes and Methods ● Concept of a Stream ● Fundamental Searching and Sorting ● Types of Exceptions ● Exception Handling Overview ● Conversion Characters ● Specifying Field Width and Precision ● Fundamentals of Characters and Strings

Course Overview

Learning to Program with Java




Course Description: This hands on VB.NET programming course provides an introduction to programming using the VB.NET language. Students are introduced to the application development cycle, structure of programs, and specific language syntax. The course also contains “Thinking Like a Programmer” sections that provide students insight on how to develop common algorithms. The course covers console and file I/O, string and character manipulation, managing data using collections and fundamental object-oriented programming concepts. Error handling techniques are also emphasized. The course also introduces how to access databases using ADO.NET and illustrates how to build user interfaces using Windows Forms. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

This class is intended for non-programmers. Students who already understand fundamental structured programming and object-oriented techniques should attend either ASP.NET 4.5 Web Forms Programming Using Visual Basic.NET, Windows Forms 4.5 Programming Using Visual Basic.NET or Windows Presentation Foundation Programming Using Visual Basic.NET instead of this more introductory course.


● Overview of Programming Concepts ● Understanding the Structure of a

VB.NET Program ● Conditional Constructs ● Looping Constructs ● Working with Data ● Defining and Calling Subroutines ● Defining and Calling Functions ● Understanding Variable Scope ● Understanding Object-Oriented

Concepts ● Designing Classes ● Coding Properties and Methods ● Understanding the Role of Namespaces

● Understanding .NET Namespaces ● Understanding Arrays ● Declaring and Instantiating Arrays ● Passing Arrays to Methods ● Working with LINQ ● Making LINQ Queries ● Understanding the ADO.NET Object Model ● Understanding Exception Handling ● Understanding Streams ● Working with Directories ● Working with the String Class ● Working with String Literals and Escape

Sequences

Course Overview

Learning to Program with VB.NET


12Colorado IT Training • 978-250-498312 Colorado IT Training • 978-250-4983

�NET Programming




Course Description: This course provides students with hands on experience using Visual Studio to create dynamic web sites with ASP.NET Web Forms and the .NET 4.5 Framework using C#. The class provides a thorough introduction to the C# programming language, including coverage of the essentials of the C# programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.

Students then learn how to leverage the power of the .NET Framework to build web user interfaces. Students learn how to build ASP.NET Web Form applications and work with a variety of ASP.NET controls, including validation controls and user controls. Students explore why state management is difficult within web sites and learn different ASP.NET techniques for managing state, including working with application, session and view state objects.

Students also learn how to use ADO.NET to interact with databases and XML files. Students learn how ASP.NET uses data binding to display data in controls such as the GridView and ListView. Students also learn how to build and interact with simple WCF SOAP Web Services.

Other topics include: using a Web.config file to control application configuration; using master pages to provide a consistent look and feel to a web site; working with cookies; reading and writing files; and deploying ASP.NET applications. Comprehensive labs provide the students with extensive experience creating and deploying dynamic ASP.NET Web Form sites.

Course Prerequisites: Knowledge of fundamental HTML syntax is helpful, but not required. Prior experience with a scripting or programming language is required.

ASP�NET 4�5 Web Forms Programming Using C#

Course Overview ● Introduction to .NET Architecture ● Creating Web Sites using Visual Studio 2012 ● C# Basic Data Types, Variables and Scoping

Rules ● Defining a C# Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (if, if/else, switch) ● Looping (while, do/while, foreach, break) ● Exception Handling ● Working with Arrays

● .NET Collections ● User-Defined Data Types ● Overview of LINQ ● Overview of Object-Oriented Programming ● Web Application Development with ASP.NET ● ASP.NET Application Structure ● Understanding the ASP.NET HTTP Pipeline ● Working with HTML and HTML5 ● Understanding the ADO.NET Object Model ● Understanding ASP.NET Data Binding ● Examining ASP.NET Data Bound Controls ● Understanding the ASP.NET Security Model ● Maintaining State within ASP.NET Applications




Course Description: This course provides students with hands on experience using Visual Studio to create dynamic web sites with ASP.NET Web Forms and the .NET 4.5 Framework using VB.NET. The class provides a thorough introduction to the VB.NET programming language, including coverage of the essentials of the VB.NET programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.


Students also learn how to use ADO.NET to interact with databases and XML files. Students learn how ASP.NET uses data binding to display data in controls such as the GridView and ListView.



ASP�NET 4�5 Web Forms Programming Using Visual Basic.NET

Course Overview ● Introduction to .NET Architecture ● The .NET Framework Base Class Library ● Using the .NET Command Line Compiler ● Using Visual Studio 2012 ● VB.NET Basic Data Types, Variables and

Scoping Rules ● Defining a VB.NET Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (If/Then, If/Then/Else,

If/Then/ElseIf, Select Case) ● Looping (Do/Loop, While, For/Next, For Each,

Exit For)

● Exception Handling ● Working with Arrays ● .NET Collections ● User-Defined Data Types ● Overview of LINQ ● Overview of Object-Oriented Programming ● Web Application Development with ASP.NET ● ASP.NET Application Structure ● Understanding the ASP.NET HTTP Pipeline ● Working with HTML and HTML5 ● Understanding the ADO.NET Object Model ● Understanding ASP.NET Data Binding ● Examining ASP.NET Data Bound Controls ● Understanding the ASP.NET Security Model ● Maintaining State within ASP.NET Applications










● Introduction to .NET Architecture ● The .NET Framework Base Class Library ● Using the .NET Command Line Compiler ● Using Visual Studio ● C# Basic Data Types, Variables and Scoping

Rules ● Defining a C# Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (if, if/else, switch) ● Looping (while, do/while, foreach, break) ● Exception Handling ● Working with Arrays ● .NET Collections

● User-Defined Data Types ● Overview of LINQ ● Web Application Development with ASP.NET ● ASP.NET Application Structure ● Creating Web Sites using Visual Studio ● Building ASP.NET Pages ● Working with Web Forms ● Global.asax ● ASP.NET Validation Controls ● Reading and Writing XML Data with a DataSet ● ASP.NET Security Models ● Data Binding ● Writing Event Handlers ● Content and Master Pages ● Overview of Web Services ● Deploying ASP.NET Applications

Course Overview



Course Description: This course provides students with hands on experience using Visual Studio to create dynamic web sites with ASP.NET Web Forms and the .NET 4.0 Framework using VB.NET. The class provides a thorough introduction to the VB.NET programming language, including coverage of the essentials of the VB.NET programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.





ASP�NET 4�0 Web Forms Programming Using Visual Basic.NET

Course Overview ● Introduction to .NET Architecture ● The .NET Framework Base Class Library ● Using the .NET Command Line Compiler ● Using Visual Studio ● VB.NET Basic Data Types, Variables and



Exit For) ● Exception Handling ● Working with Arrays

● .NET Collections ● User-Defined Data Types ● Overview of LINQ ● Web Application Development with ASP.NET ● ASP.NET Application Structure ● Creating Web Sites using Visual Studio ● Building ASP.NET Pages ● Working with Web Forms ● Global.asax ● ASP.NET Validation Controls ● Reading and Writing XML Data with a DataSet ● ASP.NET Security Models ● Data Binding ● Writing Event Handlers ● Content and Master Pages ● Overview of Web Services ● Deploying ASP.NET Applications




Course Description: This course provides students with hands on experience using Visual Studio to create dynamic web applications using the ASP.NET MVC 4 Framework and C#. The class provides a thorough introduction to the C# programming language, including coverage of the essentials of the C# programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.

Students learn how to leverage the power of the Model-View-Controller design pattern with the ASP.NET MVC Framework to separate the layers of a web application. Students will use the ASMX and Razor view engines to design a user interface. Students will learn how to build models to manage an application’s data layer using both the Entity Framework and LINQ to SQL. And students will learn how to build controllers containing action methods to manage communication between views and models.

Other topics include data scaffolding; URL routing; implementing security; using MVC and Web Forms in the same application, unit testing; and deploying ASP.NET MVC applications. Comprehensive labs provide the students with experience creating, debugging, testing and deploying dynamic ASP.NET MVC applications.


Course Overview ● Introduction to .NET Architecture ● The .NET Framework Base Class Library ● Using the .NET Command Line Compiler ● Using Visual Studio ● C# Basic Data Types, Variables and Scoping

Rules ● Defining a C# Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (if, if/else, switch) ● Looping (while, do/while, foreach, break) ● Exception Handling

● Working with Arrays ● .NET Collections ● User-Defined Data Types ● Overview of LINQ ● ASP.NET MVC Application Architecture ● Creating Controllers ● Using the ASMX View Engine ● Using the Razor View Engines ● Using Web Forms in an MVC Application ● MVC Unit Testing ● Securing MVC Applications ● Configuring an ASP.NET Application for

Deployment

ASP.NET MVC Programming Using C#








● Introduction to .NET Architecture ● Creating Web Sites using Visual Studio 2012 ● C# Basic Data Types, Variables and Scoping



Course Overview




Course Description: This course provides students with hands on experience using Visual Studio to create dynamic web applications using the ASP.NET MVC 4 Framework and VB.NET. The class provides a thorough introduction to the VB.NET programming language, including coverage of the essentials of the VB.NET programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.

Students learn how to leverage the power of the Model-View-Controller design pattern with the ASP.NET MVC Framework to separate the layers of a web application. Students will use the ASMX and Razor view engines to design a user interface. Students will learn how to build models to manage an application’s data layer using both the Entity Framework and LINQ to SQL. And students will learn how to build controllers containing action methods to manage communication between views and models.

Other topics include data scaffolding; URL routing; implementing security; using MVC and Web Forms in the same application, unit testing; and deploying ASP.NET MVC applications. Comprehensive labs provide the students with experience creating, debugging, testing and deploying dynamic ASP.NET MVC applications.





Exit For) ● Exception Handling

● Working with Arrays ● .NET Collections ● User-Defined Data Types ● Overview of LINQ ● Overview of Model-View-Controller Design

Pattern ● ASP.NET MVC Application Architecture ● Creating Controllers ● Using the ASMX View Engine ● Using the Razor View Engines ● Using Web Forms in an MVC Application ● MVC Unit Testing ● Securing MVC Applications ● Configuring an ASP.NET Application for

Deployment

ASP.NET MVC Programming Using VB.NET




Course Description: This course provides students with the skills needed to create sophisticated web applications using advanced features of ASP.NET MVC, the Entity Framework, Web API, and the popular JavaScript libraries jQuery, jQuery UI, Bootstrap and AngularJS. Students will build several ASP.NET MVC web applications using Visual Studio during the week to reinforce the skills they learn.

The course begins with an overview of ASP.NET MVC for experienced programmers and then covers the fundamentals of responsive website design. Students then learn how to use Bootstrap with MVC to make a web site responsive on devices from large desktop displays to small mobile devices.

Students will learn how to integrate jQuery into an MVC application to provide dynamic, client-side behavior. They will then learn how to use jQuery’s Ajax features to build more interactive MVC applications. Students will also learn how to use jQuery UI widgets to provide a more sophisticated user interface for their MVC views.

The course covers use of the Entity Framework to provide a data access layer for an MVC application. The Database First strategy is briefly examined before thorough coverage of the more configurable Code First strategy. Students will also learn how to use the Web API to build APIs that expose services and data via HTTP. These APIs can be used by a diverse set of clients including browsers, desktop applications and mobile devices.

The course includes coverage of Single-Page Applications. In these types of applications, the entire page is loaded in the browser after the initial request. All other interactions with the server utilize Ajax requests to update the page. The service layer is implemented with the Web API.

Additional topics include: using HTML helpers to design views; creating both inline and custom HTML helpers to encapsulate view markup; using convention-based and attribute routing to support custom routes; and use of the NuGet packages with MVC applications.

Course Prerequisites: Prior experience building ASP.NET MVC web sites. Students who are not familiar with the ASP.NET MVC or C# should take the ASP.NET MVC Programming Using C# course instead.

Advanced MVC: Building Web Applications Using the ASP.NET Web API with C#



Course Overview ● Quick Review of ASP.NET MVC ● Creating Views Using HTML Helpers ● Working with Inline and Custom Helpers ● Responsive Applications Using Bootstrap ● Using jQuery with MVC ● Adding jQuery to an MVC Layout and/or

Page ● Using Ajax to Build Interactive MVC

Applications ● Making Asynchronous Calls Using jQuery ● Using jQuery UI Widgets with MVC ● Including jQuery UI in an MVC Layout or

View

● Using Custom Routes ● Understanding RouteConfig ● Working with the Entity Framework ● Using Database First ● Generating the Context and Entity Classes ● Creating the Service Layer Using Web API ● Creating a Web API Service ● Securing and Configuring a Web API ● Using a Web API with MVC ● Building Single Page Applications with ASP.

NET MVC, Web API and AngularJS ● Working with NuGet

Advanced MVC: Building Web Applications Using the ASP.NET Web API with C# (Continued)









Course Prerequisites: Prior experience building ASP.NET MVC web sites. Students who are not familiar with the ASP.NET MVC or VB.NET should take the ASP.NET MVC Programming Using VB.NET course instead.

Advanced MVC: Building Web Applications Using the ASP.NET Web API with VB.NET






View



Advanced MVC: Building Web Applications Using the ASP.NET Web API with VB.NET (Continued)



Course Description: This course provides students with hands on experience using Visual Studio to create desktop applications using Windows Forms and the .NET 4.5 Framework using C#. The course provides a thorough introduction to the C# programming language, including coverage of the essentials of the C# programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.

Students then learn how to leverage the power of the .NET Framework to build desktop applications. Students learn how to build Windows Forms applications and use with a variety of controls to create sophisticated user interfaces. Students also learn how to use the BackgroundWorker to perform asynchronous operations.

Students also learn how to use ADO.NET to interact with databases and XML files. Students learn how Windows Forms uses data binding to display data in controls such as the DataGridView and Chart. Students also learn how to build and interact with simple WCF SOAP Web Services.

Other topics include: debugging techniques; using a .config file to control application configuration; building menus, toolbars and status bars; reading and writing files; interacting with the file system; and deploying desktop applications.

Comprehensive labs provide the students with extensive experience creating and deploying Windows Forms-based desktop applications.

Course Prerequisites: Prior programming experience is required.

Course Overview ● Introduction to .NET Architecture ● The .NET Framework Base Class Library ● Using the .NET Command Line Compiler ● Using Visual Studio 2012 ● C# Basic Data Types, Variables and Scoping

Rules ● Defining a C# Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (if, if/else, switch) ● Looping (while, do/while, foreach, break) ● Exception Handling

● Windows Forms Applications ● Understanding the ADO.NET Object Model ● Working with Windows Forms Controls ● Understanding Threading ● Working with Delegates ● Understanding ADO.NET Data Binding ● Understanding Modal vs Modeless Forms ● Working with Menus ● Working with Toolbars ● Working with Status Bars ● Working with the Windows File System ● Overview of WCF Services ● Understanding Deployment Options ● Configuring an Application for Deployment

Windows Forms 4.5 Programming Using C#











Course Overview




Course Description: This course provides students with hands on experience using Visual Studio to create desktop applications using Windows Forms and the .NET 4.5 Framework using Visual Basic.NET. The course provides a thorough introduction to the VB.NET programming language, including coverage of the essentials of the VB.NET programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.


Students learn how to use ADO.NET to interact with databases and XML files. Students learn how Windows Forms uses data binding to display data in controls such as the DataGridView and Chart. Students also learn how to build and interact with simple WCF SOAP Web Services.







Exit For)

● Exception Handling ● Windows Forms Applications ● Understanding the ADO.NET Object Model ● Working with Windows Forms Controls ● Understanding Threading ● Working with Delegates ● Understanding ADO.NET Data Binding ● Understanding Modal vs Modeless Forms ● Working with Menus ● Working with Toolbars ● Working with Status Bars ● Working with the Windows File System ● Overview of WCF Services ● Understanding Deployment Options ● Configuring an Application for Deployment

Windows Forms 4.5 Programming Using Visual Basic.NET




Course Description: This course provides students with hands on experience using Visual Studio to create desktop applications using Windows Forms and the .NET 4.0 Framework using C#. The course provides a thorough introduction to the C# programming language, including coverage of the essentials of the C# programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.


Students also learn how to use ADO.NET to interact with databases and XML files. Students learn how Windows Forms uses data binding to display data in controls such as the DataGridView and Chart. Students also learn how to build and interact with simple WCF SOAP Web Services.





Rules ● Defining a C# Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (If, If/Else, Switch) ● Looping (While, Do/While, For Each, Break) ● Exception Handling ● Working with Arrays ● .NET Collections ● User-Defined Data Types

● Overview of LINQ ● Building Applications Using Windows Forms ● Working with the .NET Charting Controls ● Using the Windows Forms Designer ● Writing Event Handlers ● Working With Controls (Text Controls, Button

Controls, List Controls, Selection Controls, Image Controls)

● ADO.NET Data Binding ● Reading/Writing Files ● Overview of Web Services ● Working with Menus, Toolbars and Status Bars ● XML and XML Schemas ● Using a .config File ● Modal and Modeless Dialogs ● .NET Deployment Options

Windows Forms 4.0 Programming Using C#











Course Overview




Course Description: This course provides students with hands on experience using Visual Studio to create desktop applications using Windows Forms and the .NET 4.0 Framework using Visual Basic.NET. The provides a thorough introduction to the VB.NET programming language, including coverage of the essentials of the VB.NET programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.


Students learn how to use ADO.NET to interact with databases and XML files. Students learn how Windows Forms uses data binding to display data in controls such as the DataGridView and Chart. Students also learn how to build and interact with simple WCF SOAP Web Services.







Exit For) ● Exception Handling ● Working with Arrays ● .NET Collections

● User-Defined Data Types ● Overview of LINQ ● Building Applications Using Windows Forms ● Working with the .NET Charting Controls ● Using the Windows Forms Designer ● Writing Event Handlers ● Working With Controls (Text Controls, Button

Controls, List Controls, Selection Controls, Image Controls)

● ADO.NET Data Binding ● Reading/Writing Files ● Overview of Web Services ● Working with Menus, Toolbars and Status Bars ● XML and XML Schemas ● Using a .config File ● Modal and Modeless Dialogs ● .NET Deployment Options

Windows Forms 4.0 Programming Using Visual Basic.NET




Course Description: This course provides students with hands on experience using Visual Studio to create Windows Presentation Foundation (WPF) applications using C#. The class provides a thorough introduction to the C# programming language, including coverage of the essentials of the C# programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.

Students then learn how to leverage the power of the .NET Framework to build WPF applications. Students learn the basics of XAML and how to use it to describe the appearance and behavior of WPF user interfaces. Students also learn how to use XAML resources to manage styles, triggers and control templates.

Students learn how use a variety of WPF controls to interact with users and manage data in multi-form applications. Students explore how to leverage the power of XAML data binding. Students also learn the basics of working with audio and images, as well as performing simple animations.

Other topics include: debugging techniques; building menus, toolbars and status bars; using the ribbon control; reading and writing files; and deploying WPF applications. Comprehensive labs and exercises provide the students with extensive experience creating and debugging WPF applications.



Rules ● Defining a C# Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (if, if/else, switch) ● Looping (while, do/while, foreach, break) ● Exception Handling ● Working with Arrays ● .NET Collections ● Types of WPF Applications ● Structure of WPF Applications

● Understanding XAML Markup ● Handling Events in XAML ● WPF User Interface Basics ● Controlling the UI’s Appearance ● Working with Transformations ● Using XAML Layout Elements ● Working with WPF Controls ● Working with Styles, Triggers and Control

Templates ● Understanding Modal vs Modeless ● Working with Menus, Toolbars and Status Bars ● Working with Sound, Images and Video ● Working with Shapes and Brushes ● Building Simple Animations ● Overview of Data Binding ● Commands and MVVM ● Understanding Deployment Options

Windows Presentation Foundation Programming Using C#











Course Overview




Course Description: This course provides students with hands on experience using Visual Studio to create Windows Presentation Foundation (WPF) applications using VB.NET. The class provides a thorough introduction to the VB.NET programming language, including coverage of the essentials of the VB.NET programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.

Students then learn how to leverage the power of the .NET Framework to build WPF applications. Students learn the basics of XAML and how to use it to describe the appearance and behavior of WPF user interfaces. Students also learn how to use XAML resources to manage styles, triggers and control templates.

Students learn how use with a variety of WPF controls to interact with users and manage data in multi-form applications. Students explore how to leverage the power of XAML data binding to build Students also learn the basics of working with audio and images, as well as performing simple animations.

Other topics include: debugging techniques; building menus, toolbars and status bars; using the ribbon control; reading and writing files; and deploying WPF applications. Comprehensive labs and exercises provide the students with extensive experience creating and debugging WPF applications.





Exit For) ● Exception Handling ● Working with Arrays ● .NET Collections ● Types of WPF Applications

● Structure of WPF Applications ● Understanding XAML Markup ● Handling Events in XAML ● WPF User Interface Basics ● Controlling the UI’s Appearance ● Working with Transformations ● Using XAML Layout Elements ● Working with WPF Controls ● Working with Styles, Triggers and Control

Templates ● Understanding Modal vs Modeless ● Working with Menus, Toolbars and Status Bars ● Working with Sound, Images and Video ● Working with Shapes and Brushes ● Building Simple Animations ● Overview of Data Binding ● Commands and MVVM ● Understanding Deployment Options

Windows Presentation Foundation Programming Using Visual Basic.NET




Course Description: This course provides students with hands on experience using Visual Studio to create service-oriented applications using Windows Communication Foundation (WCF) and C#. This class provides a thorough introduction to the C# programming language, including coverage of the essentials of the C# programming language, built in data types, operators, control structures, classes and methods. Students then learn how to leverage the power of the .NET Framework to build Web Service applications that interoperate with consumer applications including other platforms and technologies.

Students will learn how to configure addresses, bindings, and service and data contracts as well as how to use various techniques for developing endpoints to allow communication between consumer applications and the web services provider.

The course includes coverage of instance management, fault handling, and security. Students will learn how to use the WCF Routing Service for load balancing, content-based routing, and protocol bridging.

Comprehensive labs and exercises provide the students with experience creating both content server and consumer applications.


Course Overview ● Introduction to .NET Architecture ● Using the ILDASM Tool ● The .NET Framework Base Class Library ● Using the .NET Command Line Compiler ● Using Visual Studio ● C# Basic Data Types, Variables and Scoping

Rules ● Defining a C# Class ● Working with Objects ● Converting Between Types ● Operators and Expressions ● Formatting Output ● Conditional Constructs (if, if/else, switch) ● Looping (while, do/while, foreach, break) ● Exception Handling ● Working with Arrays ● .NET Collections ● User-Defined Data Types ● Overview of LINQ ● WCF Web Services Architecture

● Configuring WCF Clients ● Address Types

- Endpoint Address - Base Address - MEX (Message Exchange) Address

● Binding Selection ● Configuring Behaviors ● Consuming WCF Application Services with .NET

Applications ● Defining Service Contracts ● Data Serialization ● Contract Inheritance and Overloading ● Implementing Message Exchange Patterns ● Working with Endpoints ● Configuring Endpoints ● Fault Handling ● Securing WCF Applications

- Configuring Security on Client and Server - Managing Certificates

● WCF Routing Configuration

WCF Programming Using C#











Course Overview




Course Description: This course provides students with hands on experience using Visual Studio to create service-oriented applications using Windows Communication Foundation (WCF) and VB.NET. The class provides a thorough introduction to the VB.NET programming language, including coverage of the essentials of the VB.NET programming language, built in data types, operators, control structures, classes and methods. Students then learn how to leverage the power of the .NET Framework to build Web Service applications that interoperate with consumer applications including other platforms and technologies.

Students will learn how to configure addresses, bindings, and service and data contracts as well as how to use various techniques for developing endpoints to allow communication between consumer applications and the web services provider.

The course includes coverage of instance management, fault handling, and security. Students will learn how to use the WCF Routing Service for load balancing, content-based routing, and protocol bridging.

Comprehensive labs and exercises provide the students with experience creating both content server and consumer applications.


Course Overview ● Introduction to .NET Architecture ● Using the ILDASM Tool ● The .NET Framework Base Class Library ● Using the .NET Command Line Compiler ● Using Visual Studio ● VB.NET Basic Data Types, Variables and



Exit For) ● Exception Handling ● Working with Arrays ● .NET Collections ● User-Defined Data Types ● Overview of LINQ

● WCF Web Services Architecture ● Configuring WCF Clients ● Address Types

- Endpoint Address - Base Address - MEX (Message Exchange) Address

● Binding Selection ● Configuring Behaviors ● Consuming WCF Application Services with .NET

Applications ● Defining Service Contracts ● Data Serialization ● Contract Inheritance and Overloading ● Implementing Message Exchange Patterns ● Working with Endpoints ● Configuring Endpoints ● Fault Handling ● Securing WCF Applications

- Configuring Security on Client and Server - Managing Certificates

● WCF Routing Configuration

WCF Programming Using VB.NET



Advanced .NET Programming











Course Overview




Course Description: This hands-on course examines how to utilize advanced features of C# and the .NET Framework in order to build sophisticated, scalable, high-performing applications. The course includes coverage of features available in .NET 2.0 through .NET 4.5.

The course begins by reviewing .NET’s Common Type System, and then examines nullable types, inferred types and dynamic data. Advanced object-oriented programming topics include auto-implemented properties, inheritance, abstract classes, sealed classes, and generics, as well as how to implement many of the .NET interfaces in order to take advantage of .NET functionality.

Students learn how to use synchronous and asynchronous delegates to call methods using late binding, as well as how to use delegates to define and fire custom events and manage callbacks. The course shows how to build multithreaded applications and synchronize access to shared resources, including the Thread and ThreadPool classes as well as .NET 4.0’s Task class and the Parallel Task Library. Coverage of the new .NET 4.5 Async and Await features is included.

Students learn how to work with data in .NET’s collections, as well as how to create and use custom generic methods and collections. Database topics include how to use ADO.NET to manipulate data in databases and how advanced ADO.NET features provide support for transaction management, connection pooling, and the management of disconnected DataSets. Coverage includes how to work with XML documents and make XPath queries.

The course includes the use of LINQ to make queries of data, regardless of its location. Coverage includes using LINQ to Objects, LINQ to SQL, LINQ to DataSets and LINQ to XML, as well as how PLINQ can be used to make efficient queries on large sets of data located in memory.

Students learn about .NET’s support for n-tiered application development, including encapsulating functionality in private and shared assemblies. Students also explore how to create and consume WCF services to build distributed systems.

The course includes coverage of attributes and reflection, and how to leverage attributes and reflection to design creative, robust solutions to common design problems.

Other topics include: overriding System.Object methods; boxing and unboxing issues; when to use the String vs. StringBuilder types; working with data in other cultures (internationalization); and pattern matching using regular expressions.

Comprehensive labs provide students with extensive experience coding with Visual Studio to practice with the topics presented throughout the course.

Course Prerequisites: C# programming experience.

Advanced .NET Framework Programming Using C#






● Classes, Objects and Methods ● Conditional Constructs ● Looping Constructs ● Structured Programming Best Practices ● Purpose of Arrays ● Declaring and Instantiating Arrays ● Passing Arrays to Methods ● Controlling Access to Class Members ● Default and No-Argument Constructors ● Composition of Classes ● Superclasses and Subclasses ● Advantages of Using Inheritance ● Abstract Classes and Methods ● Concept of a Stream

● Fundamental Searching and Sorting ● Types of Exceptions ● Exception Handling Overview ● Conversion Characters ● Specifying Field Width and Precision ● Fundamentals of Characters and Strings

Course Overview



Course Overview ● Working with Types ● Value vs. Reference Types ● Defining and Using Classes ● Understanding Partial Classes ● Using Strings and StringBuilders ● Understanding .NET Collections ● Understanding Delegates ● Working with Synchronous and

Asynchronous Delegates ● Managing Data with ADO.NET ● Working with Data in Databases

● Calling Stored Procedures ● Understanding XML and XML Schemas ● Understanding LINQ ● Building LINQ Queries ● Working with Threads ● Working with the ThreadPool ● Using .NET Attributes ● Working with the Parallel Task Library ● Understanding .NET Assemblies ● Private vs. Shared Assemblies ● Understanding Reflection

Advanced .NET Framework Programming Using C# (Continued)










Course Overview




Course Description: This hands-on course examines how to utilize advanced features of VB.NET and the .NET Framework in order to build sophisticated, scalable, high-performing applications. The course includes coverage of features available in .NET 2.0 through .NET 4.5.

The course begins by reviewing .NET’s Common Type System, and then examines nullable types, inferred types and dynamic data. Advanced object-oriented programming topics include auto-implemented properties, inheritance, abstract classes, sealed classes, and generics, as well as how to implement many of the .NET interfaces in order to take advantage of .NET functionality.

Students learn how to use synchronous and asynchronous delegates to call methods using late binding, as well as how to use delegates to define and fire custom events and manage callbacks. The course shows how to build multithreaded applications and synchronize access to shared resources, including the Thread and ThreadPool classes as well as .NET 4.0’s Task class and the Parallel Task Library. Coverage of the new .NET 4.5 Async and Await features is included.

Students learn how to work with data in .NET’s collections, as well as how to create and use custom generic methods and collections. Database topics include how to use ADO.NET to manipulate data in databases and how advanced ADO.NET features provide support for transaction management, connection pooling, and the management of disconnected DataSets. Coverage includes how to work with XML documents and make XPath queries.

The course includes the use of LINQ to make queries of data, regardless of its location. Coverage includes using LINQ to Objects, LINQ to SQL, LINQ to DataSets and LINQ to XML, as well as how PLINQ can be used to make efficient queries on large sets of data located in memory.

Students learn about .NET’s support for n-tiered application development, including encapsulating functionality in private and shared assemblies. Students also explore how to create and consume WCF services to build distributed systems.

The course includes coverage of attributes and reflection, and how to leverage attributes and reflection to design creative, robust solutions to common design problems.

Other topics include: overriding System.Object methods; boxing and unboxing issues; when to use the String vs. StringBuilder types; working with data in other cultures (internationalization); and pattern matching using regular expressions.

Comprehensive labs provide students with extensive experience coding with Visual Studio to practice with the topics presented throughout the course.

Course Prerequisites: Visual Basic.NET programming experience.

Advanced .NET Framework Programming Using VB.NET








Course Overview



Course Overview ● Working with Types ● Value vs. Reference Types ● Defining and Using Classes ● Understanding Partial Classes ● Using Strings and StringBuilders ● Understanding .NET Collections ● Understanding Delegates ● Working with Synchronous and

Asynchronous Delegates ● Managing Data with ADO.NET ● Working with Data in Databases

● Calling Stored Procedures ● Understanding XML and XML Schemas ● Understanding LINQ ● Building LINQ Queries ● Working with Threads ● Working with the ThreadPool ● Using .NET Attributes ● Working with the Parallel Task Library ● Understanding .NET Assemblies ● Private vs. Shared Assemblies ● Understanding Reflection

Advanced .NET Framework Programming Using VB.NET (Continued)

Advanced Web Application Development Using ASP�NET Web Forms, C# and AJAX



Course Description: This course provides experienced ASP.NET Web Form developers with the knowledge required to effectively architect complex web-enabled applications. Upon completion, students will be able to optimize their use of ASP.NET technologies to build efficient and flexible systems.

In this course students learn how to managing the appearance of a site using CSS, themes and skins, including how to use the Profile to personalize a web site. Students also learn how to build custom controls, as well as build dashboard applications using ASP.NET Web Parts.

Coverage includes how the ASP.NET Pipeline works and how to inject custom processing using HTTP handlers and modules. The course also shows how to create and act as a consumer of WCF Web Services.

Students learn how to use both ASP.NET AJAX and jQuery to generate dynamic client-side code that enriches the experience of the user, along with techniques to improve the performance of their ASP.NET Web Sites.

Other topics include: debugging techniques; building secure web sites; designing web sites that work for different cultures (internationalization); and building accessible web sites.

Comprehensive hands-on labs provide reinforcement of the topics covered in the course and practical experience deploying solutions.

Course Prerequisites: Attendance at ASP.NET 4.5 Web Forms Programming Using C# / ASP.NET 4.0 Web Forms Programming Using C# or equivalent experience.

● Managing Site Appearance ● Personalizing Web Sites ● Working with Custom Data Types ● Building Dashboards with Web Parts ● Using the WebPartManager ● Building Custom Controls ● Understanding the HTTP Pipeline ● Creating Synchronous and Asynchronous

HTTP Handlers ● Building WCF Web Services

● Using the ASP.NET AJAX Server Controls ● Using ASP.NET AJAX to Call Web Services ● Overview of jQuery ● Implementing Asynchronous Page

Processing ● Working with Data using CultureInfo ● Building Culture-Neutral Pages ● Building Secure ASP.NET Applications ● Debugging and Tracing ASP.NET Web Site ● Building Ultra-Fast ASP.NET Web Sites

Course Overview







Course Overview



Advanced Web Application Development Using ASP.NET Web Forms, VB.NET and AJAX



Course Description: This course provides experienced ASP.NET Web Form developers with the knowledge required to effectively architect complex web-enabled applications. Upon completion, students will be able to optimize their use of ASP.NET technologies to build efficient and flexible systems.

In this course students learn how to managing the appearance of a site using CSS, themes and skins, including how to use the Profile to personalize a web site. Students also learn how to build custom controls, as well as build dashboard applications using ASP.NET Web Parts.

Coverage includes how the ASP.NET Pipeline works and how to inject custom processing using HTTP handlers and modules. The course also shows how to create and act as a consumer of WCF Web Services.

Students learn how to use both ASP.NET AJAX and jQuery to generate dynamic client-side code that enriches the experience of the user, along with techniques to improve the performance of their ASP.NET Web Sites.

Other topics include: debugging techniques; building secure web sites; designing web sites that work for different cultures (internationalization); and building accessible web sites.

Comprehensive hands-on labs provide reinforcement of the topics covered in the course and practical experience deploying solutions.

Course Prerequisites: Attendance at ASP.NET 4.5 Web Forms Programming Using Visual Basic.NET / ASP.NET 4.0 Web Forms Programming Using Visual Basic.NET or equivalent experience.

● Managing Site Appearance ● Personalizing Web Sites ● Working with Custom Data Types ● Building Dashboards with Web Parts ● Using the WebPartManager ● Building Custom Controls ● Understanding the HTTP Pipeline ● Creating Synchronous and Asynchronous

HTTP Handlers ● Building WCF Web Services

● Using the ASP.NET AJAX Server Controls ● Using ASP.NET AJAX to Call Web Services ● Overview of jQuery ● Implementing Asynchronous Page

Processing ● Working with Data using CultureInfo ● Building Culture-Neutral Pages ● Building Secure ASP.NET Applications ● Debugging and Tracing ASP.NET Web Site ● Building Ultra-Fast ASP.NET Web Sites

Course Overview










Course Overview










Course Prerequisites: Prior experience building ASP.NET MVC web sites. Students who are not familiar with the ASP.NET MVC or C# should take the ASP.NET MVC Programming Using C# course instead.

Advanced MVC: Building Web Applications Using the ASP.NET Web API with C#








Course Overview






View



Advanced MVC: Building Web Applications Using the ASP.NET Web API with C# (Continued)










Course Overview










Course Prerequisites: Prior experience building ASP.NET MVC web sites. Students who are not familiar with the ASP.NET MVC or VB.NET should take the ASP.NET MVC Programming Using VB.NET course instead.

Advanced MVC: Building Web Applications Using the ASP.NET Web API with VB.NET








Course Overview






View



Advanced MVC: Building Web Applications Using the ASP.NET Web API with VB.NET (Continued)


Mobile Programming - Android, iOS, Objective-C, Swift, jQuery Mobile




Course Description: This hands-on course conveys the fundamental skills necessary to deploy Android Apps on mobile devices such as phones and tablets. Attendees will design and build a variety of Android Apps throughout the course. Previous Java programming knowledge is not essential, but basic programming experience is required. Java code used in the exercises is fully explained.

The course emphasizes proper layout of the user interface (UI), including how to add buttons, labels, textboxes, checkboxes, images and other widgets to the UI. Students will learn how to utilize Android’s XML-based layout system, which builds the UI with containers and widgets, as well as how to set wallpapers and add menus to the UI. Students practice with dialog techniques including the display of popup messages.

Students also learn how to handle screen rotation, and how to define UIs so they can adjust for different screen sizes. The course teaches students how to accept user input from keyboards (either externally attached or from the built-in keyboard), how to use the date/time picker, and how to present users with choices using Selection Lists. Students will learn how to add tabs to the UI, as well as how to display HTML content using the built-in WebKit browser.

Students will learn how to program control of state changes in the Activity Lifecycle: active, paused, stopped or dead. For instance, since Apps often run on phones, taking a call may send an App from the active state to the paused state. Or, if battery life is low the App may be forced into the dead state. Student will learn how to manage Activities moving between these states so that Apps can, for example, save inputted data before transitioning into the dead or paused state. Also related to this is the ability for an Activity to launch Sub-Activities, which allows Apps to run processes in the background (such as downloading files).

Coverage of data storage includes best practices for storing images and files. Student will also learn how to embed SQLite databases in Apps, and then use these databases to store and retrieve any kind of data.

The course emphasizes Service Oriented Architecture (SOA), and students learn how to connect Apps to web services such as Google Maps and UPS’s package tracking API. In addition to using outside web services, the course also demonstrates how to use many of a phone or tablet’s built-in features such as the camera, location service (which determines where the device is physically located), and the Accelerometer (which determines if the device is being tilted and how fast it’s being tilted). Additional topics include how to play audio and video, and standard techniques for storage and retrieval.

Students employ the Eclipse editor and the Android Developer Tools (ADT) plugin to perform comprehensive hands on exercises throughout the course to reinforce learning and develop real competency. Various alternative App development environments are compared to Eclipse, including Flex, Air and PhoneGap. The course provides students with an introduction to a variety of Android App development resources.

Course Prerequisites: Prior experience with a scripting or programming language is required. Java skills are helpful but not required.

Android™ Application Development



Course Overview ● Creating Android Apps for Mobile Devices ● Installing and Configuring Eclipse to

Create Apps ● Creating the User Interface (UI) ● Using Containers to Control the Location

of Widgets ● The Android Input Method Framework ● Adding Traditional Application Menus to

Apps ● Displaying Context Menus When Users

Tap and Hold ● Building Apps with PhoneGap

● Using Actionbars (Toolbars For Android Apps)

● Displaying Popup Messages ● Embedding HTML Content in Apps with

WebKit ● Embedding SQLite Databases in Apps ● The Application Activity Lifecycle ● Storing Images, Strings and Arrays ● Using Pre-Compiled Java Libraries ● Built-in Android Features ● Deploying to Android Devices

Android™ Application Development (Continued)

Android is a trademark of Google Inc.


Course Description: Participants in this hands-on course will learn about and gain practice developing iOS applications for iPhone and iPad devices. Attendees will learn all the basics needed for iOS development, from installation of the Xcode editor to the Apple approval process. The Objective-C language is presented and used in hands on exercises to learn how it interacts with the hardware systems.

In hands on exercises, students will use built-in data views as well as create custom screens for data entry and presentation. Students will learn to follow Apple’s design recommendations to provide clean interfaces that appropriately size to various devices and screens.

The course includes coverage of scheduled background execution to allow code to be run when the app isn’t active and to schedule alerts to draw attention back to the app.

Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency. Students will create apps from the ground up, demonstrating the features of Objective-C and serving as an introduction to developing apps for release to the App Store.

Course Prerequisites: Prior programming experience in an object-oriented language such as Java, C# or C++.

● Installation and Configuration of iOS Development Tools

● Objective-C Language Syntax ● MVC Architecture in Practice ● The ARC System ● Usage of the Most Common Views and

View Controllers ● Storyboard Development for Multiple

Platforms

● Use of the NeXTStep Objects ● Data Persistence Using CoreData and iCloud ● Threaded Programming Support ● Service Oriented Architecture ● Web Services Support ● How to Develop Interfaces for Multiple

Platforms and Resolutions ● Views and View Controllers

Course Overview

iOS Programming for iPhone® and iPad® Applications Using Objective-C


iPad® and iPhone® are trademarks of Apple Inc., registered in the U.S. and other countries.







Course Overview




Course Description: Participants in this hands-on course will develop apps to interact with many of the hardware systems available on iPhone, iPad and iPod Touch hardware devices.

Students will learn how to use the camera and microphone for still images, videos and audio. The course includes coverage of the Core Location and Map Kit for GPS systems and the motion systems for the internal gyroscope system.

Students will learn how to save and read files for local systems and how to use the Core Data system to create local SQLite databases.

The course emphasizes Service Oriented Architecture (SOA), and students learn how iOS apps interact with Web services through request/response systems. Hands on practice includes implementing code to access a web service asynchronously using SOAP.

Attendees also learn how to develop apps incorporating iCloud support, and the requirements for sharing documents.

Comprehensive hands on exercises are integrated throughout to familiarize students with many of the hardware systems and concepts needed for iOS apps, as well as security concerns to address prior to launching iOS apps. Exercises include use of the redesigned iOS7 UI controls and many of the new features of the latest release of iOS.

Course Prerequisites: Strong experience with Objective-C programming language and basic iOS application development. The iOS Programming for iPhone and iPad Applications Using Objective-C course strongly recommended.

● iOS File Manager System ● SQLite Database Support ● Apple iCloud Storage ● Communication Using Internet Protocols ● Hardware Camera System and Image

Capturing ● Creating Apps that Use Web Services ● Using DOM and SAX Parsers ● Working with Audio and Video Systems

● Overview of the OpenAL Sound Engine ● Creating Apps that Work on iPhone and

iPad ● Creating a Simple Game Using Cocoa

Graphics ● CoreLocation Library Development ● Input and Display of GPS Information ● Core Motion for Gyroscope and

Accelerometer Systems

Course Overview

Advanced iOS Programming for iPhone® and iPad® Applications Using Objective-C


iPad® and iPhone® are trademarks of Apple Inc., registered in the U.S. and other countries.



Course Description: In this hands on Swift programming course, attendees will learn how to develop iPhone and iPad applications using the Swift programming language and the Xcode 6 Integrated Development Environment. The course emphasizes safe programming practices and introduces the MVC pattern in detail. Students are familiarized with core APIs including the Foundation and Cocoa Touch frameworks. Students will learn how to utilize Objective-C code in Swift applications in order to take advantage of the rich variety of existing APIs and frameworks. Students will learn how to save and read files for local systems and how to use the Core Data system to create local SQLite databases. Attendees also learn how to develop apps incorporating iCloud support, and the requirements for sharing documents.

Students will learn how to use built-in data views as well as create custom screens for data entry and presentation. The course presents Apple’s design recommendations for providing clean interfaces that appropriately size to various devices and screens. The course emphasizes Service Oriented Architecture (SOA), and students learn how iOS apps interact with Web services through request/response systems. Hands on practice includes implementing code to access a web service asynchronously.

Students will learn how to use the camera and microphone for still images, videos and audio. The course also includes coverage of scheduled background execution to allow code to be run when the app isn’t active and to schedule alerts to draw attention back to the app.

Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency. Students will create Swift apps from the ground up, demonstrating the features of Swift and its supporting code libraries.

Course Prerequisites: Prior programming experience in an object-oriented language such as Objective-C, Java, C# or C++.

Course Overview ● Swift Language Syntax ● Object Oriented Programming Support ● Using ARC ● String Manipulation & Pattern Matching ● Installing and Updating Xcode ● Code Development and Tracking ● Performance Testing with XCTest ● Event Driven Programming Model ● Model-View-Controller Development

Paradigm ● Common Design Patterns ● Creating Threads

● Using Threads for Asynchronous Processing ● Apple Push Notification Service (APNs) ● Apple Media Services ● Designing Views ● Apple’s UI Design Standards ● Using Generic Views and View Controllers ● Using Swift in Objective-C (Interfacing Protocols) ● Using Objective-C APIs in Swi ● Creating a Core Data Application ● Manipulating Core Data Objects ● Hardware Camera Use ● Audio and Video Systems

Swift Programming for iPhone and iPad Applications











Course Overview




Course Description: This hands-on course conveys the fundamental skills necessary to design and build responsive web sites for mobile devices such as phones and tablets. Attendees will use responsive web design (RWD) techniques such as CSS3 media queries and flexible layouts to build mobile-compatible web sites. Students will learn how to test mobile websites using emulators and simulators.

The course also provides an extensive introduction into using the jQuery Mobile Framework for building mobile-specific web sites. Students will learn how to use jQuery Mobile widgets to create forms, lists, toolbars and collapsible blocks. Students will also learn how to integrate SOA with a mobile web site including working with RSS feeds, Google Maps integration and implementing server-side data access.

Attendees will use ThemeRoller for jQuery Mobile to download existing or custom theme swatches to format the appearance of a web site. Additional topics include responding to user events, configuring jQuery Mobile defaults and using page transitions. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Course Prerequisites: Prior knowledge of HTML, CSS, JavaScript and jQuery equivalent to attending the Web Site Development With HTML/JavaScript and Developing Rich Internet Applications Using HTML5, CSS3 and jQuery courses.

Course Overview ● Creating a Responsive Website ● Using CSS3 Media Queries ● Creating Flexible Grid Layouts ● Optimizing Images and Media ● Working with the Viewport ● Using jQuery Mobile Widgets

● Configuring and Downloading the jQuery Mobile Framework

● Formatting Mobile Pages with ThemeRoller ● Reacting to Mobile Specific Events ● Integration with Web Services


Developing Mobile Websites with Responsive Web Design and jQuery Mobile


SQL Programming, SQL Server Administration



Course Description: This SQL programming training course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Extensive hands on exercises are used throughout to reinforce learning and develop real competency.

Course Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.

● Introduction to Relational Databases and SQL

● Relational Database Management Systems

● Relational Database Components ● Structured Query Language (SQL) ● Data Definition Language (DDL) ● Data Manipulation Language (DML) ● Data Control Language (DCL) ● Syntax Categories ● SQL Server Management Studio ● Designing Relational Databases ● Database Design Process ● Designing Table Structures ● Completing the Physical Model ● Creating Databases and Tables ● Creating Databases and Schemas ● Data Definition Language (DDL) ● SQL Code Editors

● Schemas on SQL Server ● Creating and Modifying Tables ● Creating Indexes ● SQL Server Indexes ● Dropping (Deleting) Objects ● Working with Records ● Data Manipulation Language (DML) ● JOIN Statements ● How Joins Work ● Using MIN() and MAX() ● Using AVG() ● Using SUM() ● Using COUNT() ● Stored Procedures and Custom Functions ● CREATE PROCEDURE Syntax ● Using IF…ELSE ● Views and Triggers ● Database Security and Transactions ● Data Control Language (DCL)

Course Overview

SQL Programming








Course Overview




Course Description: This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, predefined data types including XML, creation and use of stored procedures and user-defined functions, use of cursors and updateable views.

Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful stored procedures and views as well as complex queries and updates. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Course Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.

● Introduction to Relational Databases and SQL

● Structured Query Language (SQL) ● Data Definition Language (DDL) ● Data Manipulation Language (DML) ● Data Control Language (DCL) ● Syntax Categories ● SQL Server Management Studio ● Designing Relational Databases ● Database Design Process ● Designing Table Structures ● Completing the Physical Model ● Creating Databases and Tables ● Creating Databases and Schemas ● Data Definition Language (DDL) ● Schemas on SQL Server ● Creating and Modifying Tables ● Creating Indexes ● SQL Server Indexes ● Dropping (Deleting) Objects ● Working with Records

● Data Manipulation Language (DML) ● JOIN Statements ● Using MIN(), MAX(),AVG(),SUM() and COUNT() ● Stored Procedures and Custom Functions ● Using IF…ELSE ● Views and Triggers ● Data Control Language (DCL) ● Using Queries as Expressions ● Writing Multi-Table Joins ● Using Dynamic SQL ● Returning Aggregated Data for Analysis ● Data Types in SQL Server ● Using Functions ● Advanced Views and Stored Procedures ● Transact-SQL Statements for Script

Processing ● Working with Variables and Temporary

Tables ● Advanced Scripting Techniques ● Working with XML

Course Overview

Microsoft Transact-SQL Programming



Course Description: This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2012 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2012. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2012. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery.

Emphasis is placed on how SQL Server 2012 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. The hands-on labs provide comprehensive practice performing common administrative tasks.

Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at SQL Programming course or Microsoft Transact-SQL Programming course is highly recommended although not required.

● An Overview of SQL Server 2012 ● Configuring SQL Server 2012 ● Installing SQL Server 2012 ● Using SQL Server 2012 Management

Tools ● Monitoring Data Structures ● Creating and Configuring a Database ● Monitoring SQL Server Performance ● Optimizing SQL Server Performance

● SQL Server Security Architecture ● Automating Tasks ● Importing and Exporting Data ● Maintaining High Availability of Data ● Maintaining Data Reliability ● Choosing Appropriate Database Recovery

Model Option ● Designing a Database Recovery Plan

Course Overview

Microsoft SQL Server 2012 Administration




Course Description: This hands-on course introduces the SQL Server 2012 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students start by installing and configuring SQL Server 2012 servers that support SSRS, SSIS and SSAS. Hands-on exercises will be performed where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges.

Students learn how to group data and add subtotals and totals to reports, as well as how to add custom calculations using the built-in functions or using custom functions written in .NET. Also demonstrated are all of the data sources for reports that Reporting Services supports including: SQL Server databases, Access databases, XML files, Oracle databases, data warehouses and Analysis Services data cubes. Report Models, and how they can support end users creating ad-hoc reports, are covered and students practice with them in comprehensive hands on exercises. This includes a demonstration of Report Builder, which is a free report authoring tool from Microsoft. The course includes a complete overview of Report Server administration, including how to deploy and secure reports, how to schedule automatic report generation and delivery, how to backup reports, how to store previous copies of reports in history folders, and how to maintain and troubleshoot Report Servers.

Students also spend a full day completing hand-on exercises demonstrating Integration Services (SSIS) features, including understanding the architecture of Integration Services projects and packages, as well as how to design and implement data integration routines using SSIS. Exercises will move data between XML, Excel, flat file and database formats, and they will also demonstrate how to modify data between source and destination. Adding error handing to SSIS routines is also reviewed as well as deployment and scheduling.

The final day covers how to create data cubes using Analysis Services (SSAS), which includes an overview of data warehouse design concepts and why data cubes typically pull their data from data warehouses. Hand-on exercises are performed that create, deploy, process and connect to data cubes.


SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS)



SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS) Continued

Course Overview ● Reporting Services Architecture ● Creating Basic Reports ● Setting Up Input Parameters ● Adding Custom Report Navigation ● Adding Drill-Down for Master-Detail

Reports ● Pivoting Data with Matrix Controls ● Understanding Report Models ● Creating Reports with Report Builder ● Managing Security Roles ● Creating Snapshot Reports ● Storing Previous Versions of Reports

● Querying the Report Server ● Creating Custom Data Extensions ● Writing User-Defined Functions in .NET ● SSIS Architecture and Fundamentals ● Designing Data Integration with SSIS ● SSIS Data Transformation ● Deploying and Managing SSIS Projects ● OLAP and Data Warehouse Fundamentals ● Creating Analysis Services Cubes ● Cube Customization ● Cube Deployment and Security



Course Description: This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2012. Students will install and configure SQL Server 2012 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/SSAS.

Students work with complex SSIS data migration projects that import/export data between multiple formats including: Access, SQL Server, Oracle and other databases, XML files, Excel spreadsheets and flat files. Also demonstrated are SSIS tasks that can download from FTP Servers, copy/move files and folders, execute Win32 processes and .NET scripts, perform bulk imports, perform database maintenance, contact (via text or e-mail) administrators, and transfer database components between SQL Servers. Error handling options are also demonstrated with hands-on exercises, as well as how to use variables and input parameters in SSIS routines. The course provides thorough coverage of how to deploy, automate, secure and troubleshoot SSIS routines.

Students will learn how to use SSAS to design, build and populate data warehouses to stage data for use by data cubes, and will perform hands-on exercises to design and build a data warehouse. Advanced data warehouse concepts, such as surrogate keys and rapidly changing dimensions are also reviewed. Subsequent exercises use SSAS to create data cubes and analyze them. Cube customization options are demonstrated, including how to add Key Performance Indicators (KPIs), custom calculations, and actions that link to SSRS reports. Attendees also learn how to optimize cube performance by defining attribute relationships and custom aggregation levels.

The course also includes an overview of data mining and the tools available to do this in SSAS, supported by a hands-on exercise that walks through the process of defining a data mining structure to predict future sales. Administration topics related to data cubes are covered, including exercises that deploy and secure cubes, process and manage cubes.


SQL Server 2012 Business Intelligence: Integration Services and Analysis Services



SQL Server 2012 Business Intelligence: Integration Services and Analysis Services (Continued)

Course Overview ● Installing SQL Server Business

Intelligence Tools ● Integration Services Architecture ● Executing SQL Statements ● Merging Data from Multiple Sources ● Splitting Data to Multiple Destinations ● Using the Windows Management

Instrumentation (WMI) Tasks ● Performing Database Maintenance and

Backups During SSIS Routines ● Filling in Missing Data with Lookups ● Locating Near Duplicate Rows with Fuzzy

Grouping ● Migrating SQL Server 2000 DTS Packages ● Deploying SSIS Routines

● Manually Running SSIS Routines ● Understanding Fact and Dimension Tables ● Modeling Slowly Changing and Rapidly

Changing Dimensions ● Creating Data Warehouses (OLAP Databases) ● Creating Data Sources to Connect to Data

Warehouses ● Using SSAS to Create Cubes ● Customizing Cubes ● Cube Storage Calculations ● Securing Cubes ● Using MDX Queries to Pull Data from Cubes ● Using MDX Aggregate Functions ● Understanding the Data Mining Process ● Working with Data Mining Structures


Course Description: This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2014. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2014. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery.

Emphasis is placed on how SQL Server 2014 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.


● An Overview of SQL Server 2014 ● Configuring SQL Server 2014 ● Installing SQL Server 2014 ● Using SQL Server 2014 Management

Tools ● Monitoring Data Structures ● Creating and Configuring a Database ● Monitoring SQL Server Performance ● Optimizing SQL Server Performance

● SQL Server Security Architecture ● Automating Tasks ● Importing and Exporting Data ● Maintaining High Availability of Data ● Maintaining Data Reliability ● Choosing Appropriate Database Recovery

Model Option ● Designing a Database Recovery Plan

Course Overview

Microsoft SQL Server 2014 Administration



Course Description: This hands-on course introduces the SQL Server 2014 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students start by installing and configuring SQL Server 2014 servers that support SSRS, SSIS and SSAS. Hands-on exercises will be performed where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges.

Students learn how to group data and add subtotals and totals to reports, as well as how to add custom calculations using the built-in functions or using custom functions written in .NET. Also demonstrated are all of the data sources for reports that Reporting Services supports including: SQL Server databases, Access databases, XML files, Oracle databases, data warehouses and Analysis Services data cubes. Report Models, and how they can support end users creating ad-hoc reports, are covered and students practice with them in comprehensive hands on exercises. This includes a demonstration of Report Builder, which is a free report authoring tool from Microsoft. The course includes a complete overview of Report Server administration, including how to deploy and secure reports, how to schedule automatic report generation and delivery, how to backup reports, how to store previous copies of reports in history folders, and how to maintain and troubleshoot Report Servers.

Students also spend a full day completing hand-on exercises demonstrating Integration Services (SSIS) features, including understanding the architecture of Integration Services projects and packages, as well as how to design and implement data integration routines using SSIS. Exercises will move data between XML, Excel, flat file and database formats, and they will also demonstrate how to modify data between source and destination. Adding error handing to SSIS routines is also reviewed as well as deployment and scheduling.

The final day covers how to create data cubes using Analysis Services (SSAS), which includes an overview of data warehouse design concepts and why data cubes typically pull their data from data warehouses. Hand-on exercises are performed that create, deploy, process and connect to data cubes.










Course Overview




Course Overview ● Reporting Services Architecture ● Creating Basic Reports ● Setting Up Input Parameters ● Adding Custom Report Navigation ● Adding Drill-Down for Master-Detail

Reports ● Pivoting Data with Matrix Controls ● Understanding Report Models ● Creating Reports with Report Builder ● Managing Security Roles ● Creating Snapshot Reports ● Storing Previous Versions of Reports

● Querying the Report Server ● Creating Custom Data Extensions ● Writing User-Defined Functions in .NET ● SSIS Architecture and Fundamentals ● Designing Data Integration with SSIS ● SSIS Data Transformation ● Deploying and Managing SSIS Projects ● OLAP and Data Warehouse Fundamentals ● Creating Analysis Services Cubes ● Cube Customization ● Cube Deployment and Security










Course Overview




Course Description: This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2014. Students will install and configure SQL Server 2014 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/SSAS.

Students work with complex SSIS data migration projects that import/export data between multiple formats including: Access, SQL Server, Oracle and other databases, XML files, Excel spreadsheets and flat files. Also demonstrated are SSIS tasks that can download from FTP Servers, copy/move files and folders, execute Win32 processes and .NET scripts, perform bulk imports, perform database maintenance, contact (via text or e-mail) administrators, and transfer database components between SQL Servers. Error handling options are also demonstrated with hands-on exercises, as well as how to use variables and input parameters in SSIS routines. The course provides thorough coverage of how to deploy, automate, secure and troubleshoot SSIS routines.

Students will learn how to use SSAS to design, build and populate data warehouses to stage data for use by data cubes, and will perform hands-on exercises to design and build a data warehouse. Advanced data warehouse concepts, such as surrogate keys and rapidly changing dimensions are also reviewed. Subsequent exercises use SSAS to create data cubes and analyze them. Cube customization options are demonstrated, including how to add Key Performance Indicators (KPIs), custom calculations, and actions that link to SSRS reports. Attendees also learn how to optimize cube performance by defining attribute relationships and custom aggregation levels.

The course also includes an overview of data mining and the tools available to do this in SSAS, supported by a hands-on exercise that walks through the process of defining a data mining structure to predict future sales. Administration topics related to data cubes are covered, including exercises that deploy and secure cubes, process and manage cubes.










Course Overview




Course Overview ● Installing SQL Server Business Intelligence

Tools ● Integration Services Architecture ● Executing SQL Statements ● Merging Data from Multiple Sources ● Splitting Data to Multiple Destinations ● Using the Windows Management

Instrumentation (WMI) Tasks ● Performing Database Maintenance and

Backups During SSIS Routines ● Filling in Missing Data with Lookups ● Locating Near Duplicate Rows with Fuzzy

Grouping ● Deploying SSIS Routines ● Manually Running SSIS Routines

● Understanding Fact and Dimension Tables ● Modeling Slowly Changing and Rapidly

Changing Dimensions ● Creating Data Warehouses (OLAP Databases) ● Creating Data Sources to Connect to Data

Warehouses ● Using SSAS to Create Cubes ● Customizing Cubes ● Cube Storage Calculations ● Securing Cubes ● Using MDX Queries to Pull Data from Cubes ● Using MDX Aggregate Functions ● Understanding the Data Mining Process ● Working with Data Mining Structures



Course Description: SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements.

All reports are developed utilizing SQL Server Data Tools (SSDT), however the new 2016 Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing the newly designed charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps.

Consuming data from relational, multi-dimensional and the new tabular data sources will be incorporated into report designs. Students will become familiar with report deployment to the new Reporting Service Web Portal (replaced Report Manager) and learn how to use portal the management tools to configure report caches, snapshots and subscriptions. Instruction and practice in designing report security to insure protection of enterprise data will be provided.

The student will gain experience with the new Report Services Web portal, which enables publishing content other than paginated reports, such as Excel and Power BI. Students will also learn how to include KPIs (Key Performance Indicators) directly from a shared data set. Finally the student will apply custom branding of the Web portal.

One day is reserved for SQL Server Integration Services (SSIS). Students will learn the basics of creating SSIS packages using SQL Server Data Tools to create Extract Transform and Load solutions used to populate data warehouses and marts.

In the final day, based on a populated data warehouse they have created, students will then learn how to develop an SQL Server Analysis Services (SSAS) multidimensional (cube) model using Multidimensional Expressions (MDX) syntax. Cubes will be customized to include Key Performance Indicators (KPIs), Calculated Members, Named Sets, Navigational Hierarchies, and Perspectives. Also, a brief introduction to the SSAS Tabular module will be provided.


SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS)


SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS) Continued

Course Overview ● Reporting Services Architecture ● Creating Basic Reports ● Advanced Report Features ● Matrix Reports ● Implementing BI Semantic Model ● Report Designer

● Reporting Services Security ● Automating Report Creation and Delivery ● Adding Custom Code ● .NET Integration with Reporting Services ● Introduction to SSIS ● Introduction to SSAS



Course Description: SQL Server 2016 provides a rich environment for business intelligence development. The focus of this five day course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources.

Students will learn how to design and build data warehouses and marts using SQL Server Management Studio. In a series of exercises, students develop SSIS packages designed to maintain a data warehouse using the Data Flow control flow task. Also demonstrated are other control flow tasks that can interact with an NTFS file system, FTP server, execute Win32 processes, send emails, and run .NET scripts.

Based on the populated data warehouse they have created, students will then learn how to develop both Multidimensional and Tabular SSAS models using the languages Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX). Cubes will be customized to include Key Performance Indicators (KPIs), Calculated Members, Named Sets, Navigational Hierarchies, and Perspectives.



● Business Intelligence Framework Overview

● Integration Services Architecture ● Common SSIS Tasks ● Data Transformations ● Advanced SSIS Tasks ● Advanced Data Transformations ● SSIS Administration and Automation ● Data Warehouse Design ● Creating and Populating Data

Warehouses

● Creating and Managing Cubes ● Multidimensional (MDX) Essentials ● MDX Functions ● Customizing Cubes ● Cube Deployment and Administration ● Creating and Customizing Tabular Models ● Understanding the Data Mining Process ● Working with Data Mining Structures ● Using the Semantic Models in the

Presentation Layer

Course Overview


65Colorado IT Training • 978-250-4983 65Colorado IT Training • 978-250-4983

Java™, Java EE, OOAD








Course Overview




Course Description: This training course introduces experienced programmers to Java™ technology and Java programming techniques. The Java platform provides an object-oriented, portable and robust framework for application development. Included are core language concepts including fundamental data types, flow control, and standard function libraries. The course emphasizes object oriented programming and modular design to support distributed development environments. Included are the design of classes and objects, inheritance and polymorphism, and the details about creating programs for use on a distributed network, with emphasis on JSP, Servlets, and JDBC.The course also includes coverage of the Java Collections API, fundamental I/O, exceptions, and exception handling.

The course is designed to leverage the participants’ existing programming skills and to highlight the new and extended features of the Java programming framework as compared to other common languages. Comprehensive lab exercises provide hands on practice crucial to developing competence and confidence with the new skills being learned.

Course Prerequisites: Basic programming skills in a structured language. Knowledge and experience with Object-Oriented Design (OOD) is helpful, but not required.

● Introduction to the Java Virtual Machine (JVM)

● Installing the JDK ● Databases and JDBC ● Servlets, JSPs, and Tag Libraries ● Developing a GUI Using Swing ● Using Data Types and Operators ● Working with Flow Control Statements ● Using Java Classes and Objects ● Object-Oriented (OO) Concepts ● Inheritance ● Polymorphism ● Java SE Built-in Annotations ● Enumerated Types

● Using a Generic Class ● Basic Input and Output (I/O) ● Legacy Container Classes ● Using Collections Framework Interfaces ● Implementation Classes ● Handling Runtime Errors ● Exceptions and Exception Handling ● Enabling Assertions ● Using Streams ● Navigating the File System ● Java SE Network Capabilities ● Sending Data to a Server-Side Program ● Using Threads ● Working with Java Web Applications

Course Overview

Java™ Programming


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.


Course Description: This hands-on course provides participants with the knowledge and experience required to develop and deploy Enterprise JavaBeans, Web Services and robust JEE (Java Enterprise Edition) web applications. The Enterprise JavaBeans 3 specification is a deep overhaul of the EJB specification that improved the EJB architecture by reducing its complexity from the developer’s point of view. It leverages annotations and Object-Relational Mapping (ORM) technologies to eliminate the dependence on complex EJB APIs, allow POJO (Plain Old Java Object) based development, and provide an effective technology for creating distributed, transactional components including mapping relational data to an object schema. The EJB 3.2 release is part of the JEE 7 specification and adds additional refinements and capability.

This course covers architectural design issues as well as specific coding models for EJB3 components. It starts with the basic concepts and APIs of EJB and then continues on with complex topics such as message driven beans and transactions. Newer concepts such as the use of annotations and the use of CDI / Dependency Injection to initialize references are covered in depth. The course also includes thorough coverage of managing persistence using the Java Persistence API 2 (JPA2). Security, transaction management, inter-component communication and deployment issues are discussed in detail, with hands-on labs to solidify understanding. The course includes content on how to expose EJBs as standards-based (JAX-WS, SOAP/Http) and REST-based web services.

Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency with this complex technology. Students will come away with an understanding of the role and architecture of the most important containers in the Java EE specification: the Web Container (which hosts HTML pages, Servlets and JSP Pages) and the EJB Container (which hosts Enterprise JavaBean components).

Course Prerequisites: Java SE 5 programming experience and an understanding of object-oriented design principles. Fundamental knowledge of XML is helpful but not required.

Web Application Development Using JEE, Enterprise JavaBeans and JPA



● The features and benefits of the EJB 3 Architecture and API

● How to use EJB 3 Annotations ● Creating, deploying and using Stateful

and Stateless Session Beans ● The use of CDI (Contexts and Dependency

Injection) to initialize resources ● The use of Interceptors (Lifecycle and

Business Method) ● JNDI (Java Naming and Directory

Interface) ● Architecture and coding of EJB clients ● Deployment and Use of Message-Driven

Beans ● Distributed Transactions, the Java

Transaction API, and the EJB Transaction Model

● Practical Architectural Issues Associated with EJB Applications

● The Java Persistence API (JPA) ● The EJB Security Model ● Creating, Deploying and Using JPA

Persistent Entities ● Mapping Relational Schemas to Persistent

Entities ● Use of the EntityManager ● Java Persistence Query Language (JPQL)

syntax ● How to use Optimistic Locking and

Versioning ● Advanced JPA Capabilities ● Best Practices Associated with JPA

Applications ● AJAX Integration with Java ● Web Services Integration ● Use of JAX-WS ● Use of SOAP/Http ● Use of REST-Based Web Services

Course Overview

Web Application Development Using JEE, Enterprise JavaBeans and JPA (Continued)

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.


Course Description: This course provides students hands on experience with cutting edge Java Enterprise (Java EE) technologies, creating dynamic web and enterprise applications that utilize several Java frameworks and technologies including JSP’s and Servlets, Java Persistence API (JPA), JNDI, JDBC, AJAX, Web Services, Spring and Hibernate. The goal is to enable students to exploit the Java EE platform and accompanying frameworks to facilitate the development of distributed, web-enabled applications.

Students will architectural design issues as well as specific coding models for a variety of Java EE components. By working with several Java frameworks in hands on labs, students will build applications that incorporate many of the patterns commonly used in these and other Java frameworks. Upon completion of the course, students should be able to learn and effectively utilize frameworks appropriate for their application environment.

Starting with Java Server Pages and Servlets, the course then introduces some of the most widely used frameworks to provide concrete illustrations of the services available. Since coding and deployment files are standardized by the Java EE specifications, students may readily apply the skills learned in this class to write code for any compliant server, including Apache Tomcat, JBoss, WebSphere, Oracle, WebLogic and many others.

Students will learn how to utilize ANT, a flexible and powerful XML-based build utility, to compile, deploy and execute stand-alone and enterprise Java applications. They will also use ANT to execute standalone client applications that communicate with Java EE applications. Comprehensive hands-on lab exercises reinforce instructor lectures and build direct competence in the topics presented throughout the course.

Course Prerequisites: Java SE 5+ programming experience and an understanding of object-oriented design principles. Fundamental knowledge of XML, HTML, and JavaScript is helpful but not required. The course Java Programming or equivalent knowledge provides a solid foundation.

Web Application Development Using JEE, Frameworks, Web Services and AJAX


● Introduction to the Java EE Architecture ● Using ANT ● Servlet Classes and Interfaces ● Request and Response Objects ● Writing a Servlet ● Web Application Structure ● Introduction to Java Server Pages ● Deploying a JSP ● Communication Between Web

Components

● JSP Document Syntax ● Database Persistence with and without

Hibernate ● Designing with Spring ● Adding Spring to Existing Solutions ● AJAX Integration with Java ● Web Services in a Java Environment ● Working with AJAX Toolkits ● RESTful Web Services ● AJAX Patterns

Course Overview







Course Overview




Course Description: This course provides a comprehensive introduction to JPA (the Java Persistence API), the Spring and Hibernate open source frameworks as well as Web Services and AJAX. Suitable for both Spring3/Hibernate3 and Spring4/Hibernate4, the course includes coverage of the core Spring and Hibernate capabilities, as well as the integration capabilities provided by Spring.

This course introduces techniques for using the many new and powerful capabilities that Spring4 supports. It includes complete coverage of the three main configuration styles (@Configuration, @Component, XML), and guidelines for their usage. It also covers more advanced capabilities such as support for JDBC and persistence frameworks like Hibernate, Spring declarative transactions, and Spring integration with JEE Web technologies.

The course covers all important capabilities of the Hibernate open source object/relational persistence and query service for Java. Coverage includes developing persistent classes in Java, as well as using associations/relationships, inheritance, polymorphism, composition and collections. It also covers fundamentals of JPA (the Java Persistence API) including JPA Annotations and JPQL (Java Persistence Query Language).

Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency. Attendees build working Spring/Hibernate applications utilizing the Eclipse IDE, providing a knowledge foundation applicable to all major development environments.

Course Prerequisites: Java SE 5+ programming experience and an understanding of object-oriented design principles. Fundamental knowledge of XML, HTML, and JavaScript is helpful but not required. The course Java Programming or equivalent knowledge provides a solid foundation.

Web Application Development Using Spring, Hibernate and JPA


● The core principles of Spring and of Dependency Injection (DI)/Inversion of Control

● How to use the Spring core module and DI to configure and wire application objects (Beans) together

● How to use the different types of metadata (XML, @Component, and @Configuration)

● The complete capabilities of the core module ● Use of the ORM (Object-Relational Mapping)

module to integrate Spring with technologies such as Hibernate or JPA

● Spring’s transaction support ● Integration of Spring with Java EE Web

applications ● How to architect applications using the

Hibernate framework

● The features and benefits of Hibernate ● How to structure code using Hibernate

protocols ● How to use Hibernate Mapping to map

persistent objects to the database ● How to work with collections and associations ● How to use Hibernate’s Versioning Support ● How to Map inheritance hierarchies using

Hibernate ● How to work with Hibernate Queries, HQL, and

Criteria ● Hibernate transaction support ● The relationship between Hibernate and the

Java Persistence API (JPA) ● How to architect and code using JPA2 ● Exploiting AJAX integration ● Exploiting web services

Course Overview


Course Description: This course introduces the techniques for using the powerful capabilities of Spring 4 including the three main configuration styles: Java-based (@Configuration), annotation-based (@Component), and the traditional XML-based configuration that may still play an important role in existing and new projects. It also provides guidelines for when and how to use each one.

The course starts with in-depth coverage on using the powerful capabilities of Spring’s Core module to reduce coupling and increase the flexibility, ease of maintenance, and testing of your applications. Coverage also includes integrating persistence layers (e.g. Hibernate/JPA) with Spring, using Spring’s powerful Aspect Oriented Programming (AOP) to program cross-cutting concerns in a safe and maintainable way and using Spring’s declarative transaction capabilities.

The course includes integrating Spring with Java EE Web applications and an introduction to Spring MVC. Spring MVC utilizes a Model-View-Controller pattern for building Web applications and the intoduction covers the basics of Spring MVC and how it supports organizing your Web applications in a highly structured, loosely coupled manner. This includes an introduction to REST (Representational state transfer) and how to use Spring MVC to build RESTful resources and invoke them from Ajax-based front ends.

This course will enable you to build working Spring applications and give you an understanding of the important concepts and technology. Comprehensive hands-on labs provide reinforcement of the topics covered in the course and practical experience deploying solutions.

Students who do not require coverage of Spring MVC and RESTful Web Services may want to take the 3-day Introduction to the Spring 4 Framework class instead.

Students requiring an introduction to JEE Web Development, JDBC, JNDI, and JSP as well as Spring and Hibernate, may want to take the Programming Java EE and Frameworks: Web Application Development class instead.

Course Prerequisites: Java SE 5 programming experience and an understanding of object-oriented design principles. Fundamental knowledge of XML is helpful but not required. The course Java Programming or equivalent knowledge provides a solid foundation.

Introduction to Spring 4, Spring MVC and Spring REST



● Overview of Spring Technology ● Overview of the Spring Container ● Configuration and Usage of Dependency

Injection (DI) in Spring ● Annotation Driven Configuration ● Java Based Configuration

(@Configuration) ● Bean Scope and Lifecycle ● Creating and Using an Annotation-Based

DSL for Bean Configuration ● Overview of Spring Database Support ● Configuring a DataSource ● Using Spring with Hibernate ● Using Spring with JPA ● Overview of Aspect Oriented

Programming (AOP) ● Introduction to Spring Transaction

Management

● XML Configuration of Transactions ● Integrating Spring with Java EE Web Apps ● Using Spring Beans in Wep App Controller

Logic ● Spring Web MVC Overview ● DispatcherServlet, Configuration (@

EnableWebMvc, Servlet 3 initialization), mvc Namespace

● Reference Data with @ModelAttribute ● Forms and Binding, Spring Form Tags ● REST and Spring MVC ● @RequestMapping/@PathVariable,

@RequestBody, @ResponseBody, HTTP Method Conversion

● Returning XML and JSON Data ● Client-Side Access to RESTful Services ● Programming Common REST Patterns

Course Overview

Introduction to Spring 4, Spring MVC and Spring REST (Continued)







Course Overview




Course Description: This course introduces the techniques for using the powerful capabilities of Spring 4 including the three main configuration styles: Java-based (@Configuration), annotation-based (@Component), and the traditional XML-based configuration that may still play an important role in existing and new projects. It also provides guidelines for when and how to use each one.

The course starts with in-depth coverage on using the powerful capabilities of Spring’s Core module to reduce coupling and increase the flexibility, ease of maintenance, and testing of your applications. Coverage also includes integrating persistence layers (e.g. Hibernate/JPA) with Spring, using Spring’s powerful Aspect Oriented Programming (AOP) to program cross-cutting concerns in a safe and maintainable way and using Spring’s declarative transaction capabilities. It also covers integration of Spring with Java EE Web applications.

This course will enable you to build working Spring applications and give you an understanding of the important concepts and technology. Comprehensive hands-on labs provide reinforcement of the topics covered in the course and practical experience deploying solutions.

Students requiring an introduction to JEE Web Development, JDBC, JNDI, and JSP as well as Spring and Hibernate, may want to take the Programming Java EE and Frameworks: Web Application Development class instead.

Course Prerequisites: Java SE 5 programming experience and an understanding of object-oriented design principles. Fundamental knowledge of XML is helpful but not required. The course Java Programming or equivalent knowledge provides a solid foundation.

● Overview of Spring Technology ● Overview of the Spring Container ● Configuration and Usage of Dependency

Injection (DI) in Spring ● Annotation Driven Configuration ● Java Based Configuration

(@Configuration) ● Bean Scope and Lifecycle ● Creating and Using an Annotation-Based

DSL for Bean Configuration ● Overview of Spring Database Support

● Configuring a DataSource ● Using Spring with Hibernate ● Using Spring with JPA ● Overview of Aspect Oriented Programming

(AOP) ● Introduction to Spring Transaction

Management ● XML Configuration of Transactions ● Integrating Spring with Java EE Web Apps ● Using Spring Beans in Wep App Controller

Logic

Course Overview

Introduction to the Spring 4 Framework








Course Overview




Course Description: This OOA&D training course presents the key concepts and methodologies required to perform quality object-oriented software engineering, with particular attention to practical techniques such as use-case and CRC analysis, UML diagramming, and patterns. Students practice applying object oriented analysis during the course to improve software designs and to see how software objects can be altered to build software systems that are more robust and less expensive. Students use several methods for analyzing software systems, finding and refining useful classes and relationships between objects. Care is taken not to focus on any one language so that all students can participate in the design exercises without relying on specific programming skills.

The course emphasizes the most practical analysis and design methods, including the application of use case analysis, CRC analysis, problem domain analysis, activity diagramming, interaction diagramming, and class diagramming. The Unified Modeling Language (UML) is presented in detail and is used in the exercises and case studies. Practical aspects of project management and implementation are presented from the perspective of experienced object system designers. Special emphasis is given to the use of object patterns in developing software systems. The students apply their skills in labs that are mini design sessions, during which the instructor helps the students identify and overcome common obstacles that occur during group sessions.

Course Prerequisites: Knowledge of structured programming concepts.

● Structured vs. Object-Oriented Development

● Complexity and its Effects ● Inadequate and Unstable Requirements ● UML Notation ● OOA&D Project Methodology ● Requirements Phase Activities ● Analysis Phase Activities ● Design Phase Activities ● Characteristics of Iterative OOAD ● Conducting Productive OOAD Sessions ● Developing a High Level Use Case Model ● Adding Details to a Use Case Model ● Conceptual Class Diagrams

● Analysis Patterns ● CRC Analysis ● State Machine Diagrams ● System Operations Diagrams ● Applying Design Patterns ● Interaction Diagrams ● Communication Diagrams ● Sequence Diagrams ● Documenting a Design Using Specification

Class Diagrams ● Evaluating Object-Oriented Software

Design ● Organizing Large Scale Software

Applications

Course Overview

Object Oriented Analysis & Design with UML



75Colorado IT Training • 978-250-4983 75Colorado IT Training • 978-250-4983

Web Development








Course Overview




Course Description: This hands on Web programming class provides a thorough introduction into the creation of a Website using HTML, CSS and JavaScript. Starting with thorough coverage of HTML and Cascading Style Sheets (CSS), the course progresses to the implementation of dynamic client-side content using JavaScript. HTML topics include use of HTML5 semantic tags, block-level and inline elements, creating links, different types of lists, creation of tables and forms. Students will learn to attach CSS to a page using several different techniques, CSS selectors and pseudo-classes, CSS box model, and a variety of CSS2.1 properties.

JavaScript topics include adding JavaScript to a Webpage, use of dialogs to interact with the user and JavaScript intrinsic objects such as Date, Array and Math. Students will also be introduced to the Document Object Model (DOM), creation of functions, event handling, form validation, JSON and Ajax. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Course Prerequisites: Basic personal computer skills and basic Internet knowledge.

● The <!DOCTYPE>, <html> and <head> Tags ● Using the <body> Tag ● Introduction to HTML ● Structuring an HTML Document ● Formatting Text ● Adding Tables to a Page ● Creating Unordered, Ordered, and

Description Lists ● Adding Images to a Web Page ● Discussion of Common Image Formats ● Adding Links to a Web Page ● Using <div> and <span> Tags ● Creating Cascading Style Sheets (CSS) ● Working with the CSS Box Model ● Using Type Selectors, Class Selectors,

Attibute Selectors, and ID Selectors ● Applying Style Sheets to a Web Page ● Creating Forms Using The <form> Tag ● Understanding Form Submission ● Including JavaScript in a Page ● Using the <script> Element

● Debugging JavaScript Code ● Using an Event Handler ● Declaring Variables ● JavaScript Data Types ● Working with Strings, Numbers and Arrays ● Using the JavaScript Browser Object Model ● Using the window and navigator Objects ● Overview of JavaScript Operators (Arithmetic,

Assignment) ● Using Conditional Constructs (if else, switch) ● Using Looping Constructs (do while, while, for,

for in) ● Using Branching Statements (break, continue) ● Using JavaScript Functions and Event Handlers ● Accessing Forms from JavaScript ● Overview of Regular Expressions ● Selecting DOM Elements ● Working with JavaScript Objects and JSON ● The XMLHttpRequest Object ● Configuring an Ajax Request

Course Overview

Web Site Development with HTML5/JavaScript



Course Description: This hands on course provides a thorough introduction into the creation of a Website using HTML, CSS and Bootstrap. The course starts with thorough coverage of HTML and Cascading Style Sheets (CSS) and progresses to using the Bootstrap framework to create mobile-friendly websites.

Topics include use of HTML5 semantic tags, block-level and inline elements, creating links, ordered and unordered lists, creation of tables and forms. Students will learn to attach CSS to a page using several different techniques, CSS selectors and pseudo-classes, CSS box model, and a variety of CSS properties.

Students will learn how to create a Bootstrap page utilizing the grid system, implement commonly used components (such as dropdowns and navigation bars), use Bootstraps CSS classes to format page elements and use Bootstrap’s plugins to add tabs, modals and accordions to a page.

Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Course Prerequisites: Basic personal computer skills and basic Internet knowledge.

● HTML Fundamentals ● Structuring an HTML Document ● Formatting Text ● Introduction to Cascading Style Sheets

(CSS) ● CSS Properties ● CSS Box Model ● CSS Selectors and Pseudo-Classes ● Working with Lists

● Adding Images to a Page ● Displaying Information in Tables ● Working with Forms ● Audio and Video ● Bootstrap Overview ● Bootstrap Grid System ● Bootstrap Base CSS ● Bootstrap Components ● Bootstrap Plugins

Course Overview


Website Development with HTML5, CSS and Bootstrap


Course Description: This hands on JavaScript training course provides the fundamental knowledge necessary to design and develop dynamic Web pages using JavaScript. It introduces students to client-side JavaScript and how the language can be used to turn static HTML pages into dynamic, interactive Web pages. Students will learn the syntax of the JavaScript language and how client-side scripts interact with server-side programs.

JavaScript topics include adding JavaScript to a Webpage, use of dialogs to interact with the user and JavaScript intrinsic objects such as Date, Array and Math. Students will also be introduced to the Document Object Model (DOM), creation of functions, event handling, form validation, JSON and Ajax. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Students already familiar with JavaScript should register for the 4-day Exploiting ECMAScript 6: New JavaScript Features course.

Course Prerequisites: Basic computer skills and knowledge of HTML fundamentals including use of Cascading Style Sheets. Students who are not familiar with HTML should register for the Website Development with HTML5, CSS and Bootstrap course.

● Overview of Client-Side JavaScript ● JavaScript Fundamentals ● Controlling Flow ● Working with Strings, Numbers and

Arrays ● Implementing Functions ● Browser Object Model ● Introduction to the Document Object

Model (DOM)

● Event Handling in JavaScript ● Working with Forms ● Using Regular Expressions ● Working with JavaScript Objects and JSON ● Using Ajax ● HTML5 JavaScript APIs ● Overview of JavaScript Design Patterns ● Overview of JavaScript Libraries,

Frameworks and Tools

Course Overview

JavaScript Programming



Course Description: This hands on ECMAScript programming course is intended for JavaScript developers who are looking to transition from JavaScript (ES5) to the next version of JavaScript, ECMAScript 6 (also known as ES6 or ES2015). ECMAScript 6 includes many enhancements and new features that make JavaScript coding easier and more maintainable. This hands-on course will introduce students to many of the features of this latest version, including declaring block-scoped variables, declaring classes and modules, using new collection types such as Sets and Maps, arrow functions, destructuring objects and arrays, and asynchronous programming with promises. In addition, students will learn to “transpile” ES6 code using tools like Babel and Traceur so that it can be used even before ES6 is fully implemented by browsers and Node.js.

Course Prerequisites: Knowledge of JavaScript equivalent to attending the JavaScript Programming course.

● Overview of ECMAScript ● Review of JavaScript Features ● Object-Oriented Programming ● Working with Collections ● Syntax Changes ● Modularizing Code ● Iterators ● API Additions

● Asynchronous Programming ● Changes to Functions ● Regular Expression Changes ● Object Literal Enhancements ● Tools ● Generators ● Overview of Node.js

Course Overview


Exploiting ECMAScript 6: New JavaScript Features







Course Overview




Course Description: This hands on course is intended for experienced Web designers and developers who wish to exploit HTML5 and jQuery to create feature-rich, dynamic Web sites. The course provides a thorough introduction into the use of HTML5, CSS3 and jQuery to create Web sites that target the capabilities of modern browsers. HTML5 includes new structural and form elements, implementation of audio and video elements, and intrinsic APIs that offer features such as “offline” applications, local and Web storage, and dynamic creation of graphics using Canvas. CSS3 introduces new selectors and properties, creation of drop shadows, text shadows, rounded corners and gradient backgrounds without the use of an image editor, as well as simple animated effects without the use of JavaScript or Flash.

jQuery simplifies client-side scripting via a series of open-source libraries that provide frameworks for enhanced functionality. The course covers the jQuery library, DOM manipulation, Ajax requests, and use of the UI library to include animation effects and popular widgets such as datepickers and autocomplete. Comprehensive hands-on exercises are performed throughout each day to demonstrate key concepts. Students who are not familiar with HTML, CSS and JavaScript should instead register for the course, Web Site Development With HTML/JavaScript.

Course Prerequisites: Knowledge of HTML, CSS and JavaScript equivalent to attending the Web Site Development With HTML/JavaScript course.

Developing Rich Internet Applications Using HTML5, CSS3 and jQuery








Course Overview



Course Overview ● HTML5 Date Input Types ● Creating Multiple Columns for Laying Out

Text ● Working with RGBA and HSL Color Models ● Creating Simple Animations Using

transitions, transform, and animation ● jQuery Overview ● Overview of jQuery Selectors

- CSS Selectors - jQuery Filters - Working with the jQuery Object

● Using jQuery Methods - Wrapper Methods - Manipulating a Wrapped Set

● DOM Manipulation ● Working with Events

- Creating Dynamic Effects - Showing and Hiding Elements - Fading Elements - Sliding Elements - Creating Custom Animations

● jQuery Utility Functions ● Developing and Using jQuery Plugins ● Working with jQuery and Ajax ● jQuery UI Overview

- Widgets - Effects - Using ThemeRoller

● New Semantic Elements <header>, <footer>, <section>, <article>, <nav>, <aside>, <hgroup>, <figure>, <figcaption>, <mark>

● Browser Support for Audio/Video Formats

● <audio> and <video> Elements ● Media API Overview ● New HTML5 Form Elements

<datalist>, <progress>, <meter> ● New HTML5 Form Attributes

autocomplete, autofocus, form, height and width, min, max and step, multiple, novalidate, pattern, placeholder, required, disabled and readonly

● New HTML5 Input Types email, url, tel, number, range, color, search

● CSS3 Overview ● CSS3 Selectors and Pseudo-Classes ● CSS3 Properties ● Using Vendor-Specific Extensions to

Ensure Cross-Browser Compatibility ● Using @font-face to Add Custom Fonts ● Changing the Opacity of Text and Images ● Creating Rounded Corners, Adding

Shadows to Boxes, and Using Images as Borders

Developing Rich Internet Applications Using HTML5, CSS3 and jQuery (Continued)


Course Description: This hands-on course conveys the fundamental skills necessary to design and build responsive web sites for mobile devices such as phones and tablets. Attendees will use responsive web design (RWD) techniques such as CSS3 media queries and flexible layouts to build mobile-compatible web sites. Students will learn how to test mobile websites using emulators and simulators.

The course also provides an extensive introduction into using the jQuery Mobile Framework for building mobile-specific web sites. Students will learn how to use jQuery Mobile widgets to create forms, lists, toolbars and collapsible blocks. Students will also learn how to integrate SOA with a mobile web site including working with RSS feeds, Google Maps integration and implementing server-side data access.

Attendees will use ThemeRoller for jQuery Mobile to download existing or custom theme swatches to format the appearance of a web site. Additional topics include responding to user events, configuring jQuery Mobile defaults and using page transitions. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Course Prerequisites: Prior knowledge of HTML, CSS, JavaScript and jQuery equivalent to attending the Web Site Development With HTML/JavaScript and Developing Rich Internet Applications Using HTML5, CSS3 and jQuery courses.

● Creating a Responsive Website ● Using CSS3 Media Queries ● Creating Flexible Grid Layouts ● Optimizing Images and Media ● Working with the Viewport ● Using jQuery Mobile Widgets

● Configuring and Downloading the jQuery Mobile Framework

● Formatting Mobile Pages with ThemeRoller ● Reacting to Mobile Specific Events ● Integration with Web Services

Course Overview

Developing Mobile Websites with Responsive Web Design and jQuery Mobile








Course Overview




Course Description: This hands on programming course provides a thorough introduction to the AngularJS JavaScript Framework. Attendees will learn the fundamental skills necessary to build Web Applications using AngularJS and the MV* (Model View Whatever) design pattern. Topics include creating controllers, using scope to manage data, designing views/templates, routing, data binding and filters, applying directives, as well as form integration and validation. Students will also use AngularJS’ built-in services to communicate with RESTful web services and provide CRUD database operations.

Students will learn how to use CSS animations and Bootstrap to enhance the UI as well as learn to employ third-party components such as modal dialogs (“modals”), progress bars and navbars. In addition, students will learn to extend AngularJS with custom directives, services and filters.


Course Prerequisites: Knowledge of HTML, CSS and JavaScript equivalent to attending the Web Site Development with HTML5/JavaScript course. Knowledge of jQuery is helpful, but not required.

● Features and Benefits of AngularJS ● MV* (Model View Whatever) Design

Pattern Overview ● Downloading AngularJS ● Referencing AngularJS Using a CDN ● Single Page Application Model ● Organizing Code Using Modules ● Defining an Application with

angular.module() ● Defining a Controller with

module.controller() ● Defining $scope in a Controller

● Using Built-In AngularJS Directives ● Using the $http and $resource Services ● Using the $location and $window Services ● Configuring Routes with $routeProvider ● Defining Route Parameters ● Defining Custom Directives ● Integrating and Validating Forms in

AngularJS ● Animating AngularJS Applications ● Creating a Responsive UI with the

Bootstrap Grid System ● Applying Bootstrap CSS Classes

Course Overview

Developing Web Applications Using AngularJS



Course Description: This hands on programming course provides a thorough introduction to the second major release of the AngularJS JavaScript Framework, Angular 2. Attendees will learn the fundamental skills necessary to build Web Applications using Angular 2 and the MVVM (Model-View-ViewModel) design pattern. Topics include using TypeScript and ECMAScript 6 to create components, using directives and components to define UI elements, routes and screens, applying dependency injection, designing views/templates, routing, data binding and pipes, applying directives, as well as form integration and validation. Students will also use the Angular 2 services to communicate with RESTful web services and provide CRUD database operations.


Course Prerequisites: Knowledge of HTML, CSS and JavaScript equivalent to attending the Web Site Development with HTML5/JavaScript course. Knowledge of jQuery is helpful, but not required.

● Overview of Angular 2 and the MVVM Design Pattern

● Working with TypeScript ● Angular 2 Modules ● Angular 2 Components ● Using Built-In Directives and Filters ● Working with Pipes ● Defining and Consuming Services ● The Angular 2 Animation System

● The HTTP Library ● Angular 2 Routing and Navigation ● Data Binding and Programming Models ● Building and Deploying Applications ● Bootstraping ● Forms ● Creating Single Page Applications (SPAs) ● Unit Testing and TDD with Angular 2

Course Overview


Developing Web Applications Using Angular 2







Course Overview




Course Description: This PHP programming training course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP version 5. PHP is a language written for the web, quick to learn, easy to deploy and provides substantial functionality required for e-commerce.

This course introduces the PHP framework and syntax, and covers in depth the most important techniques used to build dynamic web sites. Students learn how to connect to any ODBC-compliant database, and perform hands on practice with a MySQL database to create database-driven HTML forms and reports. E-commerce skills including user authentication, data validation, dynamic data updates, and shopping cart implementation are covered in detail. Students also learn how to configure PHP and the Apache Web Server. Comprehensive lab exercises provide facilitated hands on practice crucial to developing competence and confidence with the new skills being learned.

Course Prerequisites: Basic computer skills and knowledge of HTML fundamentals. Prior programming experience is helpful but not required.

● PHP Architecture ● Installing and Configuring Apache for

PHP ● Name-Based Virtual Hosting ● Installing and Configuring IIS ● Configuring php.ini ● Sending Output to a Browser ● Using PHP Variables and Data Types ● Defining Constants ● Arithmetic, Comparison and Logical

Operators ● Concatenation ● Conditional Statements in PHP (If, Else

and Elseif, Switch) ● Looping Constructs in PHP (While, Do…

While, For, Exit & Break) ● Declaring Functions ● Predefined PHP Functions

● Using Include Files ● Working with Arrays ● Creating Associative Arrays ● One-Dimensional Arrays ● Multi-Dimensional Arrays ● String Manipulation Functions and Regular

Expressions ● Form Data Collection ● Using Cookies ● Starting, Continuing, & Destroying Sessions ● Using Environment Variables ● Using phpMyAdmin ● Installing and Configuring MySQL ● Executing SQLCalls ● Debugging and Error Handling ● Using ODBC ● Accessing Files and Sending E-Mail ● Uploading Files with PHP

Course Overview

PHP Programming



Course Description: This hands on Node.js course will teach front end designers and server side developers how to rapidly create, maintain, and deploy Node.js applications. This course includes thorough coverage of the Node.js architecture, the V8 engine and the Node Ecosystem. The course takes a practical approach to creating and organizing Node.js applications using functions and modules as part of the Node.js organizational structure. This course will provide attendees with a comprehensive understanding of Node.js core modules and how to procure and install packages using npm. Attendees will learn to identify and correct problems through unit testing and exception handling.

Attendees will learn how to use Node.js to create Command Line Interface applications for system administration and process management, use Node.js networking modules to communicate with TCP/IP clients and servers such as HTTP servers, and create / consume REST (Representational State Transfer) data services. Attendees will learn how to leverage frameworks such as Express to rapidly build Web Applications. Attendees will learn how to use Node.js to connect to NoSQL databases such as MongoDB to store, retrieve, and manipulate data (i.e., achieve data persistence).


Course Prerequisites: Knowledge of JavaScript equivalent to attending the Web Site Development with HTML5/JavaScript course. Attendees should also have familiarity with a Windows, Linux, or OS X command line interface as well as a basic understanding of network protocols such as HTTP.

● Node.js Overview ● Node.js Global Environment ● ES6 Enhancements ● Installation and Configuration ● Programming Fundamentals with Node ● Using Modules to Organize Code ● Unit Testing and Debugging with Node.js ● Implementing Unit Tests with the Assert

Module ● System and Data Interaction With Node

● Interacting with the System Using the os Module

● Data Persistence with Node.js ● MongoDB Capabilities ● Web Application and Network Programming ● REST-Based Web Service Fundamentals ● Process Management with the process

Module ● Creating Modules

Course Overview


Node�js Web Application Development


Python Programming



Course Description: This hands on Python programming course shows how to rapidly develop and maintain effective Python programs. The course includes thorough coverage of Python 3 syntax, built in data types and control constructs. The course takes a practical approach to creating and organizing Python programs using functions, packages, modules and classes as part of Python’s object-oriented paradigm. Attendees will learn to identify and correct problems through unit testing and exception handling. Attendees will use regular expressions to rapidly process data captured from users and from the file system. Students will learn how to create GUI based Python programs to gracefully interact with the user. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Course Prerequisites: Prior scripting experience or knowledge of fundamental programming concepts.

● Python Language Fundamentals ● Creating and Executing Python

Programs Using IDLE ● The Python Standard Library ● Using Regular Expressions ● if/elif/else Statements ● Creating Loops with while and for ● Handling Exceptions with

try/except/finally ● Using ASCII and Unicode Strings

● Manipulating Strings with String Methods ● Defining and Calling Functions ● Working with Arguments ● GUI Programming Concepts ● Object Oriented Programming ● Sending Output to STDOUT Using the print()

Method ● Reading Input with the input() Method ● Working with XML Data

Course Overview

Python Programming



XML Programming



Course Description: The Extensible Markup Language (XML) provides a standard, document-based approach to handling, transforming, storing and querying structured data. XML is widely accepted as a file and message format because it preserves application data in a language-independent way. Standard tools make it possible to merge content from distributed systems with relative ease. XML is a fundamental building block of interactive web applications, enabling service-oriented architectures in which XML is used as the message payload. XML is the basis for web display languages such as XHTML (used in browsers), WML (cell phones), SVG (vector graphics), SMIL multimedia presentations and others.

This hands-on XML programming class is a thorough introduction to using XML in a variety of practical applications. Numerous examples are presented using Java, .NET and JavaScript. AJAX programming techniques are included.

The course covers structuring data with XML; validating data with document type definitions (DTDs) and XML Schemas; creating and viewing XML documents; transforming XML documents with the XML Stylesheet Language (XSL, XSLT and XPath); Service-Oriented architectures using SOAP and Web Services; accessing and editing XML data via the document object model (DOM) and Simple API for XML (SAX) libraries; Mapping XML structures to and from databases and object-oriented languages. These techniques are then combined in client or server-based applications to deliver rich AJAX user interfaces with clear and modular code.

Extensive examples combined with comprehensive hands-on lab exercises reinforce the concepts being taught and introduce the practical application of XML to business problems.

Course Prerequisites: Programming experience in an object-oriented language such as Java, JavaScript (JScript, ECMAScript) or C# is strongly recommended.

● XML Capabilities ● XML Document Structure ● Introduction to XML Elements ● Validating XML Documents with Document

Type Definitions (DTDs) ● Using Uniform Resource Identifiers (URIs) ● Creating Document Type Definitions ● ATTLIST Markup Declaration ● Creating Entities ● Benefits of XML Schemas ● Using Namespaces in Documents ● Validating Documents with Schemas ● Overview of Schema Data Types ● Defining New Data Types ● Complex Types and Groups ● Reuse and Uniqueness in Schema Validation

● Introduction to XSL and Xpath ● Document Transformation Using XSL and XSLT ● Creating Printable Documents using XSL-FO ● Introduction to XML DOM ● The Document Object ● The NodeList Object ● Reading and Writing XML Using the DOM ● The XmlDocument Object ● Basic SAX Architecture ● Validating Parsers in Java ● Programmatic Transformations ● XSL-FO Transformations ● SOAP Architecture ● Purpose of Web Services ● Creating a Web Service ● WSDL Elements

Course Overview

XML Programming



UNIX/Linux



Course Description: This hands on course provides training on standard UNIX/Linux commands and utilities used for day to day tasks including file manipulation, program execution and control, and effective use of the shell and desktop environments. The course presents the concepts necessary to understand the way UNIX works as well as the system’s most commonly used commands. Data manipulation utilities and shell syntax for synthesizing command pipelines are emphasized. Bourne and Korn shell programming is introduced so students will be able to read and modify existing shell scripts as well as create their own. Desktop environments are also introduced from a user’s perspective, including common window managers, Open Office utilities and an introduction to configuration tools. Proficiency in applying new skills is reinforced with extensive hands on exercises after each module.

Course Prerequisites: None

● History of UNIX ● Navigating the File System ● Viewing and Copying Files ● Using the Command Line ● Creating User Logins and Passwords ● Communicating with Other Users ● Using the vi Editor ● File and Directory Naming Rules and

Conventions ● Introduction to Inodes ● Manipulating Files, Links and Directories ● UNIX Process Model ● Monitoring and Controlling Processes ● Shell Syntax

● Features of C, Korn and bash Shells ● I/O Redirection and Pipes ● Command Substitution, Quoting and

Escaping ● Command Separation and Grouping ● Using grep, egrep, awk, and sed ● Using Compression Utilities ● Backing Up Files ● tar Syntax ● UNIX Network Applications ● Using ftp ● Working With the Secure Shell ● Submitting and Controlling Print Jobs

Course Overview

UNIX/Linux Fundamentals



Course Description: This hands on Linux administration course teaches students how to install, configure and maintain a Linux system in a networked environment. Students will not only learn to perform basic administrative tasks such as adding and managing users, creating and maintaining file systems, developing and implementing a security policy, and performing software installation and package management, but will also learn to perform Linux network-related tasks, including installing and supporting SSH, NFS, Samba, DNS, DHCP, and the Apache Web server. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

The course includes comprehensive hands on practice installing and configuring a CentOS 6 / Red Hat Enterprise Linux 6 system, although much of the course content also applies to SuSE, Ubuntu, Oracle and other Linux implementations. Labs include adding and deleting users, backing up and restoring the system, adding/deleting software, automating the scheduling of tasks, creating file systems, managing remote access, and installing and tuning Samba and Apache, as well as working with modern system logging utilities such as rsyslog. Class participants will also discuss common security issues, and be introduced to several tools, such as PAM modules, that can help secure the operating environment. Upon completion of this course, students will be prepared to competently maintain a Linux system in a networked business environment.

Course Prerequisites: Experience with common UNIX/Linux user-level commands, such as for moving, copying and editing files. Attendance at the UNIX/Linux Fundamentals course provides a solid foundation.

● LINUX Architecture ● Linux System Installation ● Preparing a Server Site ● Hard Drive Partitions ● Networking Procedures Overview ● Print Service Basics ● Printing Using CUPS and LPD ● Installing and Configuring X Windows ● Installing and Using VNC ● Managing Hardware ● Installing Software with the rpm Command ● CVS Source Code Management ● Solving Problems via the Bootup Process ● System Startup and Shutdown Scripts ● Managing Users and Groups ● Adding Users to the System ● Working with Groups ● Setting User Environments ● Reviewing Basic Permissions ● Working with Extra File Permissions and

Access Control Lists

● Delegating and Limiting Access Rights on the System

● Restricting System Logins ● Linux Filesystem Basics ● Repairing Filesystems ● Shell and Perl Scripting Fundamentals ● Controlling and Automating Processes ● Working with System Logs ● System Backups ● Network File Systems ● Using Samba ● Implementing the Dynamic Host Configuration

Protocol (DHCP) ● Working with DNS ● NIS Overview ● Configuring the Master Server ● Configuring the Apache Web Server ● Using SSH ● System Security ● The Linux Kernel

Course Overview

Linux System Administration



SharePoint Administration and Power User



Course Description: This hands-on course teaches students how to deploy, configure, manage and customize the SharePoint 2013 environment. The course begins with a thorough overview of “out-of-the-box” features, and then moves on to SharePoint administration using PowerShell and Central Administration. The course also covers security issues and an introduction to advanced design techniques.

Students learn how to generate new sites using built-in templates,as well as how to create sites from scratch. Popular content components are also covered, including wikis, blogs, team sites, web databases and meeting workspaces.

Included are techniques for using built-in lists to promote information sharing, as well as the creation of custom lists. Document and file management are also covered, including content approval settings, document versioning, and document check-out/check-in. Co-authoring of MS-Office documents is also covered.

Students will learn how to use built-in workflows, as well as how to create custom workflows using SharePoint Designer. Designer will also be used to define custom master pages and cascading style sheets (CSS) to enhance the look and feel of SharePoint sites. SharePoint Server integration with Reporting and Analysis Services is also covered. This includes how to display database records on SharePoint sites using Business Connectivity Services (BCS). Using PerformancePoint Services to create reporting “dashboards” is also introduced.

Finally, SharePoint social networking features are reviewed. This includes how to configure My Sites, which allows users to manage their own web site content. Also demonstrated are the Tags and Notes feature which allows users to “like” and comment on SharePoint web content. Synchronization of Active Directory user profiles with SharePoint is also covered.

Comprehensive hands on exercises include creation of common SharePoint components such as lists, libraries, blogs, calendars, wikis, announcements and tasks. Students will add custom pages to their SharePoint sites and build navigation systems. Students will also practice implementing business rules and content access permissions. Content security and integrity are emphasized throughout.

Course Prerequisites: Familiarity with Windows 7 and/or Windows 8 operating systems. Basic understanding of Windows user logon accounts and passwords. Basic understanding of shared file and folder access and NTFS permissions.

SharePoint 2013 Customization and Administration



● Installing and Configuring SharePoint Server 2013

● Creating and Configuring SharePoint Sites and Site Collections

● Managing SharePoint Farms ● Using the Central Administration Utility ● Securing SharePoint Sites and Farms ● Creating and Customizing Lists and

Libraries ● Adding and Modifying SharePoint Site

Content ● Setting Up Site Navigation Systems ● Using SharePoint’s Built-In Workflows

● Creating Custom Workflows Using SharePoint Designer

● Using PowerShell to Administer SharePoint ● Backup and Restoring SharePoint Farms,

Site Collections and Sites ● Importing and Exporting Sites, Lists and

Libraries ● Setting Up SharePoint User Profiles ● Implementing Business Connectivity

Services (BCS) ● Integrating with Reporting and Analysis

Services

Course Overview

SharePoint 2013 Customization and Administration (Continued)


Course Description: This hands-on course thoroughly covers out-of-the-box features of SharePoint and how to customize these features to make the most of your SharePoint environment. The course begins with an overview of SharePoint system architecture, then moves on to creating SharePoint web applications, site collections and sites. From there, students will add Web pages to sites and create navigation solutions for users to easily locate data. Students learn how to create new sites from scratch, as well as by built-in template. Included are team sites, wikis, blogs, web databases and meeting workspaces. Web parts and pages are then added to sites to provide greater flexibility in the way SharePoint is presented to users.

Included are techniques for using lists to promote information sharing, creating surveys, managing tasks and projects, as well as sharing calendars. Document and file management is also covered, including setting up content approval, managing major and minor file versions, and checking-out/checking-in documents.

Students will learn how to use built-in workflows, as well as how to display database records on SharePoint sites using Business Connectivity Services (BCS).

Key administrative tasks are reviewed, including site backup/restore and user access permissions assignment.

Comprehensive hands on exercises illustrate the concepts and techniques presented, and provide practice creating common SharePoint components.

Students who need to administer and configure SharePoint for an “enterprise” should register for the five-day course SharePoint 2013 Customization and Administration, rather than this course.

Course Prerequisites: Familiarity with Windows 7 and/or Windows 8 operating system. Basic understanding of shared folders, drive maps and NTFS permissions.

● Installing and Configuring SharePoint Server ● Creating and Configuring SharePoint Sites

and Site Collections ● Managing SharePoint Farms ● Using the Central Administration Utility ● Adding and Modifying SharePoint Site

Content ● Creating and Customizing Lists and Libraries ● Setting Custom Validation Rules for New List

and Library Entries

● Setting Up Site Navigation Systems ● Setting Up Shared Calendars ● Using Built-In Web Parts ● Customizing Web Parts ● Using Built-In Workflows ● Setting Up MS-Office Documents for

Co-Authoring ● Using Business Connectivity Services (BCS) to

Display Database Records on SharePoint Sites

Course Overview

SharePoint 2013 Power User



Windows Administration



Course Description: This course provides hands on experience installing and configuring Windows Server 2012. Students will perform full installations, switch between GUI and Server Core features, configure and tune the server and assign roles and services. Attendees will practice local and remote administration of security, network, data and hardware in hands on labs. After installing an Active Directory domain controller, students will create and assign users, groups, permissions, rights, policies and profiles.

Attendees will configure and troubleshoot the TCP/IP network, utilize Powershell cmdlets, and implement a backup strategy. Also covered are many aspects of local security, such as group policy objects (GPO), Encrypting File System (EFS), rights and permissions. Students will learn to use enterprise tools such as Distributed File System (DFS) and File System Resource Manager (FSRM) to manage file storage and accessibility, as well as facilitate clustering and virtualization. Comprehensive labs and exercises give the students real experience deploying, managing and troubleshooting the Windows 2012 infrastructure.

Course Prerequisites: Understanding of Windows Vista or Windows 7 Aero interface and Control Panel applets.

● Overview of Windows Server 2012 ● Installing Windows ● Configuring Windows ● Command Line Server Core

Configuration ● Windows Management ● Windows System Resource Manager

(WSRM) ● Windows Remote Management

(WinRM) ● Creating Local Users and Groups ● Creating Domain Users and Groups

● Networking ● TCP/IP version 4 (IPv4) ● IPv4 Addressing ● Configuring Print Servers ● NTFS Permissions ● ADDS Architecture ● Group Policy Management Console (GPMC) ● Virtualization Planning and Design ● Clustering ● Distributed File System (DFS) ● File Server Resource Manger (FSRM) ● Server Backup and Restore

Course Overview

Windows Server 2012 R2 System Administration








Course Overview




Course Description: Active Directory provides a single administration point for sign-on, policies and authentication control. This hands on course provides experience configuring Active Directory and essential network security components such as AD Certificate Services, IPSec and virtual private networking (VPN). Students will install Active Directory Domain Services (ADDS), integrate DNS for Active Directory and Internet name resolution, implement AD security for DNS, and configure logical AD components, such as forests, trees, domains and organizational unit (OUs). Upgrading and migrating the ADDS structure within or between forests, troubleshooting, backup and restore methods and additional maintenance tools will be explored. Attendees will investigate additional Active Directory roles and services. With ADDS installed, we will monitor and maintain sites and replication to assure up-to-date information.

An administrator needs to control the user environment, so students will look at the architecture, scope, inheritance, replication and troubleshooting in group policy before learning to restrict and enable users with login scripts, rights, desktop policies and software deployment and control. We’ll also look at further controlling computers through security policies, loopback processing, and templates. Attendees will delegate administration of the configuration policies, control application and inheritance and explore tools to refine the user experience. Comprehensive labs and exercises give the students real experience installing and configuring Active Directory while securing the network.

Course Prerequisites: Completion of Windows 2012 System Administration course or equivalent knowledge.

● Domain Name Service (DNS) ● Active Directory Domain Services ● Active Directory DNS Naming Strategy ● Dynamic Host Configuration Protocol ● DHCP Lease Process ● Active Directory Maintenance and

Monitoring ● Server 2012 Monitoring Tools ● Administering and Defining the Active

Directory Schema ● Group Policy Objects (GPO) ● GPO User Configuration

● GPO Computer Configuration ● GPO Security ● Group Policy Management Console ● Analyzing Resultant Set of Policy (RSoP) ● Active Directory Certificate Services ● Public Key Infrastructure (PKI) ● Installing Active Directory Certificate

Services ● Virtual Private Network (VPN) Configuration ● Remote Desktop Architecture ● Dynamic Host Configuration Protocol

(DHCP)

Course Overview

Designing and Implementing Windows Server 2012 Network Infrastructure and Security



Exchange Server



Course Description: This course provides hands on experience installing and configuring Exchange Server 2010 and a variety of Microsoft messaging clients. Students will also install and configure Windows Server 2008, Active Directory Domain Services and IIS web services. Attendees will practice local and remote administration of server roles, network connectivity and user messaging data. After installing Exchange, students will create users and groups, and assign permissions, rights and policies. They will then configure and troubleshoot the Exchange environment using various consoles and management shells. We’ll investigate backup and fault tolerance strategies, as well as security and user access issues. Comprehensive labs and exercises give students real experience deploying, managing and troubleshooting an Exchange Server 2010 infrastructure.

Course Prerequisites: Familiarity with the Microsoft Windows environment (desktop, files and folders). Students should also be familiar with the basic workings of Active Directory (domains, organizational units, users and groups).

● Windows Server Installation and Configuration

● Exchange Server Installation and Configuration

● Active Directory, DNS and IIS Integration ● Management Consoles and Shells ● Exchange Server Roles and Security

Management ● Administrative Management Roles ● Message and Recipient Management

● Rights Based Access Control ● Exchange Backup and Recovery ● Exchange Database Availability Groups ● Exchange Server Maintenance, Monitoring

and Troubleshooting ● Outlook, OWA and ActiveSync Installation

and Configuration ● Managing User Email and Calendar Data ● Managing Global and Personalized

Address Lists

Course Overview

Exchange Server 2010 System Administration








Course Overview




Course Description: This course provides hands on experience installing and configuring Exchange Server 2013 and a variety of Microsoft messaging clients. Students will also install and configure Windows Server 2012, Active Directory Domain Services and IIS web services. Attendees will practice local and remote administration of server roles, network connectivity and user messaging data. After installing Exchange, students will create users and groups, and assign permissions, rights and policies. They will then configure and troubleshoot the Exchange environment using various consoles and management shells. Windows Server 2012’s backup and fault tolerance strategies are reviewed, and Exchange Server’s equivalent procedures are introduced and configured. User mailbox security and access policies are thoroughly covered and implemented. Comprehensive labs and exercises give students real experience deploying, managing and troubleshooting an Exchange Server 2013 infrastructure.

Course Prerequisites: Familiarity with the Microsoft Windows environment (desktop, files and folders). Students should also be familiar with the basic workings of Active Directory (domains, organizational units, users, groups, permissions and group policy). Completion of Windows Server 2012 System Administration course or equivalent knowledge.

● Windows Server Installation and Configuration

● Exchange Server Installation and Configuration

● Active Directory, DNS and IIS Integration ● Exchange Management Console and

Shell ● Exchange Server Roles and Security

Management ● Administrative Management Roles

● Message and Recipient Management ● Role Based Access Control ● Exchange Backup and Recovery ● Exchange Database Availability Groups ● Microsoft Outlook, OWA and ActiveSync

Installation and Configuration ● Managing User Email and Calendar Data ● Managing Global and Personalized Address

Lists

Course Overview

Exchange Server 2013 System Administration


Contact Us


Phone978-250-4983

MailColorado IT Training1 Village Square, Suite 8Chelmsford, MA 01824

[email protected]