Udemyintermediatezh

老程序员带您学SQL第2篇:MySQL数据库

Learn MySQL database management! Master SQL, functions, stored procedures, triggers & more. Ideal for students, programmers, data analysts, and DBAs.

5.0(9)
34students
5h 24m
Certificate
东升 关
东升 关技术专家,技术顾问,技术图书作家,金牌讲师

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.

$ whoami — the devs behind tutorialsearch.io

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.

5.0(81)
38m
beginner
5.0(10)
1h 46m
all

中國針灸學:初階【認識經絡與穴位】

by 駿緯視聽醫學器材股份有限公司 MEDITALENT ENTERPRISES LTD.

5.0(1)
5h 2m
all

中國針灸學-21.針刺補瀉

by 駿緯視聽醫學器材股份有限公司 MEDITALENT ENTERPRISES LTD.

5.0(2)
44m
all