Database Training Services - Classroom and Web-based

Computer Education Professionals

Database Training Services

Submit Database Questions Contact You SYS-ED/Mobile Devices

Database Training Services - Classroom and Web-based Advanced search

Knowledge Base Enrollment Web Browser Viewing - MS Edge

Enterprise Database Software Extended

Big Data, Cloud, and Mobile Devices

Database Management Systems Mobile Database Software Extending a Database Management System
Big Data Technology Apache Hadoop NoSQL Database
Database Training by SYS-ED Courseware and Distance-learning Specialized Database Training Service

Crystal Reports

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

Database Training Services - Scalable Databases and Reporting
Courseware for Teaching
Cloud Programming - 2018
Open Source Software GSA Submission


Operational Strategies with Commercial Database Software
Database Management Systems

According to the leading information technology research firms, Oracle Corporation database is the leading database management system in terms of market share. IBM Corporation DB2 is a close second, followed by Microsoft SQL Server, and SAP-Sybase. All are relational databases; each company also markets additional databases. In most cases, a commercial database will have a FOSS: Free Open Source Free or low cost counterpart: Firebird, MySQL, Ingres, and PostgreSQL. International Data Corporation projections are that by 2020 the volume of stored data will increase to over 40 times the 2009 level.

Software companies differentiate 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 IBM Corporation Microsoft Corporation
Oracle Database MySQL - FOSS DB2 Relational
IMS Hierarchical Database MS Access MS SQL Server
WebLogic Server and Oracle Fusion WebSphere Application Server and Rational MS IIS, MS Azure, and MS Visual Studio .Net

Oracle Corporation has grown through acquisition and added to its flagship commercial database with open source software: MySQL database, Java language, UNIX-Solaris operating system, and GlassFish web server. The Oracle database strategy is based upon providing enhancements and value to its customers through its Exadata software and product options for data compression and performance through both software and hardware. Oracle has two commercial web servers Oracle Application Server and WebLogic Server. WLS: WebLogic Server has been rebranded as Oracle WebLogic Server and is the preferred server in the Oracle Fusion software and development platform. The long term plan is a unified database, web server, and development platform which drives an integrated software and hardware company.

IBM Corporation's DB2 is the leading database on mainframe hardware and system software; IBM's IMS first generation hierarchical database and Teradata data warehouse provide specialized niche functionality. DB2 is competing directly with the Oracle database on other operating system platforms. Starting with DB2 9.7 for Linux, UNIX, and Windows, IBM supports Oracle and PL/SQL applications: syntax, locking mechanisms, data types, SQL, procedural language, and client interfaces. IBM provides a minimal cost trial and migration paths to DB2. DB2 can serve as an engine to the open source MySQL database. DB2 Express-C is available unsupported, free of charge, for unrestricted use in production environments. IBM also uses its established market presence with WAS WebSphere Application Server and industry leading WebSphere MQ middleware to drive sales of DB2 software.

Microsoft Corporation's strategy for growth is based upon the growth and integration of its MS Windows Azure cloud service, upgrades from its MS Access workstation database software to MS SQL Server and the popularity of its proprietary programming languages and .NET Framework and development platform. Microsoft support for FoxPro is being phased out. MS SQL Server is the recommended database on its industry leading MS SharePoint Server enterprise content management system. Windows Azure is a Microsoft PaaS: Platform as a Service for managing individual virtual machines to customize and control the cloud instance infrastructure. Microsoft supports Azure with Visual Studio and .NET,  third-party, and open source languages.

Mobile Database Software

Each commercial software company has a mobile database software strategy which integrates with its enterprise database.

IBM DB2 Everyplace supports high availability, load balancing, and enterprise synchronization for managing data distribution to mobile devices. It integrates with JDBC-compliant and RDBMS data sources: Microsoft, Oracle, Sybase, and Apache Derby. IBM Mobile Database is a IBM DB data server with a small footprint relational database optimized for mobile use. Typically, it is an embedded database accessed through an application. IBM DB2 Everyplace applications can be migrated to IBM Mobile Database.

MS SQL Server Compact 4.0 database has been optimized for use in ASP.NET Web applications. It supports the SQL Server syntax, ADO.NET programming model, and .NET web applications. The application development support for SQL Server Compact 4.0 is provided in the Professional, Premium, and Ultimate editions of Visual Studio 2010 SP1 and higher.

Oracle Database Lite is a small footprint SQL database installed as integrated software which synchronizes with an Oracle Database server. Oracle Database Lite consists of Lite Client and Lite Mobile Server. There is a mobile server middleware component which supports scalable data synchronization and centralized management of mobile resources.

