Course ID: 310338
Db2 12 for z/OS Introduction to System Administration
<div><p>After completing this course, students should be able to:</p> <ul> <li>Start and stop a Db2 subsystem</li> <li>Use the SET SYSPARM command</li> <li>Access the system log to gather information about the subsystem initialization, operation, or shutdown</li> <li>Describe the components and address space structure of a Db2 subsystem</li> <li>Explain the use of RACF (or another external security program) for Db2 connection security</li> <li>Explain the use of Roles and Trusted Contexts</li> <...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2535
VIEW DETAILS
Course ID: 310073
Working with Cassandra (TTDS6776)
<div><p>Join an engaging hands-on learning environment, where youll learn to:</p> <ul> <li>Understand the needs that C* addresses</li> <li>Be familiar with the operation and structure of C*</li> <li>Be able to install and set up a C* database</li> <li>Use the C* tools, including cqlsh, nodetool, and ccm (Cassandra Cluster Manager)</li> <li>Be familiar with the C* architecture, and how a C* cluster is structured</li> <li>Understand how data is distributed and replicated in a C* cluster</li> <li>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $1995
VIEW DETAILS
Course ID: 256592
Introduction to Data Analysis
<div><p>In this Introduction to Data Analysis Course, you will:</p> <ul> <li>Measure business performance.</li> <li>Identify improvement opportunities for business processes.</li> <li>Describe the need for tracking and identifying the root causes of deviation or failure.</li> <li>Use the principles, properties, and application of Probability Theory.</li> <li>Discuss data distribution including central tendency, variance, normal distribution, and non-normal distributions.</li> <li>Draw conclusion...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
2 days
Duration
2 days
Price: $1295
VIEW DETAILS
Course ID: 190191
Hands-On Crystal Reports®
<h3>Overview of Crystal Reports</h3>
<ul>
<li>Formatting and summarizing data</li>
<li>Filtering, sorting and grouping data</li>
<li>Customizing reports with business logic</li>
<li>Connecting to SQL Server, Oracle and Access databases</li>
</ul>
<h3>The Crystal Report Writer</h3>
<h4>Writing a basic report</h4>
<ul>
<li>Selecting a format</li>
<li>Adding text and fields</li>
<li>Connecting to remote data sources</li>
<li>Configuring the reporting environment</li>
</ul>
<h4>Format...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
2 days
Duration
2 days
Price: $990
VIEW DETAILS
Course ID: 312045
Administering Relational Databases on Microsoft Azure (DP-300T00)
<div><p>Learn to,</p> <ul> <li>Plan, deploy and configure Azure SQL offerings</li> <li>Monitor database performance and tune a database and queries for optimum performance</li> <li>Plan and configure a High Availability Solution</li> </ul></div>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
4 days
Duration
4 days
Price: $2595
VIEW DETAILS
Course ID: 269235
Veeam Availability Suite v11: Configuration & Management
<div><p>After completing this course, attendees should be able to:</p> <ul> <li>Describe Veeam Availability Suite components usage scenarios and relevance to your environment.</li> <li>Effectively manage data availability in on-site, off-site, cloud and hybrid environments.</li> <li>Ensure both Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs) are met.</li> <li>Configure Veeam Availability Suite to ensure data is protected effectively.</li> <li>Adapt with an organizations evo...
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
3 days
Duration
3 days
Price: $3000
VIEW DETAILS
Course ID: 256681
Data Modeling
<div><ul> <li>How logical data models relate to requirements</li> <li>Identifying entities and attributes</li> <li>Determining relationships and business rules</li> <li>Data integrity through normalization</li> </ul></div>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 237390
DB2 Family Fundamentals
<div><ul> <li>List and describe the major components of IBM's relational database, DB2</li> <li>Explain the characteristics of a DB2 table</li> <li>Relate the basic concepts of data modeling</li> <li>Comprehend the processing instructions given to DB2 via simple SQL statements</li> <li>List and describe several ways to build (write) and execute SQL statements</li> <li>List and describe steps needed to imbed SQL statements in an application program</li> <li>Explain some of the functions performed...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
2 days
Duration
2 days
Price: $1590
VIEW DETAILS
Course ID: 292727
Db2 12 for z/OS SQL Performance and Tuning
<div><p>After completing this course, you will be able to:</p> <ul> <li>Understand and design better indexes</li> <li>Determine how to work with the optimizer (avoid pitfalls, provide guidance)</li> <li>Optimize multi-table access</li> <li>Work with subqueries</li> <li>Avoid locking problems</li> <li>Use accounting traces and other tools to locate performance problems in existing SQL</li> </ul></div>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2610
VIEW DETAILS
Course ID: 310556
Oracle 19c Database Administration
<div><p>Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will learn to:</p> <ul> <li>Describe Oracle Database architecture</li> <li>Describe Oracle Database Cloud Service (DBCS) architecture and features</li> <li>Create and manage DBCS database deployments</li> <li>Configure the database to support your applicati...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
5 days
Duration
5 days
Price: $2595
VIEW DETAILS
Course ID: 260665
Tableau: Presenting Analytic Visualizations
<h3>Getting Started with Tableau</h3>
<h4>Employing visual analysis and analytics</h4>
<ul>
<li>Appreciating the impact of Big Data on visualization
</li><li>Handling large volumes of data
</li><li>Presenting visualizations to analysts and business users
</li></ul>
<h4>Exploring Tableau</h4>
<ul>
<li>Utilizing the Tableau interface components
</li><li>Distinguishing measures and dimensions
</li><li>Generating basic visualizations
</li></ul>
<h3>Data Visualizations for Business Intel...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
3 days
Duration
3 days
Price: $1987
VIEW DETAILS
Course ID: 314456
Configuration Management Database (CMDB) Fundamentals
<div><p>In this instructor led three-day interactive CMDB Fundamentals course, attendees learn how to:</p> <ul> <li>Describe the CMDB and the attributes that provide enterprise-wide visibility</li> <li>Learn the stages for planning a successful CMDB deployment</li> <li>Explore best practices for configuring and implementing a CMDB, including the role of Health Scan</li> <li>Explain how the CI Class Manager provides a centralized place to create and edit CI classes</li> <li>Leverage the Identific...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $2400
VIEW DETAILS
Course ID: 314981
Oracle 19c Database Administration II (Oracle DBA II)
<div><p>This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will explore:</p> <ul> <li>Creating CDBs and Regular PDBs</li> <li>Managing CDBs and PDBs</li> <li>Backup and Duplicate</li> <li>Upgrading and Transporting CDBs and Regular PDBs</li> <li>Backup Strategies and Terminology</li> <li>Restore and R...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 190172
Developing SQL Queries for Oracle® Databases: Hands-On
<h3>Introduction and Overview</h3>
<h4>The uses of SQL queries</h4>
<ul>
<li>Why SQL can be both easy and difficult</li>
<li>Recommendations for thorough testing</li>
</ul>
<h4>Enhancing query performance</h4>
<ul>
<li>Query optimization</li>
<li>Choosing the most efficient query method</li>
</ul>
<h3>Leveraging SQL Functions to Build Queries</h3>
<h4>Aggregate functions</h4>
<ul>
<li>Grouping in several levels</li>
<li>Grouping and NULLs</li>
<li>CUBE and ROLLUP</li>
<li>Building crosstab repor...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
4 days
Duration
4 days
Price: $2242
VIEW DETAILS
Course ID: 190291
Relational Database Design, Tools and Techniques: Hands-On
<h3>An Overview of DBMS Technology
</h3><ul>
<li>How data is accessed, organized, and stored</li><li>Relational and NoSQL database comparisons</li><li>Roles involved in database design, development, and administration<br></li>
<li>The database development process</li>
</ul><br><h3>How a Relational DBMS Works</h3>
<h4>Relational technology fundamentals</h4>
<ul>
<li>Terminology and definitions<br></li><li>Tables, attributes and relationships</li>
<li>Primary and foreign keys</li>
<li>M...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
4 days
Duration
4 days
Price: $2242
VIEW DETAILS
Course ID: 314557
Introduction to MongoDB for Developers
<div><p>This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore:</p> <ul> <li>Storage Basics</li> <li>MongoDB Document Model</li> <li>MongoDB Setup</li> <li>CRUD: Basics through Advanced Concepts</li> <li>Performance: Basics through Advanced Concepts</li> <...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 292053
SECURING DATABASES (TT8700)
<div><ul> <li> Consequences for not properly handling untrusted data such as denial of service, cross-site scripting, and injections</li> <li> Test databases with various attack techniques to determine the existence of and effectiveness of layered defenses</li> <li> Prevent and defend the many potential vulnerabilities associated with untrusted data</li> <li> Concepts and terminology behind supporting, designing, and deploying secure databases</li> <li> Problems associa...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
2 days
Duration
2 days
Price: $1495
VIEW DETAILS
Course ID: 310562
Oracle Database 19c Multitenant Architecture
<div><p>Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore:</p> <ul> <li>Core concepts of regular PDBs</li> <li>Creating a CDB, and then using different methods to create PDBs.</li> <li>How to start and shut down a CDB and how to open and close a PDB.</li> <li>Security aspects in CDBs and PDBs in vario...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $2495
VIEW DETAILS
Course ID: 314771
Transact-SQL Querying (DP-080T00)
<div><p>Students will learn to,</p> <ul> <li>Use SQL Server query tools</li> <li>Write SELECT statements to retrieve columns from one or more tables</li> <li>Sort and filter selected data</li> <li>Use built-in functions to returned data values</li> <li>Create groups of data and aggregate the results</li> <li>Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE</li> </ul></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
2 days
Duration
2 days
Price: $1545
VIEW DETAILS
Course ID: 237392
DB2 SQL Workshop for Experienced Users
<div><ul><li>Discuss basic relational database concepts </li><li>Use some of the OLAP features of DB2, such as GROUPing and RANKing functions </li><li>Create tables, views and indexes </li><li>Use referential integrity, check constraints and triggers </li><li>Use outer joins, and join tables to themselves </li><li>Use CASE expressions, and the CAST function </li><li>Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables </li><li>Use complex subqueries </li><li>Use...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2385
VIEW DETAILS
TrainUp.com is your one-stop source for the best virtual database training and live courses nationwide. Start your search now and browse among 45 live instructor-led database training classes near you, from the industry's best database training companies such as SkillSoft, Global Knowledge, and Learning Tree International TrainUp.com also lists more than 297 self-paced online database training courses, micro-learning videos, and eLearning bundles. If you have a team to train, we can conduct a course just for you. Check out our onsite on-site database training page to request a custom virtual or in-person training quote today.
Request Database On-Site Training. We bring the best instructors to you.
