NoSQL for FSD Development |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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) |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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) |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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) |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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) |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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) |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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 |
Course |
View details
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
|