Fast Track to Adaptive Server Enterprise 15.0 (ASE2)

Databases, SAP Sybase

Location, current course term

Contact us

Vlastní Školení na míru (termín, lokalita, obsah, délka)

The course:

Hide detail
  • Adaptive Server Enterprise
    1. Describing Client/Server Architecture and Relational Database Concepts
    2. Explaining SAP Adaptive Server Enterprise (ASE) Management of Relational Databases
  • Client Tools and Transact-SQL
    1. Creating Views
    2. Creating Indexes
  • Data Analysis
    1. Executing Queries with Select Statements
    2. Writing Qualified Queries
    3. Organizing the Result Set into Groups
    4. Querying Data from Multiple Tables Using Joins
    5. Running Queries Using Subqueries
  • Table Management
    1. Creating Tables
    2. Creating Temporary Tables
    3. Querying System Tables
  • Data Modification
    1. Listing Data Manipulation Language (DML) Statements
    2. Adding Data to Tables
    3. Updating Data in Tables
    4. Combining Insert and Update Statements
    5. Modifying Data in Tables
    6. Describing the Transaction Log
  • Views and Indexes
    1. Creating Views
    2. Creating Indexes
  • Data Integrity
    1. Explaining Data Integrity
    2. Maintaining Data Integrity with Constraints
    3. Managing Constraints
    4. Creating Defaults and Rules to Maintain Data Integrity
    5. Choosing a Data Integrity Method
  • Transact-SQL Functions
    1. Manipulating Data Using Built-in Transact-SQL Functions
    2. Creating User-Defined Functions
  • Variables
    1. Explaining Batches
    2. Applying Local and Global Variables
    3. Describing the Dynamic Execution of SQL Usi
  • Control-of-Flow Statements and Messages
    1. Creating Control-of-Flow Statements Managing Message Statements
  • Transactions and Data Consistency
    1. Examining Transaction Modes
    2. Executing Transactions
    3. Processing Transaction Errors
    4. Describing the Implementation of Data Locking Methods
    5. Implementing Locking Schemes and Isolation Levels
  • Cursors
    1. Inserting Data Using a Cursor
    2. Modifying Data with Cursors
  • Stored Procedures
    1. Describing Stored Procedures
    2. Creating Stored Procedures Using Parameters
    3. Applying Best Practices to Stored Procedures
  • Triggers
    1. Describing Triggers
    2. Creating Triggers to Complete Cascaded Updates
    3. Applying Relevant Rollback to Triggers
    4. Applying Best Practices and Data Integrity with Triggers
Schedule:
5 days (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: