Database Management with MySQL

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

About Course

Master the fundamentals of database management with our Database Management with MySQL course, designed to equip you with the skills needed to build, manage, and optimize databases in one of the world’s most popular database systems. This comprehensive program introduces you to core concepts of relational databases, SQL queries, and MySQL database operations, providing a strong foundation for anyone interested in managing data effectively.

Throughout the course, you’ll learn how to create and structure databases, retrieve and manipulate data using SQL, and implement best practices for database security, efficiency, and optimization. By the end, you’ll be proficient in handling MySQL databases, enabling you to support data-driven applications and make informed decisions based on organized, reliable data.

Whether you’re an aspiring database administrator, developer, or data analyst, this course will give you the tools you need to succeed in today’s data-focused world. Join us at Teck-Skills and take the first step towards becoming a MySQL database expert!

Here’s the updated list of learning objectives with revised items 4, 5, 6, and 7:

  1. Understand the Fundamentals of Relational Databases and MySQL
    • Gain a solid foundation in database concepts, MySQL architecture, and relational database principles.
  2. Design and Structure Databases
    • Learn to create well-structured databases by defining tables, columns, keys, and relationships according to best practices.
  3. Write SQL Queries to Retrieve and Manipulate Data
    • Develop proficiency in SQL, including SELECT, INSERT, UPDATE, DELETE, and JOIN queries for data retrieval and manipulation.
  4. Implement Effective Data Validation Techniques
    • Apply data constraints and validation rules to ensure data quality and prevent errors within the database.
  5. Use Views and Stored Procedures for Database Efficiency
    • Create and manage views, stored procedures, and functions to simplify complex queries and enhance database functionality.
  6. Monitor and Troubleshoot Database Issues
    • Learn methods for monitoring database health, diagnosing performance issues, and resolving common errors.
  7. Apply Database Normalization and Data Modeling
    • Master normalization techniques and data modeling strategies to optimize database design and minimize redundancy.
  8. Work with Real-World Data Scenarios
    • Apply database management skills to real-world examples and projects, preparing you for practical applications in the workplace.

These revised objectives provide a more hands-on approach to building, optimizing, and managing databases in MySQL!

 
Show More

What Will You Learn?

  • Grasp the fundamental principles of database management and MySQL.
  • Create and structure databases, including defining tables and relationships.
  • Master SQL commands for data manipulation and retrieval.
  • Employ data validation techniques to maintain high data quality.
  • Utilize views and stored procedures for improved database performance.
  • Gain skills in monitoring database health and diagnosing performance issues.
  • Understand database normalization and apply it to enhance design efficiency.
  • Engage with real-world data management projects to solidify your skills.

Course Content

Database Management with MySQL

  • 1.1 Course Introduction
    04:23
  • 1.2 Download & Installation of MySQL
    06:04
  • 1.3 The Workbench Overview
    09:47
  • 1.4 The SELECT Statement
    08:48
  • 1.5 The Select Clause
    10:38
  • 1.6 The WHERE Clause
    07:08
  • 1.7 The ORDER BY Clause
    06:16
  • 1.8 The LIMIT Clause
    03:32
  • 1.9 The AND, OR and NOT Operator
    06:25
  • 1.10 The IN Operators
    04:51
  • 1.11 The BETWEEN Operator
    02:55
  • 1.12 The LIKE Operator
    12:12
  • 1.13 The REGEXP Operator
    14:04
  • 1.14 The NULL Operator
    03:48
  • 1.15 Inner Join
    14:03
  • 1.16 Joining Across Database
    06:36
  • 1.17 Self Join
    06:19
  • 1.18 Joining Multiple Tables
    14:25
  • 1.19 Outer joins
    09:10
  • 1.20 Outer Joins Between Multiple Tables
    10:31
  • 1.21 Self Outer Join
    02:21
  • 1.22 The USING Clause
    09:55
  • 1.23 Natural and Cross Joins
    07:44
  • 1.24 Unions
    13:05
  • 1.25 Inserting a Single Row(Column Attributes)
    16:42
  • 1.26 Inserting a Multiple Rows
    06:01
  • 1.27 Create a Copy of a Table
    08:45
  • 1.28 Updating a Single Row
    07:15
  • 1.29 Updating a Multiple Rows
    05:44
  • 1.30 Exporting Query Output
    11:27
  • 2.31 Creating a Database and Table
    15:20
  • 2.32 Importing Excel file to MySQL Database
    10:24
  • 2.33 SubQueries in MySQL
    07:13
  • 2.34 SubQuery across tables
    06:09
  • 2.35 VIEWS in MySQL Part 1
    11:13
  • 2.36 VIEWS in MySQL Part 2
    11:32
  • 2.37 Stored Procedure 1
    06:43
  • 2.38 Stored Procedure 2
    05:01
  • 2.39 Stored Procedure 3
    07:34
  • 2.40 Trigger in MySQL
    09:12
  • 2.41 Introduction to Function in MySQL
    06:56
  • 2.42 String Functions in MySQL
    13:56
  • 2.43 The Number Function in MySQL
    05:53
  • 2.44 The Date Functions in MySQL
    09:35
  • 2.45 Aggregate Function in MySQL
    04:46
  • Course Review and Further Learning
    03:09

Earn a certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