|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-with-microsoft-sql-server-postgresql/
课程评论：没有评论
课程名称：初学者的SQL：Microsoft SQL Server与PostgreSQL 课程概述： SQL（结构化查询语言）是数据专业人士的关键工具，毫无疑问是数据分析和数据科学领域求职的最重要语言之一。随着每分钟生成百万条数据，原始数据本身并没有故事可讲。当数据被存储在数据库中时，专业人士使用SQL提取这些数据以进行进一步分析。SQL是从关系数据库中提取和组织数据的通用语言。 数据库是由行和列组成的表。SQL是数据库的语言，能够方便地从数据库中检索特定信息，这些信息随后可用于分析。SQL的主要功能包括： - 对数据库执行查询 - 从数据库检索数据 - 向数据库插入记录 - 更新数据库中的记录 - 从数据库删除记录 - 创建新数据库或新表 - 在数据库中创建存储过程和视图 - 设置表、过程和视图的权限 - 备份和恢复数据 - 连接多个表中的数据 Microsoft SQL Server是由微软开发的关系数据库管理系统，作为数据库服务器，其主要功能是根据其他应用程序的要求存储和检索数据，这些应用程序可以在同一台计算机上或通过网络在另一台计算机上运行。PostgreSQL（也称为Postgres）是一款免费的开源关系数据库管理系统，强调可扩展性和SQL的合规性。 本课程适合初学者，旨在帮助学员理解SQL基础知识，并掌握使用Microsoft SQL Server和PostgreSQL进行数据管理的技能。
SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences.Millions of data points are being generated every minute and raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.SQL is the most common language for extracting and organising data that is stored in a relational database.A database is a table that consists of rows and columns. SQL is the language of databases.It facilitates retrieving specific information from databases that are further used for analysis.SQL can be used to:Execute queries against a databaseRetrieve data from a databaseInsert records into a databaseUpdate records in a databaseDelete records from a databaseCreate new databases, or new tables in a databaseCreate stored procedures & views in a databaseSet permissions on tables, procedures, and viewsBackup and restore dataJoin data from multiple tablesMicrosoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by othersoftware applications-which may run either on the same computer or on another computer across a network. PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
