Sybase Canada Ltd.
Ottawa, Toronto, Winnipeg, Canada
http://www.sybase.com

Manage Anywhere Studio 5.0 Administration

Understand the capabilities of Manage Anywhere Studio. Learn how the product is designed, how it is best used in practical environments, and how it fits into the scheme of distributed management of mobile systems in general. Gain hands-on knowledge and skills for installing and administering the manage Anywhere Server and client agents. Lean how to deploy and install clients, distribute softwar......
 

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. New features include automating the access of remote data......
 

Get an introduction to Java 2 Platform, Enterprise Edition (J2EE) and particularly the Enterprise JavaBean (EJB) portion of that specification. EJBs allow sophisticated transaction management and integration with legacy systems to solve business problems. Study the advantages of EJB components and learn how to implement EJBs. Practice all of the topics covered by building an application from de......
 

Build on your solid knowledge of Java 2 Standard Edition (J2SE) server-side Java. Servlets and Java Server Pages (JSPs) are introduced as a means of producing dynamic Web content. Get an introduction to the Java database APIs, server-side programming, the Java 2 Platform, Enterprise Edition (J2EE) environment, and server-side API using JDBC. Course Objectives : Upon completion of this course......
 

Develop applications in Java and gain a foundation for learning Java server-side programming. Topics include running and compiling Java programs, datatypes, flow control, classes and objects, and inheritance. This course is designed for students who are proficient in C or C++ and have a prior understanding of object-oriented programming. It focuses only on the client-side Java APIs, the Java pr......
 

JavaScript for New Programmers teaches the JavaScript and programming techniques needed to develop cutting-edge, interactive Web sites. From opening windows to image-flipping and form validation, this class gives you the skills to build exciting, dynamic Web pages. Understand JavaScript Commands and Program Structure Through discussion and hands-on exercises, you will learn to write compac......
 

Acquire the HTML skills necessary to develop layouts that are more sophisticated, font schemes, and interactivity for your pages. Cascading Style Sheets (CSS) enhances HTML and gives you much more control of page layout and text formatting. Use Style Sheets and Templates for a Uniform Design Like styles in word processors, CSS lets you define certain attributes and apply that style to mul......
 

Explains why XML is the language of choice for electronic data interchange between applications and for building Internet sites that work simultaneously with classic Web browsers and Internet-enabled mobile phones. In this class, you will master the fundamentals of XML, including XSL, DTDs, and schemas, and use XML to build a variety of compelling Web applications. We are in the midst of th......
 

Learn how to plan and implement Adaptive Server Enterprise (ASE) tables, indexes, and data integrity to satisfy the data and processing requirements of an enterprise. Gain exposure to all major physical design principles needed to create optimal database designs on the ASE 12.0 platform. Study a formal design methodology that starts with a logical data model, and translate that into a relationa......
 

Learn to apply consistent methodology in creating a logical database design that is based on the relational data model and confirms to formal standards of normalization. Examine techniques for gathering and analyzing business rules, using entity-relationship diagrams to capture conceptual data designs, and modeling business processes with data flow diagrams. Study the theoretical foundations of......
 

Learn how to tune queries and Stored Procedures for optimal performance using Adaptive Server Query Optimizer. Study various techniques for writing high-performance queries that allow the optimizer to use the most efficient query plan, and learn how to diagnose and correct performance problems with existing queries. Gain proficiency in interpreting and modifying optimizer statistics to improve ......
 

Gain a deeper understanding of the data structures inside Sybase Adaptive Server Enterprise (ASE) 12.5.0.1 and how they are allocated and de-allocated. This expert-level course gets you ¡°under the hood¡± and exposes you to in-depth technical detail. Use this knowledge to prevent potential problems from database corruption and to reduce time working with Sybase Technical Support. Troubleshoot, re......
 

Get a hands-on, in-depth look at Adaptive Server Enterprise (ASE). Examine relevant internal data structures and practical troubleshooting techniques. Learn to diagnose and prevent potentially disastrous situations, optimize your use of the features of ASE for normal administrative tasks, perform mission-critical administrative tasks for efficiently, improve system performance for end users and......
 

Learn to tune Adaptive Server Enterprise (ASE) for optimal performance and explore ASE architecture in depth. Study topics that include designing databases for performance, diagnosing and correcting performance problems, managing ASE system resources (CPUs, disks, I/o), optimizer statistics, SMP features, relevant data structures, benchmarking turning methodology and techniques, and parallel pr......
 

Learn how to identify the major tasks of Sybase system and database administration and practice these tasks using your own Adaptive Server Enterprise (ASE) 12.5.0.1 in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and CPU) with a goal of creating a reliable Adaptive Server environment. Examine fundamental monitoring and troubleshooting methods, backu......
 

Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE), 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 I......
 

Learn an array of valuable tips, techniques, and advanced topics to implement cleaner and more efficient code. Lecture and lab emphasis is on good coding practices, manipulating numbers and dates, joins and subqueries, applied case logic, cursors, and proper Stored Procedure development and debugging, as well as generalized methods for solving specific problems. Course Objectives : Upon comp......
 

Securing data while moving from client to server or from server to server is a major issue in a database environment for administrators and system security officers. Learn about network security issues in general and how Sybase Adaptive Server Enterprise (ASE) database software is configured to provide secure client/server and server/server communications. ASE 12.5 supports two mechanisms for c......
 

The Backup Server is a critical element in the management of data; but it is often overlooked from a Disaster Recovery standpoint. Learn how to configure this new "no limits" Backup Server to dump and load any size database faster and on more devices, than ever before. A practical knowledge of the Adaptive Server Enterprise 12.5 Backup Server will also enable you to design appropriate......
 

Corruption of a production database can be a serious problem. This could mean lost data and/or extensive down time. Either one resulting in huge financial losses. Behind the Scenes with DBCC Commands looks at a variety of DBCC commands that are available to assist in identifying database corruption before it becomes a problem. You’ll learn about the available commands, how they work and wh......
 

Pages:- 1 2 3 4 5 6

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z