Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development MySQL

MySQL 零基础从入门到精通

10个小时,零基础开始,手把手教您入门以及熟练掌握SQL/MySQL相关技术点,全网最好的MySQL中文课程!
Bestseller
Rating: 4.6 out of 54.6 (426 ratings)
2,249 students
Created by Peng Xiao
Last updated 12/2020
Simplified Chinese
30-Day Money-Back Guarantee

What you'll learn

  • 掌握SQL语法
  • 掌握MySQL的基本操作
  • database和table的基本操作
  • 数据的插入
  • 数据的增删改查CRUD
  • SQL中字符串的操作方法
  • SELECT结果的再整理,排序,LIMIT
  • 数据的分组和聚合
  • MySQL数据类型精讲
  • SQL语句的逻辑操作符
  • MySQL内置函数
  • 一对多,多对多关系表

Course content

17 sections • 151 lectures • 12h 18m total length

  • Preview03:40
  • SQL和NOSQL
    04:40
  • 为什么选MySQL
    01:26
  • 广告时间:欢迎大家订阅我的YouTube Channel
    00:25
  • 学习建议
    00:08
  • 关于MySQL版本的选择
    01:16
  • Preview09:52
  • DOC: Install MySQL on Mac
    01:01
  • Install MySQL on Windows
    13:59
  • Install MySQL on LInux
    14:45
  • DOC: Install MySQL on Linux
    00:03
  • 推荐一下vscode
    01:51
  • 通过Docker来搭建MySQL的环境
    00:00

  • Overview
    02:07
  • Database Level的基本操作
    02:04
  • Demo: Database Level的基本操作
    03:17
  • 解释:为什么要输入分号执行SQL
    01:56
  • 解释:关于SQL语句大小写的问题
    01:48
  • Table Overview
    03:21
  • Table Data Type介绍
    04:53
  • Table的创建
    03:13
  • Demo: Table的创建
    02:30
  • Table的相关操作和Demo
    03:01
  • 练习:创建一个职工信息Table
    01:46
  • 讲解:创建一个职工信息Table
    08:45

  • Overview
    00:50
  • Data Insert
    04:13
  • Demo: Data Insert
    03:25
  • SELECT语句的基本使用讲解
    03:20
  • 练习:往职工信息表里插入数据
    01:32
  • 讲解:往职工信息表里插入数据
    02:47
  • NULL和NOT NULL
    07:07
  • 设置默认值Default Value
    02:55
  • Primary Key
    07:22
  • UNIQUE
    08:13
  • 联合PRIMARY KEY
    03:24
  • 练习:改造职工信息表
    01:59
  • Preview02:32

  • Overview
    01:46
  • 学习使用sql文件
    05:19
  • sql文件在windows系统里的使用
    01:58
  • Windows环境下使用SQL文件的注意事项
    00:01
  • 在Docker环境下使用SQL文件
    00:55
  • 数据准备
    02:55
  • SELECT语句的继续讲解
    03:40
  • 通过where语句过滤
    06:45
  • 通过update语句更新数据
    05:11
  • 通过delete语句删除数据
    06:20
  • CRUD练习题
    04:35
  • CRUD练习题讲解
    09:00
  • Answer SQL
    00:41

  • Overview
    00:57
  • 数据准备
    01:21
  • 字符拼接CONCAT
    07:47
  • 子串SUBSTRINg
    07:30
  • REPLACE, REVERSE and CHAR_LENGTH
    04:45
  • 大小写转换LOWER和UPPER
    02:20
  • 字符处理练习
    11:24

  • Overview
    01:03
  • 数据准备
    01:32
  • ORDER BY对返回结果进行排序
    06:46
  • LIMIT限制返回结果的数量
    05:29
  • LIKE进行字符串搜索过滤
    10:04
  • 大小写的匹配问题
    03:36
  • 练习和解答
    10:43

  • Overview
    02:46
  • 数据准备
    01:03
  • COUNT对结果进行计数
    02:30
  • DISTINCT统计唯一值
    02:05
  • GROUP BY数据整合
    08:21
  • MAX和MIN求最大值最小值
    03:42
  • SUM和AVG求和和平均值
    07:18
  • HAVING
    04:26
  • 练习和解答
    11:19

  • Overview
    05:00
  • Integer Types整数类型
    10:21
  • Fixed-Point Types
    09:33
  • Floating-Point Types
    04:38
  • Bit-Value Type
    08:33
  • 练习和解答
    08:10

  • Overview
    01:22
  • DATE和TIME
    09:52
  • YEAR
    06:46
  • DATETIME和TIMESTAMP
    13:42
  • 关于时区timezone
    05:20
  • 关于时区timezone的讲解修正
    03:59
  • 关于时间和日期的函数方法
    04:22
  • 练习和解答
    06:59

  • Overview
    01:33
  • CHAR和VACHAR
    07:58
  • BINARY和VARBINARY
    03:20
  • BLOB和TEXT
    04:10
  • ENUM
    01:29
  • SET
    09:49
  • 补充内容:已经定义好的Table,Column的数据类型能修改么?
    02:34

Requirements

  • 一台windows或者Mac

Description

当今是数据的时代!各种数据库技术是在数据处理环节不可或缺的核心技术。MySQL作为数据库技术里最受欢迎的开源免费产品,被各大科技公司所用。

作为IT从业人员,不管您是开发者还是其他职位,掌握MySQL技术将让您能对公司业务的了解更清晰.

通过本课程,您将学到

  • SQL的基本语法

  • 通过聚合Aggregate来分析处理数据

  • 通过函数和逻辑操作符实现复杂的数据查询

  • 学会通过SQL JOIN来处理多个表的数据

  • And more!


Who this course is for:

  • Backend Developers
  • Database Administrators

Instructor

Peng Xiao
Senor Network DevOps Engineer,Python Trainer
Peng Xiao
  • 4.5 Instructor Rating
  • 3,310 Reviews
  • 32,430 Students
  • 22 Courses

Peng Xiao is a Network and Software DevOps Engineer.

He has more than 10 years experiences in IT/Network industry, worked for Cisco Systems, Nerdalize, KPN, ING in the past  8 years.

Peng is good at Python programming(more than 10 years experiences), Network technologies especially L3 routing protocols, distributed systems, database, etc. He also like open sourced technologies, and as a GitHub user  he joined some open sourced groups and made some contribution to them.

He is a scrum master and have a Cisco Service Provider CCIE certification.

He is working and living in the Netherlands now.

目前生活工作在荷兰, 是一名DevOps工程师。在IT相关领域有着超过10年的工作经验,先后在思科,Nerdalize,KPN,ING等公司工作过。

有超过10年的Python编程经验,是《Python3面向对象编程》第一版的中文译者之一。拥有超过6年的网络软件开发经验经验,主要方向为SDN和网络运维自动化。对于网络技术,特别是三层路由技术有着深入的研究。

Google搜索 “麦兜搞IT”可以获取到更多关于我的信息。

我拥有CCIE(#39317)认证和Scrum Master认证。


欢迎关注我的youtube频道和Twitter,链接在头像下方图标按钮。

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.