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

With the skyrocketing popularity of Android and iOS operating systems, software developers got a whole new arena opened up. Many of the programmers have progressed to concentrate solely onto Mobile Technology Development. This is mainly due to the high demand as well as numerous lucrative ideas left to explore in the Mobile App world.

Exponential growth of smartphone users

As per the survey by eMarketer, the number of smartphone users across the globe crossed 1 billion almost two years ago. The expected number of smartphone users by 2014 end is 1.75 billion.

With smartphones, iPads and Tablets getting more accessible and less expensive day by day, the development potential for mobile apps is truly vast. The under-penetration in emerging markets like India and China in Asia shows that there seems to still a lot of steam left in the mobile app development industry.

Cloud computing is the recent rage in the IT industry. According to the report by Forbes, the estimated global market for cloud computing is expected to reach $35.6 billion in 2015, from the $12.1 billion market of 2010.

How it began

The idea of cloud computing was inspired by the concept of “utility computing” which introduced the idea of computing using the virtual servers. These virtual servers do not actually exist anywhere physically and can be moved anywhere without causing any disturbance to the end users. Thus it minimizes the cost involved on the devices to a great extent and provides innumerable benefits to the companies that adopt this system.

Cloud Computing Types

We’re often asked by companies about how they can get the most value from Agile/Scrum practices. More specifically, they want to know if they are being as effective as best they possibly can be by using the Scrum framework for their explicit needs.

The other objective for individuals is determining if it necessary to be certified in order to be effective in the Agile Scrum world?   In short, a good Scrum Master must understand four things: the business they work in, the technology they work with, the Agile and Scrum principles, and, most importantly, people!  Based on these facts, Scrum Master Certification is not enough – real life experience and a bit of soft skills should be part and parcel of their training. For organizations, the main goal is to understand industry best practices when adopting and applying agile principles, to build strong teams, understand and distill business needs into software requirements.

In terms of getting a good grip on training for Agile/Scrum, one can opt to pursue a certification in Scrum (CSM) Certified Scrum Master for personal reasons or for a job requirement. Or, one can simply opt to learn the benefits and pitfalls of the methodology and decide the best approach for them.

There are different ways to get started with Agile training. Below are two of the most common paths to Agile our students take.

A project manager acts as the primary link between business and technical teams. A project manager is responsible for maintaining the project schedule, developing project estimates, working with external teams and tracking project issues. The project manager belongs to either the technical team or the project management office (PMO). The project manager works with business teams, technical teams, business counterparts, testing resources, vendors and infrastructure teams.

A project manager is often challenged with diagonally opposite views from the business side and technical side. A project manager’s success depends on balancing the needs and emotions of both sides.

Understanding the Requirements
A project manager must familiarize with the project’s requirements as defined by the business or product managers. This will help you understand the business vision behind the project. You will need this knowledge while negotiating with the technical teams.

Understanding the Technical Landscape
A project manager must also understand the technical systems, resource skills and infrastructure capabilities available for the project. Business teams come up with expectations that are sometimes beyond the capabilities of the technology team. It is the responsibility of the project manager to understand the technical capabilities available to the project.

Walkthrough of Business Requirements
This is a critical step in the project delivery process. The project manager must invite members from the business team, technical team, testing team, infrastructure team and vendors. The project manager must encourage the various stakeholders to ask questions about the requirements. Any prototypes available must be demonstrated in this meeting. The project manager must find answers to all questions resulting from the requirements walkthrough. The project manager must get the final version of the requirements approved by all stakeholders.

Managing Conflicts in Timelines and Budgets
All project managers will face the conflicts arising from shortened timelines and limited budgets. Business teams typically demand many features that are nearly impossible to deliver within short timeframes. The project manager must work with business and technical teams to prioritize the requirements. If the project is executed in a product development organization, then the project manager could utilize agile methodologies to deliver projects incrementally. In this case, the project manager may be required to act as a scrum master to facilitate scrum meetings between various stakeholders.

The Art of Saying “No”
As a project manager, you may be forced to say “no” to demands from both business and technology teams. However, it is important to create a win-win situation for all parties when you are faced with conflicting demands. You can work with the stakeholders individually before bringing all parties together. Most stakeholders prefer to work together. The success of a project manager depends on how effectively he or she can bring out the best in everyone, driving everyone towards a common goal.

Finally, the job of a project manager is not to satisfy the demands from all corners. The project manager must identify the essential deliverables that will meet the business needs, with a solid understanding of what is possible within the limits of technology.

 

Related:

Smart Project Management: Best Practices of Good Managers

Is Agism an Issue in IT?

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.