20764: Administering a SQL Database Infrastructure (SQL Server 2017) course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
This course is based on the objectives of the course version 20764C.
SATV Eligible Course
Don't let your SATVs expire - put them to work for your organization today. Reserve your seat for the SATV eligible courses. To place your schedule request call at 1-888-563-8266 or chat live with a Learning Consultant.
Intended Audience for this 20764: Administering a SQL Database Infrastructure (SQL Server 2017)
» The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
» The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Course Prerequisites for 20764: Administering a SQL Database Infrastructure (SQL Server 2017)
» Required: Basic knowledge of the Microsoft Windows operating system and its core functionality.
» Required: Some experience with database design.
» Required: Working knowledge of relational databases.
» Required: Working knowledge of Transact-SQL.
20764: Administering a SQL Database Infrastructure (SQL Server 2017) Course Objectives
» Authenticate and authorize users
» Assign server and database roles
» Authorize users to access resources
» Protect data with encryption and auditing
» Describe recovery models and backup strategies
» Backup SQL Server databases
» Restore SQL Server databases
» Automate database management
» Configure security for the SQL Server agent
» Manage alerts and notifications
» Managing SQL Server using PowerShell
» Trace access to SQL Server
» Monitor a SQL Server infrastructure
» Troubleshoot a SQL Server infrastructure
» Import and export data
20764: Administering a SQL Database Infrastructure (SQL Server 2017) Course Outline
SQL Server Security
Authenticating Connections to SQL Server
Authorizing Logins to Connect to databases
Authorization Across Servers
Partially Contained Databases
Lab : Authenticating Users
Create Logins
Create Database Users
Correct Application Login Issues
Configure Security for Restored Databases
Assigning Server and Database Roles
Working with server roles
Working with Fixed Database Roles
Assigning User-Defined Database Roles
Lab : Assigning server and database roles
Assigning Server Roles
Assigning Fixed Database Roles
Assigning User-Defined Database Roles
Verifying Security
Authorizing Users to Access Resources
Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level
Lab : Authorizing users to access resources
Granting, Denying, and Revoking Permissions on Objects
Granting EXECUTE Permissions on Code
Granting Permissions at the Schema Level
Protecting Data with Encryption and Auditing
Options for auditing data access in SQL Server
Implementing SQL Server Audit
Managing SQL Server Audit
Protecting Data with Encryption
Lab : Using Auditing and Encryption
Working with SQL Server Audit
Encrypt a Column as Always Encrypted
Encrypt a Database using TDE
Recovery Models and Backup Strategies
Understanding Backup Strategies
SQL Server Transaction Logs
Planning Backup Strategies
Lab : Understanding SQL Server recovery models
Plan a Backup Strategy
Configure Database Recovery Models
Backing Up SQL Server Databases
Backing Up Databases and Transaction Logs
Managing Database Backups
Advanced Database Options
Lab : Backing Up Databases
Backing Up Databases
Performing Database, Differential, and Transaction Log Backups
Performing a Partial Backup
Restoring SQL Server 2016 Databases
Understanding the Restore Process
Restoring Databases
Advanced Restore Scenarios
Point-in-Time Recovery
Lab : Restoring SQL Server Databases
Restoring a Database Backup
Restring Database, Differential, and Transaction Log Backups
Performing a Piecemeal Restore
Automating SQL Server Management
Automating SQL Server management
Working with SQL Server Agent
Managing SQL Server Agent Jobs
Multi-server Management
Lab : Automating SQL Server Management
Create a SQL Server Agent Job
Test a Job
Schedule a Job
Configure Master and Target Servers
Configuring Security for SQL Server Agent
Understanding SQL Server Agent Security
Configuring Credentials
Configuring Proxy Accounts
Lab : Configuring Security for SQL Server Agent
Analyzing Problems in SQL Server Agent
Configuring a Credential
Configuring a Proxy Account
Configuring and testing the Security Context of a Job
Monitoring SQL Server with Alerts and Notifications
Monitoring SQL Server Errors
Configuring Database Mail
Operators, Alerts, and Notifications
Alerts in Azure SQL Database
Lab : Monitoring SQL Server with Alerts and Notifications
Configuring Database Mail
Configuring Operators
Configuring Alerts and Notifications
Testing Alerts and Notifications
Introduction to Managing SQL Server by using PowerShell
Getting Started with Windows PowerShell
Configure SQL Server using PowerShell
Administer and Maintain SQL Server with PowerShell
Managing Azure SQL Databases using PowerShell
Lab : Using PowerShell to Manage SQL Server
Getting Started with PowerShell
Using PowerShell to Change SQL Server settings
Tracing Access to SQL Server with Extended events
Extended Events Core Concepts
Working with Extended Events
Lab : Extended Events
Using the System_Health Extended Events Session
Tracking Page Splits Using Extended Events
Monitoring SQL Server
Monitoring activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data
SQL Server Utility
Lab : Monitoring SQL Server
Troubleshooting SQL Server
A Trouble Shooting Methodology for SQL Server
Resolving Service Related Issues
Resolving Connectivity and Log-in issues
Lab : Troubleshooting Common Issues
Troubleshoot and Resolve a SQL Login Issue
Troubleshoot and Resolve a Service Issue
Troubleshoot and Resolve a Windows Login Issue
Troubleshoot and Resolve a Job Execution Issue
Troubleshoot and Resolve a Performance Issue
Importing and Exporting Data
Transferring Data to and from SQL Server
Importing and Exporting Table Data
Using bcp and BULK INSERT to Import Data
Deploying and Upgrading Data-Tier Application
Lab : Importing and Exporting Data
Import and Excel Data Using the Import Wizard
Import a Delimited Text File Using bcp
Import a Delimited Text File using BULK INSERT
Create and Test an SSIS Package to Extract Data
Deploy a Data-Tier Application

AWS Business Essentials helps IT business decision makers understand the benefits of cloud computing and how a cloud strategy can help you meet your business objectives. In this course we discuss the advantages of cloud computing for your business and the fundamentals of AWS, including financial benefits. This course also introduces you to successful cloud adoption frameworks so to help you consider the AWS platform within your cloud computing strategy.
Intended Audience for this AWS Business Essentials
» IT Business Decision-Makers
» Individuals who are new to working with AWS
Course Prerequisites for AWS Business Essentials
» Required: Familiarity with basic finance concepts
» Required: Familiarity with basic IT security concepts
» Required: Working knowledge of IT infrastructure concepts
AWS Business Essentials Course Objectives
» Identify the value and benefits of the AWS cloud
» Recognize the valuable ways that the AWS platform can be used
» Understand the robust security capabilities, controls, and assurances in place to maintain security and data protection
» Articulate the financial impact the AWS cloud can have on an organization's procurement cycle, cost management, and contracts, while minimizing risks associated with consumption-based pricing models
AWS Business Essentials Course Outline
Getting started with the cloud
Leveraging AWS for competitive advantages
Cloud economics
Security and compliance
Migrating to the cloud
Do you have the right background for AWS Business Essentials?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
Take your FREE Skill Assessment test »

In this course, you will be introduced to the advanced knowledge required around project management skills and key initiatives for quality, human resource, communications, risk management, and procurement management.
Next Class Dates
Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.
Intended Audience for this Advanced Project Management
» Existing project managers seeking PMP® certification in recognition of their skills and experience
» Those looking for more advanced knowledge of project management principles as laid out by Project Management Institute (PMI)
Course Prerequisites for Advanced Project Management
» Recommended: IT Project Management
» Recommended: Project Management Fundamentals
Advanced Project Management Course Objectives
» Project communications management
» Project human resource management
» Project procurement management
» Project quality management
» Project risk management
Advanced Project Management Course Outline
Project Quality Management
Project quality planning
Quality assurance and quality control
Project Human Resource Management
Planning project human resources
Managing project human resources
Planning and managing project human resources simulation
Project Communications Management
Stakeholders and the communications management plan
Processes for managing project communications
Communicating effectively with project stakeholders simulation
Project Risk Management
Risk management planning
Identifying project risks
Performing risk analysis
Risk response, monitor, and control
Project Procurement Management
Planning project procurement
Managing procurements
Do you have the right background for Advanced Project Management?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
Take your FREE Skill Assessment test »

