Developing with MySQL

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

MySQL is the most popular open source DBMS for the enterprise. It also powers more than 30% of the web. In this course, you’ll learn to develop enterprise-level MySQL-backed applications from a data centric point of view.

1. Course Overview

1. Course Overview

2. Developing with MySQL

1. Introduction

2. Installing MySQL on Windows, Mac, and Linux

3. Creating the Databases

3. Views

1. Creating Views

2. Altering and Dropping Views

3. Updateable Views

4. Stored Procedures

1. Stored Procedures

2. Procedure Parameters

3. Parameter Validation

4. Variables

5. Triggers and Events

1. Triggers and Events

2. Viewing Triggers

3. Events

4. Viewing, Dropping, and Altering Events

6. Transactions and Concurrency

1. Transactions and Concurrency

2. Creating Transactions

3. Concurrency and Locking

4. Problems with Concurrency

5. Isolation Level Read Uncommitted

6. Isolation Level Read Committed

7. Isolation Level Repeatable Read

8. Isolation Level Serializable

9. Deadlocks

10. Summary

7. Data Types

1. Data Types Strings

2. Data Types Integers

3. Data Types Rationals

4. Data Types Boolean

5. Data Types Date and Time

8. Database Design

1. Database Design

2. Data Modelling

3. Conceptual Models

4. Relationships - One-to-one

5. Relationships - One-to-many

6. Relationships - Many-to-many

7. Logical Models

8. Physical Models

9. Primary Keys

10. Foreign Keys

11. Foreign Key Constraints

12. 1NF First Normal Form

13. 2NF Second Normal Form

14. 3NF Third Normal Form

15. Forward Engineering a Model

9. Indexing for High Performance

1. Indexing for High Performance

2. Creating Indexes

3. Viewing Indexes

4. Prefix Columns

5. Composite Indexes

6. Composite Indexes Order of Columns

7. When Indexes Are Ignored

8. Covering Indexes

9. Maintaining Indexes

10. Data Security

1. Data Security

2. Dropping Users, Changing Passwords

3. Granting Privileges to Users

4. Granting Privileges to Apps

45,900 تومان

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

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

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

تولید کننده: PluralSight