Data

NoSQL for FSD Development

Overview/Description:

Discover the role NoSQL databases play in the full stack development (FSD) process in this 14-video course. Explore both NoSQL databases, including the Couchbase, CouchDB, and MongoDB database systems. Key concepts covered here include available NoSQL databases and the advantages of using them; cloud options for NoSQL database and how to choose the best one for your project; and learning to differentiate between relational and non-relational (NoSQL) databases and the reasons to use either SQL or/and NoSQL databases in Functional Specification Document (FSD). You will review features of using the MongoDB database system; learn deployment options when working with NoSQL databases; and learn security issues when using NoSQL databases and methods to prevent these security issues. Next, identify areas for enhancing performance when using NoSQL databases; examine Cap Theorem and how it applies to NoSQL databases; and recognize unstructured data and how it applies to NoSQL databases. Finally, learn how to install and configure the MongoDB NoSQL database system and also the CouchDB NoSQL database system for use in FSD development.

Course Number:

it_fsnsqldj_01_enus

Administration & Development

Overview/Description:

Proper database management helps ensure your data is valid and secure. Explore database administration and development using Cassandra in a distributed framework.

Course Number:

it_dfcasd_03_enus

Performance Tuning Best Practices

Overview/Description:

Hadoop can scale up from single servers to thousands of machines, each offering local computation and storage. Discover performance tuning concepts, including compression, tune up options, and memory optimization.

Course Number:

it_dfahop_23_enus

RAC Architecture

Overview/Description:

Oracle Real Application Clusters (Oracle RAC) provides for clustering and high availability in Oracle database environments. Explore RAC database architecture and an in-depth understanding of all the components and requirements of Oracle RAC.

Course Number:

it_odraad_03_enus

Updating & Patching Documents

Overview/Description:

RavenDB is a document-oriented database designed for storing, retrieving, and managing semi-structured data. Discover how to update and patch documents, object relationships, asynchronous operations, and bulk inserts.

Course Number:

it_dfrvdb_03_enus

Introduction to SQL Bootcamp: Session 3 Replay

Overview/Description:

This is a recorded Replay of the Introduction to SQL Live session that ran on April 29th at 11 AM ET. In this session Lucas Kelly discusses querying datasets, performing data manipulation using SQL commands, learning to implement join, and set operations.

Course Number:

it_lbcitsql_03_enus

Working with Joins

Overview/Description:

It’s important to minimize data redundancy in a relational database. Learn how to view information across multiple tables with joins and use advanced SELECT features to obtain values based on an unknown conditional value.

Course Number:

it_odinsq_10_enus

Auditing

Overview/Description:

Auditing is an essential administration task used to track and log database events to ensure the database is performing properly. Explore auditing, Azure SQL Database audit, and analyzing audit logs and reports from Azure SQL Database.

Course Number:

it_dfsqla_04_enus

Policy-based Management & Performance Monitoring

Overview/Description:

Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore Policy-Based Management and performance monitoring of SQL Server 2016 instances.

Course Number:

it_dfsqla_12_enus

System Management

Overview/Description:

Correctly managing a MongoDB allows for seamless storing and retrieval of data. Discover how to manage databases and collections, as well as use the GUI management tools.

Course Number:

it_dfmond_08_enus

Data Access & Permissions

Overview/Description:

To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. Explore data access and permissions, including database object permissions, users, and custom roles.

Course Number:

it_dfsqla_02_enus

Managing Database Integrity

Overview/Description:

Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. Explore database consistency checks and how to identify and recover from database corruption.

Course Number:

it_dfsqla_08_enus

MySQL: Understanding & Implementing Joins

Overview/Description:

This 10-video course explores how to use joins to combine data from different relations in meaningful ways. Learners will examine why joins are such a powerful and ubiquitous concept in data analysis. Begin by observing how SQL features several types of joins, and how these can be understood, and will examine each type of join in depth. You will examine the cross join, which is the simplest kind of join, and is also known as a Cartesian join. Then examine inner joins, which can be expressed as a combination of the cross join operator along with a filter. This course continues by examining the three types of outer joins, the left, the full, and the right outer join. You will explore natural joins, which could be an inner or an outer join where two additional conditions are satisfied. You will examine several features of the join keyword. Finally, this course demonstrates how to use MySQL platform to support several varieties of different joins types.

Course Number:

it_aplumgdj_04_enus

MongoDB with Python

Overview/Description:

MongoDB can be queried, manipulated, and managed with Python. Discover how to install the Python driver for MongoDB – PyMongo, use GridFS with Python, and use a Python REST interface.

Course Number:

it_dfmond_12_enus

Connectivity & Space Management

Overview/Description:

Optimizing how data is stored in Oracle Database 12c conserves space and improves system performance. Explore tablespaces and data files, and learn how to manage the space used by data blocks and segments.

Course Number:

it_oddbre_04_enus

Automatic Storage Management

Overview/Description:

Oracle Automatic Storage Management (ASM) is designed to simplify management of data, control, and log files. Explore Automatic Storage Management, and the Oracle Cloud File System.

Course Number:

it_odraad_02_enus

SQL Programming with MariaDB: Using Joins Triggers & Stored Procedures

Overview/Description:

Joins, triggers, and stored procedures are useful tools to take advantage of when working with MariaDB. In this course, you’ll begin by using several types of joins, such as cross joins, inner joins, and outer joins, to combine data from multiple tables.Next, you’ll use aggregate functions, such as SUM, MIN, MAX, AVERAGE, and COUNT, with the GROUP BY clause to group data in rows based on a specified column. You’ll then use the HAVING clause as a way to filter the output of the GROUP BY clause.You’ll move on to use the two types of generated columns – virtual and persistent, computing them on-the-fly from a function expression.Finally, you’ll use triggers to perform operations whenever a condition is satisfied and stored procedures for code re-use and parameterization.

Course Number:

it_dasqpmdj_03_enus

Replication & Security

Overview/Description:

It’s important that data in a MongoDB database is available to users at all times and that it’s secure. Discover how to configure replication and security for MongoDB.

Course Number:

it_dfmond_04_enus

Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)

Overview/Description:

Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.

Course Number:

it_dfosfd_01_enus

Maintaining SQL Performance

Overview/Description:

Database Replay can help with performance tuning by allowing you to capture a workload and replay it on a test system to see the effect of changes outside of the production database. Learn about Database Replay in Oracle Database 12c.

Course Number:

it_odpmte_11_enus

SSIS Components

Overview/Description:

SQL Server Integration Services (SSIS) can be installed during the SQL Server installation or as a separate component. Examine the various components of SSIS, as well as installation considerations, such as upgrade options and architecture.

Course Number:

it_mdidwm_13_enus

Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views 

Overview/Description:

Explore the basics of data dictionary views. Discover how to create views on tables. Synonyms, sequences, and indexes, and how to create them is also covered.

Course Number:

it_dfosfd_07_enus

Working with SET Operators

Overview/Description:

SET operators allow you to combine the results of two queries into one. Learn how to use SET operators and match SELECT statements in Oracle Database 12c.

Course Number:

it_odinsq_14_enus

Manipulating Data

Overview/Description:

Data Manipulation Language (DML) statements are used to manipulate the actual data in MySQL databases. Explore the syntax and use of the most common DML statements, including INSERT, UPDATE, and DELETE.

Course Number:

it_dfmydd_04_enus

Performing & Managing Backups

Overview/Description:

As an Oracle database administrator, it is vital that you perform regular backups of the databases. Learn how to perform and manage different types of backups, including incremental, full, block media recovery, and encrypted.

Course Number:

it_odbkpr_05_enus

Securing Azure SQL Databases

Overview/Description:

Determining how to secure databases in SQL Server 2016 is one of the most important parts of a deployment strategy. Discover how to implement firewalls, authentication, and auditing to ensure Azure SQL database security.

Course Number:

it_dfsqlp_08_enus

Grid Infrastructure

Overview/Description:

The Oracle Grid Infrastructure lays the foundation for highly available and scalable Oracle RAC systems. Explore the Oracle Grid Infrastructure, including Oracle Clusterware and Grid plug and play.

Course Number:

it_odraad_01_enus

Introduction to SQL Bootcamp: Session 4 Replay

Overview/Description:

This is a recorded Replay of the Introduction to SQL Live session that ran on April 30th at 11 AM ET. In this session Lucas Kelly discusses implementing SQL subqueries, working with views and indexes, as well as learning about stored procedures and SQL transactions.

Course Number:

it_lbcitsql_04_enus

Data Transformation & Flow

Overview/Description:

When working with data in a data warehouse, some level of transformation is usually required between the source and destination. Learn how to work with transformations and design data flow.

Course Number:

it_mdidwm_04_enus

Always Encrypted & Cell-level Encryption

Overview/Description:

Besides Transparent Data Encryption (TDE), there are other methods available for Azure SQL database encryption. Examine alternate encryption solutions, including Always Encrypted and cell-level encryption.

Course Number:

it_dfsqlp_11_enus

Architecture & Installation

Overview/Description:

Apache Cassandra is designed to meet a scaling challenge that traditional database management systems aren’t capable of handling. Explore the Cassandra architecture and how to install Cassandra.

Course Number:

it_dfcass_01_enus

Implementing & Testing Policy

Overview/Description:

When planning a SQL Server infrastructure, you must include the management of all instances of SQL Server. Discover how to implement policy-based management and how to manage SQL Server using System Center.

Course Number:

it_mdddsa_02_enus

Data Flow Implementation & ETL

Overview/Description:

Extract, transform, load (ETL), is the main process in data warehousing solutions and helps transfer data from one source to another. During this course you will examine the ETL process and how it can be implemented. You will start by examining data flows and how to debug them. Next, you will learn how to use SQL Server Integration Services (SSIS), and perform a broad range of data migration tasks. These include how to create SSIS packages, transform data, and perform lookup tasks. Next you will employ ETL, the SSIS data warehousing tool, to facilitate the transfer of data from a source to a destination. Discover how to implement the ETL process, to extract, transform, and load data. Specify a data source and a destination. Finally, you will performance tune SSIS data flow and optimize data Integration Services.

Course Number:

it_mdidwm_05_enus

Job Scheduling

Overview/Description:

Keep your database performing efficiently by increasing your knowledge of Oracle Database 12c performance tuning, including how to use the Oracle Scheduler to create and schedule jobs.

Course Number:

it_oddbre_14_enus

Java ASYNC Interface

Overview/Description:

The MongoDB Java Driver can be used to provide both synchronous and asynchronous interaction with MongoDB. Explore the Java Async Driver for making asynchronous connections in MongoDB.

Course Number:

it_dfmond_11_enus

Application Patterns

Overview/Description:

There are various types of application patterns available when migrating SQL Server-based applications to an Azure environment. Examine some of these patterns, including 1-Tier, 3-Tier, Presentation Tier, and Business Tier.

Course Number:

it_dfsqlp_19_enus

Auditing Features & Configuration

Overview/Description:

Monitoring database access is part of the process involved in securing an Oracle Database 12c system. Discover how to detect and resolve lock conflicts, and how to enable and manage auditing of database activity.

Course Number:

it_oddbre_07_enus

Map Reduce Atomic Counters & Binary Data

Overview/Description:

MongoDB has some very powerful features to allow you to query and manipulate data. Explore the use of MapReduce and Atomic Counters, as well as how to store binary data using BSON.

Course Number:

it_dfmond_05_enus

SQL Concepts & Queries

Overview/Description:

Master SQL concepts. Learning the core fundamentals creates a foundation. Discover relational databases and Structured Query Language (SQL) database concepts.

Course Number:

it_dfsqli_01_enus

SQL Selecting Ordering & Filtering

Overview/Description:

Manipulating databases is a necessary skill. Explore Structured Query Language (SQL) and dive into the architecture. Discover efficient and easily manageable databases using features like SELECT, data types, UPDATE, and ORDER BY.

Course Number:

it_dfsqli_03_enus

SSIS Packages

Overview/Description:

SSIS in SQL Server 2014 allows for dynamic packages, enabling values within the package to be manually set, depending on your requirements at execution time. Discover what’s involved in designing SSIS packages.

Course Number:

it_mdidwm_10_enus

SQL Transaction Locks

Overview/Description:

Master SQL transaction locks. Explore transaction locks and explore the different levels of locking.

Course Number:

it_dfsqli_10_enus

Instances & Storage Considerations

Overview/Description:

SQL Server uses instances to allow more than one copy of a SQL Server component to be installed on a single server. Explore SQL Server instances in IaaS and on-premises, and the various storage solutions in SQL Server 2016.

Course Number:

it_dfsqlp_07_enus

Sets & Predicate Logic

Overview/Description:

SQL Server 2016 delivers many new features and enhancements. Explore an overview of the SQL Server 2016 architecture, from topics such as sets and predicate logic.

Course Number:

it_dfsqlq_02_enus

Tuning Problem SQL Statements

Overview/Description:

SQL is at the heart of any relational database management system, and optimizing SQL typically provides the largest performance gains in real-world situations. Explore the Cost-Based Optimizer and optimizing data retrieval.

Course Number:

it_odpmte_08_enus

Using GROUP BY PIVOT & UNPIVOT

Overview/Description:

Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore the GROUP BY clause and how to change a table-valued expression into another table using the PIVOT and UNPIVOT operators.

Course Number:

it_dfsqlq_09_enus

Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions

Overview/Description:

Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.

Course Number:

it_dfosfd_04_enus

Cloud & Hadoop Deployments

Overview/Description:

One of MongoDB’s best strengths is its ability to scale. Examine cloud deployments of MongoDB using Cloud Manager and how MongoDB can integrate with Hadoop.

Course Number:

it_dfmond_09_enus

Recovery & Backup

Overview/Description:

BI administrators need to ensure that stored data is valid and available to the users. Discover how to design and implement strategies for data backup, recovery, and logging in a BI solution.

Course Number:

it_mddbis_16_enus

SQL Tuning

Overview/Description:

Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.

Course Number:

it_oddbre_12_enus

Data Manipulation Language

Overview/Description:

Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.

Course Number:

it_odinsq_12_enus

Performance Tuning Methodology

Overview/Description:

Broaden your knowledge of Oracle Database 12c performance tuning by examining a series of commonly occurring real-world performance problems and the typical solutions for those scenarios.

Course Number:

it_odpmte_16_enus

ADDM & ASH

Overview/Description:

The Automatic Database Diagnostic Monitor allows you to analyze AWR data for performance problems. Active Session History can assist in more granular problem solving situations. Learn about using these two tools in Oracle Database 12c.

Course Number:

it_odpmte_04_enus

Tuning Instance Memory

Overview/Description:

When performance tuning in Oracle Database 12c, it’s vital to include the System Global Area in your efforts. Explore SGA tuning, including using AWR reports, adaptive cursor sharing, and the SQL query result cache.

Course Number:

it_odpmte_12_enus

Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions   

Overview/Description:

Discover how to obtain summary information, such as averages, for groups of rows in SQL. Explore how to group rows in a table into smaller sets and how to specify search criteria for groups of rows.

Course Number:

it_dfosfd_13_enus

Undo Feature Overview

Overview/Description:

An Oracle Database 12c administrator will, at some point in time, need to roll back changes made to the database. Learn how this is done using the Undo feature in Oracle Database 12c.

Course Number:

it_oddbre_05_enus

SQL Diagnostics

Overview/Description:

Increase your performance tuning knowledge by learning the basic phases of SQL processing and ways to extract detailed information about the actual execution of a SQL statement in Oracle Database 12c.

Course Number:

it_odpmte_07_enus

SSIS Security

Overview/Description:

SSIS consists of several layers, including digital signatures and database roles, to provide a rich and flexible security environment. Examine techniques and recommendations on how to secure an SSIS deployment.

Course Number:

it_mdidwm_17_enus

Oracle Database 12c R2 SQL: Using Basic SELECT statements

Overview/Description:

Explore how to retrieve data using SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings. You will also learn how to deal with duplicate rows.

Course Number:

it_dfosfd_03_enus

Working with Data Conversions & SET Operations

Overview/Description:

You can use functions, expressions, and operators to perform operations on data in Teradata. Learn how to perform data conversions and computations, and use SET operators.

Course Number:

it_dftesq_06_enus

Configuring Flashback Technologies

Overview/Description:

The Oracle Flashback technologies let you view past states of database objects or return objects to a previous state. Examine various Flashback technologies, and how to configure and use them.

Course Number:

it_odbkpr_10_enus

Assessing Recovery Requirements

Overview/Description:

It is crucial that a database can be recovered in the event of a failure. Explore the different backup and recovery solutions available in Oracle Database 12c.

Course Number:

it_odbkpr_01_enus

RAC Administration Services & Multitenant Architecture

Overview/Description:

Multitenancy is the logical creation of multiple databases within one database to be used by different organizations or applications. RAC administration services and database consolidation and standardization with Multitenant Architecture.

Course Number:

it_odraad_17_enus

SQL Views

Overview/Description:

Discover SQL views. Explore SQL views in detail, defining various views and their management, from creating views to view types, updating, and dropping views.

Course Number:

it_dfsqli_08_enus

Automatic Workload Repository

Overview/Description:

The Automatic Workload Repository provides services to database components to collect, maintain, and use statistics for issue detection and self-tuning. Explore AWR in Oracle Database 12c, including administration and reporting.

Course Number:

it_odpmte_03_enus

Backup Management

Overview/Description:

A tested backup strategy is the most effective means of protecting your data from potential disaster. Explore SQL Server 2016 backup management practices, including backup strategies, media options, and retention and recovery models.

Course Number:

it_dfsqla_05_enus

Connecting to & Configuring a Database Instance

Overview/Description:

One key aspect of administering Oracle Database 12c includes managing client connections to database servers. Discover how to manage Oracle Net Services and server configurations.

Course Number:

it_oddbre_03_enus

Aggregating Data

Overview/Description:

Grouping data according to specific conditions allows you to create more effective reports and analyze data in more productive ways. Explore group functions, grouping data, and the clauses used for grouping in Oracle Database 12c.

Course Number:

it_odinsq_09_enus

RavenDB: Getting Started

Overview/Description:

RavenDB is the most popular NoSQL database for the .Net world. It’s open source, extremely fast, and very intuitive. Explore RavenDB.

Course Number:

it_dfrvdb_01_enus

Metrics & Monitoring

Overview/Description:

Metrics are used for system health monitoring, problem detection, and self tuning in Oracle Database 12c. Explore how to establish and manage performance baselines and work with real-time SQL monitoring.

Course Number:

it_odpmte_05_enus

Importing & Exporting Data

