Database Training Services

Bookmark this page

Submit Database Questions

Contact You

Knowledge Base

Enrollment

Database New York Schedule   DB2 UDB Schedule Oracle Schedule

Crystal Reports Schedule   IMS Schedule Cost Analysis

DB2 and IMS are registered trademarks of IBM Corporation.
Access, Visual FoxPro, and SQL Server are registered trademarks of Microsoft Corporation.
Oracle database is a registered trademark of Oracle Corporation.
Sybase SQL is a registered trademark of Sybase Inc. and SAP.
IDMS is a registered trademark of Computer Associates.
ADABAS is a registered trademark of Software AG.

Database Software - Fundamental Criteria

For competitive organizational enterprises, the criteria for assessing database software have evolved to five major areas: 1- Usability 2- Performance and scalability 3- Security 4- Back-end operations 5- Business consistency considerations. When writing an application, a decision has to be made on which relational database management system to utilize. Once that choice has been made, to a large extent this becomes an investment in information technology infrastructure. Switching to open source software or different commercial database vendors to take advantage of lower prices, an improved technology, or a better partnership is undermined typically by the legacy code which requires extensive rewrite before it can be reused with another relational database system.

Industry Leading Database Software Companies

The leading software companies have differentiated their commercial software products based upon: quality of code, efficient utilization with multiple base operating systems and web servers, integration with its other software products, availability of development platforms, documentation, and support services. Not all databases will have the identical capacity and featureset; nor will a database work equally well with other commercial and open source software. The design and underlying architecture of a database will make it well suited and efficient within a range of volume, data management, transactions, and administrative functions.

Oracle Corporation has grown through acquisition and added to its flagship commercial database with open source MySQL database. It now has a UNIX-Solaris operating system, two web servers - Oracle Application Server and WebLogic servers and accompanying development platforms. The Oracle Roadmap and Fusion software is designed to integrate the component software.

IBM DB2 9.7 for Linux, UNIX, and Windows supports Oracle SQL and PL/SQL. It has aligned the syntax and semantics with the locking mechanisms, data types, SQL, procedural language residing on the server, and the client interfaces used by the applications.

Microsoft is working on a new database for Linux and UNIX developed on the PostGreSQL9.0 base code. This new database will be open source under a MS-PL: Microsoft Public License and available free of charge. It also will have a SQL Server emulation layer.

Commercial and Open Source Database Training by SYS-ED

Since 1980, SYS-ED has been providing database courses and integrated training programs designed to address the operational objectives of Fortune 1000 companies, government municipalities, healthcare providers, and consulting firms. As a training company committed to providing premium training and support service, SYS-ED identifies, teaches, and provides guidelines on both commercial and open source database: evaluation, transitioning, and upgrades. The SYS-ED database curriculum is built upon a longstanding and comprehensive knowledge of database software. With the emergence of web servers, middleware, virtualization, and cloud computing, database training must provide educational consultancy along with explaining and teaching how to make things works in an increasingly hybrid information technology infrastructure. In most cases, a commercial database will have a FOSS: Free Open Source Free counterpart and yes we teach those databases also.

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.

In addition to the database course offerings and training services on this website, the leading enterprise databases are supported through SYS-ED software specific websites: IBM - DB2trainingbysysed.us and IMStrainingbysysed.us, Oracle Corporation - Oracletrainingbysysed.us and Microsoft SQL Server - www.msapplicationstrainingbysysed.us.

Database Training - Scalable Databases

For small organizations implementing and expanding its web- based E-commerce capabilities:

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

• Utilize the new data types: graphics, sound clips, and urls.

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

• Reporting data: simple, relational, and OLAP.

• Use queries: select, delete, and update.

• Automate tasks: macros, stored procedures, scripting, and SQL.

• Provide web access to its databases: ODBC, JDBC, and ADO.

Database Training - Enterprise Databases

For large organizations looking to extend and optimize its database capabilities:

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

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

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

• Design and implement database applications: JDeveloper, JBuilder, Java and .NET.

• Provide database implementation on multiple web server platforms: IIS, Apache, Oracle, WebLogic, and WebSphere.

• With mainframe and Internet connectivity: DB2 Connect, ODBC, and JDBC.

