NetCom Learning

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

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.

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.

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.

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

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 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.

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 »

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 »