Become a MySQL Pro: Learn from Beginner to Expert

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

Step-by-Step Guidance for Mastering MySQL

1 - Introduction To Course

1 - Introduction to course

2 - Introduction To MySQL

2 - Introduction to SQL

3 - Installing MySQL Workbench

3 - Data Types in MySQL

4 - Data Types

5 - Command Prompt Interface

4 - Data Definition Language Commands in MySQL

6 - Create Database in MySQL

7 - Create Table in MySQL

8 - Alter Table in MySQL

9 - Drop Table in MySQL

10 - Truncate Table in MySQL

11 - Rename Table in MySQL

12 - Difference Between Drop Truncate and Delete

5 - Data Manipulation Language Commands

13 - Insert into table using MySQL

14 - Update Data in Table using MySQL

15 - Delete From table using MySQL

6 - Transaction Control Language Commands

16 - Commit Rollback and Save Point

7 - Constraints in MySQL

17 - Primary Key Constraint

18 - Unique key Constraint

19 - Not Null Key Constraint

20 - Check Key Constraint

21 - Foreign Key Constraints and Referential Integrity

8 - Clauses in MySQL

22 - SELECT and WHERE Clause

23 - ORDER BY Clause

24 - GROUP BY Clause

25 - HAVING Clause

26 - DISTINCT Clause

9 - MySQL Functions

27 - Functions in MySQL

10 - Logical Operators in MySQL

28 - Logical Operators in MySQL

11 - MySQL JOINS and Set Operations

29 - MySQL JOINS

30 - Set Operations in MySQL

12 - Sub Queries in MySQL

31 - Subqueries

13 - Reserved Keywords

32 - ALL and ANY keyword in MySQL

33 - BETWEEN and IN keyword in MySQL

34 - LIKE in MySQL

35 - EXISTS in MySQL

36 - EXISTS and IN with Subqueries in MySQL

14 - Practice Problems using MySQL

37 - Practice Problem I

38 - Practice Problem II

39 - Practice Problem III

40 - Practice Problem IV

139,000 تومان

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

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

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

تولید کننده: Udemy-Training