Premier Home Page

Home | Training | Solutions |Contact Us

t: +44(0)20 7729 1811

 
About Us | IT Training | Financial Training | Management Training |Delegate Information
 
 
 

Welcome to Premier

Your people are your most precious asset. Whether you are an existing Premier client, or a new customer looking to experience our services for the first time, welcome

 


PROGRAMMING A MICROSOFT SQL SERVER 2000 DATABASE - 5 DAYS
  • 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.

Microsoft Gold Partner

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk