- Execute extended stored procedures.
- Describe SQL Server 2000 and its supported operating system platforms.
- Describe SQL Server integration with Microsoft Windows 2000 and other
server applications.
- Describe SQL Server databases.
- Describe SQL Server security.
- Describe SQL Server administration and implementation activities,
as well as SQL Server application design options.
- Describe the concepts of enterprise-level application architecture.
- Describe the primary SQL Server programming tools.
- Explain the difference between the two primary programming tools in
SQL Server.
- Describe the basic elements of Transact-SQL.
- Describe the use of local variables, operators, functions, control
of flow statements, and comments.
- Describe the various ways to execute Transact-SQL statements.
- Create a database.
- Create a filegroup.
- Manage a database.
- Describe data structures.
- Create and drop user-defined data types
Create and drop user tables.
- Generate column values.
- Generate a script
- Describe the types of data integrity.
Describe the methods to enforce data integrity.
- Determine which constraint to use and create constraints.
- Define and use DEFAULT, CHECK, PRIMARY KEY, UNIQUE, and FOREIGN KEY
constraints.
- Disable constraints.
- Describe and use defaults and rules.
- Determine which data integrity enforcement methods to use.
- Describe why and when to use an index.
- Describe how SQL Server uses clustered and nonclustered indexes.
- Describe how SQL Server index architecture facilitates the retrieval
of data.
- Describe how SQL Server maintains indexes and heaps.
- Describe the importance of selectivity, density, and distribution
of data when deciding which columns to index.
- Create indexes and indexed views with unique or composite characteristics.
- Use the CREATE INDEX options.
- Describe how to maintain indexes over time.
- Describe how the query optimizer creates, stores, maintains, and uses
statistics to optimize queries.
- Query the sysindexes table.
- Describe how the Index Tuning Wizard works and when to use it.
- Describe performance considerations that affect creating and maintaining
indexes.
|
- Describe the concept of a view.
- List the advantages of views.
- Define a view with the CREATE VIEW statement.
- Modify data through views.
- Optimize performance by using views.
- Describe how a stored procedure is processed.
- Create, execute, modify, and drop a stored procedure.
- Create stored procedures that accept parameters.
- Create custom error messages.
- Describe the three types of user-defined functions.
- Create and alter user-defined functions.
- Create each of the three types of user-defined functions.
- Create a trigger.
- Drop a trigger.
- Alter a trigger.
- Describe how various triggers work.
- Evaluate the performance
- Considerations that affect using triggers.
- Describe distributed queries.
- Write ad hoc queries that access data that is stored in a remote SQL
Server 2000 or in an OLE DB data source.
- Set up a linked server environment to access data that is stored in
a remote SQL Server 2000 or in an OLE DB data source.
- Write queries that access data from a linked server.
- Execute stored procedures on a remote server or linked server.
- Explain the role of the query optimizer and how it works to ensure
that queries are optimized.
- Use various methods for obtaining execution plan information so that
they can determine how the query optimizer processed a query and validate
that the most efficient query plan was generated.
- Create indexes that cover queries
Identify indexing strategies that reduce page reads.
- Evaluate when to override the query optimizer.
- Analyze the performance gain of writing efficient queries and creating
useful indexes for queries that contain the AND logical operator.
- Analyze the performance gain of writing efficient queries and creating
useful indexes for queries that contain the OR logical operator
- Evaluate how the query optimizer uses different join strategies for
query optimization.
- Describe transaction processing.
Execute, cancel, or roll back a transaction.
- Identify locking concurrency issues.
- Identify resource items that can be locked and the types of locks.
- Describe lock compatibility
- Describe how SQL Server 2000 uses dynamic locking.
- Set locking options and display locking information.
|
4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk |
