Database Training Services - Classroom and Web-based

Database Training Services SYS-ED SYSED

Database Training Services

Bookmark this page

Submit Database Questions

Contact You

Database Training Services - Classroom and Web-based Database Skillset Assessment


Database Training Services - Classroom and Web-based Advanced search

Knowledge Base

Enrollment

Mainframe Training

Database Training
from SYS-ED
®

The Right Way!

Internetworking

Web Servers

Internet Programming

Database Training Experts

Database Time Capsule: 1980... Knowledge Transfer Experts

Learning Paths

Courseware for Teaching

Grow Your Own Database Personnel
Caveat Emptor Why SYS-ED for Database Training NYS Dept of Education Standards

Portfolio of Clients

Database Training in New York Technology Exchange Websites
Technology Driven IT Training Delivery Medium Web-based Training Services

Database
Schedule

 

Cost
Analysis

Sitemap
Sitemap


Database Training Experts

Since 1980, SYS-ED has been providing most comprehensive multi-platform database courses and integrated training programs. Our original multi level database courses were designed to address the operational objectives of Fortune 1000 companies, government municipalities, healthcare facilities, and consulting firms. With the emergence of the Internet as the transactional medium, SYS-ED’s database courses have been upgraded and retrofitted to provide the next generation of database access. Few consulting, let alone training companies, have the experience with databases and the skillset for providing world class database training like SYS-ED: Structured Query Language, database design, database administration, database programming, Open Database Connectivity, Java Database Connectivity and specialized database transition courses.

Database Training - Scalable Databases

For small organizations looking to implement their first generation of Internet database connectivity:

  • Design a relational database in order to scale from 10,000 to millions of rows.

  • Utilize the new data types: graphics, sound clips, URLs, etc.

  • Design user interface: option buttons, drop-down lists, command buttons, etc.

  • Reporting data: simple, relational, OLAP, etc.

  • Using queries: select, delete, update, etc.

  • Automating tasks: macros, stored procedures, scripting, SQL, etc.

  • Providing web access to database: ODBC, JDBC, ADO, etc.

Database Training Services - Classroom and Web-based

State of the Market

 

Database Training - Large to Enterprise

For large organizations looking to implement leading edge database functionality:

  • Design a relational database for efficient retrieval and maintaining large number of records.

  • Migrating from client/server to enterprise databases: DB2 UDB, Oracle, SQL Server 2008, etc.

  • Centralizing access rules and administration: triggers, stored procedures, business rules, etc.

  • Designing and implementing database applications: JHeadstart, JDeveloper, JBuilder, .NET, etc.

  • Providing database implementation on multiple web server platforms: IIS, Apache, WebLogic, WebSphere, etc.

  • Mainframe and Internet connectivity: DB2 Connect, ODBC, JDBC, etc.

Equally as important, SYS-ED is software vendor independent; we do not make our livelihood from selling software, our sole objective is to help you develop the staff and resources required to implement, test, optimize, and troubleshoot database software.

Database Time Capsule: SYS-ED Was There!

1970’s

Database Training Services - Classroom and Web-based

DB2: Performance, Design, and Implementation

0-07-057553-3

David Silverberg

Early 1980’s
Mid 1980’s

Database Training Services - Classroom and Web-based

DB2 for Application Programmers

ISBN 0-13-199795-5

Pacifico Amarga Lim

Late 1980’s
Early 1990’s
Mid-1990’s

Database Training Services - Classroom and Web-based

Transact-SQL User-Defined Functions for MS SQL Server 

ISBN 1-55622-079-0

Andrew Novick

Twenty-first Century

Learning Paths

Database DB2
Oracle .NET
Java XML


Database Training Services - Classroom and Web-based Advanced search

To review and print course topics, prices, and dates, invoke the search button.

Courseware for Teaching

SYS-ED's courseware library consists of a variety of databases, test data, and sample programs which we utilize as a framework for teaching how to implement, query, code, and administer databases. We have relationships with leading IT text book publishers and technologist text book authors. Industry standard text books are used in conjunction with our own courseware and training aids.

The Computer Education Techniques knowledge base is a service for answering questions, inclusive of the research and validation of the accuracy of information in the public domain. Citation of source documentation and examples are used to provide answers to the questions. This information becomes part of our knowledge base and courseware library. Content is selectively added to SYS-ED course hand-outs and training aids.


