|
|
|
Module 1: Microsoft SQL Server Overview
- What is SQL Server?
- SQL Server architecture
- SQL Server components
- Working with SQL Server
- Lab:
- Using SQL Server books online
Skills
- Skills: Students will be able to:
- Describe Microsoft SQL Server 7.0 and its supporting operating systems.
- Describe SQL Server architecture.
- Describe SQL Server components.
- Identify SQL Server design options, as well as implementation and administration activities.
Top |
|
Module 2: Transact-SQL Overview
- SQL Server programming tools
- The Transact-SQL programming language
- Elements of Transact-SQL
- Ways to execute Transact-SQL statements
- Lab:
- Transact-SQL overview
Skills
- Skills: Students will be able to:
- Describe the basic elements of Transact-SQL.
- List data definition statements.
- List data manipulation statements.
- List data control statements.
- Describe the ways to execute Transact-SQL statements
Top |
|
|
Module 3: Creating Databases
- Introduction to databases
- Working with databases
- Modifying databases
- Creating filegroups
- Creating data types
- Creating tables
- Generating scripts
- Lab:
- Creating databases
Skills
- Skills: Students will be able to:
- Evaluate database considerations.
- Create and configure a database.
- Manage a database and transaction log.
- Create and drop user-defined data types.
- Create and drop user tables.
- Generate a script.
Top |
|
Module 4: Implementing Data Integrity
- Introduction to data integrity
- Using constraints
- Using defaults and rules
- Lab:
- Implementing data integrity
Skills
- Skills: Students will be able to:
- Describe the three types of data integrity.
- Determine which features to use to enforce data integrity.
Top |
|
|
Module 5: Planning and Creating Indexes
- Implementing indexes
- Creating and dropping indexes
- Types of indexes
- Characteristics of indexes
- Indexing guidelines
- CREATE INDEX options
- Maintaining indexes
- Lab:
- Creating indexes
Skills
- Skills: Students will be able to:
- Determine when indexes are useful and decide the types of indexes to create.
- Create clustered and nonclustered indexes with unique or composite characteristics.
- Use the CREATE INDEX options to expedite index creation and improve index performance.
- Apply the appropriate fillfactor value to accommodate the future growth of tables.
- Use various tools and verification features to maintain indexes and enhance their optimal performance
Top |
|
Module 6: Using joins to combine data from multiple tables
- Manipulating a result set
- Using subqueries
- Modifying data with joins or subqueries
- Querying a remote SQL Server
- Lab:
- Performing advanced queries
Skills
- Skills: Students will be able to:
- Combine data from two or more tables using joins.
- Combine multiple result sets into one result set using the UNION operator and the SELECT INTO statement.
- Use subqueries to break down and perform complex queries.
- Use joins and subqueries as selection or data modification criteria within a statement.
- Set up a distributed environment that accesses data stored in a remote SQL Server.
Top |
|
|
Module 7: Summarizing Data
- Using aggregate functions
- Generating a summary value for a column
- Generating aggregate values within result sets
- Listing the top n values
- Lab:
- Summarizing data
Skills
- Skills: Students will be able to:
- Generate a single summary value using aggregate functions.
- Organize summary data for a column using aggregate functions with the GROUP BY, HAVING, COMPUTE, and COMPUTE BY clauses.
- Generate summary data for a table using aggregate functions with the GROUP BY clause and the ROLLUP or CUBE operators.
- Use the TOP n keyword to retrieve a list of the specified top values in a table
Top |
|
Module 8: Managing Transactions and Locks
- Introduction to transactions and locks
- Managing transactions
- Managing locks
- Managing distributed transactions
- Lab:
- Managing transactions and locks
Skills
- Skills: Students will be able to:
- Describe transaction processing.
- Execute, cancel, or roll back a transaction.
- Identify resource items that can be locked.
- Identify the types of locks.
- Set locking options and display locking information.
- Initiate a distributed transaction. top <sql7im.html>
- Compare distributed transactions and replication.
Top |
|
|
Module 9: Implementing Views
- Views: an alternate way to look at data
- Advantages of views
- Creating views
- Altering views
- Modifying data through views
- Lab:
- Implementing views
Skills
- Skills: Students will be able to:
- Explain the purpose and benefits of using views.
- Create a view using the CREATE VIEW statement.
- Drop a view from a database.
- Locate view definition information.
- Alter a view.
- Update a source table using a view
Top |
|
Module 10: Implementing Stored Procedures
- Introduction to stored procedures
- Creating, executing, and modifying stored procedures
- Using parameters in stored procedures
- Handling error messages
- Lab:
- Implementing stored procedures
Skills
- Skills: Students will be able to:
- Describe how a stored procedure is processed.
- Create, execute, modify, and drop a stored procedure.
- Execute a stored procedure on a remote server.
- Use parameters with stored procedures.
- Recompile a stored procedure.
- Create custom error messages.
Top |
|
|
Module 11: Implementing Triggers
- Introduction to triggers
- Creating, dropping, and altering triggers
- Examples of triggers
- Lab:
- Creating a trigger
Skills
- Skills: Students will be able to:
- Define a trigger.
- Explain the advantages of using a trigger.
- Describe some considerations when using a trigger.
- Create a trigger.
- Drop a trigger.
- Alter a trigger.
Top |
|
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1750
(€2486)
|
£
995.00
(€1413)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
