Course ID: 261311
Introduction to SQL Databases (M10985)
<div><p>This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. Note:</p> <ul> <li>Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session</li> <li>Redeem two SATVs for an individual GK Digital Learning course</li> </ul> <p>�</p> <p><em>*For more information on Microsoft SATVs, click<span>�</span><a href="https://www.globalknowledge.com/us-en/training/planning-logistics/payment-policies/payment-options/credits-vouchers/microsoft-satvs/">here</a>.</em></p></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 261314
Administering a SQL Database Infrastructure (M20764)
<div><p>In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.�Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.</p></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
5 days
Duration
5 days
Price: $2995
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)
4
# of Virtual Event(s)
4 EVENTS
Duration
2 days
Duration
2 days
Price: $990
VIEW DETAILS
Course ID: 256592
Introduction to Data Analysis
<div><p>Data analysis and analytics are evolving disciplines. We constantly hear about big data, prediction, AI, and modeling techniques.</p> <p>However, advanced techniques rest on fundamentals which can be applied in many job roles. This class quickly equips you with that foundation. Whether you're charting your overall business intelligence strategy or performing analysis yourself, these basic tools and techniques rapidly inform effective decision-making. In this fast-paced introductory workshop, we'll examine the history of business intelligence, its relationship to data analysis, and why the two are needed to help businesses deliver a complete assembly of the 'data puzzle'. We'll also address hurdles teams face when dealing with data overload and suggests some possible solutions.</p> <p>Amid an ongoing explosion of data, there's also a greater need to understand who is qualified to correctly analyze data. We will explore the qualifications of data analysts as well as the analytic tools available for those people to use associated with the position.</p> <p>Please note: Exercises in this course are not compatible with Excel in a web browser. Please make sure you have a version of Excel locally downloaded on your computer or access to Excel via Microsoft 365.</p> <p>This course has been submitted, reviewed, and approved by the International Institute of Business Analysis (IIBA) to award CDUs for attendance.</p></div>...
# of Virtual Event(s)
12
# of Virtual Event(s)
12 EVENTS
Duration
2 days
Duration
2 days
Price: $1445
VIEW DETAILS
Course ID: 314692
Querying Data with Microsoft Transact-SQL Training (DP-080)
<b>Important Course Information</b><ul class="accordion">
<li>
<h3>Who Should Attend This Course</h3>
<div>
<p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer....
# of Virtual Event(s)
10
# of Virtual Event(s)
10 EVENTS
Duration
2 days
Duration
2 days
Price: $1950
VIEW DETAILS
Course ID: 314981
Oracle 19c Database Administration II (Oracle DBA II)
<div><p>Geared for participants experienced with Oracle 19c DBA essentials <strong>Oracle 19c Database Administration Workshop II</strong> expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.</p> <p>NOTE: This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. This course is for 19c. It is also available for earlier editions (11g, 12c, etc). Please inquire for details.</p></div>...
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
5 days
Duration
5 days
Price: $2945
VIEW DETAILS
Course ID: 310073
Working with Cassandra (TTDS6776)
<div><p>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. It also introduces a new concept for data modeling and many organizations do not have the expertise to use it in the most efficient manner.</p> <p>This course provides an in-depth introduction to using Cassandra and creating quality data models. This course is technical and comprehensive, with a focus on the practical aspects of working with C*. It introduces all the important concepts needed to understand Cassandra, including enough coverage of internal architecture so you can make optimal decisions. It also covers CQL (Cassandra Query Language) in depth, as well as covering the Java API for writing Cassandra clients.</p> <p>After taking this course, you�ll have learned what you need to productively work with Cassandra as well as guidelines for using it in an optimal manner. You'll also understand some of the "anti-patterns" that lead to non-optimal C* data models. In the end, you'll be familiar with CQL and with the Java client library and be ready to work on production systems involving Cassandra.</p></div>...
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
3 days
Duration
3 days
Price: $2145
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)
4
# of Virtual Event(s)
4 EVENTS
Duration
4 days
Duration
4 days
Price: $2990
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)
4
# of Virtual Event(s)
4 EVENTS
Duration
4 days
Duration
4 days
Price: $2990
VIEW DETAILS
Course ID: 314557
Introduction to MongoDB for Developers
Geared for experienced developers, Introduction to MongoDB for Developers is a hands-on course that provides students with comprehensive coverage of and hands-on experience with the MongoDB query language and aggregation framework, data modeling, indexes, drivers, basic performance tuning, high availability and scaling. Throughout the course, students will explore the MongoDB Atlas database environment....
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
3 days
Duration
3 days
Price: $2445
VIEW DETAILS
Course ID: 310557
Oracle 19c Database Tuning
<div><p>Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.</p></div>...
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
5 days
Duration
5 days
Price: $2945
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)
6
# of Virtual Event(s)
6 EVENTS
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 269235
Veeam Availability Suite v11: Configuration & Management
<div><p>The Veeam� Availability Suite� v11: Configuration and Management training course is a three-day, technical deep dive focused on teaching IT professionals the skills to configure, manage and support a Veeam Availability Suite v11 solution. With extensive hands-on-labs, the class enables administrators and engineers to effectively manage data in an ever-changing technical and business environment, bringing tangible benefit to businesses in the digital world.</p> <p>This course is based on Veeam Availability Suite v11.</p></div>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $3000
VIEW DETAILS
Course ID: 256681
Data Modeling
<div><p>Since a business analyst needs to accurately elicit, define, and document user requirements, understanding the users' needs is key to an analyst's success. By using logical data modeling, a business analyst can convey requirements in a way that can easily be validated, and doing so allows stakeholders to understand the requirements, business rules, and data management methods for any given project.</p> <p>In this class, get hands-on practice modeling requirements through entity relationship diagrams, supertypes and subtypes, and attributive and associative entities. You will learn to use logical data modeling to work directly with business users to accurately define requirements.</p> <p>Students pursuing a university-recognized and/or accredited certificate in Canada or continuing education units in the US must attend at least 90% of class time, participate in class exercises and section-knowledge checks, and score at least 70% on an end-of-class, multiple-choice assessment.</p></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 310556
Oracle 19c Database Administration
<div><p>Oracle 19C Database Administration is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies.</p></div>...
# of Virtual Event(s)
8
# of Virtual Event(s)
8 EVENTS
Duration
5 days
Duration
5 days
Price: $2745
VIEW DETAILS
Course ID: 312045
Administering Relational Databases on Microsoft Azure (DP-300T00)
<div><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p> <p>One Microsoft exam voucher included with class.</p></div>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
4 days
Duration
4 days
Price: $2595
VIEW DETAILS
Course ID: 310562
Oracle Database 19c Multitenant Architecture
<div><p>The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Oracle Database 19c Multitenant Architecture is a three-day hands-on course that explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs</p></div>...
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
3 days
Duration
3 days
Price: $2645
VIEW DETAILS
Course ID: 292053
SECURING DATABASES (TT8700)
<div><p><b><i>Securing Databases</b></i> is an intense database security training workshop/seminar essential for DBAs and developers who need to produce secure database applications and manage secure databases. In addition to teaching basic skills, this course digs deep into sound processes and practices that apply to the entire software development lifecycle. Perhaps just as significantly, you will learn about current, real examples that illustrate the potential consequences of not following these best practices.</p> <p>This course quickly introduces you to the most common security vulnerabilities faced by databases today. You will examine each vulnerability from a database perspective through a process of describing the threat and attack mechanisms, recognizing associated vulnerabilities, and, finally, designing, implementing, and testing effective defenses. Multiple practical demonstrations reinforce these concepts with real vulnerabilities and attacks. You will then be challenged to design and implement the layered defenses you will need in defending your own databases. You will leave the course armed with the skills required to recognize actual and potential database vulnerabilities, implement defenses for those vulnerabilities, and test those defenses for sufficiency.</p> <p>Security experts agree that the least effective approach to security is "penetrate and patch". It is far more effective to "bake" security into an application throughout its lifecycle. After trying ...
# of Virtual Event(s)
8
# of Virtual Event(s)
8 EVENTS
Duration
2 days
Duration
2 days
Price: $1645
VIEW DETAILS
Course ID: 190312
SQL Programming Language: A Comprehensive Hands-On Introduction
<h3>SQL Overview</h3>
<ul>
<li>Outlining SQL as the cornerstone of database activity</li>
<li>Applying the ANSI/ISO standards</li>
<li>Describing the fundamental building blocks: tables, columns, primary keys and foreign keys</li>
</ul>
<h3>Building the Database Schema</h3>
<h4>Creating tables and columns</h4>
<ul>
<li>Building tables with CREATE TABLE</li>
<li>Modifying table structure with ALTER TABLE</li>
<li>Adding columns to an existing table</li>
<li>Removing tables with DROP T...
# of Virtual Event(s)
8
# of Virtual Event(s)
8 EVENTS
Duration
3 days
Duration
3 days
Price: $1950
VIEW DETAILS
Course ID: 233569
SQL Server® 2012: A Comprehensive Hands-On Introduction
<h3>Introducing SQL Server</h3>
<h4>Overview of the SQL Server suite of products</h4>
<ul><li>Fundamentals of the relational database engine
</li><li>Benefits of the Business Intelligence stack</li></ul>
<h4>SQL Server components and tools</h4>
<ul><li>SQL Server Agent and Management Studio
</li><li>Integration Services
</li><li>Analysis Services
</li><li>Reporting Services
</li><li>Data Quality Services
</li><li>Master Data Services</li></ul>
<h3>Building the Database</h3>
<h4>Const...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
4 days
Duration
4 days
Price: $2990
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.
