老程序员带您学SQL第2篇:MySQL数据库
Learn MySQL database management! Master SQL, functions, stored procedures, triggers & more. Ideal for students, programmers, data analysts, and DBAs.
Course Content
老程序员带您学SQL第2篇:MySQL数据库 is an intermediate-level Udemy course taught by 东升 关. It runs 5h 24m, is taught in Chinese, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 9 reviews, with 34 students enrolled. It is a paid course, last updated November 2022.
This course is the second installment in our comprehensive SQL series, focusing on MySQL database management. This module provides a deep dive into the MySQL database system, covering everything from installation to advanced development techniques.
Here's a detailed breakdown of what you'll learn:
MySQL Database Installation:
- MySQL Overview: Understand the key features and benefits of using MySQL, along with an overview of its major versions.
- Platform-Specific Installation: Learn how to install MySQL on Windows, Linux, and macOS operating systems. Step-by-step instructions are provided for each platform.
MySQL Database Administration:
- Server Access: Master the process of logging into your MySQL server.
- Essential Management Commands: Become proficient with common MySQL commands for efficient database administration.
- System Object Information: Learn how to view and analyze system object information within MySQL.
- Script Execution: Execute SQL script files for automated database tasks.
- Database Backup & Recovery: Implement robust MySQL database backup and recovery strategies to protect your data.
- Graphical Management Tools: Explore and utilize popular MySQL GUI tools for simplified database management.
MySQL Specific SQL Statements:
- Auto-Increment Fields: Utilize auto-increment functionality for generating unique identifiers in your tables.
- Date & Time Data Types: Work effectively with MySQL date and time data types for accurate temporal data storage.
- Limiting Results: Control the number of rows returned by your queries using techniques for limiting results.
- Common Functions: Leverage a range of commonly used MySQL functions to enhance your SQL queries.
MySQL Database Development:
- Stored Procedures: Develop reusable stored procedures to encapsulate complex database logic.
- Stored Procedure Parameters: Understand and utilize stored procedure parameters for flexible and dynamic operations.
- Stored Functions: Create and use stored functions for performing calculations and returning values.
- Triggers: Implement MySQL triggers to automate actions in response to specific database events.
This course equips you with the skills to effectively manage and develop applications using the powerful MySQL database.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.