| WORKSHOP AGENDA
Day one: 9:00 a.m. - 4:00 p.m.
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 Enterprise Manager
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 Enterprise Manager 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 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 Index Tuning Wizard 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
Day two: 9:00 a.m. - 4:00 p.m.
Importing and exporting data using Data Transformation Services
Many companies have data stored in a variety of formats and locations. Data Transformation 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 Data Transformation Services to consolidate data on your server from a huge variety of sources. You'll learn ...
How to use the DTS Import/Export Wizard to copy data to and from your server and to map transformations on the data
How to use the DTS Designer to build complex packages with workflows and event-driven logic or to edit packages created with the DTS Import/Export Wizard
The right way to add and configure a DTS task
How to set up a DTS connection to an external data source
How to add precedence constraints to your DTS 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 Enterprise Manager 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 go beyond just adding memory
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 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
What server roles are and how they're used to manage security on your server
How to troubleshoot security-related issues
|