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

.NET is a highly popular programming language from Microsoft that continues to rock the IT industry since its inception almost twelve years ago. Simply stated, it is a development framework comprising of multiple modules that helps in creating Web Applications, Windows Applications as well as Mobile Applications. The demand for .NET programmers saw a definite surge in the last decade - thanks to the evolution of the smart phones.

Listed below are some of the recent and prevalent aspects of .Net

ASP .NET - Web API

Microsoft considers Web AP I as the future of ASP .NET. The world of web is heading towards a simpler, lightweight, REST based services. Web API makes it possible with the ASP.NET MVC without the heavy lifting that WCF requires. jQuery could be utilized for displaying results in front end of the page as shown in the example in Microsoft site.

From Brennan's Blog which is no longer up and running:

I use Remote Desktop all the time to work inside of my development systems hosted by Microsoft Virtual Server. I use the host system to browse the web for documentation and searches as I work and when I need to copy some text from the web browser I find many times the link between the host clipboard and the remote clipboard is broken. In the past I have read that somehow the remote clipboard utility, rdpclip.exe, gets locked and no longer allows the clipboard to be relayed between the host and the client environment. My only way to deal with it was to use the internet clipboard, cl1p.net. I would create my own space and use it to send content between environments. But that is a cumbersome step if you are doing it frequently.

The only way I really knew to fix the clipboard transfer was to close my session and restart it. That meant closing the tools I was using like Visual Studio, Management Studio and the other ancillary processes I have running as I work and then restarting all of it just to restore the clipboard. But today I found a good link on the Terminal Services Blog explaining that what is really happening. The clipboard viewer chain is somehow becoming unresponsive on the local or remote system and events on the clipboards are not being relayed between systems. It is not necessarily a lock being put in place but some sort of failed data transmission. It then goes on to explain the 2 steps you can take to restore the clipboard without restarting your session.

  • Use Task Manager to kill the rdpclip.exe process
  • Run rdpclip.exe to restart it

The clipboard communications should be restored. My clipboard is currently working because I just restarted my session to fix it, but I wanted to test these steps. I killed rdpclip.exe and started it and was able to copy/paste from the remote to the host system. The next time my clipboard dies I will have to check to see if these steps truly do work.

When it comes to running a start up, leaders need to make sure that their key players are motivated. This has been seen with many companies. Back in the 1970's it was found with the inspiration and diligence of the late Daniel Nigro when he formed Kleer-Fax. More recently it was seen in David Khasidy, the founder and recently retired president of SunRay Power Management, the most dynamic green energy leader in the US today.

The question is, what is it that great leaders like David Khasidy and Daniel Nigro do that make the difference? How do the most vulnerable companies (start ups) break the mold and become a part of our everyday lives?

It starts with their mission and vision.

Create a Strong Mission and Vision

There are many reasons why start ups fail. For one, they usually lack the capital to last through the lean times. Secondly, they often don't have the tolerance for setbacks that occur. Lastly, they do not have a long-term plan, also called a mission.

When a business has a strong mission, the team knows it and their focus toward their work and service to others within and without the company reflects that. To complement that, the shorter term vision of the company needs to be present as well.

This can even be seen in sole proprietorships with no employees, such as when Brian Pascale started his law practice. His vision was to find justice for his clients while his mission was to build upon a career that had already set precedents in the area of tort law.

As his practice has grown, new staff members can sense the vision and mission he exudes.

Encourage Ownership of Projects and Processes

Start ups need to inspire and motivate their employees because they need to know that they are not only a part of something important, but that their contributions mean something.

What won't happen if they are not there? What contribution do they make, and what are the consequences of them not fulfilling their part of the work?

By encouraging ownership in projects, team members can find that the work they are doing is not only important for the organization, but that they are going to be a big part of what makes it happen. The alternative is that they feel replaceable.

Offer Incentives That Keep the Company Competitive

When team members embrace the mission and vision of the company, and then take ownership for the company's success, they are going to need to be justly rewarded.

This could include flexible schedules (for those who don't need a stringent one), use of an account at a nearby takeout place, or even the potential for ownership as a result of a vesting program.

The incentive everyone is looking for more immediately, though, is cash. When the company takes in more revenue as a result of the efforts of those on the team, rewarding them can go a long way not only in making them feel appreciated, but in encouraging them to bring in more business.

Members of a start up team are usually very talented, and commonly underpaid. However, if they believe they are going somewhere, it will make a big difference.

 

Related:

Good non-programmer jobs for people with software developer experience

The short answer is, yes and no. It depends upon who you are. The purpose of this entry is to help you determine, yes or no.

Full disclosure. This entry is created on a Mac mini. And doing so on Windows 8 (Release Preview). If you are a developer, in my humble opinion you need to test on all platforms you expect your app to run or you are not much of a developer.

To be successful you need to leave politics in geographical territory known as Washington DC. My definition of that is: 14 mi.² of real estate surrounded by reality.

Only in politics can we afford to take sides. Those of us in IT, especially developers need to do our best to be all things to all people. Certainly this is a technical impossibility. However in our game we can get some points for at least being serviceable if not outstanding.

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

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.