MariaDB Crash Course - Ben Forta [1]
Summary
8: Using Wildcard Filtering
Using the LIKE Operator
The Percent Sign (%) Wildcard
The Underscore (_) Wildcard
Tips for Using Wildcards
Summary
9: Searching Using Regular Expressions
Understanding Regular Expressions
Using Regular Expressions
Basic Character Matching
Performing OR Matches
Matching One of Several Characters
Matching Ranges
Matching Special Characters
Matching Character Classes
Matching Multiple Instances
Anchors
Summary
10: Creating Calculated Fields
Understanding Calculated Fields
Concatenating Fields
Using Aliases
Performing Mathematical Calculations
Summary
11: Using Data Manipulation Functions
Understanding Functions
Using Functions
Text Manipulation Functions
Date and Time Manipulation Functions
Numeric Manipulation Functions
Summary
12: Summarizing Data
Using Aggregate Functions
The AVG() Function
The COUNT() Function
The MAX() Function
The MIN() Function
The SUM() Function
Aggregates on Distinct Values
Combining Aggregate Functions
Summary
13: Grouping Data
Understanding Data Grouping
Creating Groups
Filtering Groups
Grouping and Sorting
SELECT Clause Ordering
Summary
14: Working with Subqueries
Understanding Subqueries
Filtering by Subquery
Using Subqueries as Calculated Fields
Summary
15: Joining Tables
Understanding Joins
Understanding Relational Tables
Why Use Joins?
Creating a Join
The Importance of the WHERE Clause
Inner Joins
Joining Multiple Tables
Summary
16: Creating Advanced Joins
Using Table Aliases
Using Different Join Types
Self Joins
Natural Joins
Outer Joins
Using Joins with Aggregate Functions
Using Joins and Join Conditions
Summary
17: Combining Queries
Understanding Combined Queries
Creating Combined Queries
Using UNION
UNION Rules
Including or Eliminating Duplicate Rows
Sorting Combined Query Results
Summary
18: Full-Text Searching
Understanding Full-Text Searching
Using Full-Text Searching
Enabling Full-Text Searching Support
Performing Full-Text Searches
Using Query Expansion
Boolean Text Searches
Full-Text Search Usage Notes
Summary
19: Inserting Data
Understanding Data Insertion
Inserting Complete Rows
Inserting Multiple Rows
Inserting Retrieved Data
Summary
20: Updating and Deleting Data
Updating Data
Deleting Data
Guidelines for Updating and Deleting Data
Summary
21: Creating and Manipulating Tables
Creating Tables
Basic Table Creation
Working with NULL Values
Primary Keys Revisited
Using AUTO_INCREMENT
Specifying Default Values
Engine Types
Updating Tables
Deleting Tables
Renaming Tables
Summary
22: Using Views
Understanding Views
Why Use Views
View Rules and Restrictions
Using Views
Using Views to Simplify Complex Joins
Using Views to Reformat Retrieved Data
Using Views to Filter Unwanted Data
Using Views with Calculated Fields
Updating Views
Summary
23: Working with Stored Procedures
Understanding Stored Procedures
Why Use Stored Procedures
Using Stored Procedures
Executing Stored Procedures
Creating Stored Procedures
Dropping Stored Procedures
Working with Parameters
Building Intelligent Stored Procedures
Inspecting Stored Procedures
Summary
24: Using Cursors
Understanding Cursors
Working with Cursors
Creating Cursors
Opening and Closing Cursors
Using Cursor Data
Summary
25: Using Triggers
Understanding Triggers
Creating Triggers
Dropping Triggers
Using Triggers
INSERT Triggers
DELETE Triggers
UPDATE Triggers
More on Triggers
Summary
26: Managing Transaction Processing
Understanding Transaction Processing
Controlling Transactions
Using ROLLBACK
Using COMMIT
Using Savepoints
Changing the Default Commit Behavior
Summary
27: Globalization and Localization
Understanding Character Sets and Collation Sequences
Working with Character Set and Collation Sequences
Summary
28: Managing Security
Understanding Access Control
Managing Users
Creating User Accounts
Deleting