This five-day course is designed to provide students with detailed coverage of OSPF, IS-IS, BGP, and routing policy. Through demonstrations and hands-on labs, students will gain experience in configuring, monitoring, and troubleshooting the Junos operating system and in monitoring device and protocol operations.
This course uses Juniper Networks vMX Series Routers for the hands-on component, but the lab environment does not preclude the course from being applicable to other Juniper hardware platforms running the Junos OS. This course is based on the Junos OS Release 17.1.
Next Class Dates
Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.
Intended Audience for this Advanced Junos Service Provider Routing - AJSPR (Professional)
» This course benefits individuals responsible for implementing, monitoring, and troubleshooting Layer 3 components of a service provider’s network
Course Prerequisites for Advanced Junos Service Provider Routing - AJSPR (Professional)
» Required: Students should also attend the Introduction to the Junos Operating System (IJOS) and Junos Intermediate Routing (JIR) courses prior to attending this class.
» Required: Students should have intermediate-level networking knowledge and an understanding of the Open Systems Interconnection (OSI) model and the TCP/IP protocol suite
Advanced Junos Service Provider Routing - AJSPR (Professional) Course Objectives
» Describe the various OSPF link-state advertisement (LSA) types
» Explain the flooding of LSAs in an OSPF network
» Describe the shortest-path-first (SPF) algorithm
» List key differences between OSPFv2 and OSPFv3
» Describe OSPF area types and operations
» Configure various OSPF area types
» Summarize and restrict routes
» Identify some scenarios in a service provider network that can be solved using routing policy or specific configuration options
» Use routing policy and specific configuration options to implement solutions for various scenarios
» Describe how to troubleshoot OSPF
» Explain the concepts and operation of IS-IS
» Describe various IS-IS link-state protocol data unit (LSP) types
» List IS-IS adjacency rules and troubleshoot common adjacency issues
» Configure and monitor IS-IS
» Display and interpret the link-state database (LSDB)
» Perform advanced IS-IS configuration options
» Implement IS-IS routing policy
» Explain the default operation in multiarea IS-IS
» Describe IS-IS address summarization methods
» Configure and monitor a multiarea IS-IS network
» Describe how to troubleshoot IS-IS
» Describe basic BGP operation
» List common BGP attributes
» Explain the route selection process for BGP
» Describe how to alter the route selection process
» Configure some advanced options for BGP peers
» Describe various BGP attributes in detail and explain the operation of those attributes
» Manipulate BGP attributes using routing policy
» Explain the causes for route instability
» Describe the effect of damping on BGP routing
» Explain the default behavior of damping on links
» Control damping using routing policy
» View damped routes using command-line interface (CLI) commands
» Describe the operation of BGP route reflection
» Configure a route reflector
» Describe the operation of a BGP confederation
» Configure confederations
» Describe peering relationships in a confederation
» Describe how to troubleshoot BGP
» Describe how to troubleshoot routing policy
Advanced Junos Service Provider Routing - AJSPR (Professional) Course Outline
OSPF
OSPFv2 Review
Link-State Advertisements
Protocol Operations
OSPF Authentication
Lab: OSPF Multi-Area Networks
OSPF Areas
Review of OSPF Areas
Stub Area Operation
Stub Area Configuration
NSSA Operation
NSSA Configuration
Route Summarization
Lab: OSPF Route Summarization
OSPF Case Studies and Solutions
Virtual Links
OSPF Multiarea Adjacencies
External Reachability
Lab: Advanced OSPF Options and Routing Policy
Troubleshooting OSPF
Troubleshooting OSPF
Lab: OSPF Troubleshooting
IS-IS
Overview of IS-IS
IS-IS PDUs
Neighbors and Adjacencies
Configuring and Monitoring IS-IS
Lab: IS-IS Configuration and Monitoring
Advanced IS-IS Operations and Configuration Options
IS-IS Operations
IS-IS Configuration Options
IS-IS Routing Policy
Lab: Advanced IS-IS Configuration Options and Routing Policy
Multilevel IS-IS Networks
Level 1 and Level 2 Operations
Multilevel Configuration
Lab: Configuring a Multilevel IS-IS Network
Troubleshooting IS-IS
Troubleshooting IS-IS
Lab: IS-IS Troubleshooting
BGP
Review of BGP
BGP Operations
BGP Path Selection Options
Configuration Options
Lab: BGP and BGP Attributes
BGP Attributes and Policyâ€”Part 1
BGP Policy
Next Hop
Origin and MED
AS Path
Lab: BGP Attributes - Next Hop, Origin, MED, and AS Path
BGP Attributes and Policyâ€”Part 2
Local Preference
Communities
Lab: BGP Attributes - Local Preference and Communities
Route Reflection and Confederations
Route Reflection Operation
Configuration and Routing Knowledge
BGP Confederations
Lab: Scaling BGP
BGP Route Damping
Route Flap and Damping Overview
Route Damping Parameters
Configuring and Monitoring Route Damping
Lab: BGP Route Damping
Troubleshooting BGP
Troubleshooting BGP
Lab: BGP Troubleshooting
Troubleshooting Policy
Troubleshooting Policy
Lab: Policy Troubleshooting

