COURSES
Data
OUR COURSES SERIES
Data Course Directory
- Data Platforms
- Data Core Concepts
- Data Visualization & Reporting
- Data Architectures
- Data Science
- Big Data
- Business Intelligence
- Data Analytics
- Database Development
- Data Security
- Big Data
- Business Intelligence
- Data Analytics
- Data Architectures
- Data Core Concepts
- Data Platforms
- Data Science
- Data Security
- Data Visualization & Reporting
- Database Development
- Advanced and Interactive Visualization in R Bootcamp
- Apache Cassandra
- Apache Hadoop
- Apache HBase
- Apache Spark
- Apache Storm
- Architecting Data
- Artificial Intelligence (AI)
- Big Data Core Concepts
- ChatGPT
- Data Compliance
- Data Essentials
- Data Integration
- Data Literacy for All Bootcamp
- Data Science Core Concepts
- Data Science for Managers Bootcamp
- Data Visualization and Storytelling Bootcamp
- Data Visualization Core Concepts
- Data Visualization with Python Bootcamp
- Data Warehousing
- Database Backup & Recovery
- Database Business Intelligence
- Database Core Concepts
- Database Performance Tuning
- Database Security
- IBM BigInsights
- Introduction to Machine Learning Bootcamp
- Introduction to SQL Bootcamp
- Introduction to Tableau Bootcamp
- Machine Learning
- MariaDB
- Microsoft Power Platform
- MongoDB
- MySQL
- Neo4j
- NoSQL
- Oracle Database Administration
- Oracle RAC
- Oracle SQL
- PostgreSQL
- Power BI
- Power BI Bootcamp
- Predictive Analytics
- Python for Data Science
- QlikView
- R for Data Science
- RavenDB
- Redis
- Snowflake
- Splunk
- SQL Database Administration
- SQL Database Development & Design
- Statistics
- Tableau
- Teradata
- TIBCO Spotfire
- Understanding Bias in Data Bootcamp
Data Platforms
| Course Name | Course Type | Syllabus |
|---|---|---|
| Oracle Database 12c R2 SQL: Using Structured Query Language (SQL) | Course | View details Course Syllabus | Print Syllabus 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 |
| Oracle Database 12c R2 SQL: Using Basic SELECT statements | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Using Basic SELECT statementsOverview/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 |
| Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Displaying Data from Multiple TablesOverview/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 |
| Oracle Database 12c R2 SQL: Using the Set Operators | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Using the Set OperatorsOverview/Description: Discover how to write SQL queries by using set operators. Course Number: it_dfosfd_06_enus |
| Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary ViewsOverview/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 |
| Oracle Database 12c R2 SQL: Managing Schema Objects | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Managing Schema ObjectsOverview/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 |
| Oracle Database 12c R2 SQL: Data Definition Language (DDL) | Course | View details Course Syllabus | Print Syllabus 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 |
| Oracle Database 12c R2 SQL: SQL*Plus | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: SQL*PlusOverview/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 |
| Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize OutputOverview/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 |
| Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Using Subqueries to Solve QueriesOverview/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 |
| Oracle Database 12c R2 SQL: Creating Other Schema Objects | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Creating Other Schema ObjectsOverview/Description: Explore the basics of creating and using sequences and views in Oracle Database 12c SQL. Course Number: it_dfosfd_15_enus |
| Oracle Database 12c R2 SQL: Controlling User Access | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Controlling User AccessOverview/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 |
| Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Manipulating Data Using Advanced QueriesOverview/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 |
| NoSQL for FSD Development | Course | View details Course Syllabus | Print Syllabus NoSQL for FSD DevelopmentOverview/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 RedisOverview/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 StructuresOverview/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 & StreamingOverview/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 ClientsOverview/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 ServerOverview/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 Course Syllabus | Print Syllabus Performance Tuning Best PracticesOverview/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 |
| Cluster Performance Tuning | Course | View details Course Syllabus | Print Syllabus Cluster Performance TuningOverview/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 |
| Recovery & Backup | Course | View details Course Syllabus | Print Syllabus Recovery & BackupOverview/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 Concepts & Queries | Course | View details Course Syllabus | Print Syllabus SQL Concepts & QueriesOverview/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 Tables | Course | View details Course Syllabus | Print Syllabus SQL TablesOverview/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 |
| SQL Selecting Ordering & Filtering | Course | View details Course Syllabus | Print Syllabus SQL Selecting Ordering & FilteringOverview/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 |
| Table Design: Tables Columns & Numbers | Course | View details Course Syllabus | Print Syllabus Table Design: Tables Columns & NumbersOverview/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 |
| Table Design: Functions & Strings | Course | View details Course Syllabus | Print Syllabus Table Design: Functions & StringsOverview/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 |
| Multiple SQL Tables | Course | View details Course Syllabus | Print Syllabus Multiple SQL TablesOverview/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 |
| Advanced SQL Queries | Course | View details Course Syllabus | Print Syllabus Advanced SQL QueriesOverview/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 |
| SQL Views | Course | View details Course Syllabus | Print Syllabus SQL ViewsOverview/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 |
| SQL Transactions | Course | View details Course Syllabus | Print Syllabus SQL TransactionsOverview/Description: Master SQL transactions. Explore transactions and how to group statements Transact-SQL and transaction logs. Course Number: it_dfsqli_09_enus |
| SQL Transaction Locks | Course | View details Course Syllabus | Print Syllabus SQL Transaction LocksOverview/Description: Master SQL transaction locks. Explore transaction locks and explore the different levels of locking. Course Number: it_dfsqli_10_enus |
| SQL Security Architecture | Course | View details Course Syllabus | Print Syllabus SQL Security ArchitectureOverview/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 |
| Maintaining SQL Performance | Course | View details Course Syllabus | Print Syllabus Maintaining SQL PerformanceOverview/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 |
| Tuning Instance Memory | Course | View details Course Syllabus | Print Syllabus Tuning Instance MemoryOverview/Description: When performance tuning in Oracle Database 12c its 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 |
| Memory Tuning Techniques | Course | View details Course Syllabus | Print Syllabus Memory Tuning TechniquesOverview/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 |
| SQL Memory Usage Tuning | Course | View details Course Syllabus | Print Syllabus SQL Memory Usage TuningOverview/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 |
| Performance Tuning Summary | Course | View details Course Syllabus | Print Syllabus Performance Tuning SummaryOverview/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 |
| Performance Tuning Methodology | Course | View details Course Syllabus | Print Syllabus Performance Tuning MethodologyOverview/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 |
| Grid Infrastructure | Course | View details Course Syllabus | Print Syllabus Grid InfrastructureOverview/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 |
| Automatic Storage Management | Course | View details Course Syllabus | Print Syllabus Automatic Storage ManagementOverview/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 |
| RAC Architecture | Course | View details Course Syllabus | Print Syllabus RAC ArchitectureOverview/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 |
| RAC Configuration | Course | View details Course Syllabus | Print Syllabus RAC ConfigurationOverview/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 |
| RAC One Node | Course | View details Course Syllabus | Print Syllabus RAC One NodeOverview/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 |
| RAC Administration | Course | View details Course Syllabus | Print Syllabus RAC AdministrationOverview/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 |
| RAC Initialization Parameters | Course | View details Course Syllabus | Print Syllabus RAC Initialization ParametersOverview/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 |
| RAC Backup & Recovery | Course | View details Course Syllabus | Print Syllabus RAC Backup & RecoveryOverview/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 |
| RAC Recovery Manager | Course | View details Course Syllabus | Print Syllabus RAC Recovery ManagerOverview/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 |
| RAC Global Resource Management | Course | View details Course Syllabus | Print Syllabus RAC Global Resource ManagementOverview/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 Tuning | Course | View details Course Syllabus | Print Syllabus RAC TuningOverview/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 |
| RAC Monitoring | Course | View details Course Syllabus | Print Syllabus RAC MonitoringOverview/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 |
| High Availability | Course | View details Course Syllabus | Print Syllabus High AvailabilityOverview/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 |
| Application Failover & Continuity | Course | View details Course Syllabus | Print Syllabus Application Failover & ContinuityOverview/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 |
| Quality of Service | Course | View details Course Syllabus | Print Syllabus Quality of ServiceOverview/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 |
| RAC Service Management | Course | View details Course Syllabus | Print Syllabus RAC Service ManagementOverview/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 |
| RAC Administration Services & Multitenant Architecture | Course | View details Course Syllabus | Print Syllabus RAC Administration Services & Multitenant ArchitectureOverview/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 |
| MySQL: Getting Started | Course | View details Course Syllabus | Print Syllabus MySQL: Getting StartedOverview/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 TablesOverview/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 DataOverview/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 JoinsOverview/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 OperationsOverview/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 FormsOverview/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 ProceduresOverview/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 & LocksOverview/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 AnalysisOverview/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 DataOverview/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 ProceduresOverview/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 Course Syllabus | Print Syllabus Big Data Solutions Architecture CQL & DDLOverview/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 |
| Data Manipulation Queries Collections & Indexing | Course | View details Course Syllabus | Print Syllabus Data Manipulation Queries Collections & IndexingOverview/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 |
| Administration & Development | Course | View details Course Syllabus | Print Syllabus Administration & DevelopmentOverview/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 |
| Working with JSON Java Node.js & Python | Course | View details Course Syllabus | Print Syllabus Working with JSON Java Node.js & PythonOverview/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 |
| Architecture & Installation | Course | View details Course Syllabus | Print Syllabus Architecture & InstallationOverview/Description: Apache Cassandra is designed to meet a scaling challenge that traditional database management systems arent capable of handling. Explore the Cassandra architecture and how to install Cassandra. Course Number: it_dfcass_01_enus |
| Clustering & Admin Tools | Course | View details Course Syllabus | Print Syllabus Clustering & Admin ToolsOverview/Description: Apache Cassandra is designed to meet a scaling challenge that traditional database management systems arent capable of handling. Discover clustering and admin tools and how to install manage and access data programmatically. Course Number: it_dfcass_02_enus |
| Installing MongoDB | Course | View details Course Syllabus | Print Syllabus Installing MongoDBOverview/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 |
| Write Read & Aggregate Data | Course | View details Course Syllabus | Print Syllabus Write Read & Aggregate DataOverview/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 |
| Indexes & Query Optimization | Course | View details Course Syllabus | Print Syllabus Indexes & Query OptimizationOverview/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 |
| Replication & Security | Course | View details Course Syllabus | Print Syllabus Replication & SecurityOverview/Description: important that data in a MongoDB database is available to users at all times and that secure. Discover how to configure replication and security for MongoDB. Course Number: it_dfmond_04_enus |
| Map Reduce Atomic Counters & Binary Data | Course | View details Course Syllabus | Print Syllabus Map Reduce Atomic Counters & Binary DataOverview/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 |
| Java REST & GridFS | Course | View details Course Syllabus | Print Syllabus Java REST & GridFSOverview/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 |
| User Management | Course | View details Course Syllabus | Print Syllabus User ManagementOverview/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 |
| System Management | Course | View details Course Syllabus | Print Syllabus System ManagementOverview/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 |
| Cloud & Hadoop Deployments | Course | View details Course Syllabus | Print Syllabus Cloud & Hadoop DeploymentsOverview/Description: One of MongoDBs 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 |
| Backups Monitoring & Stats | Course | View details Course Syllabus | Print Syllabus Backups Monitoring & StatsOverview/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 |
| Java ASYNC Interface | Course | View details Course Syllabus | Print Syllabus Java ASYNC InterfaceOverview/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 |
| MongoDB with Python | Course | View details Course Syllabus | Print Syllabus MongoDB with PythonOverview/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 |
| MongoDB with Spark | Course | View details Course Syllabus | Print Syllabus MongoDB with SparkOverview/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 |
| MySQL 8.0: Introduction | Course | View details Course Syllabus | Print Syllabus MySQL 8.0: IntroductionOverview/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 Course Syllabus | Print Syllabus Database Design FundamentalsOverview/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 |
| DDL Statements | Course | View details Course Syllabus | Print Syllabus DDL StatementsOverview/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 |
| Manipulating Data | Course | View details Course Syllabus | Print Syllabus Manipulating DataOverview/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 |
| SELECT Statement & Operators | Course | View details Course Syllabus | Print Syllabus SELECT Statement & OperatorsOverview/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 |
| Working with Functions | Course | View details Course Syllabus | Print Syllabus Working with FunctionsOverview/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 |
| Stored Routines Triggers & the InnoDB memcached Plugin | Course | View details Course Syllabus | Print Syllabus Stored Routines Triggers & the InnoDB memcached PluginOverview/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 |
| Query & Performance Optimization | Course | View details Course Syllabus | Print Syllabus Query & Performance OptimizationOverview/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 |
| GIS Cloud & Connectors | Course | View details Course Syllabus | Print Syllabus GIS Cloud & ConnectorsOverview/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 |
| Concepts & Background | Course | View details Course Syllabus | Print Syllabus Concepts & BackgroundOverview/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 |
| Distributed Systems & Big Data | Course | View details Course Syllabus | Print Syllabus Distributed Systems & Big DataOverview/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 |
| Models & Applications | Course | View details Course Syllabus | Print Syllabus Models & ApplicationsOverview/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 |
| Models & Data Stores | Course | View details Course Syllabus | Print Syllabus Models & Data StoresOverview/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 |
| Programming Essentials | Course | View details Course Syllabus | Print Syllabus Programming EssentialsOverview/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 |
| CouchDB cURL & Futon | Course | View details Course Syllabus | Print Syllabus CouchDB cURL & FutonOverview/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 |
| NoSQL In-Depth | Course | View details Course Syllabus | Print Syllabus NoSQL In-DepthOverview/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 |
| Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control LanguageOverview/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 |
| Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Conversion Functions & Conditional ExpressionsOverview/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 |
| Oracle Database 12c R2 SQL: Restricting & Sorting Data | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Restricting & Sorting DataOverview/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 |
| Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions | Course | View details Course Syllabus | Print Syllabus Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group FunctionsOverview/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 |
| Objects & Retrieving Data | Course | View details Course Syllabus | Print Syllabus Objects & Retrieving DataOverview/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 |
| DDL DML & Constraints | Course | View details Course Syllabus | Print Syllabus DDL DML & ConstraintsOverview/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 |
| Data Retrieval | Course | View details Course Syllabus | Print Syllabus Data RetrievalOverview/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 |
| Security & Administration | Course | View details Course Syllabus | Print Syllabus Security & AdministrationOverview/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 |
| RavenDB: Getting Started | Course | View details Course Syllabus | Print Syllabus RavenDB: Getting StartedOverview/Description: RavenDB is the most popular NoSQL database for the .Net world. open source extremely fast and very intuitive. Explore RavenDB. Course Number: it_dfrvdb_01_enus |
| Creating Documents | Course | View details Course Syllabus | Print Syllabus Creating DocumentsOverview/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 |
| Updating & Patching Documents | Course | View details Course Syllabus | Print Syllabus Updating & Patching DocumentsOverview/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 |
| Indexes | Course | View details Course Syllabus | Print Syllabus IndexesOverview/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 |
| Deployment & Scaling | Course | View details Course Syllabus | Print Syllabus Deployment & ScalingOverview/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 |
| MVC & Server Management | Course | View details Course Syllabus | Print Syllabus MVC & Server ManagementOverview/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 |
| Encryption | Course | View details Course Syllabus | Print Syllabus EncryptionOverview/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 |
| Data Access & Permissions | Course | View details Course Syllabus | Print Syllabus Data Access & PermissionsOverview/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 |
| Data Security & Azure SQL Database Options | Course | View details Course Syllabus | Print Syllabus Data Security & Azure SQL Database OptionsOverview/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 |
| Auditing | Course | View details Course Syllabus | Print Syllabus AuditingOverview/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 |
| Backup Management | Course | View details Course Syllabus | Print Syllabus Backup ManagementOverview/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 |
| Database Restoration | Course | View details Course Syllabus | Print Syllabus Database RestorationOverview/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 |
| File & Piecemeal Restores | Course | View details Course Syllabus | Print Syllabus File & Piecemeal RestoresOverview/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 |
| Managing Database Integrity | Course | View details Course Syllabus | Print Syllabus Managing Database IntegrityOverview/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 |
| Monitoring Database Activity | Course | View details Course Syllabus | Print Syllabus Monitoring Database ActivityOverview/Description: An enterprise database infrastructure has a lot of moving pieces and 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 |
| Monitoring Queries | Course | View details Course Syllabus | Print Syllabus Monitoring QueriesOverview/Description: An enterprise database infrastructure has a lot of moving pieces and 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 |
| Database Mail & Alerts | Course | View details Course Syllabus | Print Syllabus Database Mail & AlertsOverview/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 |
| Policy-based Management & Performance Monitoring | Course | View details Course Syllabus | Print Syllabus Policy-based Management & Performance MonitoringOverview/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 |
| Index & Statistical Management | Course | View details Course Syllabus | Print Syllabus Index & Statistical ManagementOverview/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 |
| Log Shipping & High Availability | Course | View details Course Syllabus | Print Syllabus Log Shipping & High AvailabilityOverview/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 |
| SQL Platform & Installation Best Practices | Course | View details Course Syllabus | Print Syllabus SQL Platform & Installation Best PracticesOverview/Description: 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 |
| Architecture | Course | View details Course Syllabus | Print Syllabus ArchitectureOverview/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 |
| Installation & Configuration | Course | View details Course Syllabus | Print Syllabus Installation & ConfigurationOverview/Description: 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 |
| Upgrading to SQL Server 2016 | Course | View details Course Syllabus | Print Syllabus Upgrading to SQL Server 2016Overview/Description: When performing a SQL Server 2016 upgrade 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 |
| Virtual Machines on Azure | Course | View details Course Syllabus | Print Syllabus Virtual Machines on AzureOverview/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 |
| Service Tiers Pools & SQL Databases | Course | View details Course Syllabus | Print Syllabus Service Tiers Pools & SQL DatabasesOverview/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 |
| Instances & Storage Considerations | Course | View details Course Syllabus | Print Syllabus Instances & Storage ConsiderationsOverview/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 |
| Securing Azure SQL Databases | Course | View details Course Syllabus | Print Syllabus Securing Azure SQL DatabasesOverview/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 |
| Dynamic Data Masking | Course | View details Course Syllabus | Print Syllabus Dynamic Data MaskingOverview/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 |
| Transparent Data Encryption | Course | View details Course Syllabus | Print Syllabus Transparent Data EncryptionOverview/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 |
| Always Encrypted & Cell-level Encryption | Course | View details Course Syllabus | Print Syllabus Always Encrypted & Cell-level EncryptionOverview/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 |
| Database Performance Settings | Course | View details Course Syllabus | Print Syllabus Database Performance SettingsOverview/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 |
| Configuring Operators & Alerts | Course | View details Course Syllabus | Print Syllabus Configuring Operators & AlertsOverview/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 |
| Multiple Tenant Deployments | Course | View details Course Syllabus | Print Syllabus Multiple Tenant DeploymentsOverview/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 |
| Migrating to Azure SQL Databases | Course | View details Course Syllabus | Print Syllabus Migrating to Azure SQL DatabasesOverview/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 |
| Virtual Machines & Benchmark Data | Course | View details Course Syllabus | Print Syllabus Virtual Machines & Benchmark DataOverview/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 |
| Performance Tuning & Availability Sets | Course | View details Course Syllabus | Print Syllabus Performance Tuning & Availability SetsOverview/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 |
| Connection Strings & Traffic Manager | Course | View details Course Syllabus | Print Syllabus Connection Strings & Traffic ManagerOverview/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 |
| Application Patterns | Course | View details Course Syllabus | Print Syllabus Application PatternsOverview/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 |
| T-SQL Queries | Course | View details Course Syllabus | Print Syllabus T-SQL QueriesOverview/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 |
| Sets & Predicate Logic | Course | View details Course Syllabus | Print Syllabus Sets & Predicate LogicOverview/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 |
| Querying & Manipulating Data | Course | View details Course Syllabus | Print Syllabus Querying & Manipulating DataOverview/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 |
| Querying with Joins | Course | View details Course Syllabus | Print Syllabus Querying with JoinsOverview/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 |
| Filtering Data | Course | View details Course Syllabus | Print Syllabus Filtering DataOverview/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 |
| Modifying Data | Course | View details Course Syllabus | Print Syllabus Modifying DataOverview/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 |
| Using Functions | Course | View details Course Syllabus | Print Syllabus Using FunctionsOverview/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 |
| Using Aggregate Functions | Course | View details Course Syllabus | Print Syllabus Using Aggregate FunctionsOverview/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 |
| Using GROUP BY PIVOT & UNPIVOT | Course | View details Course Syllabus | Print Syllabus Using GROUP BY PIVOT & UNPIVOTOverview/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 |
| Subqueries & the EXISTS Predicate | Course | View details Course Syllabus | Print Syllabus Subqueries & the EXISTS PredicateOverview/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 |
| Operators & Expressions | Course | View details Course Syllabus | Print Syllabus Operators & ExpressionsOverview/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 |
| Database Programmability Objects & Non-relational Data | Course | View details Course Syllabus | Print Syllabus Database Programmability Objects & Non-relational DataOverview/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 |
| Relational Database & Data Warehouse Basics | Course | View details Course Syllabus | Print Syllabus Relational Database & Data Warehouse BasicsOverview/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 |
| Relational Database Management System (RDBMS) | Course | View details Course Syllabus | Print Syllabus 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 |
| Client Communication | Course | View details Course Syllabus | Print Syllabus Client CommunicationOverview/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 |
| Communication & Database Security | Course | View details Course Syllabus | Print Syllabus Communication & Database SecurityOverview/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 |
| Authentication & Security | Course | View details Course Syllabus | Print Syllabus Authentication & SecurityOverview/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 |
| Primary & Partitioned Indexes | Course | View details Course Syllabus | Print Syllabus Primary & Partitioned IndexesOverview/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 |
| Secondary & Join Indexes | Course | View details Course Syllabus | Print Syllabus Secondary & Join IndexesOverview/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 |
| Locking & Data Protection | Course | View details Course Syllabus | Print Syllabus Locking & Data ProtectionOverview/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 |
| Introducing SELECT Statement Queries | Course | View details Course Syllabus | Print Syllabus Introducing SELECT Statement QueriesOverview/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 |
| Working with Clauses Operators Expressions & Aggregates | Course | View details Course Syllabus | Print Syllabus Working with Clauses Operators Expressions & AggregatesOverview/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 |
| Performing Joins | Course | View details Course Syllabus | Print Syllabus Performing JoinsOverview/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 |
| Performing Subqueries & Correlated Subqueries | Course | View details Course Syllabus | Print Syllabus Performing Subqueries & Correlated SubqueriesOverview/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 |
| Working with Functions Times Dates & Intervals | Course | View details Course Syllabus | Print Syllabus Working with Functions Times Dates & IntervalsOverview/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 |
| Working with Data Conversions & SET Operations | Course | View details Course Syllabus | Print Syllabus Working with Data Conversions & SET OperationsOverview/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 |
| Working with Data Definition Language (DDL) | Course | View details Course Syllabus | Print Syllabus 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 |
| Working with DML Optimization & Temporal Concepts | Course | View details Course Syllabus | Print Syllabus Working with DML Optimization & Temporal ConceptsOverview/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 |
| MongoDB Querying | Course | View details Course Syllabus | Print Syllabus MongoDB QueryingOverview/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 AggregationOverview/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 ReplayOverview/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 Course Syllabus | Print Syllabus Introduction to SQL Bootcamp: Session 2 ReplayOverview/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 |
| Introduction to SQL Bootcamp: Session 3 Replay | Course | View details Course Syllabus | Print Syllabus Introduction to SQL Bootcamp: Session 3 ReplayOverview/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 |
| Introduction to SQL Bootcamp: Session 4 Replay | Course | View details Course Syllabus | Print Syllabus Introduction to SQL Bootcamp: Session 4 ReplayOverview/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 Course Syllabus | Print Syllabus Planning InfrastructureOverview/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 |
| Implementing & Testing Policy | Course | View details Course Syllabus | Print Syllabus Implementing & Testing PolicyOverview/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 |
| Private Cloud Overview | Course | View details Course Syllabus | Print Syllabus Private Cloud OverviewOverview/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 |
| Private Cloud Planning & Implementation | Course | View details Course Syllabus | Print Syllabus Private Cloud Planning & ImplementationOverview/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 |
| Windows Azure SQL Database | Course | View details Course Syllabus | Print Syllabus Windows Azure SQL DatabaseOverview/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 |
| High Availability | Course | View details Course Syllabus | Print Syllabus High AvailabilityOverview/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 |
| WSFC Clustering | Course | View details Course Syllabus | Print Syllabus WSFC ClusteringOverview/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 |
| Clustering & AlwaysOn | Course | View details Course Syllabus | Print Syllabus Clustering & AlwaysOnOverview/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 |
| Backup & Recovery Strategies | Course | View details Course Syllabus | Print Syllabus Backup & Recovery StrategiesOverview/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 |
| Recovery Implementation | Course | View details Course Syllabus | Print Syllabus Recovery ImplementationOverview/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 |
| Replication Overview | Course | View details Course Syllabus | Print Syllabus Replication OverviewOverview/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 |
| Designing & Implementing Dimensions | Course | View details Course Syllabus | Print Syllabus Designing & Implementing DimensionsOverview/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 |
| Designing a Fact Table | Course | View details Course Syllabus | Print Syllabus Designing a Fact TableOverview/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 |
| Connection Managers & Data Sources | Course | View details Course Syllabus | Print Syllabus Connection Managers & Data SourcesOverview/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 |
| Data Transformation & Flow | Course | View details Course Syllabus | Print Syllabus Data Transformation & FlowOverview/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 |
| Data Flow Implementation & ETL | Course | View details Course Syllabus | Print Syllabus Data Flow Implementation & ETLOverview/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 Course Syllabus | Print Syllabus SSIS Package Execution & Script TasksOverview/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 |
| Designing Control Flow | Course | View details Course Syllabus | Print Syllabus Designing Control FlowOverview/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 |
| Implementing Control Flow | Course | View details Course Syllabus | Print Syllabus Implementing Control FlowOverview/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 |
| SSIS Variables | Course | View details Course Syllabus | Print Syllabus SSIS VariablesOverview/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 |
| SSIS Packages | Course | View details Course Syllabus | Print Syllabus SSIS PackagesOverview/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 |
| Data Loading | Course | View details Course Syllabus | Print Syllabus Data LoadingOverview/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 |
| Script Components | Course | View details Course Syllabus | Print Syllabus Script ComponentsOverview/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 |
| SSIS Components | Course | View details Course Syllabus | Print Syllabus SSIS ComponentsOverview/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 |
| Auditing Logging & Event Handling | Course | View details Course Syllabus | Print Syllabus Auditing Logging & Event HandlingOverview/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 |
| Troubleshooting Data Integration | Course | View details Course Syllabus | Print Syllabus Troubleshooting Data IntegrationOverview/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 |
| SSIS Solutions | Course | View details Course Syllabus | Print Syllabus SSIS SolutionsOverview/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 |
| SSIS Security | Course | View details Course Syllabus | Print Syllabus SSIS SecurityOverview/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 |
| Data Quality Services (DQS) & Master Data Services (MDS) | Course | View details Course Syllabus | Print Syllabus 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 |
| Data Quality Projects | Course | View details Course Syllabus | Print Syllabus Data Quality ProjectsOverview/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 |
| Assessing Recovery Requirements | Course | View details Course Syllabus | Print Syllabus Assessing Recovery RequirementsOverview/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 |
| Backup & Recovery Options | Course | View details Course Syllabus | Print Syllabus Backup & Recovery OptionsOverview/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 |
| Recovery Configuration | Course | View details Course Syllabus | Print Syllabus Recovery ConfigurationOverview/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 |
| Backup Strategies | Course | View details Course Syllabus | Print Syllabus Backup StrategiesOverview/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 |
| Performing & Managing Backups | Course | View details Course Syllabus | Print Syllabus Performing & Managing BackupsOverview/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 |
| Failure & Recovery Concepts | Course | View details Course Syllabus | Print Syllabus Failure & Recovery ConceptsOverview/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 |
| Recovery & Availability | Course | View details Course Syllabus | Print Syllabus Recovery & AvailabilityOverview/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 |
| Recovery After Loss | Course | View details Course Syllabus | Print Syllabus Recovery After LossOverview/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 |
| Secure Backup | Course | View details Course Syllabus | Print Syllabus Secure BackupOverview/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 |
| Configuring Flashback Technologies | Course | View details Course Syllabus | Print Syllabus Configuring Flashback TechnologiesOverview/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 |
| Using Flashback Technologies | Course | View details Course Syllabus | Print Syllabus Using Flashback TechnologiesOverview/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 |
| Data Transportation | Course | View details Course Syllabus | Print Syllabus Data TransportationOverview/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 |
| Performing PITR | Course | View details Course Syllabus | Print Syllabus Performing PITROverview/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 |
| Duplicating Databases | Course | View details Course Syllabus | Print Syllabus Duplicating DatabasesOverview/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 |
| Tuning RMAN | Course | View details Course Syllabus | Print Syllabus Tuning RMANOverview/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 |
| Oracle Database Instance Overview | Course | View details Course Syllabus | Print Syllabus Oracle Database Instance OverviewOverview/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 |
| Managing a Database Instance | Course | View details Course Syllabus | Print Syllabus Managing a Database InstanceOverview/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 |
| Connecting to & Configuring a Database Instance | Course | View details Course Syllabus | Print Syllabus Connecting to & Configuring a Database InstanceOverview/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 |
| Connectivity & Space Management | Course | View details Course Syllabus | Print Syllabus Connectivity & Space ManagementOverview/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 |
| Undo Feature Overview | Course | View details Course Syllabus | Print Syllabus Undo Feature OverviewOverview/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 |
| User Security Features & Configuration | Course | View details Course Syllabus | Print Syllabus User Security Features & ConfigurationOverview/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 |
| Auditing Features & Configuration | Course | View details Course Syllabus | Print Syllabus Auditing Features & ConfigurationOverview/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 |
| Backing Up & Recovering Data | Course | View details Course Syllabus | Print Syllabus Backing Up & Recovering DataOverview/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 |
| Importing & Exporting Data | Course | View details Course Syllabus | Print Syllabus Importing & Exporting DataOverview/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 |
| Database Maintenance | Course | View details Course Syllabus | Print Syllabus Database MaintenanceOverview/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 |
| Performance Tuning | Course | View details Course Syllabus | Print Syllabus Performance TuningOverview/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 |
| SQL Tuning | Course | View details Course Syllabus | Print Syllabus SQL TuningOverview/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 |
| Resource Management | Course | View details Course Syllabus | Print Syllabus Resource ManagementOverview/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 |
| Job Scheduling | Course | View details Course Syllabus | Print Syllabus Job SchedulingOverview/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 |
| Relational Database Concepts | Course | View details Course Syllabus | Print Syllabus Relational Database ConceptsOverview/Description: As an administrator or developer its 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 |
| SQL Developer | Course | View details Course Syllabus | Print Syllabus SQL DeveloperOverview/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 |
| SQL*Plus Commands | Course | View details Course Syllabus | Print Syllabus SQL*Plus CommandsOverview/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 |
| SELECT Statement Expressions & Operators | Course | View details Course Syllabus | Print Syllabus SELECT Statement Expressions & OperatorsOverview/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 |
| Restricting Output | Course | View details Course Syllabus | Print Syllabus Restricting OutputOverview/Description: Database tables often hold a large number of rows which arent 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 |
| Working with Substitution | Course | View details Course Syllabus | Print Syllabus Working with SubstitutionOverview/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 |
| Customizing Output | Course | View details Course Syllabus | Print Syllabus Customizing OutputOverview/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 |
| Data Conversion | Course | View details Course Syllabus | Print Syllabus Data ConversionOverview/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 |
| Aggregating Data | Course | View details Course Syllabus | Print Syllabus Aggregating DataOverview/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 |
| Working with Joins | Course | View details Course Syllabus | Print Syllabus Working with JoinsOverview/Description: Its 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 |
| Working with Subqueries | Course | View details Course Syllabus | Print Syllabus Working with SubqueriesOverview/Description: Its 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 |
| Data Manipulation Language | Course | View details Course Syllabus | Print Syllabus Data Manipulation LanguageOverview/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 |
| Database Transactions | Course | View details Course Syllabus | Print Syllabus Database TransactionsOverview/Description: 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 SET Operators | Course | View details Course Syllabus | Print Syllabus Working with SET OperatorsOverview/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 |
| Working with DDL | Course | View details Course Syllabus | Print Syllabus Working with DDLOverview/Description: Theres 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 |
| Introduction to Performance Tuning | Course | View details Course Syllabus | Print Syllabus Introduction to Performance TuningOverview/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 |
| Implementing Performance Tuning | Course | View details Course Syllabus | Print Syllabus Implementing Performance TuningOverview/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 |
| Automatic Workload Repository | Course | View details Course Syllabus | Print Syllabus Automatic Workload RepositoryOverview/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 |
| ADDM & ASH | Course | View details Course Syllabus | Print Syllabus ADDM & ASHOverview/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 |
| Metrics & Monitoring | Course | View details Course Syllabus | Print Syllabus Metrics & MonitoringOverview/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 |
| Application Monitoring | Course | View details Course Syllabus | Print Syllabus Application MonitoringOverview/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 |
| SQL Diagnostics | Course | View details Course Syllabus | Print Syllabus SQL DiagnosticsOverview/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 |
| Tuning Problem SQL Statements | Course | View details Course Syllabus | Print Syllabus Tuning Problem SQL StatementsOverview/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 |
| Performance Migration & Compression | Course | View details Course Syllabus | Print Syllabus Performance Migration & CompressionOverview/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 |
| Measuring SQL Performance | Course | View details Course Syllabus | Print Syllabus Measuring SQL PerformanceOverview/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 |