-
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.
-
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.
-
MySQL: Creating & Updating Tables
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.
- Discover the key concepts covered in this course
- Enumerate attributes of keys, super-keys, and candidate keys
- Model relationships in a real-world scenario for use in a database system
- Specify non-null constraints while creating tables
- Run simple queries using wildcards and where clauses
- Understand the need for SQL and enumerate its important characteristics
- Designate columns as unique while creating tables
- Perform update operations on data in a MySQL relation
- Perform DDL operations including altering tables to add primary key constraints, and dropping tables and databases
- Summarize the key concepts covered in this course
-
MySQL: Getting Started
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.
- Discover the key concepts covered in this course
- Identify requirements that a database management system needs to satisfy
- Install MySQL on different platforms
- Connect to a MySQL server using a command line interface
- Create a database and view a list of databases on a MySQL server
- Install MySQL workbench and connect to a MySQL server
- Model entities in a real-world scenario for use in a database system
- Execute commands from the MySQL Workbench environment
- Perform basic database operations such as inserting and querying data
- View table metadata and delete data from tables
- Course Summary
-
MySQL: Grouping & Aggregation Operations
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.
- Discover the key concepts covered in this course
- Prepare a small but meaningful relation that can be used to work with data aggregation operators
- Use the DISTINCT keyword as well as the GROUP BY clause to identify duplicates and cardinality
- Use the GROUP BY clause with important common aggregation functions such as SUM, COUNT, MIN, MAX
- Use the HAVING keyword along with the GROUP BY clause to apply filters to aggregates
- Use the SOME, ALL, and ANY keywords to link subqueries to outer queries
- Implement joins with more than two relations in MySQL
- Course Summary
-
MySQL: Querying Data
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.
- Discover the key concepts covered in this course
- Translate entity-relationship models to actual database table schemas
- Identify the correct data types and constraints for specific columns in a table schema
- Use relational and logical operators in the WHERE clause of MySQL queries
- Use the LIKE and IN operators as well as wildcards in queries
- Use subqueries to perform complex logical operations
- Implement referential integrity checks using foreign key constraints
- Perform filtering operations on date columns
- Use the LIMIT and ORDER BY clauses in MySQL queries
- Course Summary
-
MySQL: Transactions, Savepoints, & Locks
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.
- Discover the key concepts covered in this course
- Enumerate the ACID properties and their importance
- Start a transaction and execute statements within it
- Rollback insert and update commands executed within a transaction
- Identify commands that can not be rolled back once executed
- Enumerate DDL operations which are immediately reflected to database state
- Leverage stored procedures to control transaction execution
- Specify custom handlers for errors and warnings occurring within transactions
- Use savepoints to perform rollback to specific points within a transaction
- Understand precise semantics of sequential savepoints in transactions
- Create multiple client sessions connected to the same MySQL server
- Acquire a read lock on a relation and understand the semantics of read locking
- Acquire a write lock on a relation and understand the semantics of write locking
- Course Summary
-
MySQL: Triggers & Stored Procedures
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.
- Discover the key concepts covered in this course
- Define a trigger and enumerate use cases of triggers in a database system
- Create a row-level trigger executed after inserts into a MySQL table
- Create a row-level trigger executed before inserts into a MySQL table
- Use triggers to performing cascading inserts and satisfy foreign key constraints
- Override default ON DELETE and ON UPDATE behavior in MySQL tables
- Enumerate applications of stored procedures
- Create a simple stored procedure correctly specifying choice of delimiter
- Invoke a stored procedure and pass in required arguments
- Check if a stored procedure already exists and drop it before re-defining it
- Combine complex declarative and imperative operations in a stored procedure
- Course Summary
-
MySQL: Understanding & Implementing Joins
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.
- Discover the key concepts covered in this course
- Identify the use cases of joins
- Compute the cross-join of two relations
- Compute the inner join of two relations
- Compute the left outer join of two relations
- Compute the right outer join of two relations
- Define the natural join operator
- Implement a cross product in MySQL
- Perform join operations in MySQL
- Course Summary
-
MySQL: Views, Indices, & Normal Forms
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.
- Discover the key concepts covered in this course
- Define a view and enumerate applications of views
- Implement views in MySQL
- Use views to abstract complex queries in MySQL
- Define a database index and enumerate advantages and disadvantages of indexing columns in a relation
- View indices on an existing table and create new indices on columns
- Create composite indices and drop indices
- Identify and apply the first three normal forms of database design
- Evaluate the number of tables needed to appropriately store and model data
- Identify and rectify violations of the First Normal Form in MySQL
- Identify violations of the Second Normal Form in MySQL
- Rectify violations of the Second Normal Form in MySQL by refactoring table design
- Course Summary