Learning MySQL Development

Focused View

Brad Wheeler

1:56:23

59 View

01 - Introduction

01 - Learn to use MySQL.mp4

00:45

02 - How to get started with MySQL.mp4

02:55

02 - 1. Database Basics

01 - What is a database.mp4

03:04

02 - SQL, a declarative language.mp4

03:20

03 - Databases vs. flat files and spreadsheets.mp4

03:46

04 - Common database terms.mp4

03:53

05 - Database best practices.mp4

03:00

03 - 2. Exploring MySQL

01 - Advantages and disadvantages of MySQL.mp4

02:49

02 - Exploring MySQL Workbench.mp4

02:54

03 - MySQL data types Part 1.mp4

05:06

04 - MySQL data types Part 2.mp4

05:10

05 - Challenge Explore the built-in databases.mp4

00:38

06 - Solution Explore the built-in databases.mp4

01:41

04 - 3. Creating Tables

01 - Create a database.mp4

02:13

02 - Create a table.mp4

05:51

03 - Use CREATE and ALTER to define a table.mp4

03:55

04 - Primary keys and foreign keys.mp4

02:37

05 - Display database relationships with reverse engineering.mp4

03:56

06 - Load bulk data.mp4

03:50

07 - Challenge Create a normalized movies table.mp4

01:03

08 - Solution Create a normalized movies table.mp4

07:04

05 - 4. Selecting Data

01 - The basics of SELECT.mp4

01:17

02 - Refine SELECT queries.mp4

04:38

03 - Filter results with WHERE.mp4

05:01

04 - Display data with CASE.mp4

03:15

05 - Challenge Filter movies by score.mp4

00:54

06 - Solution Filter movies by score.mp4

02:28

06 - 5. Updating and Deleting Data

01 - Add data to tables with INSERT.mp4

02:50

02 - Update existing rows with UPDATE.mp4

03:13

03 - Remove data with DELETE.mp4

04:05

04 - Challenge Clean up the movies.mp4

00:43

05 - Solution Clean up the movies.mp4

03:50

07 - 6. Joining Tables

01 - The basics of JOIN.mp4

02:16

02 - Match fields with INNER JOIN.mp4

05:24

03 - Match all fields with outer joins.mp4

04:04

04 - Challenge Find the best film.mp4

00:25

05 - Solution Find the best film.mp4

02:10

08 - Conclusion

01 - Level up your MySQL knowledge.mp4

00:20

Description

Are you brand new to database development? After more than 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. Learn 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. Along the way, test your knowledge with challenges and solutions in each chapter.

Join Brad in this course to gain the basic skills you need to create and maintain your own MySQL databases—and take your applications to a whole new level of sophistication.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Brad Wheeler

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.