Oracle, MySQL, Cassandra, Hadoop Database Training Classes in Training/Buffalo,

Learn Oracle, MySQL, Cassandra, Hadoop Database in Training/Buffalo and surrounding areas via our hands-on, expert led courses. All of our classes either are offered on an onsite, online or public instructor led basis. Here is a list of our current Oracle, MySQL, Cassandra, Hadoop Database related training offerings in Training/Buffalo: Oracle, MySQL, Cassandra, Hadoop Database Training

We offer private customized training for groups of 3 or more attendees.

Oracle, MySQL, Cassandra, Hadoop Database Training Catalog

cost: $ 495length: 1 day(s)
We all know - Big Data is here in a Big way. However, processing that data can still be a Big challenge. This ...
cost: $ 1190length: 3 day(s)
In this 3-day course, students will learn how to use Redis's data types efficiently to manage large data sets. Get an understanding why you should use Redis... Learn how to work with Redis data structures and Web applications support and maintenance Learn about Redis Web applications support and components... Learn how to use search-based applications and how to reduce memory use... Learn major ...
cost: $ 1090length: 3 day(s)
The Cassandra (C*) database is a massively scalable NoSQL database that provides high availability and fault tolerance, as well as linear scalability when adding new nodes to a cluster. It has many powerful capabilities, such as tunable and eventual consistency, that allow it to meet the needs of modern applications, but also introduce a new paradigm for data modeling that many organizations do ...
cost: $ 1090length: 3 day(s)
This course introduces the Apache Spark distributed computing engine, and is suitable for developers, data analysts, architects, technical managers, and anyone who needs to use Spark in a hands-on manner. The course provides a solid technical introduction to the Spark architecture and how Spark works. It covers the basic building blocks of Spark (e.g. RDDs and the distributed compute engine), as ...
cost: $ 1190length: 3 day(s)
This course provides an in-depth introduction to the Structured Query Language, or SQL. Students learn key concepts of relational databases and query design, and have extensive opportunities to write database queries. The course also introduces table design and database update statements. ...
cost: $ 790length: 2 day(s)
The Introduction to SQL with PostgreSQL course provides an in-depth introduction to SQL and relational databases, focusing on PostgreSQL as the database management system. The course covers essential topics such as querying and sorting data, filtering records with WHERE, advanced SELECT statements, subqueries, joins, unions, and conditional processing using CASE. Students will also learn to ...
cost: $ 1090length: 2 day(s)
The ability to write the SQL language the cornerstone of all relational database operations is essential for anyone who develops database applications. In this training course, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. ...

Cassandra Classes

cost: $ 2250length: 3 day(s)
The Cassandra (C*) NoSQL database is one of the most powerful and widely used non-relational databases available today. It is a fault tolerant, highly scalable database with tunable consistency that meets the demanding requirements of the "can't fail, must scale" systems driving growth for many of the most successful enterprises of today. However, along with that capability comes a new ...
cost: $ 2250length: 3 day(s)
The Cassandra (C*) NoSQL database is one of the most powerful and widely used non-relational databases available today. It is a fault tolerant, highly scalable database with tunable consistency that meets the demanding requirements of the "can't fail, must scale" systems driving growth for many of the most successful enterprises of today. However, along with that capability comes a new ...

Hadoop Classes

cost: $ 1590length: 3 day(s)
Implement Hadoop Solutions throughout the enterprise If you're ready to make the most out of massively scalable analytics, you need to know how to take advantage of Hadoop technologies. With this class, you'll learn how! It focuses on the architecture and approaches for building advanced, Hadoop-based enterprise applications, taking a deeper, code-level dive into delivering real-world solutions. ...

Linux Unix Classes

