Objectifs

• Use the basic components of ASE to connect to a server database
• Create tables, populate the tables with data, and efficiently query data from those tables
• Write code in Transact-SQL
• Use and manage transactions effectively
• Write stored procedures and triggers to help in database maintenance and upkeep

Public

• Data Consultant / Manager
• System Architect
• Technology Consultant

Pré-requis

• Basic understanding of network connectivity architecture
• Knowledge of general Unix commands

Recommended

• Fundamental understanding of databases and SQL language

Post-Formation

EDB634

Méthodes

80% Pratique et 20% Théorie

Programme

• Adaptive Server Enterprise
• Describing Client/Server Architecture and Relational Database Concepts
• Explaining SAP Adaptive Server Enterprise (ASE) Management of Relational Databases
• Client Tools and Transact-SQL
• Accessing a Database Server with Client Tools and Transact-SQL
• Connecting to ASE
• 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
• Table Management
• Creating Tables
• Creating Temporary Tables
• Querying System Tables
• 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
• Views and Indexes
• Creating Views
• Creating Indexes
• 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
• Transact-SQL Functions
• Manipulating Data Using Built-in Transact-SQL Functions
• Creating User-Defined Functions
• Variables
• Explaining Batches
• Applying Local and Global Variables
• Describing the Dynamic Execution of SQL Using Variables
• Control-of-Flow Statements and Messages
• Creating Control-of-Flow Statements
• Managing Message Statements
• 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
• Cursors
• Inserting Data Using a Cursor
• Modifying Data with Cursors
• Stored Procedures
• Describing Stored Procedures
• Creating Stored Procedures Using Parameters
• Applying Best Practices to Stored Procedures
• Triggers
• Describing Triggers
• Creating Triggers to Complete Cascaded Updates
• Applying Relevant Rollback to Triggers
• Applying Best Practices and Data Integrity with Triggers

Environnement

VM Linux

Mot-clés

SAP SYBASE TRANSACT-SQL