Sybase System Training - Sybase Courses - Sybase Training - Sybase Software Courses
- NIIT
Find a Sybase Training Programs for
your specific requirement.
Sybase is a leader in database management systems with extensive applications across
industry segments.As their only authorized training partners in India, NIIT offers
a comprehensive portfolio of training on a variety of Sybase solutions. With our
expertise in the field of IT training and our wide network of training centres across
the country, NIIT offers you training customized to your needs.
Fill in the form on the right and
we will get back to you with more information about Sybase Training Programs.
You can download a PDF brochure for the following Sybase Training Programs:-
ASE Administration Certification Path
EDB553 Performance and Tuning Configuring Adaptive Server Enterprise
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, table partitions, and parallel processing. Examine
the use of Sybase performance monitoring utilities (Monitoring Tables, sp_sysmon,
system Stored Procedures) and major performance trade-offs. Gain insight on choosing
appropriate locking schemes.
EDB115 Fast Track to Adaptive Server Enterprise
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 Introduction
to SQL (EDB100), new functions, increased number of arguments in statements, increased
limits on object identifiers, and new data types.
EDB356 System and Database Administration Adaptive Server Enterprise
Learn how to identify the major tasks of Sybase system and database administration
and practice these tasks using your own Adaptive Server Enterprise (ASE) in a safe
and controlled environment. Emphasis is given to resource management (memory, disk,
and tempdb space with a goal of creating a reliable Adaptive Server environment.
Examine fundamental monitoring and troubleshooting methods, backup and recovery
strategies, job scheduling and user access issues.
ASE Developer Certification Path
EDB115 Fast Track to Adaptive Server Enterprise
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 Introduction
to SQL (EDB100), new functions, increased number of arguments in IN statements,
increased limits on object identifiers, and new datatypes.
EDB559Mastering TransactSQL Programming Advanced Tips & Techniques
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.
EDB631 Performance and Tuning Adaptive Server Enterprise Query Optimizer
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 query performance
and using simulated statistics for “what if” analysis. Acquire a benchmarking tuning
methodology Query Optimizer.
PowerDesigner Data Modeling Certification Path
JDEV133 Fast Track to PowerBuilder Part I
Part I of the Fast Track to PowerBuilder Series will get you started with PowerBuilder
development by building and deploying a fully-functional application using the business
requirements of an actual business use case. Learn the core features of the Integrated
Development Environment (IDE), after which you will begin to create PowerBuilder
Workspaces, Application Targets, work with Application Objects and manipulate PowerBuilder
libraries.
After creating the shell of an application, you will gain familiarity with coding
basics, where you will learn PowerScript syntax, variable types, scope and basic
PowerScript functions. Gain exposure to the different types of methods you may build
into classes (functions vs. events) and how to debug a PowerBuilder application.
DEV630 Fast Track to PowerBuilder Part II
Part II of the Fast Track Series allows you to learn how to use PowerBuilder to
build and deploy a fully functional application using object-oriented programming
techniques and application partitioning. Continue to improve your skills in PowerBuilder
development by learning the best practices for PowerBuilder development from an
advanced client/server developers’ perspective.Focused on a selection of complex
and advanced-level topics, you get hands-on, instructor led training that takes
you out of your fast-paced environment to let you concentrate on improving your
skills without distractions.
Replication Server Administration Learning Path
EDB374 Fast Track to Replication Server Administration
Get hands-on training on how to design, set up, and administer a Sybase Replication
Server 12.6/15.0 environment. Learn the fundamental differences between a state
consistent replicated data design and a distributed application data design. Also,
learn the basic functions of Replication Server starting with basic replication
concepts, architecture, usage, and administration issues. You will create replication
definitions, database replication definitions, subscriptions, and understand materialization
options, as well as error handling and routes. With this background, you will experience
the ease of setting up a basic Warm Standby environment and then move to general
troubleshooting practices to complete a fully functional Rep Server installation
and environment. In addition, there will be optional material available that provides
an introduction to heterogeneous replication.
EDB576 Replication Server 15.0 Masters
Designed for customers working in an environment where performance, server availability
and management are of the highest priority. Moving beyond the topics covered in
the Fast Track course, you will learn how to handle real world performance and administration
issues typically encountered in today's active production environments. This class
gives the student the opportunity to practice recovery techniques and performance
tuning while maintaining the consistency in a system with multiple correlated databases
and servers by correctly applying single-site backup and recovery strategies. Real-world
benefits include learning how to perform mission-critical administrative tasks more
efficiently, improving system performance, investigating errors and troubleshooting
disaster scenarios to recover data.
Sybase IQ Administration Learning Path
EDB771 Sybase IQ Query Plans and Optimization
Learn Sybase IQ query plans and advanced optimization features and techniques. Explore
the major differences between Sybase ASE and Sybase IQ while optimizing the system
and making performance enhancing decisions. Instructions on how to build effective
query plans and apply the appropriate use of join algorithms will help enhance capabilities
in fine-tuning a Sybase IQ environment for optimum retrieval speed. You must attend
the "Administering Sybase IQ for the Data Warehouse" class prior to enrolling in
this class.
EDB782-Administering-Sybase IQ 12.7 for the Data Warehouse
Gain a working knowledge of Sybase IQ through a combination of lecture presentations
and hands-on laboratory exercises. Learn Sybase IQ 12.7 architecture, concepts,
and terminology while setting up, loading and maintaining an Sybase IQ 12.7 database.
The course also covers must-know monitoring and troubleshooting methods, as well
as important technical information to increase the performance and tuning of Sybase
IQ. Students create a multiplex configuration of Sybase IQ to support large query
loads, as well as create tables and load data.
EDB792 Sybase IQ Understanding Optimization and Improving Performance
Gain a working knowledge of Sybase IQ through a combination of lecture presentations
and hands-on exercises. Learn Sybase IQ 15 architecture, concepts, and terminology
while setting up, configuring, administering and maintaining a Sybase IQ database
in both a simplex and multiplex environment. The course covers must-know monitoring
and troubleshooting methods, as well as important technical information to increase
the efficiency of the Sybase IQ DBA. You will also be heavily involved in creating
a multiplex configuration of Sybase IQ to support large query loads, creating numerous
tables and extracting and loading gigabits of data in to your environments.
Sybase IQ Developer Learning Path
EDB772 Sybase IQ for Developers
Understand the major differences between Sybase ASE and Sybase IQ when coding, optimizing
the system and making performance enhancing decisions. Instructions on how to build
effective query plans, applying the appropriate use of joins and group by clauses
in a Sybase IQ platform will help you enhance your capabilities in fine-tuning the
environment for optimum retrieval speed.
EDB792 Sybase IQ Understanding Optimization and Improving Performance