|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-sfg/
课程评论：没有评论
课程名称：初学者SQL 概述：SQL代表结构化查询语言，是一种用于访问和操作数据库的编程语言。自1986年在美国国家标准协会（ANSI）及1987年在国际标准化组织（ISO）成为标准以来，SQL已被广泛应用。SQL的功能包括执行数据库查询、检索数据、插入记录、更新记录、删除记录，创建新数据库、创建新表、创建存储过程、创建视图、设置表、过程和视图的权限等。SQL特别适用于处理结构化数据，即涉及实体和变量之间关系的数据。学习SQL查询有助于建立这些关系。 在本课程中，您将学习到SQL的所有重要概念，包括： 1) 数据库基础知识 2) SQL基础知识 3) 如何处理嵌套和复杂查询 4) 及更多内容 通过本课程，您将掌握使用SQL进行数据库管理的核心技能，为进一步学习和应用打下坚实基础。
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 "sequel"; Structured Query Language)is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables. So to establish the relationship entities and variables you need to learn how to work with SQL queries. In this you will learn all important concepts related to SQL.What you will Learn in this course ?1) Basics of Database 2) Basics of SQL3) How to work with nested & complex queries & Many More
