Mysql MasterClass: Master Basic to Advanced Mysql Queries

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

Complete MySQL Course: Learn Essential MySQL Techniques, Basic to Advanced Queries, and Real-Life Database Applications.

1. Introduction

1. Introduction

2. Module 1-Introduction to MySql

1.1 MySQL Course Source Codes.zip

1. MySql Full Course Source Code.html

2. Introduction to Relational Databases and MySql Part-1

3. Benefits of MySql Part-2

3. Module 2-Installation and Set-up

1. Installation and Configuring MySql Part-1

4. Module 3-Working With Tables

1. Creating and managing database Part-1

2. Table Creation and Insertion Part-2

3. Updation and Deletion in table Part 3

5. Module 4-Understanding Constraints

1. Domain and Entity Integrity Constraints Part-1

2. Referential Integrity Constraints Part-2

6. Module 5-Data Retrieval and Manipulation

1. Using Select and Where Clause Part-1

2. Understanding Operators Part-2

7. Module 6-Advanced SQL functions and Clauses

1. SQL Character Functions Part-1

2. Range Searching and Pattern Matching Part-2

3. Order by Clause Part-3

4. Group by Clause Part-4

5. Having by Clause Part-5

8. Module 7-SQL Numeric, Date and Group Functions

1. Aggregate Functions Part-1

2. Date Functions Part-2

9. Module 8-Data Conversion and Set Operations

1. Understanding Cast Function Part-1

2. Understanding Convert Function Part-2

3. Employing set Operators in a Database Part-3

10. Module 9-Advanced Data Retrieval

1. Inner Join Part-1

2. Left Join Part-2

3. Right Join and Full Join Part-3

4. Health Care Inventory Management Tasks Part-4

189,000 تومان

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

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

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

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