cost: $ 1890length: 3 day(s)
This course covers the essentials of deploying and managing an Apacheâ?¢ Hadoop cluster. The course is lab intensive with each participant creating their own Hadoop cluster using either the CDH (Cloudera's Distribution, including Apache Hadoop) or Hortonworks Data Platform stacks. Core Hadoop services are explored in depth with emphasis on troubleshooting and recovering from common cluster ...

MySQL Classes

cost: $ 490length: 1 day(s)
Covers advanced MySQL administration topics: replication, optimization and clustering. ...
cost: $ 1690length: 4 day(s)
This course introduces the Apache Spark distributed computing engine, and is suitable for developers, data analysts, architects, technical managers, and anyone who needs to use Spark in a hands-on manner. It is based on the Spark 2.x release. The course provides a solid technical introduction to the Spark architecture and how Spark works. It covers the basic building blocks of Spark (e.g. RDDs ...
cost: $ 790length: 2 day(s)
MySQL is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP Linux, Apache, MySQL, PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class walks ...
cost: $ 1290length: 4 day(s)
MySQL is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP Linux, Apache, MySQL, PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class ...
cost: $ 1190length: 3 day(s)
MySQL is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP/Linux/ Apache/MySQL/PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class ...

Oracle Classes

cost: $ 790length: 2 day(s)
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. ...
cost: $ 1190length: 3 day(s)
The Oracle 10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming ...
cost: $ 2250length: 5 day(s)
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. The Oracle 10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored ...
cost: $ 1190length: 3 day(s)
A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/SQL is Oracle's Procedural Language for SQL. It is Oracle's database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for ...
cost: $ 2250length: 5 day(s)
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. The Oracle 11g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored ...
cost: $ 790length: 2 day(s)
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 11g database features and tools. ...
cost: $ 1290length: 3 day(s)
A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/SQL is Oracleâ??s Procedural Language for SQL. It is Oracleâ??s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL ...
cost: $ 890length: 2 day(s)
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will be introduced to Oracle 12c advanced capabilities database which promote better performance, increased scalability and easier data management. ...
cost: $ 2250length: 5 day(s)
This class will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA),configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management ...
cost: $ 2250length: 5 day(s)
This class will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this course is completed, the student will have gained the foundational knowledge to begin to administer Oracle 10g databases. ...
cost: $ 2250length: 5 day(s)
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10gdatabase features and tools. Students will go on to develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and ...
cost: $ 2250length: 5 day(s)
PL/SQL is Oracle's embedded procedural database language, allowing developers and administrators to write scripts, stored procedures, functions, packages, and database triggers which run in the optimized environment of the Oracle Database server. The Oracle 10g release has greatly enhanced the features and functionality of PL/SQL. This advanced course helps PL/SQL programmers take advantage of ...
cost: $ 1190length: 3 day(s)
In this class, students will develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle SQL for large data sets and data warehouses. ...
cost: $ 2250length: 5 day(s)
This class will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management ...
cost: $ 1590length: 4 day(s)
This four day workshop will get students hands-on with all of the important new Oracle 11g features they will need. Students will start with upgrades and downgrades and move on to real application testing, diagnosability and failure repair. DBA features for memory management, flashback, tables, and new Enterprise Manager tabs will then be covered. The course covers new performance and security ...
cost: $ 2250length: 5 day(s)
This hands-on course teaches students all aspects of Oracle 11g RAC administration. Students will begin with a solid foundation in Oracle Clusterware and RAC architecture. Students will then install and configure both Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important topics such as failover, flashback, and ...
cost: $ 790length: 2 day(s)
PL/SQL is Oracle's embedded procedural database language, allowing developers and administrators to write scripts, stored procedures, functions, packages, and database triggers which run in the optimized environment of the Oracle Database server. This advanced course helps PL/SQL programmers take advantage of language features, advanced techniques, and packages and facilities provided by Oracle ...
cost: $ 690length: 1 day(s)
This Oracle BI 11g (11.1.1.9) and Exalytics: New Features training explores the new features available in Oracle BI EE release 11.1.1.9.0. Expert Oracle University instructors will teach you how to work with new enhancements to Analyses, Dashboards, Oracle BI Administration Tool and Oracle BI Publisher. Learn To: - Create a BI Mobile App using Oracle BI Mobile App Designer. - Understand the ...
cost: $ 2800length: 5 day(s)
This Oracle BI 11g R1: Create Analyses and Dashboards course for Release 11.1.1.7.0 provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. You'll begin by building basic analyses to include in dashboards, with more complexity as the course progresses. Learn To: - Build analyses and dashboards. - Build and use views and graphs in ...
cost: $ 690length: 1 day(s)
This Oracle BI 11g: Overview training begins with an introduction to fundamental concepts related to business intelligence and dimensional modeling. By participating in a combination of interactive instruction and hands-on exercises, you'll get an overview of the BI Administration Tool, BI Publisher, BI Applications and Exalytics. Learn To: - Identify the analytical business challenge and the ...
cost: $ 2800length: 5 day(s)
This Oracle BI 12c: Build Repositories training teaches you how to build and verify the three layers of an Oracle Business Intelligence (BI) repository, step-by-step. Expert Oracle University instructors will begin by teaching you how to use the Oracle BI Administration Tool to construct a simple repository. Learn To: - Construct the repository. - Import schemas. - Design and build logical ...
cost: $ 2800length: 5 day(s)
This Oracle BI 12c: Create Analyses and Dashboards course for Release 12.2.1 provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. You'll begin by building basic analyses to include in dashboards, with more complexity as the course progresses. Learn To: - Build analyses and dashboards. - Build and use views and graphs in ...
cost: $ 690length: 1 day(s)
This course provides instructions and step-by-step procedures for the new features of Oracle Business Intelligence (BI) 12c, with an emphasis on system administration features and changes. This course is primarily intended for Oracle BI system administrators who are responsible for system configuration, system management, and life cycle operations. ...
cost: $ 1690length: 3 day(s)
This 3-day Oracle BI Applications: Implementation Using ODI training provides step-by-step procedures for installing, configuring, managing, and customizing Oracle Business Intelligence Applications and Oracle Business Intelligence Warehouse. It begins by exploring Oracle BI Applications components and architecture. Learn To: - Identify and describe the products, architecture and key components ...
cost: $ 1690length: 3 day(s)
This 3-day Oracle BI Publisher 11g training will help you build a foundation of understanding how to best leverage this solution. Through Classroom Training or Live Virtual Class Training, you'll learn the ins and outs of how to use this solution. Learn To: - Create data models by using the Data Model Editor. - Create BI Publisher reports based on data models. - Create report layouts by using ...
cost: $ 2400length: 5 day(s)
The single most important new capability introduced with the Oracle 12c release of the database is the multitenant database feature. With this technology, the Oracle database can be a full participant in a cloud computing-based application architecture. Even a traditional on-premise systems architecture can be dynamically and dramatically transformed as a result of this feature. Many traditional ...
cost: $ 2600length: 5 day(s)
This 5-day Boot-Camp teaches you the principal techniques and theories to design Essbase block storage databases. Block storage databases are deployed independently for budgeting, forecasting and planning, and as the underlying data storage and analytic engine for Hyperion Planning applications. ...
cost: $ 1690length: 3 day(s)
The typical Essbase project is a high visibility, high priority development project designed to enhance bottom line performance. This course will help you develop specific Essbase administrative skills so you're able to support these projects. Learn To: - Perform backup, recovery, application migration and task automation. - Optimize Essbase system caches. - Configure the block storage and ...
cost: $ 2260length: 4 day(s)
You learn the principles of aggregate storage database design, then how to build, load, report from, and manage aggregate storage databases, constructing the sixteen-dimension in-class database through a series of guided exercises. Learn to: - Design, develop, and deploy aggregate storage databases - Manage aggregate storage databases - Construct variance, mix, and other member calculations ...
cost: $ 1690length: 3 day(s)
This course, designed for individuals on the implementation team responsible for inline service development and RTD installation and administration, enables participants to perform tasks required to successfully configure and deploy RTD with their operational applications and leverage its provision of decisions as a service. Participants learn about inline services and the elements that support ...
cost: $ 2250length: 5 day(s)
This hands-on course teaches students all aspects of Oracle 10g RAC administration. Students will begin with a solid foundation in Oracle Clusterware and RAC architecture. Students will then install and configure both Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important topics such as failover, flashback, and ...

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Blog Entries publications that: entertain, make you think, offer insight

The world of technology moves faster than the speed of light it seems. Devices are updated and software upgraded annually and sometimes more frequent than that.  Society wants to be able to function and be as productive as they can be as well as be entertained “now”.

Software companies must be ready to meet the demands of their loyal customers while increasing their market share among new customers. These companies are always looking to the ingenuity and creativity of their colleagues to keep them in the consumer’s focus. But, who are these “colleagues”? Are they required to be young, twenty-somethings that are fresh out of college with a host of ideas and energy about software and hardware that the consumer may enjoy? Or can they be more mature with a little more experience in the working world and may know a bit more about the consumer’s needs and some knowledge of today’s devices?

Older candidates for IT positions face many challenges when competing with their younger counterparts. The primary challenge that most will face is the ability to prove their knowledge of current hardware and the development and application of software used by consumers. Candidates will have to prove that although they may be older, their knowledge and experience is very current. They will have to make more of an effort to show that they are on pace with the younger candidates.

Another challenge will be marketing what should be considered prized assets; maturity and work experience. More mature candidates bring along a history of work experience and a level of maturity that can be utilized as a resource for most companies. They are more experienced with time management, organization and communication skills as well as balancing home and work. They can quickly become role models for younger colleagues within the company.

Unfortunately, some mature candidates can be seen as a threat to existing leadership, especially if that leadership is younger. Younger members of a leadership team may be concerned that the older candidate may be able to move them out of their position. If the candidate has a considerably robust technological background this will be a special concern and could cause the candidate to lose the opportunity.

Demonstrating that their knowledge or training is current, marketing their experience and maturity, and not being seen as a threat to existing leadership make job hunting an even more daunting task for the mature candidate. There are often times that they are overlooked for positions for these very reasons. But, software companies who know what they need and how to utilize talent will not pass up the opportunity to hire these jewels.

 

 Related:

H-1B Visas, the Dance Between Large Corporations and the Local IT Professional

Is a period of free consulting an effective way to acquire new business with a potential client?

Back in the late 90's, there were a number of computer scienctists claiming to know java in hopes of landing a job for $80k+/year.  In fact, I know a woman you did just that:  land a project management position with a large telecom and have no experience whatsoever.  I guess the company figured that some talent was better than no talent and that, with some time and training, she would be productive.  Like all gravey train stories, that one, too, had an end.  After only a year, she was given a pink slip.

Not only are those days over, job prospects for the IT professional have become considerably more demanding.  Saying you know java today is like saying you know that you have expertise with the computer mouse; that's nice, but what else can you do.   This demand can be attributed to an increase in global competition along with the introduction of a number of varied technologies.   Take .NET, Python, Ruby, Spring, Hibernate ... as an example;  most of them, along with many others, are the backbone of the IT infrastructure of most mid-to-large scale US corporations.  Imagine the difficulty in finding the right mix of experience, knowledge and talent to support, maintain and devlop with such desparate technologies.

Well imagine no more.  According to the IT Hiring Index and Skills Report, seventy percent of CIO’s said it's challenging to find skilled professionals today.  If we add the rapid rate of technological innovation into the mix of factors affecting more businesses now than ever before, it’s understandable that the skill gap is widening.  Consider this as well:  the economic downturn has forced many potential retires to remain in the workforce.  This is detailed in MetLife's annual Study of Employee Benefits which states that“more than one-third of surveyed Baby Boomers (35%) say that as a result of economic conditions they plan to postpone their retirement.”  How then does the corporation hire new, more informed/better educated talent?    Indeed, the IT skills gap is ever widening.

In order to compensate for these skill discrepencies, many firms have resorted to hire the ideal candidates by demanding they possess a christmas wish list of expertise in a variety of different IT disciplines.  It would not be uncommon that such individuals have a strong programming background and are brilliant DBA's.  What about training?  That is certainly a way to diminish the skills gap.

A career in the field of software development remains immensely popular due to various factors. Chief among them of course is the higher compensation and lucrative pay scale in the IT industry when compared to other career options. In addition, the flexibility of work hours and the sheer sense of achievement experienced by one while creating new programs are unsurpassed by any other job.

Popularity and reach of Software Programs

Software programming has become a quintessential part of our day to day life, right from the smartphones in your pocket, to video gaming, and everything in between. The opportunities in this field are truly astounding. The niches for specializing are also diverse, from creating operating systems, to mobile app development, or web app development to name a few.

There are various ways in which you can distinguish yourself in the market for the much coveted title of software programmer. Here, we focus on some of them.

Facebook was originally intended as a way for people to stay in touch with friends and family members by sharing pictures and status updates on their timeline. As the website's popularity has grown, so has criticism that it is becoming one giant, online high school.

Online Bullying

There has been a dramatic increase in recent years in the number of online bullying cases due to the introduction of social media. Bullying isn't just limited to younger Facebook users, either. Many adult users have also resorted to bashing others online through nasty status updates and cruel comments.

Prior to social media, bullying in high school involved "kick me" signs and toilet swirling. Facebook and other social media outlets have allowed users to take bullying to a whole other level. Victims can no longer escape bullying by leaving school or work. The torture continues online, at anytime and anyplace.

Status "Likes"

In high school, everyone wants to be part of the popular crowd; people who are outgoing, beautiful, and seem like they have everything.  Posting a status update is similar to wanting to be popular. Once an update is posted, many users wait with bated breath to see how many friends will "like" their status. They believe that the more "likes" they receive, the more popular they are.

If that isn’t enough, there are many Facebook games that involve "liking" someone's status. Games like "Truth Is", where someone likes a status update and in return the poster writes how they really feel about the friend on their Facebook wall. This can get touchy, especially if the two people aren't friends outside of Facebook. It's similar to high school where someone desperately wants another person to like them, but when they find out how that person really feels they are crushed.

Relationships Are Difficult to Keep Private

When someone signs up for Facebook they’re asked to complete their profile, which includes a relationship section. Users can select from different options including "single", "married", "widowed", and "divorced". Whenever someone changes their relationship status, the update shows up on each of their friend's news feeds.

It's easy to see how this feature correlates with high school where everyone talks about who is dating who or which couple broke up. It used to be that after graduation, people were able to keep their relationships more to themselves. Not so anymore in the age of social media. Now everyone has the ability to state their opinion on a friend's relationship status, either by "liking" their status change or by commenting on it.

Facebook has presented many benefits to its users, including the ability to rekindle old high school friendships. What one must understand when they sign up for the service is that they are opening themselves up to the same criticism and drama that takes place in a high school setting.

Proceed with caution!

training details locations, tags and why hsg

A successful career as a software developer or other IT professional requires a solid understanding of software development processes, design patterns, enterprise application architectures, web services, security, networking and much more. The progression from novice to expert can be a daunting endeavor; this is especially true when traversing the learning curve without expert guidance. A common experience is that too much time and money is wasted on a career plan or application due to misinformation.

The Hartmann Software Group understands these issues and addresses them and others during any training engagement. Although no IT educational institution can guarantee career or application development success, HSG can get you closer to your goals at a far faster rate than self paced learning and, arguably, than the competition. Here are the reasons why we are so successful at teaching:

  • Learn from the experts.
    1. We have provided software development and other IT related training to many major corporations since 2002.
    2. Our educators have years of consulting and training experience; moreover, we require each trainer to have cross-discipline expertise i.e. be Java and .NET experts so that you get a broad understanding of how industry wide experts work and think.
  • Discover tips and tricks about Oracle, MySQL, Cassandra, Hadoop Database programming
  • Get your questions answered by easy to follow, organized Oracle, MySQL, Cassandra, Hadoop Database experts
  • Get up to speed with vital Oracle, MySQL, Cassandra, Hadoop Database programming tools
  • Save on travel expenses by learning right from your desk or home office. Enroll in an online instructor led class. Nearly all of our classes are offered in this way.
  • Prepare to hit the ground running for a new job or a new position
  • See the big picture and have the instructor fill in the gaps
  • We teach with sophisticated learning tools and provide excellent supporting course material
  • Books and course material are provided in advance
  • Get a book of your choice from the HSG Store as a gift from us when you register for a class
  • Gain a lot of practical skills in a short amount of time
  • We teach what we know…software
  • We care…
learn more
page tags
what brought you to visit us
Training/Buffalo,  Oracle, MySQL, Cassandra, Hadoop Database Training , Training/Buffalo,  Oracle, MySQL, Cassandra, Hadoop Database Training Classes, Training/Buffalo,  Oracle, MySQL, Cassandra, Hadoop Database Training Courses, Training/Buffalo,  Oracle, MySQL, Cassandra, Hadoop Database Training Course, Training/Buffalo,  Oracle, MySQL, Cassandra, Hadoop Database Training Seminar