Fast Track to Adaptive Server

Product type

Fast Track to Adaptive Server

SAP Training
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

Goals

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

Audience

  • Database Administrators, Database Designers, End-Users, SQL Developers

Prerequisites

Essential
  • * Fundamental understanding of databases and SQL language * Basic understanding of network connectivity architecture * Knowledge of general Unix commands

Course based on software release

  • ASE 15…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

Goals

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

Audience

  • Database Administrators, Database Designers, End-Users, SQL Developers

Prerequisites

Essential
  • * Fundamental understanding of databases and SQL language * Basic understanding of network connectivity architecture * Knowledge of general Unix commands

Course based on software release

  • ASE 15.7

Content

  • Overview of relational database concepts and client/server architecture
  • Using the basic components of ASE to connect to a server database
  • Adaptive Server clients
  • isql and Interactive SQL
  • Creating tables
  • Modifying/querying data in tables
  • Improving query functionality and performance
  • Using temporary tables and system tables
  • Using constraints, defaults, and rules to enforce data integrity
  • Writing Transact-SQL code with functions
  • Programming with variables and control-of-flow statements
  • Managing transactions and locking

Notes

  • Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE) through 15.7, and learn to create database objects expertly using ANSI-standard SQL and Transact-SQL extensions. Study key features and functions of ASE including automatic recovery of transactions, writing Stored Procedures and triggers, and creating and using cursors. Course material also covers important concepts from introduction to the SQL language, new functions, increased number of arguments in IN statements, increased limits on object identifiers, and new data types.

Popular tags

No tags submitted for this course yet

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.