Learning MySQL Development

سرفصل های دوره

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.

01 - Introduction

01 - Learn to use MySQL

02 - How to get started with MySQL

02 - 1. Database Basics

01 - What is a database

02 - SQL, a declarative language

03 - Databases vs. flat files and spreadsheets

04 - Common database terms

05 - Database best practices

03 - 2. Exploring MySQL

01 - Advantages and disadvantages of MySQL

02 - Exploring MySQL Workbench

03 - MySQL data types Part 1

04 - MySQL data types Part 2

05 - Challenge Explore the built-in databases

06 - Solution Explore the built-in databases

04 - 3. Creating Tables

01 - Create a database

02 - Create a table

03 - Use CREATE and ALTER to define a table

04 - Primary keys and foreign keys

05 - Display database relationships with reverse engineering

06 - Load bulk data

07 - Challenge Create a normalized movies table

08 - Solution Create a normalized movies table

05 - 4. Selecting Data

01 - The basics of SELECT

02 - Refine SELECT queries

03 - Filter results with WHERE

04 - Display data with CASE

05 - Challenge Filter movies by score

06 - Solution Filter movies by score

06 - 5. Updating and Deleting Data

01 - Add data to tables with INSERT

02 - Update existing rows with UPDATE

03 - Remove data with DELETE

04 - Challenge Clean up the movies

05 - Solution Clean up the movies

07 - 6. Joining Tables

01 - The basics of JOIN

02 - Match fields with INNER JOIN

03 - Match all fields with outer joins

04 - Challenge Find the best film

05 - Solution Find the best film

08 - Conclusion

01 - Level up your MySQL knowledge

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)