SAP Sybase ASE - školení


FAST TRACK TO SAP SYBASE ADAPTIVE SERVER ENTERPRISE 16


Délka: 5 dní

Cíle:
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

Agenda:
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