The Android platform is the fastest growing mobile development platform in the world. With Android phones being produced by all of the major phone manufacturers, and the addition of new tablet devices, the platform will only continue to grow. NetCom's 7-day Android Programming course will teach application development for the Android Development using the Java Programming Language and the Eclipse Development Environment. This course will include basic application development including use of the Android phone camera, geolocation tools, and playing audio and video files.

AWS Technical Essentials course introduces you to AWS products, services, and common solutions.
It provides IT technical end users with basic fundamentals to become more proficient in identifying AWS services so that you can make informed decisions about IT solutions based on your business requirements and get started working on AWS.
Intended Audience for this AWS Technical Essentials
» Individuals responsible for articulating the technical benefits of AWS services
» Any individual who is new to AWS
» SysOps Administrators and Developers who are interested in using AWS services
AWS Technical Essentials Course Objectives
» AWS platform terminology and concepts
» AWS management console navigation
» AWS security measures
» AWS Storage options
» Create an Amazon Simple Storage Service (S3) bucket
» AWS compute and networking options
» Use Amazon Elastic Compute Cloud (EC2) and Amazon Elastic Block Storage (EBS)
» Managed Services and Database options
» Use Amazon Relational Database Service (RDS) to launch an application
» Deployment and Management options
AWS Technical Essentials Course Outline
Introduction and History of AWS
AWS Foundational Services: EC2, VPC, S3, EBS
AWS Security, Identity, and Access Management: IAM
AWS Databases: RDS, DynamoDB
AWS Management Tools: Auto Scaling, CloudWatch, Elastic Load Balancing, Trusted Advisor
Next Steps after taking this AWS Technical Essentials Course:
» Developing on AWS
» Architecting on AWS
Do you have the right background for AWS Technical Essentials?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
Take your FREE Skill Assessment test »

As companies increasingly adopt the agile methodology to manage a wide spectrum of projects, project managers and team members at all levels must learn how to effectively apply this approach to maximize results. If your role involves managing or working on projects in an existing agile environment or if your company is planning to implement agile soon, then take this course to learn how to manage an agile project from inception to closeout.
This course provides a thorough understanding of the agile process and extensive opportunities to practice implementing agile best practices throughout a project’s life cycle. You will learn about agile concepts such as the minimum viable product (MVP), project envisioning, team velocity, estimating and prioritizing user stories, how to manage risk, effective techniques to identify key stakeholders and their success criteria, and best practices for leading agile teams.
The course exercises provide hands-on experience in all areas of agile project management including developing an agile team, understanding client needs, creating user stories, estimating required resources, and prioritizing features. This course also covers how to coach and collaborate effectively, including integrating with teams using different methodologies. In addition, you will plan iterations, identify risk, modify stories in the backlog, and coordinate a release.
Intended Audience for this Agile Project Management
» Project managers
» Program managers
» IT managers
» Team leads
Course Prerequisites for Agile Project Management
» Required: Basic project management skills
» Required: Basic understanding of business development
Agile Project Management Course Objectives
» Define a project’s vision and scope.
» Identify stakeholders and success criteria
» Identify users
» Develop an agile team
» Review, estimate, and prioritize user stories
» Create an iteration and release plan
» Identify and manage project risk
» Plan communication
» Plan and conclude an iteration
» Add or modify stories in the backlog
» Manage impediments
» Interface with teams that use other development methodologies
» Coordinate a release
» Close out a project
» Apply agile practices to your organization
Agile Project Management Course Outline
Develop a Basic Understanding of Agile
Define the Project Vision and Scope
Identify Stakeholders and Success Criteria
Identify Users
Develop an Agile Team
Review and Estimate User Stories
Prioritize User Stories
Create an Iteration and Release Plan
Identify and Manage Project Risk
Plan Communication
Plan an Iteration
Conclude an Iteration
Add or Modify Stories in the Backlog
Manage Impediments
Interface with Teams that use Other Development Methodologies
Coordinate a Release
Close Out a Project
Apply Agile Practices to Your Organization
Available Similar Courses
» Advanced Disciplined Agile Delivery
» CompTIA Project+ Certification Prep
» PMI Agile Certified Practitioner (PMI-ACP)
Do you have the right background for Agile Project Management?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
Take your FREE Skill Assessment test »

Advanced AngularJS training teaches developers with some Angular experience how to take advantage of the frameworks more sophisticated features.

Game development is, perhaps, the most difficult type of programming. However games are always among the most popular types of mobile applications. This course teaches general game development techniques and then applies those to the Android development environment. This course covers topics critical to game programmers including OpenGL, audio coding, animation, and asset optimization for Android. During this course, participants will create a complete game application.

Photoshop CC Advanced - Web and Video course provides a thorough overview for experienced users who wish to further their effectiveness on Photoshop. This class is aimed at the Photoshop professional who needs to enhance their knowledge to work with web and video images more effectively.

This three-day, instructor-led course provides students with the knowledge and skills that are needed to successfully design and implement Web applications using Microsoft ASP.NET. This course assumes student exposure to the new features of ASP.NET that can be leveraged for Web applications matching corporate requirements.

Enroll Now »
Advanced Website Development with MySQL, PHP, and AJAX is an intensive programming course covering the industry's hottest web development skills:
MySQL
PHP
AJAX
This course begins with an in-depth exploration of PHP and MySQL. The combination of the PHP programming language and MySQL database technology allows participants to develop increasingly complex web applications. Finally the class introduces AJAX; a hot technology that many believe is the future of website development. Upon learning the material taught in this boot camp, participants will qualify for entry level web developer positions, and have the knowledge base to advance much farther.
Those with no web development background should attend the entire Website Development Professional course, which begins 2.5 more days before this 4.5-day course, for a total of 7-days of expert-led training without interruption.

Building on concepts introduced in Architecting on AWS, Advanced Architecting on AWS is intended for individuals who are experienced with designing scalable and elastic applications on the AWS platform. In this course, you will cover how to build complex solutions that incorporate data services, governance, and security on AWS. You will get an introduction to specialized AWS services, including AWS Direct Connect and AWS Storage Gateway to support hybrid architecture. You will also cover designing best practices for building scalable, elastic, secure, and highly available applications on AWS
This course leads to AWS Certified Solutions Architect - Professional Certification
Intended Audience for this Advanced Architecting on AWS
» Experienced IT professionals who are familiar with AWS services
Course Prerequisites for Advanced Architecting on AWS
» Required: Achieved AWS Certified Solutions Architect - Associate
» Recommended: Architecting on AWS
Advanced Architecting on AWS Course Objectives
» Manage multiple AWS accounts for your organization
» Connect on-premises datacenter to AWS cloud
» Discuss billing implications of connecting multi-region VPCs
» Move large data from on-premises datacenter to AWS
» Design large datastores for AWS cloud
» Understand different architectural designs for scaling a large website
» Protect your infrastructure from DDoS attack
» Secure your data on AWS with encryption
» Design protection of data-at-rest as well as data-in-flight
» Enhance the performance of your solutions
Advanced Architecting on AWS Course Outline
AWS Well-Architected Framework
AWS Account Strategies
Advanced Network Architectures
Designing Large Data Stores for AWS
Web-Scale Applications
Building Resilience
Comprehensive Cloud Security
Data Security and Encryption on AWS
Designing for Performance
Deployment Management
Do you have the right background for Advanced Architecting on AWS?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Architecting on AWS training covers the fundamentals of building IT infrastructure on AWS. The course is designed to teach solutions architects how to optimize the use of the AWS Cloud by understanding AWS services and how these services fit into cloud-based solutions. This course emphasizes AWS cloud best practices and recommended design patterns to help students think through the process of architecting optimal IT solutions on AWS. Case studies throughout the course showcase how some AWS customers have designed their infrastructures and the strategies and services they implemented.
This course leads to AWS Certified Solutions Architect - Associate Certification
Intended Audience for this Architecting on AWS
» Individuals who are responsible for designing cloud infrastructure and reference architectures
» Systems engineers and developers who are responsible for designing and implementing architectures on AWS
Course Prerequisites for Architecting on AWS
» Required: Attended AWS Essentials or have equivalent experience
» Required: Familiarity with cloud computing concepts
» Required: Familiarity with general networking concepts
» Required: Working knowledge of distributed systems
» Required: Working knowledge of multi-tier architectures
» Recommended: AWS Technical Essentials
Architecting on AWS Course Objectives
» Making decisions based on the AWS-recommended architectural principles and best practices
» Leveraging AWS services to make your infrastructure scalable, reliable, and highly available
» Leveraging AWS managed services to enable greater flexibility and resiliency in an infrastructure
» Making an AWS-based infrastructure more efficient in order to increase performance and reduce costs
» Using the Well-Architected Framework to improve architectures with AWS solutions
Architecting on AWS Course Outline
Core AWS Knowledge
Designing Your Environment
Making Your Environment Highly Available
Forklifting an Existing Application onto AWS
Event-Driven Scaling
Automating and Decoupling Your Infrastructure
Designing Storage at Scale
Hosting a New Web Application on AWS
The Four Pillars of the Well-Architected Framework
Disaster Recovery and Failover Strategies
Troubleshooting Your Environment
Large-Scale Design Patterns and Case Studies
This training prepares students for the following exam(s):
» AWS : AWS Certified Solutions Architect - Associate exam
Back to Top
Do you have the right background for Architecting on AWS?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
Take your FREE Skill Assessment test »

jQuery is a cross-browser JavaScript library used to create dynamic web pages. It was written to make DOM manipulation (moving things around a web page) easier for developers. It uses JavaScript to assign HTML elements these attributes. Because it is a library of predefined functions, all you need to start using jQuery is a working knowledge of the syntax and a reference for the functions available to you.
jQuery has numerous advantages over other JavaScript libraries; some of them being that it is easy to start with, is cross browser-friendly, uses shorter code, has a considerable number of available plugins, and most of all, is easy to use with Ajax
This course will show how you can integrate jQuery 3.0 into your web pages, avoid complex JavaScript code, create brilliant animation effects for your web applications, and create a flawless app.
Begin with configuring and customizing the jQuery environment and get hands-on with DOM manipulation. Learn to integrate jQuery with your favorite backend framework. Learn how the ECMAScript 6 features affect web development with jQuery. Discover how to use the newly introduced JavaScript promises and the new animation API in jQuery 3.0, along with sample code and examples.
This course extends from covering the basics of the jQuery library and discussing the latest features introduced in its newest version, jQuery 3, to implementing advanced effects, events, DOM manipulation, and Ajax.
By the end of the course, you will be able to successfully create a fully-featured and efficient single-page web application and leverage all the new features of jQuery 3.0 effectively.