Database Time Capsule: SYS-ED Staff and Technologists

DB2 for Application Programmers ISBN 0-13-199795-5 Pacifico Amarga Lim

Transact-SQL User-Defined Functions for MS SQL Server  ISBN 1-55622-079-0 Andrew Novick

DB2: Performance, Design, and Implementation 0-07-057553-3 David Silverberg

State of the Market -
Information Technology in Transition

Alternative to the Information Technology Training
Offered by the Software Companies

Longstanding Consultancy Experience
in Information Technology

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.

Grow Your Own Database Personnel

Over the past year, we have had a number of inquiries regarding whether SYS-ED still offered scalable and software specific database courses for business professionals, webmasters, and IT professionals.

1.	That it is extremely difficult to find database training which provides the foundation and develops the specialized skills needed for specific development and maintenance tasks.
2.	That there is a scarcity of fast-track database courses, 5 or fewer days in duration, geared to the employees from Fortune 500 companies, government, and healthcare providers.
3.	That a high percentage of database courses are cancelled.
4.	That travel costs and living expenses in a majority of situations are a significant constraint when it comes to attending a database course.
5.	That it is important to have a resource for asking database questions once a course is complete.
In response to these questions:
	Yes, SYS-ED offers specialized database training: report generation, administration, programming, and tailored training.
	Yes, since the early 1980's, SYS-ED has taught fast-track database courses.
	Yes, we have the flexibility and resources to provide personalized training for small groups. We very rarely cancel database courses.
	Database courses are available in multiple formats: classroom, distance-learning and blended web-based delivery.
	Upon completion of a SYS-ED course, our staff is available to answer database questions and software vendor-specific questions: DB2, Oracle, SQL Server, and open source database questions.

Portfolio of Database Clients

Portfolio of Crystal Reports Clients

Portfolio of DB2 UDB Clients

Portfolio of IMS Training Clients

Portfolio of Oracle Clients

Consultancy Derived Database Training

SYS-ED’s open source and proprietary database courses have been developed based upon a foundation of classic adult learning theory and the standards of the New York State Department of Education.

Information technology infrastructure is becoming increasingly hybrid and comprised of a combination of proprietary and open source software. We extend industry standard database content with diagrams, code snippets, examples, sample data, exercises, from the CETi knowledge base. Information from the Open Source Initiative distributed through the GPL - General Public License is also selectively presented. Subject matter can be reviewed and selected through the search engine.

It is our standard practice to qualify a prospective client's operating environment: web browser, operating system, web server, database, and middleware as part of teaching:

Logical and physical design for optimizing performance of the underlying database engine. Migrating and upgrading applications from the client/server to the emerging service oriented architecture standard. Web development utilizing .NET and open source Java frameworks. The interoperability of .NET and Java and identification of pitfalls.

At the client discretion, pre- and post- course validation assessment can be utilized for quantifying mastery of the subject matter. Upon completion of an instructor-led database course at the client location, it is standard policy to organize content for future utilization in a web-based training infrastructure.

When SYS-ED can not warranty a superior training outcome, then we will politely turn down an assignment.

• how to use client programs for accessing a MySQL database.
• creating, altering, and dropping a MySQL database.
• writing SQL statements for selecting data from a MySQL database.
• coding joins and subqueries.
• using SQL expressions.
• using SQL aggregate functions and scalar functions.
• inserting, updating, deleting, and replacing rows.
• creating and altering tables, indexes, and views.
• how to use transactions.
• granting and revoking access privileges on tables and views.
• importing and exporting.

• configuring MySQL.
• creating a database and managing tables.
• implementing a locking strategy.
• how to use storage engines.
• obtaining data from the Information_Schema database.
• managing backup and recovery.
• utilizing stored procedures.
• managing users.
• implementing security-related configuration.
• optimizing queries and the server.
• setting and using the Event Scheduler.
• creating partitioned tables.

• managing the structure of databases and tables.
• managing and using indexes.
• importing and exporting data from within MySQL.
• performing joins for accessing multiple tables.
• coding and debugging subqueries.
• creating and using stored routines, triggers, and events.
• obtaining database metadata.
• optimizing queries and debugging MySQL applications.

