Databases

SETC Training’s z/OS and DB2 training courses provide IT professionals with enterprise class mainframe training courses. Our mainframe curriculum covers the full range of topics including z/OS and DB2 administration, configuration, use and development. If you are new to mainframe environments, SETC Training can provide you with a solid introduction to the z/OS operating system, the WebSphere server or the DB2 relational database environment. If are an experienced mainframe professional, we can offer you advanced DB2, z/OS and WebSphere development, administration debugging and troubleshooting training courses. SETC Training also offers an automatic 10% discount, guaranteed dates and free course customization services for groups of 2 people or more.

The Oracle PLSQL training courses at SETC Training are based on industry best practices and standards. Every PLSQL training course is based on proper production coding practices in an enterprise database environment. You learn how to build and implement relational databases using the Oracle RDBMS. We offer everything from basic PLSQL syntax to advanced XML and Java integration with the PLSQL language. The PLSQL courses at SETC Training cover cursors, collections, report generation, object oriented programming, indexing, tuning and optimization and much more. SETC Training also offers an automatic 10% discount, guaranteed dates and free course customization services for groups of 2 people or more.

MEAN (MongoDB, Express, AngularJS, and Node.JS) represents a new breed of software platforms that creatively leverage a stack of production-ready technologies centered on JavaScript. This course introduces students to the essential concepts, design principles, idioms, and techniques behind the efficient use of the MEAN JavaScript Technology Stack. Upon completion of this training course, students will have solid understanding of MEANS' value proposition; they will also gain practical experience working with all the components of the MEAN stack. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

The SQL Server 2016 curriculum includes Reporting Services, Integration Services and Analysis Services. Our instructor-led classes provide substantial hands-on lab time and individual attention.

+Fundamental Methods for Data Science in R +Machine Learning Examples for Data Science in R

+MySQL: Database Concepts, Design, and Installation +MySQL: Querying Data Using the SELECT Statement +MySQL: Using the Data Manipulation and Definition Statements +MySQL: General Syntax, Advanced Queries, and Stored Programs +MySQL: Advanced Routines, Optimization, and DCL +MySQL: Storage Engines, Advanced Indexing, and Maintenance +MySQL: Administration, Transactions, Optimization, Scaling, Backup, and Recovery +MySQL: Performance Monitoring, Database Health and Integrity, and Security

+MapReduce Essentials +Apache Hadoop

+The Big Data Technology Wave +Big Data Opportunities and Challenges

+RavenDB Overview +RavenDB Integration

+MongoDB: Indexing, Replication, and Security

The MCSA: SQL 2012/MCSE: Business Intelligence training and certification bootcamp is the most comprehensive class for SQL 2012 Business Intelligence. Microsoft has completely revamped the SQL 2014 certification to blend Administrator and Business Intelligence concepts together into a unified training and certification. The 16 day length of this bootcamp was decided after careful consideration of time needed to cover all new concepts. Our program incorporates Microsoft Courses: 20461 Querying Microsoft SQL Server 2012; 20462 Administering Microsoft SQL Server Databases; 20463 Implementing a Data Warehouse with Microsoft SQL Server; 20466 Implementing Data Models and Reports with Microsoft SQL Server 2012; 20467 Designing Self-Service Business Intelligence and Big Data Solutions. Below are topics covered in camp. Fundamentals are covered quickly and majority of lecture, demonstrations and labs are focused on the advanced topics related to new technologies in SQL 2014.

The Microsoft MCSA SQL Server certification boot camp is a 9 day comprehensive deep dive into the SQL Server covering topics such as including query, administration and data warehousing. This instructor led training program will teach you the skills needed to support an SQL 2014 environment. Theprogram incorporates Microsoft Official Courses: 20461 Querying Microsoft SQL Server & 20462 Administering Microsoft SQL Server Databases & 20463 Implementing a Data Warehouse with Microsoft SQL Server. While attending this training program - you take three exams to test and certify for the Microsoft Certified Solutions Associate (MCSA): SQL Server official certification. If your goal is to learn how to use SQL Server and pass the certification exams (70-461, 70-462 & 70-463)

Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.

This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. After completing this course, students will be able to: Describe SQL Server Reporting Services and its components. Create a Reporting Services report. Enhance a Reporting Services report. Create and manipulate data sets. Use report models to implement reporting for business users. Configure report publishing and execution settings. Implement subscriptions for reports. Administer Reporting Services. Implement custom Reporting Services applications.

This instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. After completing this course, students will be able to: Describe SQL Server Integration Services and its tools. Create an Integration Services package. Implement control flow in an Integration Services package. Implement data flow in an Integration Services package. Implement logging in an Integration Services package. Debug and implement error handling in an Integration Services package. Implement checkpoints and transactions in an Integration Services package. Deploy an Integration Services package. Manage and secure an Integration Services package.

This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. After completing this course, students will be able to: * Describe how SQL Server Analysis Services can be used to implement analytical solutions. * Create multidimensional analysis solutions with SQL Server Analysis Services. * Implement dimensions and cubes in an Analysis Services solution. * Implement measures and measure groups in an Analysis Services solution. * Query a multidimensional Analysis Services solution.

This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2005 or 2008. After completing this course, students will be able to: Describe the uses of and ways to execute the Transact-SQL language. Use querying tools. Write SELECT queries to retrieve data. Group and summarize data by using Transact-SQL. Join data from multiple tables. Write queries that retrieve and modify data by using subqueries. Modify data in tables. Query text fields with full-text search. Describe how to create programming objects. Use various techniques when working with complex queries.