|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-mysql-for-beginners-analyse-and-manipulate-data/
课程评论：没有评论
课程名称：SQL与MySQL入门：数据分析与处理 概述：本课程介绍SQL（结构化查询语言）及其在数据库中的应用和数据操控。SQL是访问和操作数据库的标准语言，尽管有不同版本，但所有版本至少支持一些主要命令，如选择(SELECT)、更新(UPDATE)、删除(DELETE)、插入(INSERT)和条件(WHERE)，并遵循ANSI/ISO标准。SQL于1986年成为美国国家标准协会（ANSI）标准，1987年成为国际标准化组织（ISO）标准。SQL能够执行数据库查询、检索数据、插入记录、更新记录、删除记录、创建新数据库、创建新表、创建存储过程、创建视图及设置权限等操作。 MySQL是一种非常流行的开源关系型数据库管理系统（RDBMS），具有快速、可靠、可扩展和易于使用的特点，适用于小型和大型应用。MySQL是跨平台并符合ANSI SQL标准，自1995年首次发布以来，由甲骨文公司开发、分发和支持。MySQL的名称源于共同创始人Monty Widenius的女儿，广泛应用于Facebook、Twitter、Airbnb、Uber、GitHub、YouTube等大型网站，以及WordPress、Drupal、Joomla等内容管理系统，成为全球众多Web开发者的首选数据库。
SQL is a standard language for accessing and manipulating databases.Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsMost of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!MySQL is a very popular open-source relational database management system (RDBMS).MySQL is a relational database management systemMySQL is open-sourceMySQL is freeMySQL is ideal for both small and large applicationsMySQL is very fast, reliable, can be scaled, and easy to useMySQL is cross-platformMySQL is compliant with the ANSI SQL standardMySQL was first released in 1995MySQL is developed, distributed, and supported by Oracle CorporationMySQL is named after co-founder Monty Widenius's daughter: MyHuge websites like Facebook, Twitter, Airbnb, , Uber, GitHub, YouTube, etc.Content Management Systems like WordPress, Drupal, Joomla etc.A very large number of web developers around the world use MySQL in their development.
