Learning MySQL Development

Learning MySQL Development
Learning MySQL Development
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 48m | 250 MB

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 tables, 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
Table of Contents

1 Learning to use MySQL
2 How to get started with MySQL
3 What is a database
4 SQL, a declarative language
5 Databases vs. flat files and spreadsheets
6 Common database terms
7 Database best practices
8 Advantages and disadvantages of MySQL
9 Exploring MySQL Workbench
10 MySQL data types, part 1
11 MySQL data types, part 2
12 Challenge Explore the built-in databases
13 Solution Explore the built-in databases
14 Create a database
15 Create a table
16 Use CREATE and ALTER to define a table
17 Primary keys and foreign keys
18 Load bulk data
19 Challenge Create normalized movies table
20 Solution Create normalized movies table
21 The basics of SELECT
22 Refine SELECT queries
23 Filter results with WHERE
24 Display data with CASE
25 Challenge Filter movies by score
26 Solution Filter movies by score
27 Add data to tables with INSERT
28 Update existing rows with UPDATE
29 Remove data with DELETE
30 Challenge Clean up the movies
31 Solution Clean up the movies
32 The basics of JOIN
33 Match fields with INNER JOIN
34 Match all fields with outer joins
35 Challenge Find the best film
36 Solution Find the best film