In Installing, Configuring and Troubleshooting Microsoft® SQL Server®, 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, knowledegably 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
Click on a session title to view details
Installation and configuration of Microsoft SQL Server+
- What the real hardware requirements are for Microsoft SQL Server
- What you need to know about the new streamlined installation process to get it installed right the first time
- 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+
- 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+
- 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+
- 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 one
- 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+
- 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
- How the new Merge operator can automatically either insert a new record or update an existing record when populating data from a source into an existing table
- 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+
- 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 debunk the error codes from your SQL Server
Database replication+
- 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+
- 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
