MS-6231: Maintaining a Microsoft SQL Server Database

 

Course Overview:

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to maintaining a database.

Attendees to MS-6231: Maintaining a Microsoft SQL Server Database will receive TechNow approved course materials and expert instruction.

Dates/Locations:

No Events

Duration: 5 Days

Course Objectives:

  • Installing and Configuring SQL Server
  • Managing Databases and Files
  • Disaster Recovery
  • Managing Security
  • Transferring Data
  • Automating Administrative Tasks
  • Implementation Replication
  • Maintaining High Availability
  • Monitoring SQL Server
  • Troubleshooting and Performance Tuning

Prerequisites:

  • None

Comments

Latest comments from students

User: angelangeles

Instructor comments: Clay was knowledgeable instructor with enough experience to make subject matter relatable to real world usage.

 

Liked the class?  Then let everyone know!

DP-201: Designing an Azure Data Solution

 

Course Overview:

In this course, the students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, NoSQL, or Data Warehouse data. They will also learn how to design process architectures using a range of technologies for both streaming and batch data. The students will also explore how to design data security, including data access, data policies, and standards. They will also design Azure data solutions, which includes the optimization, availability, and disaster recovery of big data, batch processing, and streaming data solutions.

TechNow has worked worldwide enterprise infrastructures for over 20 years and has developed demos and labs to exemplify the techniques required to demonstrate cloud technologies and to effectively manage security in the cloud environment.

Attendees to DP-201: Designing an Azure Data Solution will receive TechNow approved course materials and expert instruction.

Date/Locations:

No Events

Course Duration: 3 days

Course Outline:

  • Data Platform Architecture Considerations
  • Azure Batch Processing Reference Architectures
  • Azure Real-Time Reference Architectures
  • Data Platform Security Design Considerations
  • Designing for Resiliency and Scale
  • Design for Efficiency and Operations

Prerequisites :

      • In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:
      • AZ-900: Microsoft Azure Fundamentals
      • DP-200: Implementing an Azure Data Solution

Comments

Latest comments from students

 

Liked the class?  Then let everyone know!

PM-242: Defining Agile Requirements with User Stories

 

Course Overview: 

 

This course identifies how business analysts can elicit Agile requirements by writing user stories from use cases and personas of customer profiles.  This leads to the processes of confirming the validity and usability for quality of the product development.  An Agile Business Analyst has become a new recognized role within the other Agile Framework roles.

Attendees to PM-242:Defining Agile Requirements with User Stories will receive TechNow approved course materials and expert instruction.

Dates/Locations:

No Events

Duration: 2 Days

Course Objectives: At the conclusion of this course, students will be able to:

  • Understand the Scrum Flow, the core components of the Scrum framework
  • Understand the scope of the Product Owner role in detail
  • Understand the scope of the Agile Business Analysis role in coordination with the Product Owner, Scrum Master and Development Team
  • Understand the scope of the Scrum Master role at a high level
  • Understand the scope of the Scrum Development Team roles
  • Document the interactions between the user of a system and the system itself
  • Dive into understanding the Agile principles for requirements using user stories in a card, conversation, and confirmation format

 

Target Student:

  • Designed specifically for Agile project team members, product owners, project leaders and business analysts or anyone wanting to understand the Agile Framework.

Comments

Latest comments from students

Liked the class?  Then let everyone know!

TN-215: Shell Programming

Course Overview:

This intensive hands-on class teaches students to develop customized UNIX™ commands, read & write Bourne, Korn & Bash Shell scripts & automate critical server functions.  The course includes extensive lab exercises, including hands-on development & debugging of shell scripts, which will give students the ability to be more efficient and productive in less time. The focus of the course will be the Bash shell.

Attendees to TN-215: Shell Programming will receive TechNow approved course materials and expert instruction.

Dates/Locations:

No Events

Duration: 5 days

Course Objectives:

  • Shell Review
  • Shell Interpretation of Quotes & Backslash
  • The Bash Shell
  • Shell’s combined with UNIX utilities
  • Programming Basics
  • Data Constructs
  • Programming Looping
  • Your Environment
  • More on Parameters
  • Advanced Shell Programming

Prerequisites:

Comments

Latest comments from students

User: hnzarate

Instructor comments: Very knowledgeable.

Facilities comments: This hotel needs better water.

Liked the class?  Then let everyone know!

MS-5002: Introduction to SQL Databases

 

Course Overview:

The introduction to SQL Databases training course is designed to train the learners on the fundamentals of database concepts. You will not only learn about the different types of databases, the languages and designs as well as describe important database concepts using SQL Server 2016. Anyone who is moving into a database role will benefit from taking this course.

 

Attendees to MS-5002: Introduction to SQL Databases will receive TechNow approved course materials and expert instruction.

Date/Locations:

No Events

Course Duration: 2 days

 

Comments

Latest comments from students

 

Liked the class?  Then let everyone know!