• how a schema describes an IDMS/R database.
• using a subschema for defining a view in an application.
• how an application program navigates an IDMS/R database.
• DB and DC fundamentals.
• defining and utilizing IDMS/R sets.
• how to execute IDMS utilities for printing, loading and reporting on the database.

• how to construct a conceptual model using normalization from the results of data analysis.
• mapping the business model into a logical model.
• mapping the logical model to a physical model for evaluation using physical space and timing estimates.
• designing and drawing ER diagrams.
• normalizing a database and when to denormalize a database for developing and enhancing structured design charts.
• enforcing structured design and program modularity.
• creating process specifications and validating their accuracy.

• designing efficient IDMS/R application programs.
• coding and compiling the DDL and DMCL statements.
• coding, compiling, debugging, and executing a program using the IDMS/R commands for retrieval and update.
• how to use the IDMS/R communication block in programs.
• coding programs using index, LRF, DBKEY, OLQ: Online Query, control/save statements, record locks, update, and retrieval commands.
• currency and its utilization in programming.

• how to perform startup and shutdown procedures.
• executing ADS/O commands.
• creating and using subroutines.
• security issues and setup.
• working with ACF screens.
• ADS/O flow of control.

• the purpose and features of a data dictionary.
• the benefits of IDD.
• how to create and test various DDL statements.
• coding and testing reporting routines.
• coding and testing DDL statements.

• the ADS processing environment.
• how to design efficient applications.
• creating dialog and application prototypes.
• programming with IDD and the ADS.
• functional processing of MAPC and ADS/O.
• processing DML commands.

• how to implement event driven programming concepts.
• using the MS Visual FoxPro programming environment.
• working with forms and form controls.
• utilizing the MS Visual FoxPro language elements.
• creating and using subroutines and functions.
• creating custom menus.
• utilizing text/input features.
• debugging and deploying applications.

• the MS Visual FoxPro development environment.
• how to apply object oriented principles, properties, events, and methods.
• the screen builder.
• writing event handler code.
• add OLE to an application.
• test and debug applications.
• optimize applications.

• defining supported data types.
• retrieving and modifying data.
• manipulating data.
• utilizing views.
• managing indexes.
• utilizing triggers.
• implementing defaults and rules.
• optimizing performance.

• how to identify SQL Server components.
• installing and upgrading SQL Server.
• setting up clients.
• managing storage.
• scheduling jobs and alerts.
• managing security.
• implementing replication.
• implementing a backup and recovery strategy.

• using the SQL Server programming facility.
• creating and managing databases.
• creating and maintaining indexes.
• utilizing views.
• implementing and managing stored procedures.
• implementing data integrity.
• utilizing triggers.

• using SQL in relational databases.
• retrieving data from single and multiple related tables.
• coding summary queries.
• working with data types and functions.
• using Enterprise Manager.
• coding stored procedures, functions, and triggers.
• working with cursors.
• managing transactions and locking.

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:

• Review the database and interrelated personal and scalable enterprise learning paths.
• Read the technology assessments and CFAQs - course frequently asked questions.
• Examine the training aids that we use in our database courses.
• Optional - pre and post course assessment questions.
• Interview our systems consultant/instructor.

SYS-ED has been conducting courses in the public domain since 1980; however, there have been changes in the laws and regulations governing computer training in the state of New York.. The schedule on our websites reflects a projected time frame for licensure with the New York State Department of Education - Bureau of Proprietary School Supervision and submission and approval of curriculum. It will be updated quarterly.

Selection of Delivery Medium 

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

Select Your Database.

To review and print course level(s) and content for a database, click on the database software.

First Generation Databases

ACT! Crystal Reports Delphi Lotus Approach PAL and ObjectPAL Q&A Paradox PowerBuilder

Microsoft Databases

MS FoxPro MS Access MS SQL Server

Enterprise Databases

DB2 Oracle Sybase MySQL           Mainframe ADABAS IMS Relational Databases

Database Training in New York
 

Courseware
SYS-ED's database courseware and training aids are highly regarded 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 background corresponding to the appropriate 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 training center in midtown Manhattan 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 websites compile, organize, and present software specific and established operational categorizations of information technology. They provide a framework for assessing knowledge transfer: web-based training, classroom instruction, courseware, learning paths, and validation assessment.

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