Upon completion of this course, the student will be able to: Describe the components of a logical data model. Identify primary keys. Choose the foreign key that will enforce a relationship between entities and ensure referential integrity. Incorporate business rules and constraints into the data model. Create user-defined data types. Implement constraints. Create SQL stored procedure variables. Write SQL control-of-flow statements for stored procedures. Embed SQL transactions in stored procedures. Write SQL stored procedures for passing arguments and accepting return values. Declare a cursor. Specify cursor sensitivity. Identify the types of cursors. Describe what is meant by the global or local scope. Navigate a cursor. Design and manage transactions.
Unit 1: Database Design
- Creating a Logical Data Model
- Logical Database Components
- Data Integrity
Unit 2: Advanced Transact-SQL
- Programming SQL Variables
- Using Control-of-Flow Language
- SQL Transactions
- Creating Stored Procedures
- Implementing Error Handling
Unit 3: Cursors
- Declaring Cursors
- Types of Cursors
- Navigating a Cursor
Unit 4: Transaction Management
- Designing a Transaction
- Locking
- Avoiding Deadlocks