MS Access:
Introduction
MS Access:
Advanced
MS Access:
VBA Programming
MS Visual FoxPro
for Users
Table of Contents Table of Contents Table of Contents Table of Contents
Copyright Acknowledgement Copyright Acknowledgement Copyright Acknowledgement Copyright Acknowledgement
Training Aid Training Aid Performance Objectives Performance Objectives
Performance Objectives Performance Objectives Chapter 1 Chapter 1
    Chapter 2 Chapter 2
    Index Index

MS SQL Server:
Implementation and Administration
Crystal Reports Crystal Reports for
Visual Studio.NET
Delphi
Programming
Table of Contents Table of Contents Table of Contents Table of Contents
Copyright Acknowledgement Copyright Acknowledgement Copyright Acknowledgement Copyright Acknowledgement
Performance Objectives Performance Objectives Performance Objectives Performance Objectives
Chapter 1 Chapter 1 Chapter 1 Chapter 1
Chapter 2 Chapter 2 Chapter 2 Chapter 2
Index Index Index Index

Delphi Programming:
Advanced
Oracle PL/SQL
Programming
Oracle PL/SQL
Programming - Advanced
Oracle Application
Development and Tuning
Table of Contents Table of Contents Table of Contents Table of Contents
Copyright Acknowledgement Copyright Acknowledgement Copyright Acknowledgement Copyright Acknowledgement
Performance Objectives Performance Objectives Performance Objectives Performance Objectives
Chapter 1 Chapter 1 Chapter 1 Chapter 1
Chapter 2 Chapter 2 Chapter 2 Chapter 2
Index Index Index Index

DB2 QMF:
Query Management Facility
DB2 UDB
Application Programming
DB2 UDB Application
Programming - Advanced
Table of Contents Table of Contents Table of Contents
Copyright Acknowledgement Copyright Acknowledgement Copyright Acknowledgement
Performance Objectives Performance Objectives Performance Objectives
Chapter 1 Chapter 1 Chapter 1
Chapter 2 Chapter 2 Chapter 2
Index Index Index

Consultancy Derived Database Training

SYS-ED’s database courses and integrated training programs provide an impartial presentation of content and hands-on experience which extends the source software vendor content and training aids. These courses have been developed as part of our work as leading edge consultants and in response to request by our clients.

Industry Standard Content
ANSI SQL Database Design Data Modeling
You will learn:
  • retrieving, adding, updating and deleting rows in a table.
  • table creation and administration.
  • the functions of SQL transactions, logs, commits and rollbacks.
  • how to code and use stored procedures.
You will learn:
  • views, indexes, and physical storage.
  • how to use composite and name attributes.
  • identify relationships and key attributes.
  • when and how to denormalize.
  • how to design and create various data partitioning plans.
  • storing duplicate data and repeating groups.
  • guidelines for table creation.
You will learn:
  • how data modeling and data mapping are used to represent business knowledge.
  • data entities, attributes and associations used to represent business knowledge.
  • how to identify business requirements for databases, Internet/intranet and data warehousing projects.
  • data modeling for forward engineering, reverse, and business reengineering projects.

Caveat Emptor
Prior to scheduling a database course from the source software company, compare the quality of the training service that SYS-ED offers with the alternatives:


Why SYS-ED for Database Training?

Get on the Fast Track .......

Database Training Services - Classroom and Web-based Hands-on training
Database Training Services - Classroom and Web-based Superb courseware and training aids
Database Training Services - Classroom and Web-based New York Database Schedule
Database Training Services - Classroom and Web-based Resources to accommodate small groups
Database Training Services - Classroom and Web-based Tailored private courses
Database Training Services - Classroom and Web-based Warranty of service
Database Training Services - Classroom and Web-based Satisfied customers and industry testimonials
Database Training Services - Classroom and Web-based Qualified training consultant for needs analysis and skills inventory
Database Training Services - Classroom and Web-based Distance- and e-learning

Database Training Services - Classroom and Web-based

Portfolio of Database Clients



Grow Your Own Database Personnel
Over the past year, we have had a number of inquiries regarding whether SYS-ED still offered database courses for business professionals, IT support personnel, webmasters, and programmers.

The typical comments were:

1. That it is extremely difficult to find database training specific to a proprietary software which provides the foundation and develops the specialized skills needed for specific development and administrative tasks.
2. That there is a scarcity of fast-track database courses, 1 to 3 days in duration, geared to corporations and their employees.
3. That a high percentage of database courses are cancelled.
In response to these questions:
Database Training Services - Classroom and Web-based Yes, SYS-ED offers specialized database training: basic, advanced, and tailored modules.

