MySQL Fundamentals

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

Fundamentals of MySQL, an essential part of the LAMP stack.

1. Introduction

1. Version Check

2. Introduction

2. Installations and GUI Tools

1. Introduction

2. Downloads

3. Demo - Installation

4. Demo - Installation Part 2

5. MySQL Workbench

6. Demo - MySQL Workbench

7. MySQL Command Line Editor

8. Demo - MySQL Command Line Editor

9. Summary in Sixty Seconds

3. Fundamentals of RDBMS and Database Designs

1. Introduction

2. ClientServer System

3. Web Application Server

4. History of Relational Database Model

5. Relational Database Model Concepts

6. Relational Database Model Keys

7. Column Definition

8. Summary in Sixty Seconds

04. Introduction MYSQL Workbench

01. Introduction

02. MySQL Workbench Features

03. Starting MySQL Workbench

04. Demo - Opening a New Connection

05. Demo - Manage Connections

06. Demo - Selecting Data

07. Demo - Updating Data

08. Demo - Open and Execute SQL File

09. Demo - Inserting Data

10. Demo - Deleting Data

11. Demo - View and Edit Column Definition

12. Demo - Creating Snippet

13. Demo - Output Window

14. Demo - Data Modeling

15. Demo - Server Administration

16. Demo - Workbench Central

17. Summary in Sixty Seconds

05. Data Retrieval Techniques

01. Introduction

02. Basics of SELECT statement

03. Setup for demo

04. Beginning SELECT statement

05. Demo - Select without FROM clause

06. Demo - Retrieve all the data from table

07. Demo - Order data based on a column

08. Demo - Retrieve selected columns from table

09. Demo - Retrieve selected columns and rows

10. Demo - Bringing it together

11. Demo - Retrieve empty resultset

12. Working with Arithmetic Expressions

13. Demo - Arithmetic Expressions

14. Select statement and other functions

15. Demo - Select statement and other functions

16. Demo - Select statement and string functions

17. Demo - Select statement and date functions

18. Demo - Select statement and distinct rows

19. Introducing WHERE clause

20. Select statement and Comparision Operators

21. Demo - Comparision Operators

22. Select statement and Logical Operators

23. Demo - Logical Operators

24. Select statement and WHERE clause

25. Demo - Using Between in WHERE clause

26. Demo - Using Like in WHERE clause

27. Select statement and ORDER BY clause

28. Demo - Select statement and

29. Retrieving limited rows

30. Demo - Retrieving limited rows

31. Summary in Sixty Seconds

6. Data Modification Techniques

1. Introduction

2. Insert Statement

3. Demo - Insert Statement

4. Update Statement

5. Demo - Update Statement

6. Delete Statement

7. Demo - Delete Statement

8. Summary in Sixty Seconds

7. Summary and Resources

1. Final Words

45,900 تومان

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

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

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

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