-92%

Mastering MySQL

Last Update November 24, 2025

5.0 /5

(1)

0 already enrolled

About This Course

The Entrepreneur’s Guide for beginners and is a course created in collaboration with all Catalan public universities and EIT Health and aims to be the starting point for all those who want to improve their knowledge and skills in the world entrepreneurship. In this course you will be able to identify a business opportunity, develop the business model (and the steps to validate it) and know the main mechanisms to find your business.

In addition, you will have the help of experts who will be there to help you resolve any questions that may arise during the course.

Learning Objectives

To promote an entrepreneurial spirit and to consider the option of setting up a company as an employment opportunity

Development of entrepreneurial skills and use of tools that equip people to work in an entrepreneurial project

Essential knowledge for those interested in managing their own business

Material Includes

Videos
Booklets

Requirements

Passion for entrepreneurship
Basic business concepts

Target Audience

Young entrepreneurs
Business persons
College students
Professionals
Startups

Curriculum

110 Lessons21h 15m

1. Introduction

1. Introduction00:00

2. Tools Used in This Course00:00

2. Setting Up Course Tools

3. Browsing & Filtering Data

4. Filter Data with AND, OR, NOT Operators

5. Math Operations

6. String Concatenation

7. Tidy Up Your Results Sorting, Alias Names, Limit Records

8. NULL, DISTINCT & CASE Statements

9. Functions in SQL Multiple-Row Functions

10. Functions in SQL Single-Row Functions

11. Nested Queries

12. Casting & Data Conversion

13. Combination Relationships

14. Joins in SQL

15. Data Manipulation (DML)

16. SQL Data Definition Language (DDL)

17. Access Control

Your Instructors

hiilearne

4.95/5

19 Courses

19 Reviews

70 Students

Student Feedback

5.0

1 Rating

100%

Reviews (1)

hiilearne

7 months ago

₹199.00~~₹2,500.00~~

92% off

Level

Beginner

Duration 21.3 hours

Lectures

110 lectures

Subject

Database Programming Languages

Material Includes

Videos
Booklets

-88%

Mastering MySQL

About This Course

Learning Objectives

Material Includes

Requirements

Target Audience

Curriculum

1. Introduction

1. Introduction00:00

2. Tools Used in This Course00:00

2. Setting Up Course Tools

1. Download PostgreSQL00:00

2. Install PostgreSQL00:00

3. Download SQLectron00:00

4. Install SQLectron00:00

5. Connect to PostgreSQL – Credentials00:00

6. Connect to PostgreSQL Using SQLectron00:00

7. Import Course Data Using SQLectron00:00

9. FOR WINDOWS 32-BIT USERS Download, Install, Configure & Import Data00:00

3. Browsing & Filtering Data

1. Check Imported Data00:00

2. So.. What is a Database00:00

3. SQL Data Types00:00

4. Finally Some Fun! Extracting Data Based on Requirements00:00

5. Filtering Data using WHERE Keyword00:00

6. Filter Data by Range Using BETWEEN00:00

7. Filter Data by Set of Values Using IN00:00

8. Filter Data by Date00:00

9. More Filtering by Date00:00

10. Another Query Filtering by Date00:00

11. Filter Data by Strings (Names, Addresses, …)00:00

12. More Filtering by Strings00:00

13. More Filtering by Strings 200:00

14. More Filtering by Strings 300:00

15. How to Ignore Caps when Filtering by String00:00

4. Filter Data with AND, OR, NOT Operators

1. AND Operator00:00

2. OR Operator00:00

3. NOT Operator00:00

4. AND, OR & NOT Operators Which Has The Highest Priority00:00

5. Math Operations

1. Basic Math Operations00:00

2. Modulo Operator00:00

3. It_s Payday! Calculate The Net Salary for Employees00:00

4. Filter Data with Math Equations00:00

6. String Concatenation

1. Concatenate Strings with _ Operator00:00

2. Concatenate Strings with Numbers00:00

7. Tidy Up Your Results Sorting, Alias Names, Limit Records

1. Give Your Report Fields A Cool Name00:00

2. A Report for Payroll00:00

3. Order Records by Column00:00

4. Order Records by Multiple Columns00:00

5. How Alias Names Cannot Be Used with WHERE00:00

6. LIMIT Record Count Fetched by Your Query00:00

8. NULL, DISTINCT & CASE Statements

1. Fetch A Field_s Unique Values Using DISTINCT00:00

2. Using DISTINCT Keyword with Multiple Columns00:00

3. What is a NULL Value Anyway00:00

4. Build More Sophisticated Queries with CASE Statements00:00

5. Your Knowledge So Far Under A Great Test00:00

9. Functions in SQL Multiple-Row Functions

1. Let Me Introduce You to Functions00:00

2. SUM Function00:00

3. AVG (Average) Function00:00

4. COUNT Function00:00

5. MIN & MAX Functions00:00

6. How To Count Your Field_s Unique Values00:00

7. GROUP BY Clause Use Functions with Dimensions00:00

8. GROUP BY More Than One Dimension00:00

9. Now For Some Tough Workout00:00

10. Filter By Aggregate Functions with HAVING Clause00:00

10. Functions in SQL Single-Row Functions

1. Character Functions – UPPER, LOWER & INITCAP00:00

2. Character Functions – CONCAT & LENGTH00:00

3. Character Functions – LPAD & RPAD00:00

4. Character Functions – TRIM00:00

5. Character Functions – REPLACE00:00

6. Character Functions – SUBSTR00:00

7. Number Functions – MOD & ROUND00:00