Mobile database technology is being used in a variety of applications and device environments, ranging from music databases within MP3 players, to mobile CRM software on smartphones devices. A flexible comprehensive mobile database will support multiple indexes: B-Trees, R-Trees for mapping data, Patricia Tries, KD-Trees for k-dimensional, and hash tables. The mobile database management system will be required to support the user requirements. The selection of a central database needs to be integrated with the mobile database for coexistence in a single system while sharing the data.

There also are a number of alternative commercial and open source mobile software databases.

Extending a Database Management System

The criteria for organizational enterprises to assess database software has evolved to five major areas: 1- Usability 2- Performance and scalability 3- Security 4- Back-end operations 5- Return on investment or cost center accounting. 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. The ability to design, model, implement, and administer a database is used to provide comparative advantage in relation to the cost structure and services offered by a competitor.

  Database Management Software  
  Operational Strategies  
  Scripting     Web Server  
  SQL: Structured Query Language     Enterprise Content Management  
  Data Recovery     Middleware  
  Programming Languages     System Software  
  Develoment Platform     Backup/Recovery  
  Data Integrity     Data Administration  
  BI: Business Intelligence     Data Warehousing  
  Mobile Computing     Cloud Computing  
  Local Database     Virtualization  
The operational requirements which apply to database management systems are far more extensive and multivariate than either the first generation 1970 hierarchical databases or the relational databases from the mid 1980's. Databases are being used in hybrid combinations with commercial and free open source software specific to the organization's information processing operations. In addition to the standard issues, there are decisions that have to be made with respect to development platforms and scripting for new applications, integration of open source software, and developing a capability for mobile computing devices. Alternatively, information technology operations may be outsourced to cloud computing service providers.

Cloud databases are fully automated multitenant services that present a database capability. Cloud solutions allow for application development with a low start up cost and minimal database administration. There is on demand scalability which mitigates capacity management issues and provides scalability. MongoDB and CouchDB have emerged as niche cloud computing databases. They are competing with the cloud databases offered by Oracle, IBM, and Microsoft.

The leading commercial software companies are developing cloud computing strategies which incorporate and leverage its database management technologies. They are competing with Amazon Web Services, Google Corporation, and number of new entrants.

Big Data Technology

IDC forecasts that the worldwide Big Data technology services will grow at approximately a 30% compound annual growth rate with revenues projected to exceed $23.8 billion by 2017. 2 The Big Data market is expanding rapidly as large IT companies and startups compete for customers and market share by providing more opportunities to use Big Data technology to improve operational efficiency and drive innovation. The major IT vendors increasingly are evolving and offering enterprise database configurations which support Big Data.

Apache Hadoop

Hadoop is a project from the Apache Software Foundation developed for leading cloud based companies such as Google, Yahoo, and Facebook operational requirements required supporting daily access to huge datasets across distributed servers. Open source Hadoop enables distributed data processing for for big data applications across a large number of servers. The concept and principle of operation is that distributed, parallel processing will result in redundancy and more efficient performance across clouds to prevent outages. Its increased implementation is being driven by the: 1- Growing number of companies applications using very large datasets. 2- The availability of clouds containing hundreds or thousands of distributed processors with huge storage capacity.

Hadoop is a generic processing framework designed to execute queries and other batch read operations against extremely large datasets that can be tens or hundreds of terabytes and even petabytes in size. Hadoop operates on massive datasets by horizontally scaling the processing across very large numbers of servers through MapReduce. Vertical scaling is used for executing on the single most powerful single server available; however, this is expensive in terms of resources and limiting. MapReduce splits up a problem, sends the sub-problems to different servers, and lets each server solve its sub-problem in parallel. It then merges all the sub-problem solutions together and writes out the solution into files which be used as inputs into additional MapReduce steps. Hadoop has been useful in environments where massive server farms are being used to collect the data. Hadoop processes parallel queries as large background batch jobs on the same server farm.

Open source database products do not support operations such as parallel query through horizontal scaling. The leading commercial database products offer capabilities that Hadoop does not provide: performance optimizations, analytic functions, and declarative features. This provides for complex analysis by non-programmers, enterprise class features for security, auditing, maximum availability, and disaster recovery.

The Oracle corporation database can coexist and complement Hadoop. The inexpensive cycles of server farms and Hadoop can be used for transforming masses of unstructured data with low information density into smaller amounts of information dense structured data which is then loaded into Oracle Exadata. Oracle Data Integrator is based on Hive and provides native Hadoop integration. A user interface is provided for creating programs to load data to and from files or relational data stores. Oracle Data Integrator provides: 1- High performance data integration between Hadoop and a Oracle database. 2- Simplifies Java MapReduce development through optimized developer productivity. 3- High performance load to the Oracle database using ODI with Oracle Loader for Hadoop. 4- Oracle Data Integrator Enterprise Edition E-LT: Extract Load and Transform improves performance and reduces data integration costs.

