وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

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
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 18535
    حجم: 212 مگابایت
    مدت زمان: 117 دقیقه
    تاریخ انتشار: 14 شهریور 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید