|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-developer/
课程评论：没有评论
课程名称：SQL Developer 技巧与窍门 课程概述：您是否厌倦了记忆SQL语法来执行日常的数据库操作？解决方案是：使用 Oracle SQL Developer 图形用户界面 (GUI)。Oracle SQL Developer 是一个功能强大的SQL客户端，提供图形用户界面，用于数据库的查询和管理。本课程将一步步教您如何使用这个GUI环境执行各种SQL操作。您将学习（所有这些都通过图形用户界面完成，无需编码）： * 创建表 * 向表中添加新列 * 向表中添加索引 * 向表中添加约束 * 插入、更新和删除表中的数据 * 将SQL保存为视图 * 将SQL保存到桌面 * 将数据导出到Excel工作表 * 将数据从Excel工作表导入到数据库表中 * 监控其他用户活动 * 使用查询生成器构建SQL * 以及更多。 当然，我也会在这里回答您的问题。
Are you TIRED!!!! of remembering the Syntax of SQL to perform your day to day database operations?? The solution to this problem is: Use a Oracle SQL Developer Graphical User Interface(GUI). Oracle SQL Developer is a powerful SQL client with Graphical User Interface(GUI) for querying and administration of databases. In this course I will be teaching you step by step how to perform various SQL operations using this GUI environment. You will learn how to.(All of this using Graphical user Interface without typing) Create tablesAdd new columns to the tablesAdd Indexes to the tablesAdd constraints to the tablesInsert, Update and Delete data from the tableSave your SQL as a ViewSave your SQL to DesktopExport data to an Excel worksheetImport data from an Excel worksheet to database tableMonitoring other User activitiesBuilding SQL's using Query Builderand many more. and of course I will be there to answer your questions.....
