-
Advanced Insert Statements
In MySQL; you can use an advanced insert statement to insert selected column names and associated values in a new table. In this video; Aaron Sampson demonstrates the use of the advanced insert statement.
-
Advanced Join Types
In MySQL; you can use outer join queries to retrieve orphaned or missing records from multiple tables. In this video; Aaron Sampson demonstrates outer join types.
-
Advanced Update Statements
In MySQL; you can use Advanced Update statements to make updates on a single record; a single column; or a range of records and columns. In this video; Aaron Sampson demonstrates how to use Advanced Update statements to make changes to multiple records.
-
Aggregate Functions - Count
In MySQL; you can use the group by clause and the aggregate functions on numeric values to generate summary values. In this video; Aaron Sampson demonstrates how to use count; one of the aggregate functions.
-
Aggregate Functions - Min/Max
In MySQL; you can use the min and max functions to determine the lowest and highest values in any particular column. In this video; Aaron Sampson demonstrates how to use the min and max functions.
-
Aggregate Functions - Putting It All Together
In MySQL; you can use the common aggregate functions together in a statement to generate a user-friendly report. In this video; Aaron Sampson demonstrates how to use the common aggregate functions together.
-
Aggregate Functions - Sum/Average
In MySQL; you can use the sum and average functions to produce useful reports with the total sales; the average sale; total sales per quarter; annual sales by customer; by region; and so on. In this video; Aaron Sampson demonstrates how to use the sum and average functions.
-
Altering and Nested Views
In MySQL; you can use the Alter statement for altering and nested views. In this video; Aaron Sampson demonstrates how to use alter and nested views to create a view based on a previous view.
-
Basic Select Statement - Filtering and Ordering Records
In MySQL; you can use the SELECT statement to focus on specific data. In this video; Aaron Sampson demonstrates how to use the SELECT statement to filter and order records.
-
Basic Select Statement - Putting it all together
In MySQL; you can use the basic SELECT statement and pull in only the relevant fields in a table and then execute other commands to bring the information together. In this video; Aaron Sampson explains how to extract data and put it together.
-
Basic Select Statement - Selecting Columns and Limiting Records
In MySQL; you can use the SELECT statement to select data from a database and store the result in a result table. In this video; Aaron Sampson demonstrates how to use the SELECT statement to select columns and limit records.
-
Basic Select Statement - Using Range Comparison Operators
In MySQl; you can use the numeric comparison operators on the where clause to filter out data between specific ranges. In this video; Aaron Sampson explains how to use the comparison operators on the where clause.
-
Character Expression and Aliases
In MySQL; you can sort information to display only the required details from the available table columns. In this video; Aaron Sampson demonstrates how to create an expression using character-based information and use aliases to assign friendly names to the resulting column.
-
Concepts of Column Design
In MySQL; you can design and format columns for your databases. In this video; Aaron Sampson demonstrates the concepts of column design.
-
Concepts of Table Design
In MySQL; you can design your tables to store data in databases. In this video; Aaron Sampson demonstrates the concepts of table design.
-
Core Concepts of an RDBMS
Working with MySQL requires a thorough understanding of RDBMS structures. In this video; Aaron Sampson discusses the core concepts of RDBMS.
-
Creating Advanced Procedures - Using Input Parameters
In MySQL; you can create stored procedures; which reduce query-handling time by reusing already saved parameters. In this video; Aaron Sampson demonstrates how to use input parameters to allow dynamic values to pass each time the procedure is called.
-
Creating Advanced Procedures - Using Insert Statement
In MySQL; you can edit the existing records within tables. In this video; Aaron Sampson demonstrates how to create new records by using the Insert statement in a Procedure.
-
Creating Advanced Procedures - Using Loops
In MySQL; you can use stored procedures which include logic and functionality that select statements and views can't accommodate; to achieve time-saving. In this video; Aaron Sampson demonstrates how to use the stored procedures to edit existing records.
-
Creating Advanced Views
In MySQL; you can create a reusable Select statement; save it as a view; and then reuse it selecting it from the Views. In this video; Aaron Sampson demonstrates how to create and use reusable Select statement to edit existing records.
-
Determining Table and Column Properties
MySQL allows users to view and edit the table and column properties that have been defined in a database. In this video; Aaron Sampson demonstrate how to view and modify the columns in a database.
-
Exporting Result Sets
MySQL allows users to export data to external files. In this video; Aaron Sampson explains how to export data by using the Export/Import feature.
-
Filtering Data Sets
MySQL allows users to perform several actions on the result set such as editing; exporting; and filtering data. In this video; Aaron Sampson explains how to filter data sets.
-
Getting Started with Character Functions
MySQL provides several character-based functions that you can use to operate on string or text-based information. In this video; Aaron Sampson demonstrates how to use character-based functions.
-
Getting Started with Date/Time Functions
In MySQL; you can use functions with particular uses and capabilities to manipulate any type of data. In this video; Aaron Sampson demonstrates how to use some common date and time functions.
-
Getting Started with DDL Statements - Alter and Drop Database Statement
Using MySQL Drop and Alter statements; you can easily drop an entire database without emptying it like Tables or alter database options and adjust properties. In this video; Aaron Sampson demonstrates how to use the Drop and Alter statements to edit existing records.
-
Getting Started with DDL Statements - Alter and Drop Table Statement
In MySQL; you can make changes to the table by using the Alter statement and delete the table by using the Drop statement. In this video; Jamie Campbell demonstrates the use and syntax of the Alter and Drop Table statements.
-
Getting Started with DDL Statements - Create Database Statement
In MySQL; you can use the DDL statements to create the database object. In this video; Aaron Sampson demonstrates how to create a new database.
-
Getting Started with DDL Statements - Create Procedure Statement
In MySQL; you can learn to create the stored procedure statement. In this video; Aaron Sampson demonstrates how to create stored procedure statement.
-
Getting Started with DDL Statements - Create Table Statement
In MySQL; tables are the means for storing data. In this video; Aaron Sampson explains how to create tables in MySQL.
-
Getting Started with DDL Statements - Create View Statement
In MySQL; you can use DDL statements to retrieve records from tables. In this video; Aaron Sampson demonstrates how to use create view statements to retrieve desired information from tables.
-
Getting Started with Delete Statements
In MySQL; you can use the delete statement to remove existing records from a table. In this video; Aaron Sampson demonstrates how to use the delete statement in tables.
-
Getting Started with Functions
MySQL provides several numeric functions that allow users to gather relevant information from tables that contain a lot of information. In this video; Aaron Sampson explains how to use some basic numeric functions.
-
Getting Started with Group By and Aggregate Functions
In MySQL; you can use the Group by and aggregate functions to view totals that will help you understand your business model and generate a report for your users. In this video; Aaron Sampson demonstrates how to use the Group by and aggregate functions.
-
Getting Started with Insert Statements
In MySQL; you can use the Data Modification Language or DML statements to change the underlying database or the tables or the records in the table. In this video; Aaron Sampson demonstrates how to use the Insert statement to edit existing records.
-
Getting Started with Multi-Table Queries
In MySQL; you can use queries to retrieve data from multiple tables. In this video; Aaron Sampson demonstrates multi-table queries using join statements.
-
Getting Started with Workbench
The MySQL Workbench is a unified visual tool and the primary administrative interface for accessing and configuring MySQL databases. In this video; Aaron Sampson demonstrates how to access the server configuration and set its value in MySQL.
-
Getting Started with System Functions
In addition to providing numeric functions; MySQL also provides several system functions that you can also use as criteria to compare relevant information. In this video; Aaron Sampson explains how to use system functions.
-
Getting Started with Update Statements
In MySQL; you can edit the existing records within tables. In this video; Aaron Sampson demonstrates how to use the update statement to edit existing records.
-
Getting Started with Views
In MySQL; views refer to stored select statements that you can reuse to retrieve information from base tables. In this video; Aaron Sampson demonstrates how to use views.
-
Inserting and Deleting Data
My SQL provides the option of inserting and deleting information. In this video; Aaron Sampson demonstrates how to insert and delete records from a table.
-
Introducing Visual Query Builders
In MySQL; you can use visual query builders to build queries and avoid typos and syntax errors. In this video; Aaron Sampson demonstrates the use of a visual query editing tool in MySQL.
-
Multi-Table/Multi-Join Queries
In MySQL; you can use queries to retrieve data from multiple tables. In this video; Aaron Sampson demonstrates multi-table queries using two join statements.
-
Workbench - Configuring the Options File
In MySQL; you can configure the Options File from the MySQL Workbench to administer and design the database structure. In this video; Aaron Sampson demonstrates how to configure Options File.
-
Workbench - Connecting to Databases
In MySQL; you can use the MySQL Workbench wizard to connect to databases. In this video; Aaron Sampson demonstrates how to configure the detailed options of the connections.
-
Workbench - Creating New Users
In MySQL; you need to create new user accounts to establish new connections to your MySQL environment. In this video; Aaron Sampson demonstrates how to create additional user accounts.
-
Workbench - Server Status and Navigation
MySQL provides an efficient and easy-to-use interface. In this video; Aaron Sampson explains the navigational elements and the Server Status.
-
Workbench - Status and System Variables
In MySQL; you get details about the server and the databases within that server through the Status and System Variables option in Workbench. In this video; Aaron Sampson demonstrates various options within Status and System Variables.
-
Workbench - Users and Privileges
In MySQL; you can assign administrative roles with different privileges to users from the Workbench. In this video; Aaron Sampson demonstrates various options within Users and Privileges tab.
-
Numeric Expression and Aliases
MySQL provides several numeric expressions that you can use to analyze data. In this video; Aaron Sampson explains how to use some basic comparison operators and the alias operator.
-
Online Documentation - Comparison Operators
In MySQL; you can locate additional documentation and options for comparison operators in the Developer Zone. In this video; Aaron Sampson explains online documentation for comparison operators.
-
Selecting and Downloading Your Edition
There are several editions of MySQL available and you can select the appropriate edition that will suit your database needs. In this video; Aaron Sampson demonstrates how to select the appropriate edition of MySQL and download it.
-
Understanding Comparison Operators; Expressions; and Aliases
In MySQL; you can compare values and make your reports more user-friendly by using comparison operators; expressions; and aliases. In this video; Aaron Sampson explains the uses of comparison operators; expressions; and aliases in MySQL queries.
-
Understanding DDL Statements
In MySQL; you can use the Data Definition Language (DDL) statements to modify databases and tables and the objects within the databases and tables. In this video; Aaron Sampson explains how to use the DDL statements.
-
Understanding DML Statements
In MySQL; you can use Data Manipulation Language statements or DML statements to modify table values in the underlying tables. In this video; Aaron Sampson explains how to use the insert; delete; and update statements with examples.
-
Understanding Events
In MySQL; you can use events to schedule repetitive tasks in a database. In this video; Aaron Sampson demonstrates how to use events.
-
Understanding Functions
In MySQL; you can use various functions to produce rich result sets when working with the data. In this video; Aaron Sampson discusses the concepts of functions in MySQL.
-
Understanding Group By and Aggregate Functions
MySQL provides the Group by clause and the associated aggregate functions to perform several mathematical functions that help users to efficiently analyze data. In this video; Aaron Sampson explains the use of the Group by clause and aggregate functions.
-
Understanding Multi-Table Queries
In MySQL; you can use the join statement to pull in information from one or more related tables. In this video; Aaron Sampson discusses the concept of the join statement.
-
Understanding Select Statement Concepts
In MySQL; you can retrieve data from your database objects by using Select statements. In this video; Aaron Sampson demonstrates the Select statement and its key elements; syntax; and optional components.
-
Understanding Stored Procedures
The MySQL database supports stored procedures; which can be called and executed by applications. In this video; Aaron Sampson discusses the uses and limitations of stored procedures.
-
Understanding Triggers
In MySQL; triggers are called automatically in response to Data Manipulation Language statements. In this video; Aaron Sampson explains the concept of triggers.
-
Understanding Views
Views in MySQL are objects that are stored in a database; but are select statements. In this video; Aaron Sampson explains the concept of views.
-
Using Character Comparison Operators
In addition to numeric characters; MySQL also provides several text-based comparison operators. In this video; Aaron Sampson explains how to use text-based characters.
-
Using Numeric Comparison Operators
MySQL provides several numeric and text-based operators to pull out and analyze relevant information in a table. In this video; Aaron Sampson explains how to use the basic numeric operators.
-
Viewing and Editing Data
In MySQL; you can apply; cancel; and make changes to existing records. In this video; Aaron Sampson demonstrates how to view and edit existing data in the MySQL databases.
-
AND v. OR Conditions
In this video; Aaron Sampson outlines the uses of the AND versus OR conditions.
-
Backup Frequency and Schedules
In this video; Aaron Sampson describes backup frequency and schedules to protect database records in MySQL.
-
Comparing Storage Engine Features
In this video; Aaron Sampson describes the features of storage engines available for MySQL databases.
-
Creating a Clustered Index
In this video; Aaron Sampson demonstrates how to create a clustered index.
-
Creating a Covered Index
In this video; Aaron Sampson demonstrates how to create a covered index.
-
Creating a Secondary Index
In this video; Aaron Sampson demonstrates how to create secondary indexes.
-
Creating and Using Benchmarks
In this video; Aaron Sampson demonstrates how to create and use benchmarks in MySQL.
-
Creating and Using Transactions
In this video; Aaron Sampson demonstrates how to implement transactions in MySQL.
-
Creating Multicolumn Indexes
In this video; Aaron Sampson demonstrates how to create multicolumn indexes.
-
Creating Multiple Instances
In this video; Aaron Sampson discusses installing multiple MySQL instances on a single server.
-
Creating Partitioned Tables
In this video; Aaron Sampson demonstrates how to create partitioned tables in MySQL.
-
Creating Triggers
In this video; Aaron Sampson demonstrates how to use the before and after triggers to record; and react to database changes.
-
Defining Security Policies
In this video; Aaron Sampson describes the security policies implemented in MySQL.
-
Determining and Planning Capacity
Determining and planning capacity in MySQL can be a challenge because you need to determine whether the infrastructure you have in place is adequate to meet the performance demands of your systems. In this video; Aaron Sampson discusses capacity planning.
-
Determining Index Effectiveness
Indexes are used to traverse through data and locate content effectively in a limited period of time. In this video; Aaron Sampson describes how to determine the effectiveness of an index.
-
Encryption and Certificates
In this video; Aaron Sampson outlines the uses of encryption and certificates in MySQL.
-
Exporting a Database
In this video; Aaron Sampson demonstrates how to export a database by using the Data Export feature of MySQL.
-
Identifying Different Data Types and Usage
In this video; Aaron Sampson describes the various types of data types in MySQL.
-
Identifying Optimization Strategies for InnoDB Usage
In this video; Aaron Sampson describes optimization strategies for InnoDB usage in MySQL.
-
Identifying Queries Requiring Optimization
MySQL uses a query optimization process to retrieve data efficiently by examining the code that has been entered against the underlying data that needs to be retrieved. In this video; Aaron Sampson discusses a few techniques that can optimize queries and reduce the amount of time to retrieve data.
-
Implementing Replication
In this video; Aaron Sampson describes the steps involved in implementing MySQL replication.
-
Importing a Database
In this video; Aaron Sampson demonstrates how to import a database by using the Data Import/Restore feature of MySQL.
-
Indexing - Best Practices
In this video; Aaron Sampson discusses indexing best practices for MySQL database queries.
-
InnoDB v. MyISAM
Several storage engines are available for MySQL and the most common ones are InnoDB and MyISAM. In this video; Aaron Sampson outlines the differences between InnoDB and MyISAM.
-
Query Optimizer
In this video; Aaron Sampson describes the MySQL Query Optimizer.
-
Operating System Optimization
In this video; Aaron Sampson discusses how to optimize operating systems for MySQL servers.
-
Optimizing AND Conditions
In this video; Aaron Sampson outlines the uses of AND condition to determine its effect on a query by changing the required indexes.
-
Optimizing OR Conditions
In this video; Aaron Sampson demonstrates how to optimize the OR condition query in MySQL.
-
Other Index Types
In this video; Aaron Sampson describes spatial index; full text index; TokuDB index; and InfiniDB index types in MySQL.
-
Overview of Identifiers
In this video; Andy Alfred demonstrates how to work with the process object in Node.js.
-
Partitioning Tables
In this video; Aaron Sampson describes how to check whether a table has been partitioned in MySQL.
-
Performing a Backup
In this video; Aaron Sampson demonstrates how to perform a database backup using the mysqldump utility of MySQL.
-
Performing a Recovery
In this video; Aaron Sampson demonstrates how to restore a backup in a command prompt environment in MySQL.
-
Performing Data and Index Defragmentation
In this video; Aaron Sampson outlines the steps to perform data and index defragmentation.
-
Performing Table and Index Maintenance
In this video; Aaron Sampson demonstrates performing table and index maintenance in MySQL.
-
Planning for Disasters
In this video; Aaron Sampson describes how to plan for disasters and protect MySQL information in the event of disasters.
-
Querying Data Using Subqueries
In MySQL; a subquery can be nested within another query in order to determine unknown values before the parent query is run. In this video; Aaron Sampson demonstrates how to query data by using subqueries.
-
Querying Data Using the UNION Clause
The MySQL UNION statement is used to combine results from two or more queries into a single result set. In this video; Aaron Sampson demonstrates how to query data by using the UNION statement.
-
Recovering Transactions
In this video; Aaron Sampson demonstrates how to recover transactions.
-
Replication Configurations
In this video; Aaron Sampson describes replication configuration in MySQL.
-
Securing Backups and Logs
In this video; Aaron Sampson describes how to secure and encrypt backups in MySQL.
-
Selecting a Storage Engine
Storage engines and server optimization are directly linked to the performance; stability; and protection of MySQL databases. In this video; Aaron Sampson describes how to identify the storage engine that best supports the desired performance features.
-
Server Hardware Optimization
In this video; Aaron Sampson discusses how to optimize server hardware for MySQL databases.
-
Setting Transaction Isolation Levels
In this video; Aaron Sampson demonstrates how to change transaction isolation levels in MySQL.
-
The Recovery Process
In this video; Aaron Sampson discusses backup and recovery types for MySQL servers.
-
Tuning Servers
MySQL is a database management system that runs on both the web and a server. In this video; Aaron Sampson describes the considerations involved in tuning MySQL Servers.
-
Understanding ACID Transactions
In this video; Aaron Sampson outlines the Autonomous; Consistent; Isolated; and Durable (ACID) transactions.
-
Understanding Backup and Recovery
In this video; Aaron Sampson describes the importance of backup and recovery in MySQL.
-
Understanding Before and After Triggers
In MySQL; triggers are statements stored in the database; and they are executed when a particular event occurs for the table. In this video; Aaron Sampson discusses BEFORE and AFTER triggers.
-
Understanding Benchmarks and Profiling
The performance of MySQL servers is a key component in maintaining a stable; consistent; and secure database. In this video; Aaron Sampson describes how to determine the performance of systems and identify where improvements can be made.
-
Understanding Clustered Indexes
When you use InnoDB storage engine; every table has a clustered index. In this video; Aaron Sampson describes the clustered indexes in MySQL.
-
Understanding Constraints
After watching this video; you will be able to recognize how constraints help to ensure the integrity and consistency of your tables.
-
Understanding Covered Indexes
In this video; Aaron Sampson explains the concept of covering indexes.
-
Understanding Data and Index Fragmentation
In this video; Aaron Sampson describes the concept of data and index fragmentation in MySQL.
-
Understanding DCL Statements
In this video; Aaron Sampson describes the use of Data Control Language; or DCL statements; used to assign user permissions to database objects.
-
Understanding Hash Indexes
In this video; Aaron Sampson outlines the uses of hash indexes in MySQL.
-
Understanding Index Maintenance
Keeping the database indexes and tables updated and running at peak performance requires users to maintain the indexes. In this video; Aaron Sampson describes index maintenance in MySQL.
-
Understanding Index Structure
Index structures can have a great impact on the performance of a database. In this video; Aaron Sampson describes the types of index structures available in MySQL.
-
Understanding Indexes
Indexes are used to traverse through information and locate required content effectively in a limited period of time. In this video; Aaron Sampson outlines the use of indexes in MySQL.
-
Understanding Input and Output Parameters
In this video; Aaron Sampson explains the IN; OUT; and INOUT parameters for MySQL.
-
Understanding Join Types
In this video; Aaron Sampson demonstrates how to recognize and define Join Types.
-
Understanding Locks and Deadlocks
In this video; Aaron Sampson describes the concept of locks and deadlocks in MySQL.
-
Understanding Metadata
In this video; Aaron Sampson describes metadata in MySQL.
-
Understanding Operating System Security
In this video; Aaron Sampson describes operating system security in MySQL.
-
Understanding Optimizer Hints
In this video; Aaron Sampson explains how to use hints to improve Query Optimizer performance using MySQL.
-
Understanding Partitions
In this video; Aaron Sampson describes the concept of partitioning large objects into smaller ones to enhance the performance in MySQL.
-
Understanding Prepared Statements
In this video; Aaron Sampson describes prepared statements in MySQL.
-
Understanding Query Analysis Tools
In this video; Aaron Sampson describes the query analysis tools.
-
Understanding Replication
In this video; Aaron Sampson describes the concept of replication in MySQL.
-
Understanding Secondary Indexes
In this video; Aaron Sampson describes the concept of secondary indexes in MySQL.
-
Understanding Security
In this video; Aaron Sampson describes the various features used to protect and secure databases in MySQL.
-
Understanding SHOW GLOBAL STATUS
In this video; Aaron Sampson outlines the uses of SHOW STATUS and SHOW GLOBAL STATUS statements in MySQL.
-
Understanding Statistics
In this video; Aaron Sampson outlines the use of statistics in MySQL.
-
Understanding Storage Engines
In this video; Aaron Sampson describes the features of a storage engine in MySQL.
-
Understanding Stored Procedure Recursion
In MySQL; recursion is the ability of a stored procedure to reference or call itself repeatedly until the execution of the code is complete. In this video; Aaron Sampson discusses stored procedure recursion.
-
Understanding Stored Procedures vs. Stored Functions
In this video; Aaron Sampson describes how to recognize the difference between stored procedures and stored functions in MySQL.
-
Understanding the EXPLAIN Statement
In this video; Aaron Sampson demonstrates how to use the EXPLAIN statement.
-
Understanding the Syntax for Subqueries
In MySQL; a subquery is a query that is nested inside of another query. In this video; Aaron Sampson describes the syntax for subqueries.
-
Using Comments in Statements
In this video; Aaron Sampson describes the purpose of comments and demonstrates the use of different comment characters in MySQL statements.
-
Using Different Storage Engines
In this video; Aaron Sampson demonstrates how to alter the default storage engine.
-
Using Expressions and Functions for Data Types
In this video; Aaron Sampson demonstrates how to use expressions and functions for data types.
-
Using Full Joins
In this video; Aaron Sampson demonstrates how to get a full join in MySQL.
-
Using Index Hints
In this video; Aaron Sampson demonstrates how to use index hints in MySQL.
-
Using INFORMATION_SCHEMA
In this video; Aaron Sampson demonstrates the functionality of INFORMATION_SCHEMA Tables in MySQL.
-
Using Input/Output Parameters
In this video; Aaron Sampson describes the use of input and output parameters to create a stored procedure.
-
Using Prepared Statements
The PREPARE statement in MySQL creates reusable code that can be run as many times as needed without having to reoptimize; reparse; and recache the results every time it is executed. In this video; Aaron Sampson demonstrates how to use the PREPARE statement.
-
Using PRIMARY/FOREIGN Keys
In this video; Aaron Sampson describes how to use Primary and Foreign Keys to implement integrity in MySQL records.
-
Using Profiling Tools
MySQL offers many profiling tools that are designed specifically for gathering performance data so that you can understand better how the systems are performing. In this video; Aaron Sampson discusses profiling tools in MySQL.
-
Using SHOW GRANTS
In this video; Aaron Sampson describes how to use the show grants statement in MySQL.
-
Using SHOW PRIVILEGES
In this video; Aaron Sampson describes the use of show privileges statement in MySQL.
-
Using the Grant Statement
In this video; Aaron Sampson demonstrates how to use the GRANT statement.
-
Using the load data Statement to Import Data
The load data statement is an efficient way of importing large amounts of data into MySQL tables. In this video; Aaron Sampson demonstrates how to use the load data statement to import data into a table.
-
Using the REPLACE statement to Insert Data
The REPLACE statement in MySQL can be used to insert or update data in a database table. In this video; Aaron Sampson demonstrates how to use the REPLACE statement.
-
Using the Revoke Statement
In this video; Aaron Sampson demonstrates how to use the revoke statement.
-
Using the SHOW INDEX Statement
In this video; Aaron Sampson demonstrates how to use the SHOW INDEXES statement to retrieve information about the index values in the MySQL database.
-
Using the SHOW PROFILE Statement
In this video; Aaron Sampson demonstrates how to use the show profile statement to gather statistics on query execution time in MySQL.
-
Using the Truncate Statement to Remove Data
The TRUNCATE statement can remove data from a table while preserving the table's structure. In this video; Aaron Sampson demonstrates how to use the TRUNCATE statement to remove data.
-
Using Triggers for Security
In this video; Aaron Sampson demonstrates how to use triggers for security in MySQL.
-
Using UNIQUE Indexes
In this video; Aaron Sampson demonstrates the use of unique indexes in ensuring data integrity in MySQL.
-
Using Views for Security
In this video; Aaron Sampson demonstrates the use of view statement to secure information in MySQL.
-
Viewing Metadata for Database Objects Using Various Methods
Metadata is descriptive information about an individual data item. In this video; Aaron Sampson demonstrates how to view metadata for database objects.
-
Database Server Consolidation Overview
In SQL Server; you can restructure an existing database. In this video; Aaron Sampson discusses how to consolidate database servers.
-
Denormalization
In Microsoft SQL Server 2014; you can perform denormalization process for a database to undo the normalization process performed earlier. In this video; Aaron Sampson demonstrates the features; usage scenarios; and advantages of database denormalization.
-
Using Futon with CouchDB in Practice
In NoSQL; you can use Futon; the built-in; web-based interface to interact with CouchDB. This front end administrative console allows you to create and manage databases and document stores. In this video; Chuck Easttom demonstrates how to use Futon with CouchDB.
-
Using Outer Joins
In this video; Aaron Sampson describes the uses of Outer Join statements in MySQL.
-
Installing on Windows
You can install and configure MySQL on a Microsoft Windows platform. In this video; Aaron Sampson demonstrates how to install MySQL in Windows system.
-
Introducing
MySQL is an open-source database platform. In this video; Aaron Sampson discusses the advantages of using MySQL.
-
Understanding Data Security
In this video; Aaron Sampson describes the data security features in MySQL.
-
Understanding Relationships
In MySQL; you will work with one-to-many; one-to-one; and many-to-many relationships. In this video; Aaron Sampson discusses the relationship types in database management systems.
-
Importing Data
MySQL provides the ability to import external Excel file information to the SQL database. In this video; Aaron Sampson explains how to import data.
-
Using Inner Joins
In this video; Aaron Sampson demonstrates how to implement an Inner Join statement in MySQL.
-
Backup Types
In this video; Aaron Sampson describes the backup types available in MySQL.
-
Creating and Using Stored Functions
In this video; Aaron Sampson demonstrates how to create and use stored functions in MySQL.
-
Introduction: Initial Configuration of the MySQL Server
After watching this video, you will be able to properly configure the MySQL Server.
-
Introduction: Introduction to MySQL Workbench
After watching this video, you will be able to describe what MySQL Workbench is and recognize the various functions it can perform.
-
Introduction: Options File Configuration
After watching this video, you will be able to configure the Options File to change the behavior of the MySQL server.
-
Introduction: MySQL Workbench Connections
After watching this video, you will be able to use MySQL Workbench to create and maintain database connections .
-
Introduction: MySQL Connection Navigator
After watching this video, you will be able to use the Navigator Window to perform common server management tasks.
-
Introduction: Status and System Variables
After watching this video, you will be able to use MySQL Workbench to define and configure both system variables and status variables.
-
Introduction: New User Creation
After watching this video, you will be able to use MySQL Workbench to create and manage new user accounts.
-
Introduction: Users and Privileges Management
After watching this video, you will be able to manage the permissions each user has within your MySQL environment.
-
Introduction: Exercise: Working with MySQL Workbench
After watching this video, you will be able to work with MySQL Workbench to perform various administrative tasks.
-
Database Design Fundamentals: RDBMS Essentials
After watching this video, you will be able to describe the key components of a RDBMS, including table structure, keys, and relationships.
-
Database Design Fundamentals: Table Design Concepts
After watching this video, you will be able to define the standards used in tables for data storage, such as removing duplicates, breaking down fields, and the use of primary keys.
-
Database Design Fundamentals: Column Design Concepts
After watching this video, you will be able to define the standards used in column design and properties, such as auto increment columns, default and null values, and modifying size and format.
-
Database Design Fundamentals: Table and Column Properties
After watching this video, you will be able to use MySQL Workbench to determine table and column properties.
-
Database Design Fundamentals: Relationships
After watching this video, you will be able to define table relationships in a database, including one-to-many, one-to-one, and many-to-many.
-
Database Design Fundamentals: Normalization
After watching this video, you will be able to describe database normalization and identify the various levels of normalization.
-
Database Design Fundamentals: Benefits of Database Normalization
After watching this video, you will be able to identify the benefits achieved through the normalization process.
-
Database Design Fundamentals: What is Full Stack Development (FSD)?
After watching this video, you will be able to describe what Full Stack Development is and the various tasks a developer would perform in each area.
-
Database Design Fundamentals: Anatomy of a Full Stack Environment
After watching this video, you will be able to describe the components of a full stack environment and how each component interacts.
-
Database Design Fundamentals: FSD and MySQL
After watching this video, you will be able to describe the most common software stacks available that employ MySQL.
-
Database Design Fundamentals: Exercise: Database Design and FSD Concepts
After watching this video, you will be able to describe the overall structure of a RDBMS and the FSD environment.
-
DDL Statements: Data Definition Language (DDL) Statements
After watching this video, you will be able to describe the use of the CREATE, ALTER, and DROP DDL statements, and recognize their basic syntax.
-
DDL Statements: Creating MySQL Databases
After watching this video, you will be able to use the CREATE DATABASE DDL statement to create a new database with specific syntax and parameters.
-
DDL Statements: Altering and Dropping MySQL Databases
After watching this video, you will be able to use the ALTER and DROP DDL statements to change and drop an existing database.
-
DDL Statements: Creating MySQL Tables
After watching this video, you will be able to use the CREATE TABLE DDL statement to create new tables and define their properties.
-
DDL Statements: Altering and Dropping MySQL Tables
After watching this video, you will be able to use the ALTER and DROP DDL statements to change and drop an existing table.
-
DDL Statements: Creating and Altering Views
After watching this video, you will be able to use the CREATE and ALTER VIEW DDL statements to create and alter views in MySQL databases.
-
DDL Statements: Querying Views
After watching this video, you will be able to use views to retrieve records from tables and other views.
-
DDL Statements: Nested Views
After watching this video, you will be able to create nested views.
-
DDL Statements: Advanced Views
After watching this video, you will be able to create advanced views using join statements and use aggregate functions.
-
DDL Statements: Exercise: Using DDL Statements and Views in MySQL
After watching this video, you will be able to use DDL statements to work with database objects and views.
-
Query & Performance Optimization: Optimizing the Server Hardware
After watching this video, you will be able to recognize options for optimizing the configuration for the server running MySQL.
-
Query & Performance Optimization: Optimizing MySQL
After watching this video, you will be able to configure MySQL values to fine-tune the instance for optimal performance.
-
Query & Performance Optimization: The MONyog Monitoring Tool
After watching this video, you will be able to download and install the MONyog performance monitoring tool for MySQL.
-
Query & Performance Optimization: Using MONyog
After watching this video, you will be able to use MONyog to monitor and configure OS settings to optimize MySQL performance.
-
Query & Performance Optimization: Exercise: Performance Optimization in MySQL
After watching this video, you will be able to recognize various methods available for optimizing the overall performance of MySQL, including optimizing queries.
-
Query & Performance Optimization: Understanding Query Optimization
After watching this video, you will be able to recognize potential problems affecting query run time and how to eliminate these problems.
-
Query & Performance Optimization: EXPLAIN Statement Fundamentals
After watching this video, you will be able to describe the purpose of the EXPLAIN statement and the results it returns.
-
Query & Performance Optimization: Visual Explain Plan
After watching this video, you will be able to use the Visual Explain feature to generate a visual representation of a MySQL query.
-
Query & Performance Optimization: Using the EXPLAIN Statement
After watching this video, you will be able to use the EXPLAIN statement to analyze query execution in the MySQL client.
-
Query & Performance Optimization: The Query Optimizer
After watching this video, you will be able to use the query optimizer to control query plan evaluation.
-
Query & Performance Optimization: Optimizing InnoDB Storage
After watching this video, you will be able to identify strategies available for optimizing InnoDB storage usage.
-
GIS, Cloud, & Connectors: Migrating to Amazon RDS
After watching this video, you will be able to describe MySQL setup and migration using the Amazon Relational Database Service (RDS) and the Amazon Database Migration Service (DMS).
-
GIS, Cloud, & Connectors: Integrating with Oracle Cloud
After watching this video, you will be able to describe provisioning and integrating MySQL on the Oracle Cloud using Oracle's Cloud Services .
-
GIS, Cloud, & Connectors: Using the MySQL JDBC Connector
After watching this video, you will be able to use the Java Database Connectivity (JDBC) connector to access MySQL from within a Java app.
-
GIS, Cloud, & Connectors: Working with the ADO.NET Connector
After watching this video, you will be able to work with the ADO.NET MySQL connector within Visual Studio.
-
GIS, Cloud, & Connectors: Using MySQL via the Python Connector
After watching this video, you will be able to use the Python connector to access MySQL from within a Python App.
-
GIS, Cloud, & Connectors: Exercise: Using Geospatial Data Types
After watching this video, you will be able to describe and use geospatial database types in MySQL.
-
Database Design Fundamentals: Normal Forms
After watching this video, you will be able to describe the normalization process through each level of the normal forms.
-
GIS, Cloud, & Connectors: Using Geospatial Data in MySQL
After watching this video, you will be able to create and use geospatial tables, fields, and indexes to manage GIS based data in MySQL.
-
GIS, Cloud, & Connectors: Working with the GIS Data Types
After watching this video, you will be able to work with the basic Point, Polygon, and Geometry spatial data types in MySQL.
-
GIS, Cloud, & Connectors: Using the Geospatial Collection Data Types
After watching this video, you will be able to use the MySQL collection data types like Multipoint and Multilinestring to manage collections of values.
-
GIS, Cloud, & Connectors: Using the Azure MySQL Service
After watching this video, you will be able to describe a MySQL deployment using the Microsoft Azure cloud service.
-
Manipulating Data: Importing Data
After watching this video, you will be able to use MySQL Workbench to import existing data into your tables.
-
Manipulating Data: Data Manipulation Language (DML) Statements
After watching this video, you will be able to describe the use of the INSERT, UPDATE, and DELETE DML statements, and recognize their basic syntax.
-
Manipulating Data: Basic INSERT Statements
After watching this video, you will be able to work with the INSERT statement to add new data to your MySQL tables.
-
Manipulating Data: Basic UPDATE Statements
After watching this video, you will be able to work with the UPDATE statement to modify existing data in your MySQL tables.
-
Manipulating Data: DELETE Statements
After watching this video, you will be able to work with the DELETE statement to remove existing data from your MySQL tables.
-
Manipulating Data: Advanced INSERT Statements
After watching this video, you will be able to use additional INSERT options to add new data to your MySQL tables.
-
Manipulating Data: Advanced UPDATE Statements
After watching this video, you will be able to use additional UPDATE options to modify existing data in your MySQL tables.
-
Manipulating Data: Inserting and Deleting Data
After watching this video, you will be able to use MySQL Workbench to insert and delete data in your tables.
-
Manipulating Data: Viewing and Editing Data
After watching this video, you will be able to use MySQL Workbench to view and modify existing data in your tables.
-
Manipulating Data: Filtering Data
After watching this video, you will be able to use MySQL Workbench to retrieve data from your tables using filters.
-
Manipulating Data: Exporting Data
After watching this video, you will be able to use MySQL Workbench to export existing data in your tables to an external file.
-
SELECT Statement & Operators: Control Flow Operators
After watching this video, you will be able to use control flow operators to control the results returned by SELECT statements.
-
SELECT Statement & Operators: Exercise: Creating SELECT Statements
After watching this video, you will be able to work with various operator types to create effective SELECT statements.
-
Manipulating Data: Exercise: Using DML Statements and MySQL Workbench
After watching this video, you will be able to manipulate data using the DML statements and MySQL Workbench.
-
SELECT Statement & Operators: SELECT Statement Fundamentals
After watching this video, you will be able to recognize the basic syntax of the SELECT statement and how it is used to retrieve data.
-
SELECT Statement & Operators: Record Filtering and Ordering
After watching this video, you will be able to create SELECT statements using the WHERE and ORDER BY clauses to limit and order returned records.
-
SELECT Statement & Operators: The INSERT... SELECT Statement
After watching this video, you will be able to create INSERT INTO statements using SELECT to copy data between tables.
-
SELECT Statement & Operators: SELECT Statements and Joins
After watching this video, you will be able to create SELECT statements using the JOIN clause to return records from multiple tables.
-
SELECT Statement & Operators: SELECT Statements and Unions
After watching this video, you will be able to create SELECT statements using the UNION clause to combine the result of multiple SELECT statements into a single returned dataset.
-
SELECT Statement & Operators: Comparison Operators
After watching this video, you will be able to use comparison operators on both number and string values in SELECT statements.
-
SELECT Statement & Operators: Logical Operators
After watching this video, you will be able to use logical operators to test values in SELECT statements.
-
SELECT Statement & Operators: Assignment Operators
After watching this video, you will be able to use assignment operators in SELECT statements to assign values to variables.
-
Working with Functions: String Comparison Functions
After watching this video, you will be able to use the string comparison functions to compare one string to another.
-
Working with Functions: Date/Time Functions
After watching this video, you will be able to work with date and time values, including how to modify the way they are displayed.
-
Working with Functions: Exercise: Using Functions in Queries
After watching this video, you will be able to create queries that use various MySQL functions to return specific results from the database.
-
Working with Functions: Introduction to Functions in MySQL
After watching this video, you will be able to describe what functions are, what they are used for, and the different categories of functions available in MySQL.
-
Working with Functions: The GROUP BY Clause and Aggregate Function Basics
After watching this video, you will be able to recognize the syntax of the GROUP BY clause in a SELECT statement and the basic aggregate functions that are available.
-
Working with Functions: Using the GROUP BY Clause and Aggregate Functions
After watching this video, you will be able to work with the GROUP BY clause and aggregate functions in SELECT statements to filter result sets.
-
Working with Functions: Numeric Functions
After watching this video, you will be able to work with numeric functions such as ROUND, POW, CEILING, and FLOOR.
-
Working with Functions: The COUNT Function
After watching this video, you will be able to use the COUNT function to determine the number of rows returned by a query.
-
Working with Functions: MIN and MAX Functions
After watching this video, you will be able to use the MIN and MAX functions in queries to return the smallest and largest values.
-
Working with Functions: SUM and AVERAGE Functions
After watching this video, you will be able to use the SUM and AVERAGE functions to calculate the total and average of the values returned by a query.
-
Working with Functions: Character Functions
After watching this video, you will be able to work with various character functions in queries, including CONCAT, LEFT, RIGHT, and LENGTH.
-
Query & Performance Optimization: Creating Indexes
After watching this video, you will be able to work with clustered and secondary indexes on a table .
-
Query & Performance Optimization: Maintaining Indexes
After watching this video, you will be able to recognize general methods for maintaining tables and indexes.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: Exercise: Using the InnoDB memcached Plugin
After watching this video, you will be able to use triggers, events, and the InnoDB memcached plugin in MySQL databases.
-
Query & Performance Optimization: MySQL Indexes
After watching this video, you will be able to identify the types of indexes and how they function in queries.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: Working with Stored Programs
After watching this video, you will be able to create and execute stored programs in MySQL.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: Working with Stored Routines
After watching this video, you will be able to create and execute stored routines in MySQL.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: Creating and Dropping Triggers
After watching this video, you will be able to use the CREATE_TRIGGER and DROP_TRIGGER statements to create a new trigger or delete an existing trigger in MySQL.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: Working with Triggers
After watching this video, you will be able to create and execute triggers in MySQL.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: Working with Events
After watching this video, you will be able to use events in MySQL to schedule and run repetitive tasks in your database.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: InnoDB memcached Architecture
After watching this video, you will be able to recognize how the InnoDB memcached plugin fits in the overall architecture of MySQL and the function it serves.
-
Stored Routines, Triggers, & the InnoDB memcached Plugin: Installing the InnoDB memcached Plugin
After watching this video, you will be able to install and configure the InnoDB memcached plugin for use in MySQL.
-
Introduction: Install MySQL on Windows
After watching this video, you will be able to perform the installation and configuration of MySQL.
-
Introduction: Introduction to MySQL
After watching this video, you will be able to describe the MySQL database platform, why you would want to use it, and the various editions available.
-
Introduction: Select and Download MySQL
After watching this video, you will be able to locate and select the download options for the correct edition of MySQL.