Overview/Description:

An Oracle database administrator is responsible for ensuring data is secure and available. Explore working with Oracle data, including data migration, the Oracle Data Pump, SQL*Loader files, and external tables.

Course Number:

it_oddbre_09_enus

MongoDB Aggregation

Overview/Description:

This Skillsoft Aspire course explores MongoDB, a cross-platform document-oriented database that has become a popular tool for data wrangling and data science. MongoDB is a NoSQL (not only structured query language) that uses Javascript Object Notation (JSON)- like documents with schemata. This course demonstrates reshaping, aggregating and summarizing documents in a MongoDB database, and gather, filter, modify, and query data, and to perform MongoDB actions related to data wrangling. Learners observe demonstrations of how to recognize the structure of aggregate operations in MongoDB; how to use the group operator to perform aggregate computations; and how to use limit and sort operators in an aggregations pipeline. Next, learn how to use the unwind operator to expand an array field in an aggregation, and how to use the Lookup operator to perform a joint operation between 2 collections in an aggregation, and how to use the index stats operator in an aggregation stage to view the statistics on the indexes. Finally, you will learn how to use a Geospatial Index for a geosearch operation.

Course Number:

it_dsmgswdj_02_enus

RAC Tuning

Overview/Description:

Ensuring that a database is performing at its optimum capacity is crucial for any database administrator. Explore key RAC monitoring and tuning techniques.

Course Number:

it_odraad_11_enus

Designing Control Flow

Overview/Description:

Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations. Examine how to design control flow elements in SSIS.

Course Number:

it_mdidwm_07_enus

The Redis In-memory Data Store: Data Structures

Overview/Description:

Redis offers a variety of data structures and collections which enable developers to deliver several types of high-performing applications to end-users. In this course, you’ll learn how to work with Redis’s different data structures, namely lists, hashes, and sets. You’ll then learn to perform various set operations, such as union, intersection, and set difference. Next, you’ll distinguish sorted sets from regular sets and learn how to work with them. You’ll then examine the benefits and limitations of HyperLogLog structures and how to use these in Redis. Upon completing this course, you’ll be able to compare and work with each of these structures and recognize their use cases.

Course Number:

it_jmwrdsdj_02_enus

Querying & Manipulating Data

Overview/Description:

SELECT statements in SQL Server 2016 are used to query tables and views and to manipulate data for customized results. Explore the fundamentals of using SELECT statements, including how to use aliases and case expressions.

Course Number:

it_dfsqlq_03_enus

T-SQL Queries

Overview/Description:

SQL Server 2016 delivers many new features and enhancements. Explore an overview of the SQL Server 2016 architecture through the fundamentals of T-SQL querying.

Course Number:

it_dfsqlq_01_enus

Windows Azure SQL Database

Overview/Description:

Meet Microsoft Windows Azure and Windows Azure SQL Database. Explore Windows Azure architecture, services, and storage, and examine Windows Azure SQL Database, including security and migration.

Course Number:

it_mdddsa_05_enus

WSFC Clustering

Overview/Description:

Windows Server Failover Clustering (WSFC) helps increase the availability of applications and services. Explore WSFC, including processes and cluster storage, and how to create a failover cluster.

Course Number:

it_mdddsa_07_enus

Troubleshooting Data Integration

Overview/Description:

SSIS includes tools and features that can be used to troubleshoot data integration. Learn how to debug and troubleshoot packages at the design and production level using techniques such as data viewers and break points.

Course Number:

it_mdidwm_15_enus

Working with Subqueries

Overview/Description:

It’s not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.

Course Number:

it_odinsq_11_enus

Using Aggregate Functions

Overview/Description:

Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore various types of aggregate functions such as SUM, MIN, MAX, AVG, and COUNT.

Course Number:

it_dfsqlq_08_enus

Relational Database Concepts

Overview/Description:

As an administrator or developer, it’s important to understand the object-relational aspects of Oracle Database 12c. Learn about data models, the Entity Relationship Model, and the Oracle HR sample schema.

Course Number:

it_odinsq_01_enus

Client Communication

Overview/Description:

As with any RDBMS the database needs to be secure and accessible. Teradata is no exception and requires workstation and mainframe access. Explore the workstation and mainframe attachment communication methods.

Course Number:

it_dftera_03_enus

Auditing Logging & Event Handling

Overview/Description:

SQL Server Integration Services (SSIS) and SQL Server Data Tools (SSDT) both offer tools and techniques to monitor and optimize SSIS solutions. Discover how to implement auditing, logging, and event handling in SSIS.

Course Number:

it_mdidwm_14_enus

Measuring SQL Performance

Overview/Description:

Once poorly performing SQL is identified and changes are proposed, you need to ensure that they will yield the desired effect. Discover how tools such as the SQL Performance Analyzer and SQL Tuning Advisor can be used to achieve this goal.

Course Number:

it_odpmte_10_enus

File & Piecemeal Restores

Overview/Description:

In the event of an unforeseen disaster, critical data should be protected and easily recoverable. Discover how to perform piecemeal and page restores, and restoring file groups.

Course Number:

it_dfsqla_07_enus

RAC Backup & Recovery

Overview/Description:

Oracle DBAs must ensure that the database is backed up and that it can be restored in the event of a failure. Explore RAC backup and recovery, including media recovery and failure protection, parallel recovery, and backup settings.

Course Number:

it_odraad_08_enus

Deployment & Scaling

Overview/Description:

RavenDB has combined the best of relational databases with that of document databases. Discover how to deploy and accomplish scaling, embed RavenDB, shard, and implement replication.

Course Number:

it_dfrvdb_05_enus

User Security Features & Configuration

Overview/Description:

Securing an Oracle Database 12c system involves controlling who can access the database and what they can do. Learn how to manage privileges, and use roles, profiles, quotas, and password security to make your databases secure.

Course Number:

it_oddbre_06_enus

Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries 

Overview/Description:

Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types, syntax, and guidelines for using subqueries in Oracle.

Course Number:

it_dfosfd_14_enus

Database Restoration

Overview/Description:

An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. Explore restoring SQL Server 2016 databases, including point-in-time recovery and automation for testing.

Course Number:

it_dfsqla_06_enus

Working with DDL

Overview/Description:

There’s a lot of flexibility available in how you create tables to store data in an Oracle 12c database. Learn about how to create tables, choose the proper data type for columns, set constraints, and change or delete existing tables.

Course Number:

it_odinsq_15_enus

The Redis In-memory Data Store: An Introduction to Redis

Overview/Description:

Redis is an in-memory, key-value store with many use cases. It is a popular tool among software developers for delivering improved performance to end-users due to its ease of use, rich feature set, and open source status. In this course, you’ll explore the various use cases, features, and limitations of the Redis in-memory store. You’ll examine the different data types, structures, and client connections supported in Redis. Next, you’ll learn how to install Redis and to set up an instance of the Redis server. You’ll then learn to carry out basic Redis operations involving string and numeric data, such as create, read, update, and delete (CRUD) operations and key expiration setting.

Course Number:

it_jmwrdsdj_01_enus

Database Mail & Alerts

Overview/Description:

Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore the creation and management of operators and SQL Server Agent alerts.

Course Number:

it_dfsqla_11_enus

Application Failover & Continuity

Overview/Description:

Managing connections to a database ensures that the most important business workloads get the highest priority in the database. Explore application failover and continuity in RAC database connections.

Course Number:

it_odraad_14_enus

Data Loading

Overview/Description:

SQL Server Integration Services (SSIS) is an extensible platform for creating data integration and workflow solutions. Explore various options available for loading data, including incremental, full, and bulk load.

Course Number:

it_mdidwm_11_enus

SQL Programming with MariaDB: Analyzing Relational Data

Overview/Description:

To query data with SQL, you need to know which queries and keywords to use for which operations. In this course, you’ll learn to query data using the classic SQL syntax construct, the SELECT-FROM-WHERE query, and how keywords, such as LIKE, can be used to filter data based on a condition and using wildcards. You’ll learn how to carry out different aspects of inserting, updating, and deleting data – such operations, along with querying, are collectively known as CRUD operations, an acronym for Create-Read-Update-Delete. Finally, you’ll learn how to take advantage of another important aspect of relational database usage – the ability to impose constraints upon data. You’ll work with UNIQUE, NOT NULL, and FOREIGN KEY constraints.

Course Number:

it_dasqpmdj_02_enus

Database Performance Settings

Overview/Description:

SQL Server 2016 offers various tools to tune a SQL Server environment for peak performance. Discover how to maximize database performance as well as the maximum amount of server memory.

Course Number:

it_dfsqlp_12_enus

MySQL: Getting Started

Overview/Description:

Explore how database systems allow data to be stored and updated in a robust manner, and queried conveniently by using SQL language, and learn how MySQL can be installed and used from different operating environments. Key concepts covered in this 11-video course include requirements that a database management system needs to satisfy and the importance that consistency of the data in a system always be maintained; how to install MySQL on different platforms; and how to connect to a MySQL server by using a command-line interface. You will learn how to create a database and view a list of databases on a MySQL server; learn how to install MySQL workbench and connect to a MySQL server; and learn model entities in a real-world scenario for use in a database system. Next, explore how to execute commands from the MySQL Workbench environment; learn perform basic database operations such as inserting and querying data; and learn how to view table metadata and delete data from tables.

Course Number:

it_aplumgdj_01_enus

Performing PITR

