Course Content:

Unit 1: SQL Server fundamentals

• Introduction
• Access and object basics
• Tools and utilities

Unit 2: Database design

• Business analysis
• Data modeling
• Application design and database implementation

Unit 3: Database implementation

• Database design
• Creating and modifying databases
• Managing databases

Unit 4: Implementing tables

• Database objects
• Data types
• Table management
• Managing constraints, rules, and defaults
• Managing indexes

Unit 5: Data load and transfer

• Using bulk copy program (bcp) and BULK INSERT
• Using Data Transformation Services (DTS)
• Designing for replication

Unit 6: Data retrieval

• Data retrieval
• T-SQL functions
• Organizing data
• Joins and subqueries
• Heterogeneous data sources
• XML data manipulation

Unit 7: SQL programming

• Programming fundamentals
• Security and error fundamentals
• Control-of-flow statements
• Views
• Stored procedures
• User-defined functions (UDFs)

Unit 8: Data manipulation

• Data modification
• Transactions and locking
• Using server cursors
• Using triggers

Unit 9: Database optimization

• Management tools
• Managing locks
• Database object optimization
• Query optimization

For more information on Acumen Classes
Please contact Deb Wagnon 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it