NetCom Learning

As a data pro, you know that some scenarios—particularly those involving real-time analytics, site personalization, IoT, and mobile apps—are better addressed with NoSQL storage and compute solutions than they are with relational databases. Microsoft Azure has several NoSQL (or “Not Only SQL”) non-relational data storage options to choose from. NoSQL databases are generally built to be distributed and partitioned across many servers. And they’re built to scale out for high availability and to be flexible enough to handle semi-structured and unstructured data. If you have a data model that is constantly evolving and you want to move fast, that’s what these databases are about.

In this practical course, complete with labs, assessments, and a final exam, join the experts to learn how NoSQL has evolved over time. Explore non-relational data storage options in Azure, and see how to use them in your applications. Find out how to create, store, manage, and access data in these different storage options. Get an in-depth look at Azure Table Storage, DocumentDB, MongoDB, and more. Learn about the “three Vs”—variety (schemas or scenarios that evolve quickly), volume (scale in terms of data storage), and velocity (throughput needs to support a large user base). Take this opportunity to get hands-on with NoSQL options in Azure.

In Skype for Business: Cloud Voice Concepts and Planning you will learn about Skype for Business Online and how it can provide meeting and voice functionality.

You will learn how to plan a Cloud PBX deployment, including the integration with on-premises PSTN connections. You will also learn how to deploy PSTN conferencing, and integrate cloud identity and security with on-premises Active Directory. Finally, you will learn how to successfully plan a voice deployment.

This course is the second in a series of three online courses designed to help you prepare for taking the 70-333 “Deploying Enterprise Voice with Skype for Business 2015” exam.

IT Support: Networking Essentials is designed to introduce the core networking concepts to learners who are new to IT Support. The course begins by explaining the purpose of networking and then examines how networks are configured in homes, offices, between offices, and around the world with the Internet. This includes a review of network topologies, physical networking, and network protocols. The course concludes with an introduction to network troubleshooting, including how to troubleshoot common networking issues.

In this course, you will learn about network solutions you can implement in your organization. You will learn how to enable user access and secure communications, protect data, connect and run remote software, and virtualize your network infrastructure. The course will help you:

- Improve your skills in implementing a storage infrastructure
- Decide if a career in IT is for you
- Prepare for an introductory job in Windows Server administration
- Study for Microsoft certification tests and badges

In this introductory/intermediate-level class, you will learn the basics of building and working with ASP.NET applications using Visual Studio.NET. You will get an introduction to ASP.NET for web development, and you'll cover Visual Studio 2008, enabling you to get up and running quickly. Drill down into the details of web application architecture, leveraging user controls, and managing session and application state. You also will learn to work with ADO.NET and the data bound controls in the framework. The class includes examples and exercises in both C# and VB.NET.

Google Cloud Platform Fundamentals for AWS Professionals course with labs introduces AWS professionals to the core capabilities of Google Cloud Platform (GCP) in the four technology pillars: networking, compute, storage, and database. It is designed for AWS Solution Architects and SysOps Administrators familiar with AWS features and setup and want to gain experience configuring GCP products immediately. With presentations, demos, and hands-on labs, participants get details of similarities, differences, and initial how-tos quickly.

Intended Audience for this Google Cloud Platform Fundamentals for AWS Professionals

» AWS Solution Architects just getting started with Google Cloud Platform
» AWS SysOps Administrators used to building IaaS solutions
» Architects and Engineers operating in multi-cloud environments

Course Prerequisites for Google Cloud Platform Fundamentals for AWS Professionals

» Required: Basic proficiency with networking technologies like subnets and routing
» Required: Experience with Amazon VPC, Amazon EC2 instances, and disks
» Required: Familiarity with Amazon S3 and AWS database technologies

Google Cloud Platform Fundamentals for AWS Professionals Course Objectives

» Identify GCP counterparts for Amazon VPC, subnets, routes, NACLs, IGW, Amazon EC2, Amazon EBS, auto-scaling, Elastic Load Balancing, Amazon S3, Amazon Glacier, Amazon RDS, Amazon Redshift, AWS IAM, and more
» Configure accounts, billing, projects, networks, subnets, firewalls, VMs, disks, auto scaling, load balancing, storage, databases, IAM, and more
» Manage and monitor applications
» Explain feature and pricing model differences
» Locate documentation and training

Google Cloud Platform Fundamentals for AWS Professionals Course Outline

Introducing Google Cloud Platform
Google Cloud infrastructure
AWS regions, availability zones, and CloudFront
GCP regions, zones, edge caching, and Cloud CDN
GCP services
Setting up Accounts and Billing
AWS accounts, billing, and IAM roles
GCP accounts, billing accounts, projects, and admin setup
Account, billing, project, and admin setup
Networking
Amazon VPC, subnets, routes, NACLs, and security groups
GCP networks, subnets, routes, and firewall rules
VMs in networks
Working with VM Instances
Amazon EC2 instance types, AMIs, Amazon EBS, ephemeral drives, spot instances
Google Compute Engine machine types, instances, persistent disks, local SSDs, preemptible VMs
VM and web app deployment
Scaling and Load Balancing Apps
Amazon EC2 launch configurations, auto-scaling groups, load balancing
Google Compute Engine instance templates, managed instance groups, load balancing
Autoscaling and load balancing setup
Isolating Instances and Apps
A 3-tier web app in GCP
A custom network with custom subnets and firewall rules
Using Storage as a Service and Database as a Service
Amazon S3, Amazon Glacier, Amazon RDS, Amazon DynamoDB, Amazon Redshift, Amazon Athena
Google Cloud Storage, Google Cloud SQL, Cloud Spanner, Google Cloud Datastore, Google Cloud Bigtable, Google BigQuery
Deployment and Monitoring
AWS CloudFormation, Amazon CloudWatch
Google Cloud Deployment Manager, Google StackDriver
Labs:
Set up projects and billing accounts with a free-trial GCP account
Add VMs, explore the default network, and test connectivity
Deploy VMs with an app by console and command line
Scale and load balance instances and test under load
Build a 3-tier web app with public front-end and private backend
Use gsutil command-line tool to perform operations on buckets and objects in Cloud Storage
Load and analyze data in BigQuery
Deploy your infrastructure using Deployment Manager

Do you have the right background for Google Cloud Platform Fundamentals for AWS Professionals?
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 gain an all-round understanding of Bitcoin, the revolutionary cryptocurrency that is causing shockwaves through the finance industry. As well as gaining an understanding, you will be able to pinpoint ways in which you can get involved in the Bitcoin eco-system as an individual, or a business.

This course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

This course is based on the objectives of the course version 20767C.

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.

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 20767: Implementing a SQL Data Warehouse (SQL Server 2017)

» The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Course Prerequisites for 20767: Implementing a SQL Data Warehouse (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

20767: Implementing a SQL Data Warehouse (SQL Server 2017) Course Objectives

» Describe the key elements of a data warehousing solution
» Describe the main hardware considerations for building a data warehouse
» Implement a logical design for a data warehouse
» Implement a physical design for a data warehouse
» Create columnstore indexes
» Implementing an Azure SQL Data Warehouse
» Describe the key features of SSIS
» Implement a data flow by using SSIS
» Implement control flow by using tasks and precedence constraints
» Create dynamic packages that include variables and parameters
» Debug SSIS packages
» Describe the considerations for implement an ETL solution
» Implement Data Quality Services
» Implement a Master Data Services model
» Describe how you can use custom components to extend SSIS
» Deploy SSIS projects
» Describe BI and common BI scenarios

20767: Implementing a SQL Data Warehouse (SQL Server 2017) Course Outline

Introduction to Data Warehousing
Overview of Data Warehousing
Considerations for a Data Warehouse Solution
Lab : Exploring a Data Warehouse Solution
Exploring data sources
Exploring an ETL process
Exploring a data warehouse
Planning Data Warehouse Infrastructure
Considerations for data warehouse infrastructure.
Planning data warehouse hardware.
Lab : Planning Data Warehouse Infrastructure
Planning data warehouse hardware
Designing and Implementing a Data Warehouse
Designing dimension tables
Designing fact tables
Physical Design for a Data Warehouse
Lab : Implementing a Data Warehouse Schema
Implementing a star schema
Implementing a snowflake schema
Implementing a time dimension table
Columnstore Indexes
Introduction to Columnstore Indexes
Creating Columnstore Indexes
Working with Columnstore Indexes
Lab : Using Columnstore Indexes
Create a Columnstore index on the FactProductInventory table
Create a Columnstore index on the FactInternetSales table
Create a memory optimized Columnstore table
Implementing an Azure SQL Data Warehouse
Advantages of Azure SQL Data Warehouse
Implementing an Azure SQL Data Warehouse
Developing an Azure SQL Data Warehouse
Migrating to an Azure SQ Data Warehouse
Copying data with the Azure data factory
Lab : Implementing an Azure SQL Data Warehouse
Create an Azure SQL data warehouse database
Migrate to an Azure SQL Data warehouse database
Copy data with the Azure data factory
Creating an ETL Solution
Introduction to ETL with SSIS
Exploring Source Data
Implementing Data Flow
Lab : Implementing Data Flow in an SSIS Package
Exploring source data
Transferring data by using a data row task
Using transformation components in a data row
Implementing Control Flow in an SSIS Package
Introduction to Control Flow
Creating Dynamic Packages
Using Containers
Managing consistency.
Lab : Implementing Control Flow in an SSIS Package
Using tasks and precedence in a control flow
Using variables and parameters
Using containers
Lab : Using Transactions and Checkpoints
Using transactions
Using checkpoints
Debugging and Troubleshooting SSIS Packages
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package
Lab : Debugging and Troubleshooting an SSIS Package
Debugging an SSIS package
Logging SSIS package execution
Implementing an event handler
Handling errors in data flow
Implementing a Data Extraction Solution
Introduction to Incremental ETL
Extracting Modified Data
Loading modified data
Temporal Tables
Lab : Extracting Modified Data
Using a datetime column to incrementally extract data
Using change data capture
Using the CDC control task
Using change tracking
Lab : Loading a data warehouse
Loading data from CDC output tables
Using a lookup transformation to insert or update dimension data
Implementing a slowly changing dimension
Using the merge statement
Enforcing Data Quality
Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match Data
Lab : Cleansing Data
Creating a DQS knowledge base
Using a DQS project to cleanse data
Using DQS in an SSIS package
Lab : De-duplicating Data
Creating a matching policy
Using a DS project to match data
Using Master Data Services
Introduction to Master Data Services
Implementing a Master Data Services Model
Hierarchies and collections
Creating a Master Data Hub
Lab : Implementing Master Data Services
Creating a master data services model
Using the master data services add-in for Excel
Enforcing business rules
Loading data into a model
Consuming master data services data
Extending SQL Server Integration Services (SSIS)
Using scripting in SSIS
Using custom components in SSIS
Lab : Using scripts
Using a script task
Deploying and Configuring SSIS Packages
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Lab : Deploying and Configuring SSIS Packages
Creating an SSIS catalog
Deploying an SSIS project
Creating environments for an SSIS solution
Running an SSIS package in SQL server management studio
Scheduling SSIS packages with SQL server agent
Consuming Data in a Data Warehouse
Introduction to Business Intelligence
An Introduction to Data Analysis
Introduction to reporting
Analyzing Data with Azure SQL Data Warehouse
Lab : Using a data warehouse
Exploring a reporting services report
Exploring a PowerPivot workbook
Exploring a power view report

ROUTE v2.0, course, includes major updates and follows an updated blueprint. (However, note that this course does not cover all items listed on the blueprint.) Some older topics have been removed or simplified, while several new IPv6 routing topics have been added. The course content has been adapted to Cisco IOS Software Release 15 and technically updated.

The goal of the course is to build upon the knowledge and skills from CCNA Routing and Switching and help you expand competencies to plan, implement, and monitor a scalable routing network.

Exam Format
Exam Number - 300-101
Duration - 120 minutes (45 - 55 questions)
Register with - Pearson VUE

This is an all-inclusive e-learning solution designed to prepare CCNP Routing and Switching or CCDP candidates for the exam topics covered by the ROUTE exam (300-101).

This is an advanced course on Cisco routing configuration for both IPv4 and IPv6. Students will gain the knowledge to configure and optimize a routing domain using OSPF, EIGRP, BGP, PBR, IP SLA and configure redistribution when needed. It also includes the configuration of highly secure routing solutions to support branch offices and mobile workers.

This training product builds knowledge using a sequence of structured modules that provide an interactive, hands-on learning approach, enabling students to master the essential technology topics in a self-paced format.

This Cisco self-paced course is designed to be as effective as classroom training. Course content is presented in easily-consumable segments via both Instructor Video and text. Interactivity is enabled through Discovery labs, content review questions, and graded Challenge labs and tests. This makes the learning experience hands-on, increasing course effectiveness, and provides students direct feedback on how well they have mastered the material. And gamification features are built in, including earning badges and a leaderboard, to encourage better performance.