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!

Course Overview:

This instructor-led course provides students with the knowledge and skills to plan, deploy, and manage Microsoft SCCM. The course focuses on planning and deploying sites and clients, configuring software distribution, deploying operating systems, and managing software updates. It also focuses on remote tools and managing mobile devices.

Attendees to MS-6451A: Planning, Deploying, and Managing Microsoft System Center Configuration Manager will receive TechNow approved course materials and expert instruction.

Dates/Locations:

No Events

Duration: 5 days

Course Objectives:

• Overview of Configuration Manager 2007
• Planning and Deploying a Single-Site Architecture
• Planning and Deploying Configuration Manager 2007 Clients
• Collecting Inventory and Metering Software Usage
• Querying and Reporting Data
• Preparing for and Managing Software Distribution
• Deploying Operating Systems Using Configuration Manager 2007
• Deploying and Managing Software Updates
• Working with Desired Configuration Management in Configuration Manager 2007
• Remote Tools and Wake on LAN Features
• Managing Mobile Devices Using Configuration Manager 2007
• Maintaing and Troubleshooting Configuration Manager 2007

Prerequisites:

• A base-level understanding of Systems Management Server 2003.
• System Administrator–level working knowledge of:
  • Deployment, configuration, and troubleshooting for Windows-based personal computers
  • TCP/IP networking
  • SQL Server
  • Active Directory

Comments

Latest comments from students

Liked the class?  Then let everyone Know!

Course Overview

Sharepoint is becoming an institution in the modern office.  Collaboration, file sharing, and even internal social sites are all available in SharePoint 2010/2013. Take advantage of all that Sharepoint has to offer.  Learn to install, configure and administer SharePoint 2010/2013, by taking this 5 day course.

Attendees to MS-10174: Configuring and Administering SharePoint 2010/2013 will receive TechNow approved course materials and expert instruction.

Dates/Locations

No Events

Duration: 5 Days

Course Objectives:

• Prepare and Install SharePoint 2010/2013
• Configure the Fundamental Services and Logical Components
• Administer SharePoint Using Command Line, User Interface and Powershell
• Manage Content in Lists and Libraries
• Install, Configure, and Operate a SharePoint Farm

Prerequisites

• Students should be experienced Windows 2003 or Windows 2008 server administrators

Comments

Latest comments from students

Liked the class?  Then let everyone know!

Course Overview:

This course will provide you with the knowledge and skills to configure and manage an Exchange Server 2010 messaging environment. This course does not require previous Exchange Server experience, but does require that students have significant experience in managing Windows Server and Active Directory directory services or Active Directory Domain Services (AD DS). This course will teach you how to configure Exchange Server 2010, as well as provide guidelines, best practices, and considerations that will help you optimize your Exchange Server deployment.

Attendees to MS-10135: Configuring, Managing, and Troubleshooting Microsoft Exchange Server 2010 will receive TechNow approved course materials and expert instruction.

Dates/Locations:

No Events

Duration: 5 days

Course Objectives:

• Deploying MS Exchange Server
• Configuring Mailbox servers
• Managing Recipient Objects
• Managing Client Access
• Managing Message Transport
• Implementing Message Security
• Implementing High Availability
• Implementing Backup and Recovery
• Configuring Message Policy, and Compliance
• Securing MS Exchange Server
• Maintaining Exchange Server

Prerequisites:

• Fundamental knowledge of network technologies including Domain Name System (DNS) and firewall technologies.
• Experience with the Windows Server 2003 and Microsoft Windows Server 2008 operating systems.
• Experience with Active Directory directory services in Windows Server 2003 or AD DS Windows Server 2008.
• Experience managing backup and restore on Windows Servers.
• Experience using Windows management and monitoring tools such as Microsoft Management Console, Active Directory Users and Computers, Performance Monitor, Event Viewer, and Internet Information Services (IIS) Administrator.
• Experience using Windows networking and troubleshooting tools such as Network Monitor, Telnet, and NSLookup.

Comments

Latest comments from students

Liked the class?  Then let everyone know!

Course Overview:

This course is intended for IT Professionals who use Microsoft SharePoint 2010 in a team-based, medium-sized to large environment. While they may have implemented a SharePoint deployment, they have limited experience in designing a SharePoint infrastructure. They likely work as a senior administrator who acts as a technical lead over a team of administrators. Members of this audience should have at least 6 months experience with SharePoint 2010 (including pre-released versions of the product).

Attendees to MS-10231: Designing a Microsoft SharePoint 2010/2013 Infrastructure will receive TechNow approved course materials and expert instruction.

Date/Location:

No Events

Duration: 5 days

Course Objectives:

• Designing a Logical Architecture
• Planning Service Application Architecture
• Planning for Performance and Capacity
• Designing a Physical Architecture
• Designing a Security Plan
• Planning Authentication
• Planning Managed Metadata
• Planning Social Computing
• Designing Enterprise Search Strategy
• Planning Enterprise Content Management
• Developing a Plan for Governance
• Designing a Maintenance and Monitoring Plan

Prerequisites:

• At least 2 years experience administering, deploying, managing, monitoring, upgrading, migrating, and designing SharePoint servers
• At least one year’s experience of mapping business requirements to logical and physical technical design
• Working knowledge of network design, including network security

Comments

Latest comments from students

Liked the class?  Then let others know!