Are you brand new to database development? After 25 years, MySQL is still the most popular and approachable database management system—ideal for developers who want to start programming data-driven applications. This course provides an overview of MySQL tools and techniques for software development. Discover what a database is and how it's structured and explore the data types underlying MySQL records. Find how to CREATE TABLE IF NOT EXISTSs, define primary and foreign keys, and load data from external sources. Instructor Brad Wheeler then takes you through the basics of writing queries and statements to select, update, delete, and transform data. Plus, get an introduction to advanced concepts such as joining existing tables. By the end of this course, you'll have the basic skills you need to create and maintain your own MySQL databases—and take your applications to a whole new level of sophistication.

Topics include:

Understanding the structure of a database

Database best practices

Creating tables

Importing data

Writing SELECT queries

Filtering results

Inserting data

Updating data

Deleting data

Joining tables

Homepage:

https://www.lynda.com/MySQL-tutorials/Learning-MySQL-Development-2020/2825724-2.html