MySQL Fundamentals
Fundamentals of MySQL, an essential part of the LAMP stack.
What you'll learn
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as write basic data retrieval and data modification queries.
Table of contents
- Introduction 1m
- MySQL Workbench Features 2m
- Starting MySQL Workbench 2m
- Demo: Opening a New Connection 2m
- Demo: Manage Connections 3m
- Demo: Selecting Data 1m
- Demo: Updating Data 5m
- Demo: Open and Execute SQL File 2m
- Demo: Inserting Data 1m
- Demo: Deleting Data 1m
- Demo: View and Edit Column Definition 3m
- Demo: Creating Snippet 2m
- Demo: Output Window 1m
- Demo: Data Modeling 2m
- Demo: Server Administration 3m
- Demo: Workbench Central 2m
- Summary in Sixty Seconds 1m
- Introduction 1m
- Basics of SELECT statement 2m
- Setup for demo 1m
- Beginning SELECT statement 1m
- Demo: Select without FROM clause 2m
- Demo: Retrieve all the data from table 2m
- Demo: Order data based on a column 2m
- Demo: Retrieve selected columns from table 2m
- Demo: Retrieve selected columns and rows 3m
- Demo: Bringing it together 3m
- Demo: Retrieve empty resultset 1m
- Working with Arithmetic Expressions 2m
- Demo: Arithmetic Expressions 3m
- Select statement and other functions 1m
- Demo: Select statement and other functions 3m
- Demo: Select statement and string functions 4m
- Demo: Select statement and date functions 4m
- Demo: Select statement and distinct rows 2m
- Introducing WHERE clause 1m
- Select statement and Comparision Operators 1m
- Demo: Comparision Operators 5m
- Select statement and Logical Operators 1m
- Demo: Logical Operators 7m
- Select statement and WHERE clause 2m
- Demo: Using Between in WHERE clause 5m
- Demo: Using Like in WHERE clause 5m
- Select statement and ORDER BY clause 1m
- Demo: Select statement and 3m
- Retrieving limited rows 1m
- Demo: Retrieving limited rows 2m
- Summary in Sixty Seconds 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 52 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,600 database tech articles on his blog at https://blog.sqlauthority.com.