INSTALLING, CONFIGURING AND TROUBLESHOOTING MICROSOFT® SQL SERVER

In this seminar you'll learn...

How to install Microsoft SQL Server right the first time

How to configure your server for optimum performance

Security techniques that´ll keep your critical data safe and secure

How to design a relational database from start to finish

And much more!

Managing your database projects efficiently, knowledgably and effectively is only two intensive days of training away—compared with spending weeks or even months poring over huge manuals filled with information you may not want or even use! No more time spent on frustrating trial-and-error methods either. You´ll get nothing but the best hands-on training in database management methods that will really work for you. Just for starters, you´ll not only find out what the real hardware requirements are and why they´re different from what´s listed on the side of the box; you´ll find out why the default configuration is rarely—if ever—the right configuration for your system. After you´ve mastered installation and configuration, the learning is just beginning. Understanding database design, queries, Views, Stored Procedures, Triggers and Data Transformation Services is your next step. If you´ve been tasked with managing your company´s valuable data, this is must-have training. Enroll today and gain the skills to boost your Microsoft SQL Server status to that of "expert" after only two days spent in this information-packed workshop.

WORKSHOP AGENDA E-mail this Page

Installation and configuration of Microsoft® SQL Server

Getting Microsoft SQL Server installed and configured correctly can mean the difference between a system that´s efficient and stable and one that is constantly crashing or slows to a crawl with just a few users. This session will show you how to properly install your server software and then make the critical changes to the initial configuration that are a must when it comes to a properly functioning database server. You´ll learn ...

What the real hardware requirements are for Microsoft SQL Server

Which protocols you´ll want to enable and which ones you´ll want to exclude

How to register local and remote SQL servers in the SQL Server Management Studio

How to properly configure the memory allocation for your server, depending on your expected load level

Why you might want to change the default authentication settings, depending on how your server will be used

Database design and implementation

Proper database design is the first step toward creating an efficient and effective database solution. In this session, you´ll gain a thorough understanding of how a relational database works and the keys to proper database design. We´ll also show you how to use the Database Diagram tool to help you visualize the relationships between tables and aid you in the proper design of your databases. Also in this session ...

How to create a database within the SQL Server Management Studio and how to create one from a script

How to manually create a new table and how to import data into a new table from an external source

The importance of primary keys and how to set them

What a foreign key is and how it is used

The different data types supported in Microsoft SQL Server and how to create custom data types

Queries—getting the right data

Nothing is more frustrating than knowing what data you want to pull from your database but not knowing how to get it. In this session, you´ll learn the proper steps to create queries in the Query Editor that´ll give you the right data set without wasting valuable time on trial-and-error methods. You´ll also learn the techniques for optimizing your queries so you don´t overload your servers, especially those using extremely large data sets. You´ll also find out ...

How a query can be used to not only pull data but also to update or insert new data into your tables

How to use the "Order by" clause to sort the results of your query

A quick technique to output all the columns in a table in your query and why you shouldn´t always use that technique

How to change the look of the output from a query by using column aliases

The correct way to use the "Where" clause to limit the results of your query and what to do when the "Where" clause won´t work

Views, indexes, Stored Procedures and Triggers

Microsoft SQL Server has a variety of tools and functions that give you flexibility and incredible control when working with your data. In this session, you´ll discover how to work with Views, indexes, Stored Procedures and Triggers to view, validate and modify your data. You´ll learn the purpose of each one and how to use them to maximize the functionality of your database system. Also in this session ...

How to create a View and why you may want to restrict the number of Views you create for a particular database

How an indexed View can dramatically improve the performance of some types of queries and what version of Microsoft SQL Server you must have in order to implement them

The purpose of an index and how to use the Database Engine Tuning Advisor to analyze your queries and suggest the indexes that should be created

What a Stored Procedure is and the rules you have to follow when creating one

How to extend the capabilities of your server by creating Extended Stored Procedures

How to use Triggers to enforce business rules and data integrity

Importing and exporting data using SQL Server Integration Services

Many companies have data stored in a variety of formats and locations. SQL Server Integration Services provide an easy-to-use graphical interface that allows you to extract, transform and consolidate your company´s data into one or more locations. In this session, you´ll learn how to take advantage of SQL Server Integration Services to consolidate data on your server from a huge variety of sources. You´ll learn ...

How to use the SSIS Import/Export Wizard to copy data to and from your server and to map transformations on the data

How to use the SSIS Designer to build packages with workflows and event-driven logic or to edit packages created with the SSIS Import/Export Wizard

The right way to add and configure an SSIS task

How to set up an SSIS connection to an external data source

How to add precedence constraints to your SSIS workflow to control when and if each task is executed

Managing your Microsoft SQL Server

Once you´ve got your system set up and you have active users accessing it, you have to monitor and manage your server to maintain proper performance, and that´s what this session is about. You´ll learn how to use the SQL Server Management Studio to monitor server activity, and you´ll also find out how to use the Microsoft SQL Server Best Practices Analyzer to verify the implementation of common Best Practices on your servers. You´ll also find out ...

How to set up the SQL Server Agent to schedule periodic activities and send notifications of server problems

How to use a Database Maintenance Plan to create a job to automatically handle maintenance tasks in SQL

How to use the SQL Server Logs to monitor and troubleshoot SQL Servers

Tips and techniques for tuning your SQL Server that use the Database Engine Tuning Advisor

How to de-bunk the error codes from your SQL Server

Database replication

Replication provides the benefit of data availability when and where you need it, and that´s the topic of this informative session. You´ll start off this session by learning how to plan for replication and which types will work best for your organization. You´ll then discover the correct steps for implementing replication, including configuring Publishers and Distributors. Also in this session ...

How to simplify the process of configuring and implementing replication by using the Replication Wizard

How to monitor and administer replication agents, replication alerts and replication processes to ensure that your replication plan meets your organization´s needs

How to enhance replication performance through some sure-fire tweaks

All the replication options that are available, such as filtering and data transformation

How replication affects the security of your data

Microsoft SQL Server security

Protecting your critical business data is one of the most important components of a database administrator´s job, and that´s the focus of this session. You´ll uncover the security architecture of Microsoft SQL Server, and find out where the potential security risks are and what you can do to eliminate them. You´ll learn about some recently discovered security flaws and why blindly applying patches may not be your best option when trying to lock down your server. You´ll also learn ...

The different security levels found in Microsoft SQL Server

How to use the SQL Server Management Studio to create and manage security accounts

How to apply permissions on database objects all the way down to the field level

What linked servers are and how to establish security on them

What server roles are and how they´re used to manage security on your server

How to troubleshoot security-related issues

How replication affects the security of your data

Microsoft® SQL Server security

The different security levels found in Microsoft SQL Server

How to use the Enterprise Manager to create and manage security accounts

How to apply permissions on database objects all the way down to the field level

What linked servers are and how to establish security on them