-
Advanced Locking Techniques
After watching this video; you will be able to describe advanced locking techniques in a relational database.
-
Architectures; Models; and Normalization
After watching this video; you will be able to identify the different database architectures; models; and perform normalization on a database.
-
Benefits of Normalization
After watching this video; you will be able to identify the benefits of a well normalized database for users.
-
Concurrency Problems (Part 1)
After watching this video; you will be able to identify the concurrency issues that can occur within a relational database.
-
Concurrency Problems (Part 2)
After watching this video; you will be able to identify the concurrency issues that can occur within a relational database.
-
Database Modeling
After watching this video; you will be able to describe entity-relationship modelling for an RDBMS.
-
DBA and the Role of Views in Security
After watching this video; you will be able to recognize how the role of a DBA can ensure security within a relational database.
-
DBMS Transactions and ACID Properties
After watching this video; you will be able to describe DBMS transactions and the ACID properties used to maintain data integrity.
-
DDL and DCL Statements
After watching this video; you will be able to identify the different DDL and DCL statements and their uses.
-
Describing Concepts for Managing Data
After watching this video; you will be able to identify relational algebra concepts; how transactions are implemented; and concurrency and locking concepts.
-
DML Statements
After watching this video; you will be able to identify the different DML statements and their uses.
-
Domain Relational Calculus
After watching this video; you will be able to identify what domain relational calculus is.
-
Dr. Codd's 13 Rules for a Relational Database
After watching this video; you will be able to identify the 13 rules published by Dr. Codd to help determine whether a database is relational.
-
Features of RDBMSs
After watching this video; you will be able to describe the features and components of an RDBMS.
-
Flat-File; Hierarchical; and XML Database Models
After watching this video; you will be able to describe the features and characteristics of flat-file; hierarchical; and XML database models.
-
Functions Performed Using SQL
After watching this video; you will be able to describe the different functions that can be performed using SQL in a relational database.
-
Fundamentals of Locking
After watching this video; you will be able to recognize the fundamentals of locking in a relational database.
-
Indexes; Triggers; and Stored Procedures
After watching this video; you will be able to describe indexes; triggers; and stored procedures and how they help to access and manage data.
-
Introduction to a DBMS
After watching this video; you will be able to describe a DBMS; its components; and advantages for users.
-
Introduction to Relational Algebra
After watching this video; you will be able to describe relational algebra; what it achieves in a database; and the basic operations.
-
Introduction to Relational Calculus
After watching this video; you will be able to describe relational calculus for a relational database .
-
Levels of a DBS Architecture
After watching this video; you will be able to describe the three levels of a DBS architecture.
-
Network and Relational Database Models
After watching this video; you will be able to describe the network and relational database models.
-
Normalization (Part 1)
After watching this video; you will be able to describe the 1NF and 2NF in normalization for a database.
-
Normalization (Part 2)
After watching this video; you will be able to describe 3NF and BCNF in normalization for a database.
-
Normalization (Part 3)
After watching this video; you will be able to describe 4NF and 5NF in normalization for a database.
-
Object-Oriented and Object-Relational DB Models
After watching this video; you will be able to describe the object-oriented and object-relational database models.
-
Relational Algebra Difference and Product
After watching this video; you will be able to describe the relational algebra difference and Cartesian product set operations.
-
Relational Algebra Division
After watching this video; you will be able to describe the native relational algebra division operation.
-
Relational Algebra Joins
After watching this video; you will be able to describe the native relational algebra theta; equi; natural; semi join operations.
-
Relational Algebra Outer Joins
After watching this video; you will be able to describe the native relational algebra outer joins.
-
Relational Algebra Projection
After watching this video; you will be able to describe the native relational algebra projection operation.
-
Relational Algebra Selection
After watching this video; you will be able to describe the native relational algebra selection operation.
-
Relational Algebra Union and Intersection
After watching this video; you will be able to describe the relational algebra union and intersection set operations .
-
Requirements of a Good Database
After watching this video; you will be able to identify the requirements that make up a good database.
-
SQL Security Concepts
After watching this video; you will be able to recognize security concepts in a relational database.
-
The ANSI/ISO Model SQL Transaction Statements
After watching this video; you will be able to describe the ANSI/ISO model and the SQL statements used to process transactions.
-
The Centralized DBMS Architecture
After watching this video; you will be able to identify the characteristics of a centralized DBMS architectures.
-
The Client/Server DBMS Architecture
After watching this video; you will be able to identify the characteristics of a client/server DBMS architecture.
-
The Distributed and Parallel DBMS Architecture
After watching this video; you will be able to identify the characteristics of a distributed and parallel DBMS architecture.
-
The N-Tier DBMS Architecture
After watching this video; you will be able to identify the characteristics of an n-tier DBMS architecture.
-
Tuple Relational Calculus
After watching this video; you will be able to identify what tuple relational calculus is.
-
Types of Constraints
After watching this video; you will be able to describe the types of constraints that can be used for data integrity.
-
Types of Database Users
After watching this video; you will be able to identify different types of database users.
-
Types of Keys in a Table
After watching this video; you will be able to describe the different types of keys that can be implemented on a column in a table.
-
Understanding Tables
After watching this video; you will be able to identify the characteristics of a table in the conceptual level of the database architecture.
-
Advanced Relationship Modeling
After watching this video; you will be able to define advanced relationships in a logical data model.
-
Boyce-Codd Normal Form
After watching this video; you will be able to perform BCNF when designing a database.
-
Conceptual Schema Integration – Steps 1 and 2
After watching this video; you will be able to perform view integration into an ERD by performing step 1: preintegration analysis and step2: comparison of schemas.
-
Conceptual Schema Integration – Steps 3 and 4
After watching this video; you will be able to perform view integration into an ERD by performing step 3: conformation of schemas and step 4: merging and restructuring schemas.
-
Creating a Conceptual ERD
After watching this video; you will be able to identify the steps for designing a database and create an ERD.
-
Creating an ERD for Designing a Database
After watching this video; you will be able to create an ERD for a database based on a scenario.
-
Data Modeling
After watching this video; you will be able to use data modeling to represent real-world concepts.
-
Database Design Methodology
After watching this video; you will be able to describe the design methodology and outline the characteristics of a well-designed database.
-
DBMS Selection
After watching this video; you will be able to determine the factors in selecting a DBMS for the physical database.
-
Defining Attributes
After watching this video; you will be able to identify the different categories of attributes that are used in a logical data model.
-
Defining Constraints and Nullability
After watching this video; you will be able to define DEFAULT and CHECK constraints and nullability for attributes in a logical data model.
-
Defining Entities
After watching this video; you will be able to define entities in the logical data model for designing a database.
-
Defining Keys for Tables
After watching this video; you will be able to describe the different keys used in a logical data model.
-
Defining Referential Integrity
After watching this video; you will be able to describe referential integrity and foreign key constraints for a logical data model.
-
Defining Relationships
After watching this video; you will be able to define relationships in a logical data model for designing a database.
-
Defining the Data Type
After watching this video; you will be able to define the data types for attributes in a logical data model.
-
Design the Logical and Physical Database
After watching this video; you will be able to create a logical data model and implement the physical database.
-
Determining Attributes and Keys
After watching this video; you will be able to determine attributes for a conceptual ERD for designing databases.
-
Determining Entities
After watching this video; you will be able to determine the entities and attributes for a conceptual ERD for designing a database.
-
Determining Relationships in an ERD
After watching this video; you will be able to determine the relationships between entities in a conceptual ERD for designing a database.
-
First Normal Form
After watching this video; you will be able to perform first normal form when designing a database.
-
Fourth and Fifth Normal Form
After watching this video; you will be able to perform fourth and fifth normal forms when designing a database.
-
Implementing Hash and Bitmap Indexes
After watching this video; you will be able to implement indexes into a physical database - Hash and Bitmap Indexes.
-
Implementing Indexes
After watching this video; you will be able to implement indexes into a physical database.
-
Implementing Views
After watching this video; you will be able to implement views into a physical database.
-
Information Gathering Techniques (Part 1)
After watching this video; you will be able to describe the different techniques used for requirements gathering when designing a database.
-
Information Gathering Techniques (Part 2)
After watching this video; you will be able to identify the advantages and disadvantages of the techniques used to conduct interviews for database design.
-
Integrating Views into an ERD
After watching this video; you will be able to intergrate views into an ERD for designing a database.
-
Modeling Entity Supertypes and Subtypes
After watching this video; you will be able to model entity supertypes and subtypes in a logical data model.
-
Overview of Creating a Conceptual Design
After watching this video; you will be able to describe what a conceptual design and an ERD are when designing a database.
-
Overview of Entities; Attributes; and Relationships
After watching this video; you will be able to define entities; attributes; and relationships for a conceptual ERD for designing a database.
-
Overview of Normalization
After watching this video; you will be able to describe normalization in relation to designing a database.
-
Overview of the Logical Data Model
After watching this video; you will be able to describe the logical data model that is used during the design process of a database.
-
Overview of the Logical Database Design
After watching this video; you will be able to describe the logical data model and its advantages.
-
Overview of the Physical Data Model
After watching this video; you will be able to describe the physical data model that is used during the design process of a database.
-
Overview of the Physical Database Design Phase
After watching this video; you will be able to describe the physical database design phase.
-
Planning and Performing the Interviews
After watching this video; you will be able to identify the factors; types of questions; and who the interviewees will include when planning the interviews for database design.
-
Requirements Gathering and Analysis Overview
After watching this video; you will be able to identify the objectives for gathering information for the requirements of the database design phase.
-
Resolving Many-to-many Relationships
After watching this video; you will be able to resolve many-to-many relationships when building a logical data model.
-
Second Normal Form
After watching this video; you will be able to perform second normal form when designing a database.
-
The Database Design Life Cycle (Part 1)
After watching this video; you will be able to describe the first two phases of the database design life cycle.
-
The Database Life Cycle (Part 2)
After watching this video; you will be able to describe the last two phases of the database design life cycle.
-
Third Normal Form
After watching this video; you will be able to perform third normal form when designing a database.
-
Three-Schema Database Architecture (Part 1)
After watching this video; you will be able to describe the three-schema database architecture.
-
Three-Schema Database Architecture (Part 2)
After watching this video; you will be able to describe the three-schema database architecture mappings and data independence provisioning.
-
Transforming Attributes to Columns
After watching this video; you will be able to transform attributes to columns in the physical database design.
-
Transforming Entities to Tables
After watching this video; you will be able to transform entities to tables in the physical database design.
-
Introduction to SQL
After watching this video; you will be able to describe SQL and its advantages and disadvantages to a relational database.
-
Talend Integration: Writing Data to a Database
After watching this video, you will be able to recognize how to write data to a database.
-
Talend Integration: Modifying Data
After watching this video, you will be able to recognize how to modify data.
-
Talend Integration: Using Dynamic Lookups
After watching this video, you will be able to identify the various dynamic lookups.
-
Talend Integration: The Talend Architecture
After watching this video, you will be able to recognize the Talend framework and various basic techniques.
-
Talend Integration: Transferring Databases
After watching this video, you will be able to recognize how to transfer from one database to another.
-
Talend Integration: Data Extraction with XML
After watching this video, you will be able to extract data with XML.
-
Talend Integration: Talend Metadata
After watching this video, you will be able to recognize Talend metadata.
-
Talend Integration: Talend Global Variables and Contexts
After watching this video, you will be able to recognize various Talend variables and contexts.
-
Talend Integration: Transforming Maps and Expressions
After watching this video, you will be able to recognize various map transformations and expressions.
-
Talend Integration: Multi-schema XML with Talend
After watching this video, you will be able to use multi-schema with XML.
-
Talend Integration: Converting CSV to XML
After watching this video, you will be able to convert a CSV file to XML.
-
Talend Integration: Converting XML to CSV
After watching this video, you will be able to convert an XML file to CSV.
-
Talend Integration: Pulling Data from a Database
After watching this video, you will be able to read data from a database.
-
Talend Integration: Pulling Data from Several Tables
After watching this video, you will be able to read data from several tables in a database.
-
Talend Integration: Talend Complex XML Conversions
After watching this video, you will be able to recognize various complex XML conversions.
-
Talend Integration: Adding Lookups to Data
After watching this video, you will be able to configure lookups in Talend for data.
-
Talend Integration: Installing a Database
After watching this video, you will be able to install a relational database system to be used with Talend.
-
Talend Integration: Creation of a New Project and Job
After watching this video, you will be able to create a new Talend project and a Talend job.
-
Talend Integration: Preparing for Talend Installation
After watching this video, you will be able to recognize the dependencies required for installing and running Talend.
-
Talend Integration: First Look at the Talend Interface
After watching this video, you will be able to recognize the various elements of the Talend UI.
-
Talend Integration: Installing Talend
After watching this video, you will be able to recognize the various ways of installing Talend step by step.
-
Talend Integration: Projects, Dependencies, and Data Files
After watching this video, you will be able to recognize how to work with projects, dependencies, and data files in Talend.