This course is for database administrators who want to learn about using and managing Sybase System 11.
This is self-paced, internet-based tutorial -- there are no books to purchase and no scheduled classes to attend.
Training that's Easy, Convenient and Affordable! High-quality, online, self-paced training designed to help you achieve your goals.
Affordable annual subscription plans give you unlimited access to an entire suite of training topics at prices that you just won't find anywhere else.
Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.
Try our FREE courses right now, and see for yourself how much you will learn!
After completing Sybase courses, the user should be able to:
Compare characteristics of host and client/server systems
Identify features and advantages of the Sybase client/server system architecture
Explain the function of key Sybase components, tools, and utilities
Describe how Sybase System 11 accommodates non-Sybase applications
Explain the basic features of SQL Server
Describe the major functions of SQL and T-SQL
Describe the security features and roles of SQL Server
Perform database queries with isql
Manage database tables
Update and maintain databases
Explain the role of a system administrator
Use system procedures for database administration
Manage databases
Manage segments
Create and manage user accounts
Control user access and aliases
Create and manage groups
Create and manage roles
Grant and revoke permissions
Identify the basic features of T-SQL and isql
Create, alter, and drop tables
Specify integrity constraints to protect databases
Create integrity rules and defaults
Create and manage views
Create and manage indexes
Create queries
Use functions in queries
Modify query results
Order and group query results
Use queries through views
Combine query results
Create join queries
Use subqueries
Insert data in databases
Modify and delete data
Course Features
Courses have special design features listed below:
Certificates of Completion
Instructional steps -- walk through a procedure
Exercises -- try it out
Notes - See additional information related to the topic in the text
Tips - See a different, faster, or easier way of doing something
Quick References - See a quick reference guide to the features introduced in a chapter
Details - Display more detailed information related to the current topic
Hotwords - See related information
Navigation Bar - Maneuver easily through the courses
Course Topics and Index -- with searching feature and hyper-links
Printable Exercises - PDF downloadable files
Sample Application Files - PDF downloadable files
Course Glossary
Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and course grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which course topics you want to focus on and to go directly into that unit.
Technical Requirements
200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.
Learning comes to life with challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. Our proven methodology provides an unequalled experience with exceptional results
Learning that's Easy, Convenient and Affordable! High-quality, online, self-paced courses designed to help you achieve your goals.
Affordable annual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.
Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.
Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.