IBM InfoSphere BigInsights Basic software is the IBM distribution of Hadoop which incorporates open source projects, and IBM-add-ons: text analysis engine, development tool, data exploration, enterprise software integration, platform administration, and runtime performance improvements. There also is a BigInsights Enterprise Edition which includes a text processing engine and library of annotators for querying and identifying items of interest in documents and messages. It employs IBM-specific software to further enhance administration and performance.

The Hadoop team development and documentation effort centered on the Linux platform. Microsoft Win32 is supported as a development platform. However, distributed operation has not been thoroughly tested on Win32 as a production platform. There currently is minimal Hadoop support in pseudo- and distributed- mode on the Microsoft Windows operating system platform.

NoSQL Database

A NoSQL database is a non-relational database. The NoSQL databases under development include: Apache Cassandra, MongoDB, Voldemort, Apache HBase, SimpleDB, and BigTable. Projects are underway for developing SQL interfaces to NoSQL databases.

NoSQL operates on massive datasets by horizontally scaling the processing across very large numbers of servers. This sharding technique essentially is the same that has has been deployed for supporting high volume systems using conventional relational databases. Sharding requires that a separate database run on each server and that the data be physically partitioned in order that each database has its own subset of the data stored on its own local disks. There are tradeoffs associated with sharding; important relational database capabilities will be lost such as for performing joins, transactions, and schema changes. ACID: atomicity, consistency, isolation, and durability principles can no longer be applied uniformly. In order to join data with sharding, it will be necessary to distribute queries that span potentially very large numbers of separate databases. There will be additional complexity with distributed queries as compared to queries which join data within a single database. This can result in additional overhead and degrade performance. As a result, NoSQL databases, typically will not support joins.

Transactions that allow updates for multiple rows to be committed or rolled back together should a failure occur together require distributed transactions in a sharded environment; the implementation requirement will be a two phase commit protocol. This will result in additional complexity and resource consumption than if all the data is contained within a single database Two phase commit can be slow, and can compromise availability resulting from failures can lead to indoubt transactions which cause data to become locked and inaccessible until the failure is repaired. NoSQL databases typically will not support transactions that involve updates to data in multiple tables or multiple rows within a table.

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, and healthcare providers. SYS-ED teaches and provides guidelines on both commercial database software and the open source alternatives: enterprise, Big Data, cloud computing, and mobile databases.

The SYS-ED database curriculum is built upon a longstanding and comprehensive knowledge of database and interrelated areas of information technology: operating systems, web servers, scripting, middleware, programming languages, and development platforms.

Client/Server Databases

Enterprise Databases Scalable to Big Data

For organizations implementing and expanding its web-based E-commerce capabilities:   For organizations extending and optimizing its database capabilities:
  • Design user interface option buttons, drop-down lists, and, command buttons.

  • Migrate from client/server workstation databases to enterprise databases: IBM DB2, Oracle, and MS SQL Server.

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

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

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

  • Centralize access rules and administration: triggers, stored procedures, and business rules.
  • Reporting data: simple, relational, and OLAP.
  • Provide database implementation on multiple web server platforms: IIS, Apache, Oracle, WebLogic, and WebSphere.
  • Use queries: select, delete, and update.
  • Design and implement database applications: JDeveloper, JBuilder, Java, and .Net.
  • Utilize the new data types: graphics, sound clips, and urls.
  • Provide database access to mobile devices and virtual desktop operating systems.
  • Provide web access to its databases: ODBC, JDBC, and ADO.Net.
  • With mainframe and Internet connectivity: DB2 Connect, ODBC, and JDBC.

Cloud Computing and Databases


Mobile Devices Databases

For organizations expanding its database services and application development to cloud computing platforms.

  For organizations designing and coding mobile database applications.
  • Utilization of cloud databases and DaaS: Database as a Service for operational efficiency and reduced costs.
  • Selection of a mobile application database capable of running on smartphones and synchronizing its database with the server database.
  • On demand scalability of cloud platforms for reducing capacity management and administration responsibility.
  • Application development which functions both connected to the network or offline standalone.
  • Monitoring the cloud environment for failures and configuring auto-failover mechanisms and database synchronization.
  • Single- and cross- platform development.
  • A virtual database system to provide access and share data independent as to the user's current location.
  • Efficient database query processing and updates on locally cached data.
  • Database and application design on Amazon Web Services with SimpleDB.
  • Allocating resources for connections from desktop and laptop computers that address latency for Internet connections.
  • Application database design and development with Google Corporation cloud database and its GoogleAppEngine Data Store.
  • Routing which will work at the network level through the database schema and synchronization.
  • Guidelines for integration and scalability of Microsoft Azure and SQL Server.
  • Physical and logical database design for terrestrial locations and WiFi access where network availability and transmission are unreliable and unpredictable.
  • Cloud database security.
  • End-to-end encryption and security at multiple levels - device theft, device loss, and data interception over the Internet.