Overview/Description:

In Oracle Database 12c, Point-in-Time Recovery lets you recover one or more objects to an earlier time without affecting other objects within the database. Learn how to perform tablespace Point-in-Time recovery and table recovery.

Course Number:

it_odbkpr_13_enus

Multiple SQL Tables

Overview/Description:

Work with multiple tables. Mastering the fundamentals of SQL creates a foundation. Explore multi-table database architecture and design, connecting several tables, using inner/outer joins, and equijoins and non-equijoins.

Course Number:

it_dfsqli_06_enus

Backup & Recovery Strategies

Overview/Description:

From an individual to the largest organization, it is crucial that you always back up your data. Discover SQL Server 2014 backup strategies, how to perform a backup, and how to create and maintain a disaster recovery plan.

Course Number:

it_mdddsa_09_enus

SQL Developer

Overview/Description:

Oracle offers a free integration development environment, SQL Developer. Learn about SQL Developer, including creating connections, using SQL Worksheet, debugging, modeling data, and linking to external tools.

Course Number:

it_odinsq_02_enus

Failure & Recovery Concepts

Overview/Description:

The Data Recovery Advisor is an excellent tool to help protect data in your Oracle databases. Learn how to diagnose and repair failures using Data Recovery Advisor, and how various restores and recoveries are performed.

Course Number:

it_odbkpr_06_enus

Tuning RMAN

Overview/Description:

Because RMAN uses resources, you need to monitor and correct any performance issues that may occur. Learn to use the Oracle Database 12c tools for troubleshooting and tuning RMAN, and best practices for restore and recovery performance.

Course Number:

it_odbkpr_15_enus

MongoDB Querying

Overview/Description:

This course explores how to use MongoDB, a cross-platform document-oriented database that has become a popular tool for data wrangling and data science. MongoDB is a NoSQL (not only structured query language) that uses JSON (Javascript Object Notation) like documents with schemata. One advantage of MongoDB is the flexibility of how it stores data. You will learn how to perform MongoDB actions related to data wrangling by using Python with the PyMongo library. You will learn how to perform basic CRUD (create, read, update, delete) operations on a Mongo DB document. Next, learn how to use the find operation to select documents from a collection, and to use query operators to match document criteria. You will learn how to select documents using a specified criterion, similar to a WHERE clause in an SQL statement. Finally, this course demonstrates how to use the mongoimport tool to import from JSON or CSV, and mongoexport to export data from a MongoDB collection to JSON or CSV (comma separated values).

Course Number:

it_dsmgswdj_01_enus

Oracle Database Instance Overview

Overview/Description:

To work with Oracle database instances, you must understand the new multitenant architecture in Oracle Database 12c. Explore the memory, process, and storage architectures and how they work together.

Course Number:

it_oddbre_01_enus

Application Monitoring

Overview/Description:

Oracle Database 12C includes services that organize work execution within the database, and make execution that much more manageable, measurable, tunable, and recoverable. Learn about working with and scheduling these services.

Course Number:

it_odpmte_06_enus

Performance Migration & Compression

Overview/Description:

Better tune your Oracle 12c database by understanding index maintenance, extent management, database blocks, Automatic Segment Space Management, migration and chaining, and data compression.

Course Number:

it_odpmte_09_enus

Backups Monitoring & Stats

Overview/Description:

MongoDB tends to be heavily used in performance-critical and large-scale environments. This means monitoring and backup solutions are important. Discover how to monitor MongoDB stats, and work with backup and restore methods.

Course Number:

it_dfmond_10_enus

Architecture

Overview/Description:

Understanding the architecture of SQL Server 2016 is important to being able to effectively work with it. Explore the SQL Server architecture, including parallelism, I/O operations, account types, and network protocols.

Course Number:

it_dfsqlp_02_enus

Working with DML Optimization & Temporal Concepts

Overview/Description:

Teradata supports the use of SQLs data manipulation language (DML) to retrieve, insert, update, and delete data in a database. Explore DDL and DML operations in a database or temporal tables.

Course Number:

it_dftesq_08_enus

SQL Security Architecture

Overview/Description:

Mastering security is crucial. Explore one of the most important aspects of SQL security. Discover the lock system, levels of security access and management, privileges and rights, and the setup and installation of security architecture.

Course Number:

it_dfsqli_11_enus

SQL Tables

Overview/Description:

Master SQL tables. Take your first steps in learning about relational databases and Structured Query Language (SQL) tables. Discover how to manage tables, and queries, including complex tables, changing tables, and deleting tables.

Course Number:

it_dfsqli_02_enus

Java REST & GridFS

Overview/Description:

MongoDB includes a number of features to query and manipulate data. Discover how to use persistence, Java REST API, and GridFS in MongoDB.

Course Number:

it_dfmond_06_enus

Relational Database Management System (RDBMS)

Overview/Description:

Teradata offers a high quality system using a parallel database architecture providing a "share nothing" architecture. Explore a relational database system and the hardware and software used by Teradata for the database architecture.

Course Number:

it_dftera_02_enus

Recovery After Loss

Overview/Description:

In some cases, an Oracle database will lose files when a failure occurs. Discover how to recover from the loss of control, password, and redo log files, and how to restore a database to a new host and perform disaster recovery.

Course Number:

it_odbkpr_08_enus

Resource Management

Overview/Description:

Ensure efficient database performance by taking advantage of tuning tools available in Oracle Database 12c. Discover how to manage resources to optimize performance, including working with Resource Manager and monitoring statistics.

Course Number:

it_oddbre_13_enus

Database Programmability Objects & Non-relational Data

Overview/Description:

SQL Server 2016 offers various database programmable objects, such as stored procedures and functions. Discover how to implement database programmability objects and how to work with temporal and non-relational data in SQL Server 2016.

Course Number:

it_dfsqlq_12_enus

Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output   

Overview/Description:

Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.

Course Number:

it_dfosfd_12_enus

SQL Transactions

Overview/Description:

Master SQL transactions. Explore transactions and how to group statements, Transact-SQL, and transaction logs.

Course Number:

it_dfsqli_09_enus

Restricting Output

Overview/Description:

Database tables often hold a large number of rows, which aren’t necessarily sorted. Learn how to selectively return only a subset of rows, sorted and customized, using operators, conditions, wildcards, and clauses.

Course Number:

it_odinsq_05_enus

Database Maintenance

Overview/Description:

Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. Learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c.

Course Number:

it_oddbre_10_enus

Index & Statistical Management

Overview/Description:

By carefully managing aspects of your database, you can better tune performance and identify potential issues. Explore index management tasks, such as identifying and repairing fragmentation, and identifying and creating missing indexes.

Course Number:

it_dfsqla_13_enus

Migrating to Azure SQL Databases

Overview/Description:

Migrating a database to Azure SQL Database primarily involves three steps: preparing, exporting, and importing. Explore the requirements and processes involved in migrating data to Azure SQL Databases.

Course Number:

it_dfsqlp_15_enus

CouchDB cURL & Futon

Overview/Description:

CouchDB database management systems provides a lot of flexibility for storing and accessing your data. Learn about using CouchDB with NoSQL, including how to work with the API, using and installing cURL, and using Futon.

Course Number:

it_dfnsql_06_enus

Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language

Overview/Description:

Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.

Course Number:

it_dfosfd_02_enus

Recovery Implementation

Overview/Description:

Should something go wrong, you can always use your SQL Server backup to recover your data. Explore the SQL Server 2014 recovery process, including restoring from Azure and Azure SQL Database.

Course Number:

it_mdddsa_10_enus

Performance Tuning & Availability Sets

Overview/Description:

Moving Microsoft SQL Server applications to Azure virtual machines can help optimize overall performance. Discover various methods used for performance tuning and configuring availability sets for redundancy.

Course Number:

it_dfsqlp_17_enus

Using Flashback Technologies

Overview/Description:

The Oracle Flashback technologies let you view past states of database objects or return objects to a previous state. Discover how to use Flashback Data Archive and Flashback Database as part of your backup and recovery strategy.

Course Number:

it_odbkpr_11_enus

Advanced SQL Queries

Overview/Description:

Master advanced queries. Queries in SQL allow you to manipulate databases like a pro. Discover advanced techniques including subqueries, correlated queries, difficult queries, and learn query tips for better efficiency.

Course Number:

it_dfsqli_07_enus

Implementing Control Flow

Overview/Description:

By using the control flow data flow task, data flow can be implemented into the SSIS package specifying the data source, data transformation, and data destination. Discover how to implement control flow elements.

Course Number:

it_mdidwm_08_enus

High Availability

Overview/Description:

Windows Azure lets you configure and manage a dedicated VM to run an instance of SQL Server. Discover VMs on Windows Azure; how to install, configure and manage SQL Sever on a VM; and high availability options in SQL Server 2014.

Course Number:

it_mdddsa_06_enus

Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries

Overview/Description:

Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.

Course Number:

it_dfosfd_17_enus

Installation & Configuration

Overview/Description:

It’s important to understand the numerous recommended pre- and post-installation best practices set forth by Microsoft to ensure a successful deployment. Explore deployment options, including post-installation best practices.

Course Number:

it_dfsqlp_03_enus

RAC Global Resource Management

Overview/Description:

Global Enqueue Management is essential in diagnosing performance problems, preventing outages, and tuning the database for optimum performance. Explore concepts related to Global Enqueue Management.

Course Number:

it_odraad_10_enus

