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!

MS-6232: Implementing a Microsoft SQL Server Database

Course Overview:

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

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

Dates/Locations:

No Events

Duration: 5 Days

Course Objectives:

Creating Databases and Databases Files
Creating Data Types and Tables
Creating and Tuning Indexes
Implementing Data Integrity by Using Constraints and Triggers
Using XML
Implementing Views
Implementing Stored Procedures
Implementing Functions
Implementing Managed Code in the Database
Managing Transactions and Locks
Using Service Broker

Prerequisites:

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
Some experience with database design

Comments

Latest comments from students

User: bangbangsplat

Instructor comments: some kind of presentation would have been helpful in learning the objectives of the course (PowerPoint, drawing on easel, etc.) It seemed like the instructor is not too familiar with the error codes we were receiving during the Practice Exams.

Facilities comments: preferred to have the location located in a less busy area of the city

User: smaxam

Instructor comments: Clay was very knowledgable but had to repeat questions a number of times to get his attention.

Facilities comments: Holiday Inn was nice

Liked the class? Then let everyone know!

TechNow Security Courses

Here are the security courses specific to TechNow:

TN-5305: Supporting and Troubleshooting Windows 11

Course Overview:

This five-day instructor-led course provides IT professionals with the knowledge and skills required to Support and Troubleshoot Windows 11 PCs and devices in an on-premises Windows Server Active Directory domain environment.

Attendees to TN-5320: Supporting and Troubleshooting Windows 11 will receive TechNow approved course materials and expert instruction.

Dates/Locations:

No Events

Duration: 5 Days

Course Objectives:

Describe the processes involved in planning and using a troubleshooting methodology for Windows 11
Troubleshoot startup issues and operating system services on a Windows 11 PC
Perform system recovery
Resolve issues related to hardware devices and device drivers
Administer Windows 11 devices
Troubleshoot issues related to network connectivity
Configure Windows 11 devices by using Group Policy
Configure and troubleshoot user settings
Configure and troubleshoot resource access
Implement remote connectivity
Deploy and troubleshoot applications
Maintain Windows 11 devices

Prerequisites:

Networking fundamentals, including Transmission Control Protocol /Internet Protocol (TCP/IP), User Datagram Protocol (UDP), and Domain Name System (DNS).
Microsoft Active Directory Domain Services (AD DS) principles.
Understanding of the Public Key Infrastructure (PKI) components.
Windows Server fundamentals.

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