10990: Analyzing Data with SQL Server Reporting Services course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
This course is based on the objectives of the course version 10990C.
SATV Eligible Course
Don't let your SATVs expire - put them to work for your organization today. Reserve your seat for the SATV eligible courses. To place your schedule request call at 1-888-563-8266 or chat live with a Learning Consultant.
Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.
Intended Audience for this 10990: Analyzing Data with SQL Server Reporting Services (SQL Server 2017)
» The primary audience for this course is database professionals who need to fulfill a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.
» The secondary audiences for this course are power information workers.
Course Prerequisites for 10990: Analyzing Data with SQL Server Reporting Services (SQL Server 2017)
» Required: Basic knowledge of the Microsoft Windows operating system and its core functionality.
» Recommended: 20761: Querying Data with Transact-SQL (SQL Server 2017)
10990: Analyzing Data with SQL Server Reporting Services (SQL Server 2017) Course Objectives
» Describe reporting services and it’s components
» Describe reporting services data sources
» Implement paginated reports
» Work with reporting services data
» Visualize data with reporting services
» Aggregate report data
» Share reporting services reports
» Administer reporting services
» Expand and integrate reporting services
» Describe mobile reports
» Develop mobile reports
10990: Analyzing Data with SQL Server Reporting Services (SQL Server 2017) Course Outline
Introduction to Business Intelligence and Data Modeling
Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services
Lab : Exploring an enterprise BI solution
Reporting Services Data
Data sources
Connection strings
Datasets
Filters and parameters
Lab : Configuring a data connection
Implementing reports
Creating a report with the report wizard
Creating a report
Showing data graphically in a report
Lab : Creating a report
Configuring reports
Implementing filters and parameters
Implementing sorting and grouping
Publishing a report
Lab : Create and Publish reports that include parameters
Creating Mobile Reports
Overview of SQL Server mobile reports
Preparing data for mobile reports
SQL Server Mobile report publisher
Lab : Working with mobile reports
Do you have the right background for 10990: Analyzing Data with SQL Server Reporting Services (SQL Server 2017)?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
Take your FREE Skill Assessment test »

Artiﬁcial Intelligence (AI) is a big ﬁeld, and this course explores the full breadth of the ﬁeld, which encompasses logic, probability, and continuous mathematics, perception, reasoning, learning, and action, and everything from microelectronic devices to robotic planetary explorers.

Analytic SQL for Data Warehousing / Advanced SQL Workshop Course Objectives
» Using SQL with aggregation operators
» Understand the GROUPING function, Composite Columns and the concatenated Groupings
» Analyzing and reporting data using Ranking functions
» Performing advanced pattern matching
» Using regular expressions to search for, match and replace strings
Analytic SQL for Data Warehousing / Advanced SQL Workshop Course Outline
Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
Perform advanced pattern matching.
Use regular expressions to search for, match and replace strings.
Do you have the right background for Analytic SQL for Data Warehousing / Advanced SQL Workshop?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
Take your FREE Skill Assessment test »

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
This course is based on the objectives of the course version 20778B.

Adobe Illustrator is a cutting-edge vector graphics editor used to compose, edit, and transform vector images. This robust graphics editor software allows you to create and store images in widely popular vector formats, such as EPS, PDF, WMF, SVG, or VML, to be used on a wide range of platforms and devices. Considered as the most essential skill for graphic and web designers, Illustrator helps create eye-catching and engaging graphics, logos, cartoons, and fonts, as well as photo realistic layouts for Adobe Photoshop.
NetCom Learning is a pioneer in providing Adobe Illustrator training courses to empower you with comprehensive skills in developing and editing vector images for commercial and personal use. We deliver best-in-class Adobe Illustrator certification trainings explaining how to work with layers, create captivating infographics, trace artwork, and use ultra-modern drawing tools for creating vector graphics as an expert professional.