RAC Administration

Overview/Description:

Enterprise Manager Cloud Control is a valuable tool in the day-to-day administration tasks of an Oracle RAC database. Explore Enterprise Manager and command-line utilities to manage an Oracle RAC database.

Course Number:

it_odraad_06_enus

Introduction to Performance Tuning

Overview/Description:

There are many methodologies for troubleshooting performance problems in Oracle Database 12c. Learn about performance management techniques, including tuning goals and objectives, and working with waits, events, classes, and statistics.

Course Number:

it_odpmte_01_enus

Quality of Service

Overview/Description:

Quality of Service management is a component of Oracle RAC that ensures that the most critical business workloads are prioritized for database resources. Explore QoS management, policy sets, server pools, and more.

Course Number:

it_odraad_15_enus

Recovery & Availability

Overview/Description:

When an Oracle database fails, a restore or recovery operation will be needed. Examine how to perform different types of restore operations, including when the database is in ARCHIVELOG or NOARCHIVELOG mode.

Course Number:

it_odbkpr_07_enus

Backing Up & Recovering Data

Overview/Description:

A key responsibility of an Oracle database administrator is protecting databases from failure. Learn how to back up and recover databases, how to migrate and load data, and how to work with external tables in Oracle Database 12c.

Course Number:

it_oddbre_08_enus

Private Cloud Overview

Overview/Description:

SQL Server 2014 has a number of enhancements and features aimed at private cloud deployment and management of SQL databases. Explore SQL Server consolidation and management of consolidated resources.

Course Number:

it_mdddsa_03_enus

User Management

Overview/Description:

Managing MongoDB is more than just storing and retrieving data. Explore the operational requirements and user management tasks that must be handled to manage MongoDB users.

Course Number:

it_dfmond_07_enus

Distributed Systems & Big Data

Overview/Description:

NoSQL databases are increasingly used in real-time web applications and big data. Learn about distributed systems, issues, and models, as well as consistent hashing, big data, and analytics.

Course Number:

it_dfnsql_02_enus

SELECT Statement Expressions & Operators

Overview/Description:

SQL*Plus provides a convenient way to work with Oracle data. Learn to retrieve data using SELECT statements with arithmetic expressions, NULL values, column aliases, and literal strings. In addition, learn how to handle duplicate rows.

Course Number:

it_odinsq_04_enus

Data Security & Azure SQL Database Options

Overview/Description:

To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. Explore user options for Azure SQL Database, row-level security, and dynamic data masking.

Course Number:

it_dfsqla_03_enus

MySQL: Querying Data

Overview/Description:

Explore how MySQL continue to play an important role in complementing both data warehouses and programming language based frameworks, in this 10-video course. Learners will observe how MySQL tables can be queried by using classic SQL syntax and how common types of queries tie closely to common patterns in table design. Key concepts covered here include how to write queries to explore entity and relationship data, including foreign keys; how to translate entity-relationship models into actual database table schemas; and learning about correct data types and constraints for specific columns in a table schema. You will learn how to use relational and logical operators in WHERE clause of MySQL queries; how to use LIKE and IN operators, as well as pattern matching with wildcards in queries; and how to use subqueries to perform complex logical operations. Next, learn to implement referential integrity checks by using foreign key constraints. Finally, you will learn how to perform filtering operations on date columns; and how to use LIMIT and ORDER BY clauses in MySQL queries.

Course Number:

it_aplumgdj_03_enus

Performance Tuning Summary

Overview/Description:

To fully tune your database, you need a solid understanding of manipulating SGA components and Automatic Memory Management Maintenance. Learn about these Oracle Database 12c concepts.

Course Number:

it_odpmte_15_enus

Oracle Database 12c R2 SQL: SQL*Plus

Overview/Description:

SQL*Plus is an interactive and batch query tool that is installed with every Oracle server and client installation. This course will teach you the features and functionality of SQL*Plus.

Course Number:

it_dfosfd_10_enus

Performing Subqueries & Correlated Subqueries

Overview/Description:

A subquery is simply a query contained within another query. Discover how to use ANSI SQL and Teradata extensions to perform subqueries and correlated subqueries in Teradata.

Course Number:

it_dftesq_04_enus

High Availability

Overview/Description:

High availability is a critical requirement of Oracle RAC. Explore the configuration of client and server components to ensure high availability in RAC database connections.

Course Number:

it_odraad_13_enus

Clustering & AlwaysOn

Overview/Description:

SQL Server AlwaysOn Availability Groups are built on WSFC clusters and AlwaysOn Failover Cluster Instances (FCI). Discover how to create, configure, and manage SQL Server AlwaysOn FCIs and AlwaysOn Availability Groups.

Course Number:

it_mdddsa_08_enus

Planning Infrastructure

Overview/Description:

A SQL Server infrastructure must be planned from the hardware up. Discover how to plan both the physical and logical database structures using the Microsoft Planning and Assessment Toolkit.

Course Number:

it_mdddsa_01_enus

Locking & Data Protection

Overview/Description:

To control concurrency, Teradata uses different locking mechanisms. Discover the different locking mechanisms and performance availability features, such as RAID, failover, cliques, and hot standby.

Course Number:

it_dftera_08_enus

Implementing Performance Tuning

Overview/Description:

Oracle Enterprise Manager gives you a central area for managing Oracle tools. Learn about OEM architecture and pages, as well as using alerts in tuning, user trace files, common tuning problems, and service requests.

Course Number:

it_odpmte_02_enus

Upgrading to SQL Server 2016

Overview/Description:

When performing a SQL Server 2016 upgrade, it’s important to understand numerous recommended pre- and post-installation best practices. Examine upgrade options, such as in-place and side-by-side upgrades.

Course Number:

it_dfsqlp_04_enus

MySQL 8.0: Introduction

Overview/Description:

MySQL is fast, reliable, easy to use, free to download, and supports standard SQL. Discover how to download and configure MySQL, how to use the MySQL Workbench, and learn abow MySQL connection navigator, status and system vatiables, new user creations, and users and privileges management.

Course Number:

it_dfmydd_01_enus

Database Design Fundamentals

Overview/Description:

A database is only as good as its initial design. Explores RDBMS design fundamentals, such as table design, normalization, and relationships. Full Stack Development and how MySQL fits into the FDS landscape is also covered.

Course Number:

it_dfmydd_02_enus

Table Design: Tables Columns & Numbers

Overview/Description:

Fundamentals create foundation. Get a clear picture of what SQL is all about. Discover table functions including ALTER and CREATE, as well as column functions and math operators.

Course Number:

it_dfsqli_04_enus

Encryption

Overview/Description:

Ensuring data security is an important part of administering any database infrastructure, and encryption is one method to help you protect sensitive data. Explore encryption-related tools and processes used in SQL Server 2016.

Course Number:

it_dfsqla_01_enus

Oracle Database 12c R2 SQL: Data Definition Language (DDL)

Overview/Description:

Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.

Course Number:

it_dfosfd_09_enus

RAC Configuration

Overview/Description:

Installing, upgrading, and patching are essential tasks for any DBA, ensuring outages due to software problems are kept to a minimum. Explore implementation and maintenance of Oracle RAC software in a production environment.

Course Number:

it_odraad_04_enus

Backup & Recovery Options

Overview/Description:

What makes Oracle Database 12c tick? Explore the Oracle Database Server architecture, process architecture, grid infrastructure, and DBA tools.

Course Number:

it_odbkpr_02_enus

Performance Tuning

Overview/Description:

Performance tuning is an important aspect of Oracle Database 12c administration. Learn how to monitor and tune both database and memory performance in Oracle Database 12c.

Course Number:

it_oddbre_11_enus

Working with Clauses Operators Expressions & Aggregates

Overview/Description:

Learn how to work with clauses, operators, expressions, and aggregates in Teradata using ANSI SQL and Teradata extensions.

Course Number:

it_dftesq_02_enus

Working with Substitution

Overview/Description:

Learn how to build dynamic queries in Oracle Database 12c using substitution variables and the DEFINE and VERIFY commands.

Course Number:

it_odinsq_06_enus

MongoDB with Spark

Overview/Description:

MongoDB is a powerful NoSQL database that can use Spark to perform real-time analytics on its data. Examine how to integrate and use MongoDB and Spark together using Java and Python.

Course Number:

it_dfmond_13_enus

Oracle Database 12c R2 SQL: Controlling User Access

Overview/Description:

Discover how to control database access to specific objects and add new users with different levels of access privileges.

Course Number:

it_dfosfd_16_enus

MySQL: Triggers & Stored Procedures

Overview/Description:

Learners can explore how triggers can be used to react to specific conditions in your database, and how stored procedures can be used to achieve code reuse and code composition of SQL commands, in this 12-video course. You will examine how triggers, which are described as actions or groups of logic, and special stored procedures, that are executed by the MySQL database when certain specific events occur. This course demonstrates how to use several types of triggers, and the use of foreign keys. You will learn how to use the ON DELETE and ON UPDATE cascade functionality. Then learn how to create stored procedures, which are bits of SQL code, queries, or other operations, which can be saved, given a name, and then invoked at will. Observe how to invoke stored procedures, to redefine stored procedures, and then examine advance and intricate stored procedures. Finally, this course demonstrates how to construct an elaborate stored procedure.

Course Number:

it_aplumgdj_07_enus

Oracle Database 12c R2 SQL: Creating Other Schema Objects

