|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/everything-about-mysql-database/
课程评论：没有评论
课程名称：关于MySQL数据库的全部内容 概述：MySQL是目前最受欢迎的小型到中型网页项目数据库管理系统，仅次于专有的Oracle数据库和小型的嵌入式SQLite。MySQL的名字来源于其主要作者Ulf Michael Widenius的长女My的名字。MySQL使用结构化查询语言（SQL）来定义、更新和查询数据库。SQL几乎在所有主要的关系数据库系统中都被使用，涵盖多个平台和应用程序。本课程将教授使用和编程MySQL数据库所需的技能。数据库管理系统的特点在于SQL在各系统中的实现存在显著差异，本课程将重点展示MySQL中SQL的实现及其在数据库应用中的有效使用。我将提供清晰简明的教程，指导您创建和维护自己的MySQL数据库。课程从MySQL特有的基本SQL语法讲起，包括如何使用SELECT语句，以及如何创建、更新和删除表中的数据。我将详细介绍MySQL版SQL与标准SQL的区别，帮助您充分利用MySQL的特定方言。此外，我还会探讨基本语法，使用SQL语句创建、插入、更新和删除数据。课程内容包括从零开始创建新数据库、数据类型、事务处理、子查询、视图和存储例程。同时，我会讲解多平台的PHP PDO接口，以帮助您将数据库连接到网页应用程序。最后，我将展示一个完整的CRUD应用程序，CRUD是创建（Create）、读取（Read）、更新（Update）和删除（Delete）的缩写。了解MySQL将对您的数据库应用程序大有裨益。
MySQL is by far the most popular database management system for small- to medium-sized web projects. Only the proprietary Oracle database and the small embeddable SQLite are more widely deployed. MySQL is named after the eldest daughter of Ulf Michael Widenius, the main author of the original version of MySQL whose daughter's name is My. MySQL routines the Structured Query Language also known as SQL to define, update and query the database. SQL is used on fundamentally all major relational database systems, on many platforms and in many applications. I will cover the necessary skills to use and program a database using MySQL. It is the nature of database management systems that there is marvellous divergence between how SQL is implemented in each system. Most of this course is keen on showing you how SQL is implemented by MySQL and how it can be used effectively in your database applications. In this course, I will provide clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. We will start with the basic syntax of SQL as it's implemented by MySQL. I will explain how to use the select statement, and how to create, update, and delete data from your tables. I'll show you specifically where the MySQL version of SQL differs from the standard, and how to get the most out of MySQL specific dialect. I also will explore the basic syntax, using SQL statements to CreateInsert Update And delete data from your tables I will also cover creating a new database from scratchData typesTransactionsSubselectsViewsAnd stored routines Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications. I will cover creating and deleting databases, data types, transactions, sub selects, views, and stored routines. And finally, I will show you a full working CRUD application. CRUD is an acronym for Create, Read, Update and Delete. MySQL is one of the most widely deployed database management systems in the world. Understanding MySQL will serve you well in your database applications.
