SQL Anywhere 11.0 Fundamentals

Product type
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

  • Develop and manage standalone network databases
  • Insert data into and retrieve data from local and remote databases
  • Design databases, queries, and stored procedures for optimum performance
  • Meet enterprise standards for data availability, security, consistency, and integrity and network databases
  • Use proxy tables to access remote database
  • Automate tasks with schedules and events
  • Understand the common Application Programming Interfaces (ODBC, ESQL, JDBC, ADO, Open Client, .NET) in addition to the SQL Anywhere general programming interface
  • Use the debugger for solving problems with procedures, triggers and/or events, queries and stored procedures for best performance

Audience

  • Database A…

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

  • Develop and manage standalone network databases
  • Insert data into and retrieve data from local and remote databases
  • Design databases, queries, and stored procedures for optimum performance
  • Meet enterprise standards for data availability, security, consistency, and integrity and network databases
  • Use proxy tables to access remote database
  • Automate tasks with schedules and events
  • Understand the common Application Programming Interfaces (ODBC, ESQL, JDBC, ADO, Open Client, .NET) in addition to the SQL Anywhere general programming interface
  • Use the debugger for solving problems with procedures, triggers and/or events, queries and stored procedures for best performance

Audience

  • Database Administrators, SQL Anywhere Application Developers

Prerequisites

Essential
  • * None

Content

  • An overview of SQL Anywhere
  • Connecting to the database
  • Creating and using databases
  • Database objects
  • Manipulating data
  • Programming interfaces overview
  • Transaction processing
  • Backup and recovery
  • Security
  • Common administration tools
  • Stored procedures and triggers
  • Automating tasks with schedules and events
  • Performance and tuning
  • Accessing remote data
  • Deploying SQL Anywhere

Notes

  • Gain an understanding of mobile and workgroup database functionality and administration. Learn how to develop and manage standalone and server databases. Insert and retrieve data; meet enterprise standards for data availability, security, consistency and integrity. Design databases, queries, and stored procedures for optimal performance.

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.