Database Training Services - Classroom and Web-based

Portfolio of Database Clients

Database Training Services - Classroom and Web-based Yes, since 1980, SYS-ED has taught fast-track database courses.
Database Training Services - Classroom and Web-based Yes, we have the flexibility and resources to provide personalized training for small groups. We very rarely cancel database courses.

Select Your Database.

To view and print course level(s) and content for a database, click on the database software.
First Generation Databases
Database Training Services - Classroom and Web-basedACT! Database Training Services - Classroom and Web-basedClipper Database Training Services - Classroom and Web-basedCrystal Reports
Database Training Services - Classroom and Web-basedDelphi Database Training Services - Classroom and Web-basedLotus Approach Database Training Services - Classroom and Web-basedPAL and ObjectPAL
Database Training Services - Classroom and Web-basedQ&A Database Training Services - Classroom and Web-basedParadox Database Training Services - Classroom and Web-basedPowerBuilder
     
Microsoft Databases
Database Training Services - Classroom and Web-basedMS FoxPro/Visual FoxPro Database Training Services - Classroom and Web-basedMS Access Database Training Services - Classroom and Web-basedMS SQL Server
     
Enterprise Databases
Database Training Services - Classroom and Web-basedDB2 Database Training Services - Classroom and Web-basedOracle Database Training Services - Classroom and Web-basedSybase
     
Mainframe
Database Training Services - Classroom and Web-basedADABAS Database Training Services - Classroom and Web-basedIMS Database Training Services - Classroom and Web-basedRelational Databases
     

Database Training in New York
 

Real Hands-on Training
SYS-ED's database courses are tough, but they're worth it. Our challenging "hands-on" database courses provide the framework and skillset across the complete spectrum of operating systems, application software, networking, and web development platforms.

Courseware
SYS-ED's database courseware and training aids are respected in the IT field. Our database courseware includes both industry standard content and undocumented features and facilities. We draw upon our extensive library of walkthroughs, examples, and case studies to explain, demonstrate, and implement information technology - databases, scripting, and web development.

Teaching is Our Only Business

Most computer training companies are divisions of large software companies or consulting companies. Not SYS-ED. Our only goal is to provide quality computer training for highly motivated professionals - no more and no less. Because we're independent, we're free to concentrate on teaching - and since 1980 we have been doing it very well.

Our Teachers Know How to Teach
SYS-ED instructors combine teaching skills with broad practical experience as consultants. Our instructors average 30 years of experience with database applications and web enablement software. And they know how to teach it. We teach not only "how to", but "why", building a solid foundation in fundamentals and insights into advanced materials. After a course, they're available to students for additional advice or support.

Enrollment - SYS-ED Database Courses are NOT for Everyone
No one is allowed to enroll in a SYS-ED course, without a consultation with our Director of Education. We review the operational objectives and project specifications for the organization evaluating whether to send its employee for the training. The employee is only allowed to register if they have the appropriate background corresponding to the correct course outline, performance objectives, and learning path.

Database Training in New York, at Your Office, or Web-based
SYS-ED database courses are held at our modern fully equipped training center in New York City and in conjunction with technology partners in North America. If you prefer, we'll arrange tailored database training courses at your organization’s facilities inclusive of hands-on exercises. On-site courses can include the identical workshops and case studies we offer in New York. Web-based database courses are offered selectively. Contact our New York office for additional information.

For additional information including outlines, availability of private courses, references, and course customization, contact David Shapiro at our New York office at 212-564-9147 or register online.


Technology Exchange Websites

SYS-ED's technology exchange websites compile, organize, and present software specific and established operational categorizations of information technology. They provide a framework for assessing knowledge transfer: learning paths, classroom instruction with a subject matter expert, web-based training, courseware, training aids, and validation assessment.

http://www.databasetrainingbysysed.us/commquests.htm

www.msnetworkstrainingbysysed.us www.unixtrainingbysysed.us
www.macintoshtrainingbysysed.us www.pcapplicationstrainingbysysed.us
www.db2trainingbsysed.us www.oracletrainingbysysed.us
www.xmltrainingbysysed.us www.msapplicationstrainingbysysed.us
www.dotnettrainingbysysed.us www.javatrainingbysysed.us

Footnote 1:
SYS-ED’s core computer applications, mainframe, UNIX, and Java curriculum have been submitted to the New York State Department of Education - Bureau of Proprietary School Supervision for review and licensure.