|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/build-sql-queries-with-excel-from-scratch/
课程评论：没有评论
课程名称：从零开始用Excel构建SQL查询 概述： SQL是一种标准语言，用于访问和操作数据库。SQL代表结构化查询语言（Structured Query Language），使您能够访问和操作数据库。SQL在1986年成为美国国家标准协会（ANSI）的标准，并在1987年成为国际标准化组织（ISO）的标准。 SQL的功能： - 执行数据库查询 - 从数据库中检索数据 - 向数据库中插入记录 - 更新数据库中的记录 - 从数据库中删除记录 - 创建新的数据库 - 在数据库中创建新表 - 创建存储过程 - 创建视图 - 设置表、过程和视图的权限 尽管SQL是ANSI/ISO标准，但各个版本的SQL语言存在差异。然而，为了符合ANSI标准，它们都以类似的方式支持主要命令，例如SELECT、UPDATE、DELETE、INSERT和WHERE。SQL在数据库开发和操作中非常有用和重要。使用SQL可以执行许多任务，并且分享更有效的SQL工作方法总是有益的。 在实际生产环境中，执行批量更新、删除或插入是一项常见任务。如果不专注，这些任务可能会非常耗时和棘手，错误的发生可能会导致生产环境的问题。Microsoft Excel在进行大规模更新、删除和插入时非常有用，能够节省大量时间并帮助避免错误。通过Excel，我能快速构建从简单到复杂的SQL查询，以执行各种批量SQL任务。 在本课程中，我将逐步教您如何从零开始构建SQL脚本，您将在课程中使用这些脚本执行插入和更新的批量任务。您将在本课程中学习到的技能将帮助您自信地处理实际生产环境中的任何批量SQL请求任务。
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.SQL is a very useful and important language in database development and manipulation. There are several ways to perform numerous task using SQL and it's always useful to share new ideas and ways to make us work more efficiently using SQL.A common task that you may have to perform in a live production environment is bulk updates, deletions or inserts. These tasks can be both time consuming and delicate if one is not focussed. By delicate I mean mistakes could be made that can cause problems in a live production environment if one is not switched on and focussed.Microsoft excel has been a very useful tool to me when i have had to do bulk updates ,deletions and inserts. It saves so much time and helps you avoid errors especially with bulk deletions. With excel i am able to quickly build simple to complex SQL queries that i can you execute various bulk sql tasks.In this course i will show you how to build SQL scripts from scratch step by step that you will use during the course to execute insert and update bulk tasks. The skills you will learn on this course will help you confidently approach any bulk SQL request task you in a live production environment.
