|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-to-how-to-build-bulk-sql-queries-using-excel/
课程评论：没有评论
**课程名称：** 学习如何使用 Excel 构建批量 SQL 查询 **课程概述：** SQL 是一门在数据库开发和操作中非常有用且重要的语言。执行许多任务有多种方法，分享新的想法和更高效地使用 SQL 的方法总是很有益的。在实际生产环境中，一项常见的任务是进行批量更新、删除或插入。这些任务可能耗时且风险较高，稍有不慎就可能导致问题。 Microsoft Excel 已经成为作者手中的得力工具，用于处理批量更新、删除和插入操作。它可以节省大量时间，并帮助避免错误，尤其是在批量删除时。通过 Excel，作者能够快速构建简单到复杂的 SQL 查询，用于执行各种批量 SQL 任务。 本课程将**循序渐进地**展示如何从零开始构建 SQL 脚本，用于执行批量插入和更新任务。通过本课程学到的技能，您将能够自信地处理在实际生产环境中遇到的任何批量 SQL 请求任务。 **课程内容包括：** * 下载 Oracle 数据库 * 安装 Oracle 数据库 * 下载 TOAD * 安装 TOAD * 下载并安装 JDK * 下载并安装 Oracle SQL Developer 工具 * 如何使用 Excel 构建 SQL INSERT 查询 * 如何使用 Excel 构建 SQL UPDATE 查询 * 如何使用 Excel 构建 SQL DELETE 查询 **教学方式：** 这是一门**动手实践**的课程，强烈建议您跟随课程进行操作，以便熟练掌握。 期待在课堂上见到您！祝您有美好的一天！
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.What you will learn includes:Download Oracle databaseInstall Oracle databaseDownload TOADInstall TOADDownload and Install JdkDownload and install Oracle SQL Developer ToolHow to build SQL Insert queries with ExcelHow to build SQL Update queries with ExcelHow to build SQL Update Delete queries with ExcelThis is a hands on practical course and I strongly encourage you to follow along with me to get the hang of it.Looking forward to seeing you in class:-)Have a great day!
