|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-with-postgresql-mysql-sql-server/
课程评论：没有评论
课程名称：初学者的SQL课程（使用：PostgreSQL、MySQL、SQL Server） 课程概述： SQL是一种访问和操作数据库的标准语言，是许多行业中需求量最大的技术技能之一。SQL代表结构化查询语言（Structured Query Language），可以执行多种操作，包括： - 访问和操作数据库 - 执行数据库查询 - 从数据库中检索数据 - 向数据库插入记录 - 更新数据库中的记录 - 从数据库中删除记录 - 创建新数据库和新表 - 创建存储过程和视图 - 过滤和排序返回的数据 - 清空和删除表 该课程将介绍三种流行的数据库管理系统： 1. **PostgreSQL**：一个强大的开源对象关系数据库系统，支持SQL和JSON查询，经过20多年开发，具有高度稳定性，广泛应用于web应用程序和移动大数据分析。 2. **MySQL**：基于SQL的关系数据库管理系统，被广泛用于数据仓库、电子商务及日志应用，最常见的用途是作为web数据库。 3. **SQL Server**：由微软开发的关系数据库管理系统，旨在与MySQL和Oracle数据库竞争。SQL Server支持ANSI SQL，并具有自身的SQL语言实现—T-SQL（Transact-SQL），提供了更多声明变量、异常处理和存储过程等功能。SQL Server Management Studio (SSMS)是SQL Server的主要界面工具，兼容32位和64位环境。 本课程为那些希望学习和掌握SQL基础知识的初学者提供了全面的指南，帮助学员在多个流行的数据库系统中进行有效的数据管理。
SQL is a standard language for accessing and manipulating databases.SQL is one of the most in-demand tech skill used across many industries.What is SQL?SQL stands for Structured Query LanguageWhat Can SQL do?SQL lets you access and manipulate databasesSQL 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 filter data returned from a databaseSQL can sort data returned by a database.SQL can be used to truncate and drop tables.PostgreSQL is a powerful, open source object-relational database system.PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.MySQL is a relational database management system based on SQL - Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database.SQL SERVER is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database.SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL).T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capabilities of declaring variable, exception handling, stored procedure, etc.SQL Server Management Studio (SSMS) is the main interface tool for SQL Server, and it supports both 32-bit and 64-bit environments.