Overview/Description:

Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.

Course Number:

it_dfosfd_15_enus

Programming Essentials

Overview/Description:

NoSQL databases are attractive to developers due to their simplicity of design and finer control over availability. Learn about how to install CouchDB, as well as MapReduce, RESTFul, and some basic programming using Java and JavaScript.

Course Number:

it_dfnsql_05_enus

Data Conversion

Overview/Description:

Frequently when retrieving data stored in an Oracle database it needs to be converted, manipulated, or aggregated. Learn about the Oracle conversion functions and conditional expressions.

Course Number:

it_odinsq_08_enus

Clustering & Admin Tools

Overview/Description:

Apache Cassandra is designed to meet a scaling challenge that traditional database management systems aren’t capable of handling. Discover clustering and admin tools and how to install, manage, and access data programmatically.

Course Number:

it_dfcass_02_enus

MySQL: Grouping & Aggregation Operations

Overview/Description:

Learners can explore how to use grouping and aggregation operators to analyze groups of rows rather than just individual rows, in this 8-video course. In it you will learn how to perform filtering operations on groups of rows. Then examine the GROUP BY clause, one of the most important syntactic constructs in SQL. You will learn how to use the GROUP BY clause to analyze groups of rows aggregated by common attribute values. Next, learn about aggregate functions such as SUM, COUNT, MIN, and MAX, and how they are used with GROUP BY clauses. You will learn how subqueries can be leveraged by using the ANY, SOME, and ALL keywords. You will learn how to implement multi-way joins in MySQL, and how the HAVING clause adds to the effectiveness of the GROUP BY construct by allowing groups of rows to be filtered based on specific conditions. Finally, this course explains the differences between the WHERE clause and the HAVING clause, which applies conditional filters to groups of rows rather than to individual rows.

Course Number:

it_aplumgdj_05_enus

Oracle Database 12c R2 SQL: Restricting & Sorting Data

Overview/Description:

Database tables hold a large number of rows, which are often not sorted in any specific order. Learn how to selectively return only a subset of rows, sorted and customized.

Course Number:

it_dfosfd_11_enus

Duplicating Databases

Overview/Description:

There may be times when you want to duplicate a database, such as for recovery or testing purposes. Examine various methods for duplicating a database in Oracle Database 12c, including using RMAN.

Course Number:

it_odbkpr_14_enus

Designing & Implementing Dimensions

Overview/Description:

A data warehouse combines data from multiple sources that can be used to create analytical reports. Explore schemas and tables that are created within it, and how to create dimension and fact tables.

Course Number:

it_mdidwm_01_enus

Data Retrieval

Overview/Description:

Make your data work for you. Learn to ensure data integrity using constraints and analyze data using the SELECT command and WHERE, GROUP BY, DISTINCT, and ORDER BY clauses. And explore how to speed up searches using indexes and views.

Course Number:

it_dfpost_03_enus

Virtual Machines & Benchmark Data

Overview/Description:

Microsoft SQL Server applications can be moved to Azure virtual machines to help reduce costs and to optimize overall performance. Explore the various methods used to migrate applications as well as gathering benchmark data.

Course Number:

it_dfsqlp_16_enus

Dynamic Data Masking

Overview/Description:

Part of your deployment strategy should be to secure not only the databases but also the data itself. Examine dynamic data masking, a feature in SQL Server 2016 that can be used to limit exposure to sensitive data.

Course Number:

it_dfsqlp_09_enus

Performing Joins

Overview/Description:

Introduce yourself to joins in Teradata! Discover how to use ANSI SQL and Teradata extensions to perform a number of different joins, including inner, outer, self, and cross joins.

Course Number:

it_dftesq_03_enus

Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables

Overview/Description:

Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.

Course Number:

it_dfosfd_05_enus

Models & Data Stores

Overview/Description:

Increase your NoSQL knowledge by learning about the various replication models, key-value data stores and permutations, and working with document, column, graph, object, and XML data stores.

Course Number:

it_dfnsql_04_enus

SSIS Package Execution & Script Tasks

Overview/Description:

Microsoft SQL Server Integration Services (SSIS) is a platform that can be used to build packages for data warehousing. Discover how to create simple SSIS packages and use script tasks.

Course Number:

it_mdidwm_06_enus

Backup Strategies

Overview/Description:

You can backup, restore and recover Oracle databases using the Oracle Recover Manager (RMAN). Explore backup requirements and different strategies that you can employ.

Course Number:

it_odbkpr_04_enus

Querying with Joins

Overview/Description:

SELECT statements in SQL Server 2016 are used to query tables and views and to manipulate data for customized results. Explore the fundamentals of querying multiple tables using joins.

Course Number:

it_dfsqlq_04_enus

DDL Statements

Overview/Description:

Data Definition Language (DDL) statements are used to manipulate MySQL database schema objects. Examine the use of the CREATE, ALTER, and DROP statements to create, modify, and maintain MySQL databases, tables, and views.

Course Number:

it_dfmydd_03_enus

SSIS Solutions

Overview/Description:

SSIS consists of several layers, including package properties and centralized management, to provide a rich and flexible environment. Explore SSIS catalog creation, package deployment, and package validation.

Course Number:

it_mdidwm_16_enus

Creating Documents

Overview/Description:

RavenDB is a document-based database designed for storing, retrieving, and managing semi-structured data. Discover how to create, manage, read, and query documents.

Course Number:

it_dfrvdb_02_enus

Security & Administration

Overview/Description:

Managing data and users are important tasks for a database administrator. Learn about administrative tasks like securing objects, managing groups, as well as command line management options, scripting, and reporting.

Course Number:

it_dfpost_04_enus

Log Shipping & High Availability

Overview/Description:

Data is an important enterprise asset and must be protected, retrievable, and highly available. Examine high availability and disaster recovery in SQL Server 2016, including log shipping, shared disks, and cluster shared volumes.

Course Number:

it_dfsqla_14_enus

Installing MongoDB

Overview/Description:

MongoDB is an open-source documentation database that can be installed on various operating systems with minimum requirements. Explore MongoDB, and discover how to install it on Linux and Windows.

Course Number:

it_dfmond_01_enus

Working with Functions

Overview/Description:

Funtions in MySQL are used to produce values from other values, or to determine values that may be unknown. Explore the syntax and use of the most common MySQL functions, including aggregate, date/time and string functions.

Course Number:

it_dfmydd_06_enus

Transparent Data Encryption

Overview/Description:

Transparent Data Encryption (TDE) performs real-time I/O encryption of data and can be used to secure SQL servers and Azure SQL databases. Discover TDE commands, functions, and considerations.

Course Number:

it_dfsqlp_10_enus

Big Data Solutions Architecture CQL & DDL

Overview/Description:

Apache Cassandra is an open-source NoSQL database management system for handling large amounts of data. Explore the mechanics and architecture of Cassandra, data modeling, and the Cassandra Query Language (CQL).

Course Number:

it_dfcasd_01_enus

SQL Memory Usage Tuning

Overview/Description:

The SGA is a key component to the effective working of the Oracle database engine. Explore SQL memory usage, the PGA and its role in sort operations, and temporary tablespaces.

Course Number:

it_odpmte_14_enus

Customizing Output

Overview/Description:

In Oracle Database 12c, you have the ability to use functions to return and analyze data in a large variety of ways. Learn about character, case-conversion, numeric, nesting, date, and numeric functions.

Course Number:

it_odinsq_07_enus

Introduction to SQL Bootcamp: Session 1 Replay

Overview/Description:

This is a recorded Replay of the Introduction to SQL Live session that ran on April 27th at 11 AM ET. In this session Lucas Kelly discusses SQL and its uses, explains entity relationship diagrams and schemas, establishes a database connection, creates a database, and describes data types and their constraints.

Course Number:

it_lbcitsql_01_enus

Secure Backup

Overview/Description:

To help recover from a failure, you can use Oracle Secure Backup with Recover Manager (RMAN). Learn about Oracle Secure Backup, and how to install and configure it for use with RMAN to perform backups and restores.

Course Number:

it_odbkpr_09_enus

Recovery Configuration

Overview/Description:

The Oracle Recover Manager (RMAN) lets you backup, restore and recover Oracle databases. Learn how to configure Recovery Manager (RMAN), and how to create a recovery catalog for managing database backup, restore, and recovery processes.

Course Number:

it_odbkpr_03_enus

Configuring Operators & Alerts

Overview/Description:

Keeping a SQL Server environment running its best involves constant monitoring of activity. Discover how to configure operators and alerts in SQL Server 2016 to help you maintain peak performance.

Course Number:

it_dfsqlp_13_enus

Virtual Machines on Azure

Overview/Description:

Azure virtual machines provide a way to move on-premise SQL Server workloads and applications to the cloud. Discover the recommended usage scenarios for Azure VMs as well as how to provision, create, and connect to Azure SQL Databases.

Course Number:

it_dfsqlp_05_enus

Operators & Expressions

Overview/Description:

Set operators in SQL Server 2016 are used to compare rows between input sets. Explore the UNION, INTERSECT, and EXCEPT set operators, the APPLY operator, and the basic components of common table expressions.

Course Number:

it_dfsqlq_11_enus

The Redis In-memory Data Store: Administering a Redis Server

Overview/Description:

Once a Redis server is in place, there are several essential tasks involved in managing it. In this course, you’ll explore how to carry out some of these critical tasks, namely assigning user permissions, establishing replacement servers, and setting cache replacement policies.
You’ll start by learning how to use ACL commands to set user permissions for new users and continue to assign permissions using ACL categories. Next, you’ll learn how to duplicate a copy of a Redis server, before setting up a replica of your server and establishing a master-slave relationship between the server and its replica. Finally, you’ll learn how to set up a Redis server to function as a cache by applying the least-recently-used (LRU) or least-frequently-used (LFU) cache replacement policies.

Course Number:

it_jmwrdsdj_05_enus

Oracle Database 12c R2 SQL: Managing Schema Objects    

Overview/Description:

Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.

Course Number:

it_dfosfd_08_enus

Filtering Data

Overview/Description:

SQL Server 2016 offers various clauses that work in conjunction with SELECT statements. Discover how to sort and filter data, use predicates and operators, and use NULL in queries.

Course Number:

it_dfsqlq_05_enus

Cluster Performance Tuning

Overview/Description:

Hadoop can scale up from single servers to thousands of machines, each offering local computation and storage. Examine tune up options, best practices for performance tuning, HDFS, YARN and MapReduce.

Course Number:

it_dfahop_24_enus

Data Quality Projects

Overview/Description:

When creating a data warehouse, data quality should be one of your top priorities. In order to trust the results of data analysis, high-quality data is essential. Explore various strategies for creating data quality projects.

Course Number:

it_mdidwm_19_enus

Communication & Database Security

Overview/Description:

As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover workstation and mainframe attachment communication methods and how to configure users, profiles, and roles.

Course Number:

it_dftera_04_enus

GIS Cloud & Connectors

Overview/Description:

GIS data types, cloud integration, and low level access for database performance give MySQL the power necessary to handle many data storage tasks. Explore these features in MySQL.

Course Number:

it_dfmydd_09_enus

Private Cloud Planning & Implementation

Overview/Description:

SQL Server 2014 includes features for private cloud deployment and management of SQL databases. Explore cloud computing, configuring SQL in a private cloud configuration, and working with prepared instances of SQL Server.

Course Number:

it_mdddsa_04_enus

Introduction to SQL Bootcamp: Session 2 Replay

Overview/Description:

This is a recorded Replay of the Introduction to SQL Live session that ran on April 28th at 11 AM ET. In this session Lucas Kelly discusses SQL DDL commands as well as querying and filtering data.

Course Number:

it_lbcitsql_02_enus

Data Manipulation Queries Collections & Indexing

Overview/Description:

Big data is the analysis of massive amounts of data, finding relationships that might not otherwise be apparent. Explore data manipulation, queries, collections, and indexing using Cassandra in a distributed framework.

Course Number:

it_dfcasd_02_enus

MySQL: Transactions Savepoints & Locks

Overview/Description:

This 14-video course explores how to execute groups of commands in an all-or-nothing fashion. Learners will examine how locks are used to regulate table access when multiple clients are accessing the database simultaneously. First, you will explore the ACID properties (atomicity, consistency, isolation, and durability) of database management systems. Next, you will learn how transactions, a unit of work which needs to be executed in an all or nothing fashion, work in MySQL. Next, learners you will examine the start transaction keyword, how transactions are defined as committed or rolled back. You will examine implicit commits, operations which create, alter, or drop database entities, such as databases or tables, and how these operations are affected by transaction commits and rollbacks. Learners will observe DDL (data definition language) operations in MySQL. Continue by exploring savepoints, specific checkpoints where the copy of a system state is created, and release savepoints when they are no longer needed. Finally, the course examines the precise semantics of read and write locks in MySQL.

Course Number:

it_aplumgdj_08_enus

RAC Initialization Parameters

Overview/Description:

Initialization parameter files provide parameters to the Oracle database instance on how it must start. Explore RAC-specific initialization parameters.

Course Number:

it_odraad_07_enus

Working with Data Definition Language (DDL)

Overview/Description:

Teradata supports the use of SQLs data definition language (DDL) to create, modify, and remove objects in a database. Work with DDL to create and alter databases, tables, indexes, triggers, and more.

Course Number:

it_dftesq_07_enus

Introducing SELECT Statement Queries

Overview/Description:

Teradata supports the use of ANSI SQL to query data housed in a database system, and with ANSI SQL, it supports Teradata extensions. Discover how to use the SELECT statement to perform queries.

Course Number:

it_dftesq_01_enus

Primary & Partitioned Indexes

Overview/Description:

Teradata databases use indexes to store and access rows of data from tables. Discover how to create the various primary and partitioned indexes used by Teradata.

Course Number:

it_dftera_06_enus

Connection Managers & Data Sources

Overview/Description:

Connection managers in a data warehouse are used to define the data source connections. Discover how to use connection managers to specify source and destinations, as well as how to create custom data sources.

Course Number:

it_mdidwm_03_enus

The Redis In-memory Data Store: Working With Redis Clients

Overview/Description:

Once the primary functions of Redis are implemented, several advanced features can optimize processes further and enable you to work with Python apps. In this course, you’ll explore some of these advanced features and how they apply to pipelines, transactions, and locks. You’ll learn how to work with these features using both the Redis CLI and Python clients. You’ll start by learning how to use both Pub/Sub and pipelines in a Python app with a Redis client. You’ll then learn how to define and execute transactions in Redis and use the watch feature.
You’ll move on to learn how to apply optimizations using features and techniques, such as the pipe mode feature and server-assisted client-side caching. Finally, you’ll learn how to use Redis keys and locks to synchronize access to shared Redis resources.

Course Number:

it_jmwrdsdj_04_enus

Data Quality Services (DQS) & Master Data Services (MDS)

Overview/Description:

DQS can help identify duplicate or invalid data entries while automatically correcting them. MDS enables data validation and rules to ensure consistency in your data. Discover how to install and use both of these technologies.

Course Number:

it_mdidwm_18_enus

Using Functions

Overview/Description:

SQL Server 2016 offers built-in functions that provide data type conversion, comparison, and NULL handling. Explore the various types of built-in functions and how to write queries using built-in functions.

Course Number:

it_dfsqlq_07_enus

Query & Performance Optimization

Overview/Description:

Indexing and understanding the configuration of MySQL can be key to performance. Explore index types and configuration options that can be set to fine-tune the performance of your MySQL databases to optimal levels

Course Number:

it_dfmydd_08_enus

Monitoring Database Activity

Overview/Description:

An enterprise database infrastructure has a lot of moving pieces, and it’s crucial that they be monitored. Explore managing and monitoring SQL Server database activity, including data collector and creating a utility control point.

Course Number:

it_dfsqla_09_enus

Models & Applications

Overview/Description:

NoSQL databases offer a data retrieval and storage alternative to RDBMS. Explore the different NoSQL data models, including Cassandra, MongoDB, and Riak. In addition, learn about polyglot persistence and JSON.

Course Number:

it_dfnsql_03_enus

Authentication & Security

Overview/Description:

As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover how to configure security, including logging on, views, macros, and UDFs.

Course Number:

it_dftera_05_enus

Secondary & Join Indexes

Overview/Description:

Teradata offers various types of indexes which can be used based on the type of data and how it is accessed by the users. Discover how to create the secondary and join indexes used by Teradata.

Course Number:

it_dftera_07_enus

RAC Recovery Manager

Overview/Description:

Oracle Recovery Manager (RMAN) lets you efficiently backup and recover an Oracle database. Explore RMAN to back up and restore a RAC database, archived redo log files in a RAC environment, and archiving schemes.

Course Number:

it_odraad_09_enus

MySQL: Creating & Updating Tables

Overview/Description:

In this 10-video course, learners can explore how tables in MySQL can be created to match entities and relationships as modeled in an E-R diagram and how MySQL allows the specification of different types of columns and column constraints. Key concepts covered in this course include attributes of keys, super keys, and candidate keys; learning how to model relationships in a real-world scenario for use in a database system; and learning how to specify non-null constraints while creating tables. You will learn how to run simple queries by using wildcards and where clauses; learn about the need for SQL and its important characteristics, SQL-based technologies also known as relational databases; and learn how to designate columns as unique while creating tables. Continue by learning how to perform update operations on data updating the structure of tables as well as the data contained within them in a MySQL relation; and learning how to perform DDL operations, including altering tables to add primary key constraints and dropping tables and databases.

Course Number:

it_aplumgdj_02_enus

SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis

Overview/Description:

MariaDB is a popular tool for SQL programming. To use it, you must first know how to install it on your machine and set it up for your needs. In this course, you’ll learn how to install MariaDB for macOS and MS Windows. You’ll then run MariaDB from a command line interface (CLI) and create a new custom user for MariaDB from the CLI -an essential step for running MariaDB from a client such as DBeaver, as connecting as root is not considered a best practice. Next, you’ll work with DBeaver and recognize how it is a handy user interface to interact with a MariaDB server. Finally, you’ll run a few basic MariaDB commands and queries from DBeaver.

Course Number:

it_dasqpmdj_01_enus

Script Components

Overview/Description:

SQL Server Integration Services (SSIS) provides the ability to create custom components if the integrated components do not suit your specific needs. Learn how to develop and install custom components and implement script tasks.

Course Number:

it_mdidwm_12_enus

RAC Monitoring

Overview/Description:

A main concern for any database administrator is that a database is performing optimally. Explore RAC monitoring and tuning techniques using Enterprise Manager Cloud Control and database tools like AWR, ASH, and ADDM.

