|
|
|
SQL Server 2005: A Comprehensive Hands-On Introduction
Course: 131
Type: Hands-On Training
Duration: 4 Days
You Will Learn How To
- Build databases, queries and reports for SQL Server 2005
- Create and manage databases with SQL Server Management Studio
- Generate Transact-SQL statements for data retrieval and modification
- Implement security and back up databases to protect critical data
- Configure merge replication and handle data conflicts
- Explore business intelligence solutions using Integration, Analysis and Reporting Services
Course Benefits SQL Server 2005 offers a robust architecture for enterprise data management, developer productivity and business intelligence. This course provides the knowledge and practical skills needed to maximize the benefits of SQL Server 2005. You gain a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements and implementing security.
Who Should Attend Those who are new to SQL Server, as well as those evaluating SQL Server 2005. Familiarity with relational databases is helpful.
Hands-On Training Exercises throughout the course reinforce the knowledge you gain in class, including:
- Installing SQL Server 2005
- Creating databases with SQL Server Management Studio
- Adding primary and foreign key constraints to tables
- Retrieving and joining data from tables
- Simplifying data access using views
- Defining a database maintenance plan
- Backing up databases to protect against disasters
- Automating administrative jobs with SQL Server Agent
- Importing data from text files using SSIS
Course 131 Content
- Express
- Standard
- Enterprise
- Workgroup
- Mobile
- Developer
- SQL Server Management Studio
- Business Intelligence Development Studio
- SQL Server Agent
- Database engine
- Choosing file names and locations
- Determining file size and growth parameters
- Utilizing schemas to partition tables
- Defining columns and attributes
- Selecting appropriate datatypes
- Setting the primary keys and indexes
- Modifying or removing columns
- Enforcing check constraints
- Validating the existing data
- Protecting relationships with foreign keys
- Writing SQL queries with Management Studio
- Sorting the final result sets
- Aggregating data by groups
- Joining columns from different tables
- Refining result sets with subqueries
- Generating views with Management Studio
- Simplifying data access with views
- Constructing a stored procedure
- Executing a stored procedure
- Exploring functions and triggers
- Integrating SQL Server with Office
- Upsizing from Microsoft Access
- Displaying data on the Web with ASP.NET
- Pulling data into Microsoft Excel
- Allowing logins access to databases
- Creating SQL Server logins
- Implementing a security plan
- Defining database roles
- Granting permissions on tables to roles
- Checking database consistency
- Backing up the database and log
- Reporting on maintenance plan success
- Defining operators
- Generating and scheduling jobs
- Notifying operators of job outcome
- Performing routine database backups
- Restoring databases to fix corruptions
- Designing replication strategies
- Configuring the distribution server
- Publishing data with merge replication
- Pulling or pushing subscriptions
- Resolving conflicts using priorities
- Importing data into SQL Server
- Exporting data to text or CSV format
- Storing multidimensional data
- Pivoting cubes in Microsoft Excel
- Detecting patterns with data mining
- Authoring and deploying reports
- Viewing reports from a Web site
|
Related Courses
SQL Server is a registered trademark of Microsoft Corporation.
|
|
|
|
Print Friendly
E-mail a Colleague
Course FAQ
Course PDF
Home
