Responsive Section

SQL/MySQL Database Basics Course for Beginners

Develop your database management skills and open up new professional opportunities.

Price: 100 50$

Lifetime access

After the enrollment, the course will be available online in your account, in the My Dashboard section and can be completed at your own pace, at times chosen by you.

After enrollment, you will receive personalized upgrade offers tailored to your needs and goals to benefit from additional support and materials to help you move beyond the database administration level.

Responsive Section

Think of SQL/MySQL as a tool that can transform your life. With this knowledge, you will be able to manage databases and become a sought-after specialist in the job market.

Whether you want to work in a large corporation or start your own business, the skills you will gain from this course will give you the confidence and expertise you need.

You will learn

💾 Advanced Installation and Configuration: Learn how to install and configure the MySQL server and MySQL Workbench for complex development environments.

📊 Advanced Databases and Tables Gain an in-depth understanding of what databases and tables are, how to create, modify, and optimize them to function efficiently in large projects.

📈 Advanced Data Types and Structures: Learn how to manage complex data types and structure information to ensure performance and scalability in databases.

💼 Table Modification and Optimization: Learn advanced techniques for modifying and optimizing table structures to achieve maximum performance in complex queries and operations.

🔑 Unique Identifiers and Specific Keywords: Discover the importance of correctly using unique identifiers and specific keywords to maintain the integrity and security of your data.

🔍 Reading and Filtering Data from Tables: Learn how to extract specific data using advanced filtering and optimization techniques to quickly retrieve relevant information from large databases.

✏️ Modifying and Updating Data: Discover how to efficiently modify existing data in tables while ensuring their integrity and consistency.

🗑️ Deleting Data and Safe Management: Learn advanced methods for deleting data from tables, preventing accidental losses, and ensuring the security of information.

📋 Advanced Pagination and Sorting: Explore techniques for paginating and sorting to efficiently manage and visualize large datasets.

🌍 Foreign Keys and Table Relationships: Learn how to implement and manage relationships between tables using foreign keys, ensuring data integrity in a relational structure.

🔗 Joins and Complex Queries: Master the art of combining data from multiple tables using various types of Joins to retrieve correlated and relevant information.

📊 Aggregation Functions: Discover how to use advanced aggregation functions to perform detailed analysis of your data.

🚦 Triggers for Process Automation: Learn to create triggers to automate actions and improve the efficiency of data management.

🔄 Functions and Stored Procedures: Learn to develop custom functions and stored procedures to automate and optimize complex operations in your databases.

Course curriculum

1. MySQL Server & MySQL Workbench
1. What is a database
2. What is a table
1. SQL Data Types
2. Quiz
1. CREATE DATABASE & CREATE TABLE - Theory
2. CREATE DATABASE & CREATE TABLE - Practice
3. Quiz
1. DROP AND ALTER TABLE - Theory
2. DROP AND ALTER TABLE - Practice
3. Quiz
1. INSERT - Theory
2. INSERT - Practice
3. Quiz
1. PRIMARY KEY - Theory
2. PRIMARY KEY - Practice
3. AUTO_INCREMENT - Theory
4. AUTO_INCREMENT - Practice
5. Quiz
1. NOT NULL - Theory
2. NOT NULL - Practice
3. UNIQUE - Theory
4. UNIQUE - Practice
5. DEFAULT - Theory
6. DEFAULT - Practice
7. Quiz
1. SELECT - Theory
2. SELECT - Practice
3. Quiz
1. WHERE - theory
2. WHERE - practice
3. AND & OR - theory
4. AND & OR - practice
5. IN - theory
6. IN - practice
7. BETWEEN - theory
8. BETWEEN - practice
9. LIKE - theory
10. LIKE - practice
11. DISTINCT - theory
12. DISTINCT - practice
13. COALESCE - theory
14. COALESCE - practice
15. Quiz 1
16. Quiz 2
1. UPDATE - theory
2. Settings
3. UPDATE - practice
4. Quiz
1. DELETE and TRUNCATE - theory
2. DELETE and TRUNCATE - practice
3. Quiz
1. LIMIT & OFFSET - theory
2. LIMIT & OFFSET - practice
3. ORDER BY - theory
4. ORDER BY - practice
5. Quiz 1
6. Quiz 2
1. FOREIGN KEYS - theory
2. FOREIGN KEYS - practice
3. ON DELETE - theory
4. ON DELETE - practice
5. Quiz
1. INNER JOIN - theory
2. INNER JOIN - practice
3. LEFT JOIN - theory
4. LEFT JOIN - practice
5. RIGHT JOIN - theory
6. RIGHT JOIN - PRACTICE
7. FULL JOIN & UNION
8. Quiz
1. COUNT - theory
2. COUNT - practice
3. SUM - theory
4. SUM - practice
5. MIN & MAX - theory
6. MIN & MAX - practice
7. AVG - theory
8. AVG - practice
9. GROUP BY - theory
10. GROUP BY - practice
11. Quiz
1. TRIGGERS - part 1
2. TRIGGERS - part 2
3. TRIGGERS - part 3
4. TRIGGERS - part 4
5. TRIGGERS - part 5
6. Quiz
1. STORED FUNCTIONS - theory
2. STORED FUNCTIONS - practice
3. CASE
4. Quiz
1. STORED PROCEDURES theory
2. STORED PROCEDURES + SUBSELECT
3. STORED PROCEDURES practice
4. Quiz
1. Databases

About this course

$100.00
97 lessons
9 hours of video content

The complete SQL/MySQL database course

Enroll now

SQL/MySQL Database Basics Course for Beginners

You will learn

Course curriculum

Installing the necessary software

Databases and tables

SQL Data Types

Creating databases and tables

Modifying our table structure

Inserting data into tables

Unique Identifiers

Table specific SQL Keywords

Reading data from tables

Filtering the table data

Updating table data

Deleting the table data

Pagination and order

Foreign keys

Joins

Aggregate Functions

Triggers

Stored Functions

Stored Procedures

Databases

About this course

The complete SQL/MySQL database course