|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-essentials-for-beginners-using-command-line-interface/
课程评论：没有评论
课程名称：初学者SQL基础课程（使用命令行界面） 课程概述： SQL（结构化查询语言）是访问和操作数据库的标准语言。SQL于1986年成为美国国家标准协会（ANSI）的标准，1987年成为国际标准化组织（ISO）的标准。SQL可以执行对数据库的查询、检索数据、插入记录、更新记录、删除记录、创建新数据库和表、创建存储过程和视图，并设置权限。 虽然SQL是一个标准，但不同版本的SQL语言存在差异。所有符合ANSI标准的SQL版本至少支持主要命令（如SELECT、UPDATE、DELETE、INSERT、WHERE）以类似的方式。然而，大多数SQL数据库程序在SQL标准之外也有自己的专有扩展。 本课程将使用MySQL，这是一个关系数据库管理系统，安装时会包含一些示例数据库。我们将使用MySQL客户端工具（命令行界面工具）执行数据库系统中常见的基本操作。这些基本操作简称为CRUD（创建、读取、更新和删除）。 您将学习如何创建数据库和表，插入数据，更新记录以及删除记录。通过本课程，您将掌握数据库操作的基本技能。
SQL is a standard language for accessing and manipulating databases.What is SQL?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 1987What Can SQL do?SQL 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 viewsSQL is a Standard - BUT....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.Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!In this course we will use MySQL which is a relational database management system that comes with some sample database when installed.We will perform the essential operations that occur frequently on any database system using the MySQL Client Tool which is a command line interface utility.The most essential operations on any database system is called CRUDCreate Read Update DeleteYou will learn how to create database and table ; also how to insert some data into the table ,update records and the delete records.
