FAST TRACK TO SAP SYBASE ADAPTIVE SERVER ENTERPRISE 16
Duration: 5 days
Goals:
1. Use the basic components of ASE to connect to a server database
2. Create tables, populate the tables with data, and efficiently query data from those tables
3. Write code in Transact-SQL
4. Use and manage transactions effectively
5. Write stored procedures and triggers to help in database maintenance and upkeep
Content:
1. Adaptive Server Enterprise
Describing Client/Server Architecture and Relational Database Concepts
Explaining SAP Adaptive Server Enterprise (ASE) Management of Relational Databases
2. Client Tools and Transact-SQL
Accessing a Database Server with Client Tools and Transact-SQL
Connecting to ASE
3. Data Analysis
Executing Queries with Select Statements
Writing Qualified Queries
Organizing the Result Set into Groups
Querying Data from Multiple Tables Using Joins
Running Queries Using Subqueries
4. Table Management
Creating Tables
Creating Temporary Tables
Querying System Tables
5. Data Modification
Listing Data Manipulation Language (DML) Statements
Adding Data to Tables
Updating Data in Tables
Combining Insert and Update Statements
Modifying Data in Tables
Describing the Transaction Log
6. Views and Indexes
Creating Views
Creating Indexes
7. Data Integrity
Explaining Data Integrity
Maintaining Data Integrity with Constraints
Managing Constraints
Creating Defaults and Rules to Maintain Data Integrity
Choosing a Data Integrity Method
8. Transact-SQL Functions
Manipulating Data Using Built-in Transact-SQL Functions
Creating User-Defined Functions
9. Variables
Explaining Batches
Applying Local and Global Variables
Describing the Dynamic Execution of SQL Using Variables
10. Control-of-Flow Statements and Messages
Creating Control-of-Flow Statements
Managing Message Statements
11. Transactions and Data Consistency
Executing Transactions
Examining Transaction Modes
Processing Transaction Errors
Describing the Implementation of Data Locking Methods
Implementing Locking Schemes and Isolation Levels
12. Cursors
Inserting Data Using a Cursor
Modifying Data with Cursors
13. Stored Procedures
Describing Stored Procedures
Creating Stored Procedures Using Parameters
Applying Best Practices to Stored Procedures
14. Triggers
Describing Triggers
Creating Triggers to Complete Cascaded Updates
Applying Relevant Rollback to Triggers
Applying Best Practices and Data Integrity with Triggers