COURSES

Data

A wide range of learning to choose from presented by professional instructors.

OUR COURSES SERIES

Data Course Directory

Data Platforms

Course Name	Course Type	Syllabus
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)	Course	View details
Oracle Database 12c R2 SQL: Using Basic SELECT statements	Course	View details
Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables	Course	View details
Oracle Database 12c R2 SQL: Using the Set Operators	Course	View details
Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views	Course	View details
Oracle Database 12c R2 SQL: Managing Schema Objects	Course	View details
Oracle Database 12c R2 SQL: Data Definition Language (DDL)	Course	View details
Oracle Database 12c R2 SQL: SQL*Plus	Course	View details
Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output	Course	View details
Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries	Course	View details
Oracle Database 12c R2 SQL: Creating Other Schema Objects	Course	View details
Oracle Database 12c R2 SQL: Controlling User Access	Course	View details
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries	Course	View details
NoSQL for FSD Development	Course	View details Course Syllabus \| Print Syllabus 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
The Redis In-memory Data Store: An Introduction to Redis	Course	View details Course Syllabus \| Print Syllabus 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 youll explore the various use cases features and limitations of the Redis in-memory store. Youll examine the different data types structures and client connections supported in Redis. Next youll learn how to install Redis and to set up an instance of the Redis server. Youll 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
The Redis In-memory Data Store: Data Structures	Course	View details Course Syllabus \| Print Syllabus 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 youll learn how to work with Rediss different data structures namely lists hashes and sets. Youll then learn to perform various set operations such as union intersection and set difference. Next youll distinguish sorted sets from regular sets and learn how to work with them. Youll then examine the benefits and limitations of HyperLogLog structures and how to use these in Redis. Upon completing this course youll be able to compare and work with each of these structures and recognize their use cases. Course Number: it_jmwrdsdj_02_enus
The Redis In-memory Data Store: Messaging & Streaming	Course	View details Course Syllabus \| Print Syllabus 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 youll explore the use cases of Redis that go beyond its use as a database or cache specifically its application in messaging and streaming. Youll start by setting up communications between Redis clients using the Publish/Subscribe paradigm and the Redis CLI. Next youll learn how to set up Redis streams and retrieve data from them using the XREAD command. Finally youll 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
The Redis In-memory Data Store: Working With Redis Clients	Course	View details Course Syllabus \| Print Syllabus 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 youll explore some of these advanced features and how they apply to pipelines transactions and locks. Youll learn how to work with these features using both the Redis CLI and Python clients. Youll start by learning how to use both Pub/Sub and pipelines in a Python app with a Redis client. Youll then learn how to define and execute transactions in Redis and use the watch feature. Youll 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 youll learn how to use Redis keys and locks to synchronize access to shared Redis resources. Course Number: it_jmwrdsdj_04_enus
The Redis In-memory Data Store: Administering a Redis Server	Course	View details Course Syllabus \| Print Syllabus 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 youll explore how to carry out some of these critical tasks namely assigning user permissions establishing replacement servers and setting cache replacement policies. Youll start by learning how to use ACL commands to set user permissions for new users and continue to assign permissions using ACL categories. Next youll 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 youll 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
Performance Tuning Best Practices	Course	View details
Cluster Performance Tuning	Course	View details
Recovery & Backup	Course	View details
SQL Concepts & Queries	Course	View details
SQL Tables	Course	View details
SQL Selecting Ordering & Filtering	Course	View details
Table Design: Tables Columns & Numbers	Course	View details
Table Design: Functions & Strings	Course	View details
Multiple SQL Tables	Course	View details
Advanced SQL Queries	Course	View details
SQL Views	Course	View details
SQL Transactions	Course	View details
SQL Transaction Locks	Course	View details
SQL Security Architecture	Course	View details
Maintaining SQL Performance	Course	View details
Tuning Instance Memory	Course	View details
Memory Tuning Techniques	Course	View details
SQL Memory Usage Tuning	Course	View details
Performance Tuning Summary	Course	View details
Performance Tuning Methodology	Course	View details
Grid Infrastructure	Course	View details
Automatic Storage Management	Course	View details
RAC Architecture	Course	View details
RAC Configuration	Course	View details
RAC One Node	Course	View details
RAC Administration	Course	View details
RAC Initialization Parameters	Course	View details
RAC Backup & Recovery	Course	View details
RAC Recovery Manager	Course	View details
RAC Global Resource Management	Course	View details
RAC Tuning	Course	View details
RAC Monitoring	Course	View details
High Availability	Course	View details
Application Failover & Continuity	Course	View details
Quality of Service	Course	View details
RAC Service Management	Course	View details
RAC Administration Services & Multitenant Architecture	Course	View details
MySQL: Getting Started	Course	View details Course Syllabus \| Print Syllabus 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
MySQL: Creating & Updating Tables	Course	View details Course Syllabus \| Print Syllabus 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
MySQL: Querying Data	Course	View details Course Syllabus \| Print Syllabus 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
MySQL: Understanding & Implementing Joins	Course	View details Course Syllabus \| Print Syllabus 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
MySQL: Grouping & Aggregation Operations	Course	View details Course Syllabus \| Print Syllabus 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
MySQL: Views Indices & Normal Forms	Course	View details Course Syllabus \| Print Syllabus 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
MySQL: Triggers & Stored Procedures	Course	View details Course Syllabus \| Print Syllabus 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
MySQL: Transactions Savepoints & Locks	Course	View details Course Syllabus \| Print Syllabus 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
SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis	Course	View details Course Syllabus \| Print Syllabus 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 youll learn how to install MariaDB for macOS and MS Windows. Youll 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 youll work with DBeaver and recognize how it is a handy user interface to interact with a MariaDB server. Finally youll run a few basic MariaDB commands and queries from DBeaver. Course Number: it_dasqpmdj_01_enus
SQL Programming with MariaDB: Analyzing Relational Data	Course	View details Course Syllabus \| Print Syllabus 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 youll 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. Youll 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 youll learn how to take advantage of another important aspect of relational database usage – the ability to impose constraints upon data. Youll work with UNIQUE NOT NULL and FOREIGN KEY constraints. Course Number: it_dasqpmdj_02_enus
SQL Programming with MariaDB: Using Joins Triggers & Stored Procedures	Course	View details Course Syllabus \| Print Syllabus 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 youll begin by using several types of joins such as cross joins inner joins and outer joins to combine data from multiple tables.<<Next youll 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. Youll then use the HAVING clause as a way to filter the output of the GROUP BY clause.<<Youll move on to use the two types of generated columns – virtual and persistent computing them on-the-fly from a function expression.<<Finally youll 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
Big Data Solutions Architecture CQL & DDL	Course	View details
Data Manipulation Queries Collections & Indexing	Course	View details
Administration & Development	Course	View details
Working with JSON Java Node.js & Python	Course	View details
Architecture & Installation	Course	View details
Clustering & Admin Tools	Course	View details
Installing MongoDB	Course	View details
Write Read & Aggregate Data	Course	View details
Indexes & Query Optimization	Course	View details
Replication & Security	Course	View details
Map Reduce Atomic Counters & Binary Data	Course	View details
Java REST & GridFS	Course	View details
User Management	Course	View details
System Management	Course	View details
Cloud & Hadoop Deployments	Course	View details
Backups Monitoring & Stats	Course	View details
Java ASYNC Interface	Course	View details
MongoDB with Python	Course	View details
MongoDB with Spark	Course	View details
MySQL 8.0: Introduction	Course	View details Course Syllabus \| Print Syllabus 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
DDL Statements	Course	View details
Manipulating Data	Course	View details
SELECT Statement & Operators	Course	View details
Working with Functions	Course	View details
Stored Routines Triggers & the InnoDB memcached Plugin	Course	View details
Query & Performance Optimization	Course	View details
GIS Cloud & Connectors	Course	View details
Concepts & Background	Course	View details
Distributed Systems & Big Data	Course	View details
Models & Applications	Course	View details
Models & Data Stores	Course	View details
Programming Essentials	Course	View details
CouchDB cURL & Futon	Course	View details
NoSQL In-Depth	Course	View details
Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language	Course	View details
Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions	Course	View details
Oracle Database 12c R2 SQL: Restricting & Sorting Data	Course	View details
Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions	Course	View details
Objects & Retrieving Data	Course	View details
DDL DML & Constraints	Course	View details
Data Retrieval	Course	View details
Security & Administration	Course	View details
RavenDB: Getting Started	Course	View details
Creating Documents	Course	View details
Updating & Patching Documents	Course	View details
Indexes	Course	View details
Deployment & Scaling	Course	View details
MVC & Server Management	Course	View details
Encryption	Course	View details
Data Access & Permissions	Course	View details
Data Security & Azure SQL Database Options	Course	View details
Auditing	Course	View details
Backup Management	Course	View details
Database Restoration	Course	View details
File & Piecemeal Restores	Course	View details
Managing Database Integrity	Course	View details
Monitoring Database Activity	Course	View details
Monitoring Queries	Course	View details
Database Mail & Alerts	Course	View details
Policy-based Management & Performance Monitoring	Course	View details
Index & Statistical Management	Course	View details
Log Shipping & High Availability	Course	View details
SQL Platform & Installation Best Practices	Course	View details
Architecture	Course	View details
Installation & Configuration	Course	View details
Upgrading to SQL Server 2016	Course	View details
Virtual Machines on Azure	Course	View details
Service Tiers Pools & SQL Databases	Course	View details
Instances & Storage Considerations	Course	View details
Securing Azure SQL Databases	Course	View details
Dynamic Data Masking	Course	View details
Transparent Data Encryption	Course	View details
Always Encrypted & Cell-level Encryption	Course	View details
Database Performance Settings	Course	View details
Configuring Operators & Alerts	Course	View details
Multiple Tenant Deployments	Course	View details
Migrating to Azure SQL Databases	Course	View details
Virtual Machines & Benchmark Data	Course	View details
Performance Tuning & Availability Sets	Course	View details
Connection Strings & Traffic Manager	Course	View details
Application Patterns	Course	View details
T-SQL Queries	Course	View details
Sets & Predicate Logic	Course	View details
Querying & Manipulating Data	Course	View details
Querying with Joins	Course	View details
Filtering Data	Course	View details
Modifying Data	Course	View details
Using Functions	Course	View details
Using Aggregate Functions	Course	View details
Using GROUP BY PIVOT & UNPIVOT	Course	View details
Subqueries & the EXISTS Predicate	Course	View details
Operators & Expressions	Course	View details
Database Programmability Objects & Non-relational Data	Course	View details
Relational Database & Data Warehouse Basics	Course	View details
Relational Database Management System (RDBMS)	Course	View details
Client Communication	Course	View details
Communication & Database Security	Course	View details
Authentication & Security	Course	View details
Primary & Partitioned Indexes	Course	View details
Secondary & Join Indexes	Course	View details
Locking & Data Protection	Course	View details
Introducing SELECT Statement Queries	Course	View details
Working with Clauses Operators Expressions & Aggregates	Course	View details
Performing Joins	Course	View details
Performing Subqueries & Correlated Subqueries	Course	View details
Working with Functions Times Dates & Intervals	Course	View details
Working with Data Conversions & SET Operations	Course	View details
Working with Data Definition Language (DDL)	Course	View details
Working with DML Optimization & Temporal Concepts	Course	View details
MongoDB Querying	Course	View details Course Syllabus \| Print Syllabus 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
MongoDB Aggregation	Course	View details Course Syllabus \| Print Syllabus 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
Introduction to SQL Bootcamp: Session 1 Replay	Course	View details Course Syllabus \| Print Syllabus 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
Introduction to SQL Bootcamp: Session 2 Replay	Course	View details
Introduction to SQL Bootcamp: Session 3 Replay	Course	View details
Introduction to SQL Bootcamp: Session 4 Replay	Course	View details Course Syllabus \| Print Syllabus 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
Planning Infrastructure	Course	View details
Implementing & Testing Policy	Course	View details
Private Cloud Overview	Course	View details
Private Cloud Planning & Implementation	Course	View details
Windows Azure SQL Database	Course	View details
High Availability	Course	View details
WSFC Clustering	Course	View details
Clustering & AlwaysOn	Course	View details
Backup & Recovery Strategies	Course	View details
Recovery Implementation	Course	View details
Replication Overview	Course	View details
Designing & Implementing Dimensions	Course	View details
Designing a Fact Table	Course	View details
Connection Managers & Data Sources	Course	View details
Data Transformation & Flow	Course	View details
Data Flow Implementation & ETL	Course	View details Course Syllabus \| Print Syllabus 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
SSIS Package Execution & Script Tasks	Course	View details
Designing Control Flow	Course	View details
Implementing Control Flow	Course	View details
SSIS Variables	Course	View details
SSIS Packages	Course	View details
Data Loading	Course	View details
Script Components	Course	View details
SSIS Components	Course	View details
Auditing Logging & Event Handling	Course	View details
Troubleshooting Data Integration	Course	View details
SSIS Solutions	Course	View details
SSIS Security	Course	View details
Data Quality Services (DQS) & Master Data Services (MDS)	Course	View details
Data Quality Projects	Course	View details
Assessing Recovery Requirements	Course	View details
Backup & Recovery Options	Course	View details
Recovery Configuration	Course	View details
Backup Strategies	Course	View details
Performing & Managing Backups	Course	View details
Failure & Recovery Concepts	Course	View details
Recovery & Availability	Course	View details
Recovery After Loss	Course	View details
Secure Backup	Course	View details
Configuring Flashback Technologies	Course	View details
Using Flashback Technologies	Course	View details
Data Transportation	Course	View details
Performing PITR	Course	View details
Duplicating Databases	Course	View details
Tuning RMAN	Course	View details
Oracle Database Instance Overview	Course	View details
Managing a Database Instance	Course	View details
Connecting to & Configuring a Database Instance	Course	View details
Connectivity & Space Management	Course	View details
Undo Feature Overview	Course	View details
User Security Features & Configuration	Course	View details
Auditing Features & Configuration	Course	View details
Backing Up & Recovering Data	Course	View details
Importing & Exporting Data	Course	View details
Database Maintenance	Course	View details
Performance Tuning	Course	View details
SQL Tuning	Course	View details
Resource Management	Course	View details
Job Scheduling	Course	View details
Relational Database Concepts	Course	View details
SQL Developer	Course	View details
SQL*Plus Commands	Course	View details
SELECT Statement Expressions & Operators	Course	View details
Restricting Output	Course	View details
Working with Substitution	Course	View details
Customizing Output	Course	View details
Data Conversion	Course	View details
Aggregating Data	Course	View details
Working with Joins	Course	View details
Working with Subqueries	Course	View details
Data Manipulation Language	Course	View details
Database Transactions	Course	View details
Working with SET Operators	Course	View details
Working with DDL	Course	View details
Introduction to Performance Tuning	Course	View details
Implementing Performance Tuning	Course	View details
Automatic Workload Repository	Course	View details
ADDM & ASH	Course	View details
Metrics & Monitoring	Course	View details
Application Monitoring	Course	View details
SQL Diagnostics	Course	View details
Tuning Problem SQL Statements	Course	View details
Performance Migration & Compression	Course	View details
Measuring SQL Performance	Course	View details