Few consulting, let alone training companies, have the experience with databases and the skillset to provide premium training services: Structured Query Language, database design, administration, programming, Open and Java Database Connectivity, and specialized database platform transition courses.

Courseware and Distance-learning Service

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 information textbook publishers and technologists. Industry standard textbooks 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 handouts and training aids.

Open Source Software
Java Development Platform and Language
Linux Operating System UNIX Operating System
Open Source Scripting XML Platform
Database Training - Distance-learning Service
Commercial Database Software
SAP - Crystal Reports SAP - Business Objects
SAP - Sybase
  Distance-learning Service  
IBM Database and System Software
DB2 Relational Database
IMS Hierarchical Database
WebSphere Family
Microsoft Database Software
MS Relational Databases
MS Development Platforms
MS Scripting
Oracle Database and Development Platform
Oracle Relational Database
Oracle and WebLogic Development
MySQL - Open Source Software UNIX - Solaris

SYS-ED courseware combines industry standard content with consultancy derived techniques for managing data and controlling applications. An important component in the delivery of database training was the utilization of courseware: student handouts, sample programs, skeleton programs, workshops, and training aids. The classic principles of adult learning are applied to the content, interpreting and translating subject matter into performance objectives, narrative descriptions, and diagrams which explain the architecture, design, and logic of commercial and open source databases. Our courseware library has been incrementally augmented, revised, and maintained. It is highly valued, especially in interrelated areas of information technology. Upon completion of a instructor-led database course at the client location, it is standard practice to organize content for future utilization in a web-based training infrastructure.

Distance-learning Service

SYS-ED's distance-learning training service is 65% lecture and 35% hands-on exercises with a subject matter expert, with optional validation assessment. Support services are provided through SYS-ED websites.

Oracle Database Administration Training Program Java Enterprise Development MS SQL Server Training Program MS .NET Programming

Enrollment is contingent upon the prospective trainee's having been qualified by our Director of Education to have the appropriate background for the training and checklist of items required for transmission of the service to the client location: bandwidth, firewall, base operating system, software requirements, web browser, and set-up of hands-on machine exercises.

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 information technology professionals.

The typical comments were:
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:
Database Training Services  Yes, SYS-ED offers specialized database training: report generation, administration, programming, and tailored training.
Database Training Services  Yes, since the early 1980's, SYS-ED has taught fast-track database courses.
Database Training Services  Yes, we have the flexibility and resources to provide personalized training for small groups. We very rarely cancel database courses.
Database Training Services  Database courses are available in multiple formats: classroom, distance-learning and blended web-based delivery.
Database Training Services  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.

SYS-ED Database Curriculum

SYS-EDís database curriculum 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. Industry standard subject matter can be augmented with the course 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 performanceofthe 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.

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.

Specialized Database Training Services
ETL: Extract, Transform, Load have been combined into a unified tool for extraction from one database and placement into another database. ETL functionality is presented in conjunction with database programming, administration, utilities, and performance courses.
  ETL: Extract, Transform, and Load Tools  
  Extract   Transform   Load  
  Read from a database.   Convert the extracted data for placement into another database.   Write data into the target database.  
The leading commercial ETL vendors are: Ab Initio, Adeptia ETL, Business Objects Data Integrator, DBSoft Lab, IBM Infosphere DataStage, Informatica, Information Server, Integration Services, Oracle Data Integrator, Oracle Warehouse Builder, Pervasive ETL, SAS ETL, SSIS: SQL Server Integration Services, and Sybase ETL.

Traditional business intelligence, ETL: extract, transform, and load database vendors integrate with Apache Hadoop.BI: Business Intelligence and Data warehouse vendors have been extending their tool sets and connecting to or interoperating with Hadoop. The emerging trend is to develop BI and ETL products which run natively on Hadoop and which will convert existing mappings to run as MapReduce jobs on Hadoop.

Database Training Services
Database 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, networking, middleware, and web development platforms.1

SYS-ED's database courseware is highly respected. 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 only is allowed to register if they have the background corresponding to the appropriate course outline, performance objectives, and learning path.

Database Training - Distance-learning or at Your Office
Database courses are provided over the Internet through a distance-learning delivery medium or classroom instruction on-site at the client location. Client location courses can include the identical workshops, case studies, and hands-on approach as the distance-learning service schedule.

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.

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.