Course Number:

it_odraad_12_enus

Monitoring Queries

Overview/Description:

An enterprise database infrastructure has a lot of moving pieces, and it’s crucial that they be monitored. Explore SQL Server database queries, including the Query Store, Extended Events, SQL Trace, and troubleshooting server health.

Course Number:

it_dfsqla_10_enus

Subqueries & the EXISTS Predicate

Overview/Description:

Subqueries in SQL Server 2016 are nested SELECT statements used to create more effective queries in T-SQL. Explore subqueries and correlated subqueries and the EXISTS predicate.

Course Number:

it_dfsqlq_10_enus

DDL DML & Constraints

Overview/Description:

Data definition and data manipulation languages allow you to work with data in meaningful ways. Discover how to work with SQL DML commands, constraints, and datatypes in PostgreSQL.

Course Number:

it_dfpost_02_enus

Oracle Database 12c R2 SQL: Using the Set Operators  

Overview/Description:

Discover how to write SQL queries by using set operators.

Course Number:

it_dfosfd_06_enus

RAC Service Management

Overview/Description:

Managing varying workloads from different applications can be very complicated. Discover how to create and manage services with Enterprise Manager Cloud Control and SRVCTL.

Course Number:

it_odraad_16_enus

Managing a Database Instance

Overview/Description:

Discover how to get started with Oracle Database 12c, configure initialization parameters, start up a database instance, work with log files, and use the various database views.

Course Number:

it_oddbre_02_enus

Objects & Retrieving Data

Overview/Description:

PostgreSQL is an open-source DBMS that supports most SQL constructs. Learn about downloading, installing and configuring the PostgreSQL RDBMS, as well as creating a database, using database objects, and retrieving data.

Course Number:

it_dfpost_01_enus

Modifying Data

Overview/Description:

SQL Server 2016 offers various clauses determine how the results of a particular query are presented. Explore data modification using conversions, character data, SELECT INTO, INSERT, and more.

Course Number:

it_dfsqlq_06_enus

Data Transportation

Overview/Description:

Using Data Transport in Oracle Database 12c, you can transport tablespace to other databases or transport entire databases. Discover how to perform both tablespace and database transports.

Course Number:

it_odbkpr_12_enus

Stored Routines Triggers & the InnoDB memcached Plugin

Overview/Description:

Stored programs (procedures) and routines (functions) in MySQL are used to create reusable, executable code. Explore the syntax and use of stored procedures and functions in MySQL

Course Number:

it_dfmydd_07_enus

Replication Overview

Overview/Description:

One method for maintaining data integrity and minimizing potential disaster is replication. Discover how to configure, implement, and manage SQL Server replication as part of your backup and recovery plan.

Course Number:

it_mdddsa_11_enus

MySQL: Views Indices & Normal Forms

Overview/Description:

This 13-video course explores how indexes work to speed up query execution, and how views can be used to abstract complex queries in a convenient fashion. Learners will explore advanced abstractions in MySQL, including a view, which is a virtual table, and indices. Then you will learn how to use views to build abstractions for complex and common query operations in your use case. You will examine indices, which are auxiliary data structures which are maintained by a DBMS (database management system). Next, learn how to use an index on a database to make queries fast and easy. You will examine normal forms in database design, a standard set of rules to test the design of a table. This course demonstrates how to apply the analysis of normal forms to optimize the structure of your relations, and then to use appropriate indices to speed up query execution on them. Finally, this course demonstrates first, second, and third normal forms, and how to fix violations.

Course Number:

it_aplumgdj_06_enus

SELECT Statement & Operators

Overview/Description:

SELECT statements are used to retrieve data from MySQL tables or views. Explore the syntax and use of the most common SELECT statement elements, including SELECT, FROM, WHERE, and ORDER BY, as well as unions and joins.

Course Number:

it_dfmydd_05_enus

Indexes & Query Optimization

Overview/Description:

Administrating a MongoDB database includes ensuring queries respond fast enough for users to obtain the correct data from the database. Learn how to create indexes and perform query optimization in MongoDB.

Course Number:

it_dfmond_03_enus

Multiple Tenant Deployments

Overview/Description:

There are many variables to consider when deciding on a single-tenant or multi-tenant design for Windows Azure. Examine the considerations for each design option.

Course Number:

it_dfsqlp_14_enus

Designing a Fact Table

Overview/Description:

Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. Explore the implementation of fact tables using partitions, data compression, and columnstore indexes.

Course Number:

it_mdidwm_02_enus

SQL Platform & Installation Best Practices

Overview/Description:

It’s important to understand the various components, editions, and versions that exist when discussing SQL Server 2016. Explore the SQL Server platform and best practices and guidelines to follow when preparing for an installation.

Course Number:

it_dfsqlp_01_enus

Relational Database & Data Warehouse Basics

Overview/Description:

Teradata provides a relational database system that offers various tools and utilities for management, administration, and querying. Explore the basics of Teradata including what a data warehouse is along with its architecture and design.

Course Number:

it_dftera_01_enus

Memory Tuning Techniques

Overview/Description:

The SGA a key component to the effective working of the Oracle database engine. Learn about SGA tuning, including tuning the buffer cache and I/O.

Course Number:

it_odpmte_13_enus

Working with Functions Times Dates & Intervals

Overview/Description:

Teradata supports the use of functions, expressions, and operators to perform operations on data. Explore attribute, string, and analytical functions, as well as times, dates, and intervals in Teradata.

Course Number:

it_dftesq_05_enus

Table Design: Functions & Strings

Overview/Description:

Master the core functions of SQL strings. Strings are a key component to any database, and you can work magic using fundamental SQL commands. Explore string functions like LENGTH, REVERSE, and TRIM, as well as how to put them together.

Course Number:

it_dfsqli_05_enus

Indexes

Overview/Description:

In Raven, an index is an optimized on-disk data structure that returns query results very quickly. Explore indexes, full text searches, paging results, and streaming large result sets.

Course Number:

it_dfrvdb_04_enus

MVC & Server Management

Overview/Description:

RavenDB is a document-based database for .Net. Learn how to integrate RavenDB into an MVC application, and how to manage your server, including importing and exporting data, performing backups, and implementing authentication.

Course Number:

it_dfrvdb_06_enus

RAC One Node

Overview/Description:

RAC One Node provides high availability for single instance Oracle databases. Discover how to convert a single instance database to RAC and the administration of Oracle RAC One Node.

Course Number:

it_odraad_05_enus

Write Read & Aggregate Data

Overview/Description:

MongoDB provides CRUD operations to read and write documents within collections. Discover how to create and manage documents, as well as how to query them using the find() method and aggregation.

Course Number:

it_dfmond_02_enus

Connection Strings & Traffic Manager

Overview/Description:

Connection strings are used to allow client applications to interact with Azure SQL databases. Explore application connections strings and the Azure Traffic Manager, which is used to control the distribution of incoming user traffic.

Course Number:

it_dfsqlp_18_enus

NoSQL In-Depth

Overview/Description:

NoSQL databases are attractive to developers due to their simplicity of design, but data security is always a concern. Learn about security issues and how to address them, as well as HL7, HIPAA, and PCI considerations.

Course Number:

it_dfnsql_07_enus

Database Transactions

Overview/Description:

It’s important to ensure that the SQL statements that make up a transaction succeed or fail as a group. Explore the concepts of database transaction control using the COMMIT, ROLLBACK, and SAVEPOINT commands.

Course Number:

it_odinsq_13_enus

Working with JSON Java Node.js & Python

Overview/Description:

One of the benefits of Cassandra is the ability to develop using a number of different languages. Explore Cassandra support for JSON, user-defined functions, and Cassandra drivers for various development platforms.

Course Number:

it_dfcasd_04_enus

SSIS Variables

Overview/Description:

SQL Server 2014 allows for the use of parameters, variables, and expressions to create dynamic packages. Examine SSIS variable concepts, such as system variables, scope, parameterization of properties, and data types.

Course Number:

it_mdidwm_09_enus

The Redis In-memory Data Store: Messaging & Streaming

Overview/Description:

Redis is primarily an in-memory, key-value store, but has many additional use cases. In this course, you’ll explore the use cases of Redis that go beyond its use as a database or cache, specifically its application in messaging and streaming. You’ll start by setting up communications between Redis clients using the Publish/Subscribe paradigm and the Redis CLI. Next, you’ll learn how to set up Redis streams and retrieve data from them using the XREAD command. Finally, you’ll use the stream data structure in Redis to record information and communicate messages to a group of consumer processes.

Course Number:

it_jmwrdsdj_03_enus

Concepts & Background

Overview/Description:

NoSQL databases provide a mechanism for data retrieval and storage other than relational databases. Learn about NoSQL data stores, queries and updates, and why NoSQL may be a better choice than a traditional relational database model.

Course Number:

it_dfnsql_01_enus

Service Tiers Pools & SQL Databases

Overview/Description:

Azure virtual machines (VMs) provide a way to move on-premise SQL Server workloads and applications to the cloud. Explore service tiers, pools and SQL databases for Azure VMs.

Course Number:

it_dfsqlp_06_enus

SQL*Plus Commands

Overview/Description:

SQL*Plus is an interactive and batch query tool that is installed with every Oracle Server and client installation. Learn about the features and functionality of SQL*Plus, including editing, file, and output commands.

Course Number:

it_odinsq_03_enus