|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/installing-and-manipulating-oracle-database-using-sql/
课程评论：没有评论
**课程名称：** 安装和使用SQL操作Oracle数据库 **课程概述：** Oracle数据库在全球范围内被广泛应用，从大型到中型企业都用它来存储各种信息。本课程将一步步指导您从零开始安装Oracle数据库，不遗漏任何步骤。您还将获得样本模式对象和数据库表的访问权限，并学习如何使用特殊代码解锁它们。 安装完成后，您需要一个工具来连接数据库并进行数据操作。本课程将详细介绍如何安装Oracle SQL Developer（Oracle官方开发的免费工具），包括其可能遇到的安装难题和解决方案。 课程将使用SQL（结构化查询语言）与数据库进行交互，执行各种数据操作。本课程适合具备基础数据库知识和SQL知识的学习者，同时也对仅具备基本电脑操作能力的学习者友好。课程以视频形式呈现，总时长不到2小时，包含大量实践操作、易于跟随的真实场景示例。 **您将学到：** * 如何向数据库添加新数据 * 如何从数据库中删除数据 * 如何更新数据库中的现有数据 * 如何从数据库检索数据并生成报告 * 如何获取数据库中的唯一数据值
Oracle Databases are among the most widely used in the world. You will find oracle databases in large to medium size organizations to store various types of information. This course will teach you how to install an oracle database step by step from scratch with no steps skipped. You will also be getting access to a sample schema object and database tables. But before you can access the tables in the schema it has to be unlocked. I will show you the special code used to unlock that in this course. Once the database is installed you will need a tool to connect to it and perform data manipulation. The tool you will need to install is Oracle SQL developer developed by oracle. This is a free tool that can sometimes be tricky to install. I will show you how to install it step by step. You will be using SQL (Structured Query Language) to talk to and give instructions to the database to perform various types of data manipulation. This course is for those who have some very basic knowledge of database fundamentals as well as basic SQL knowledge. However the course is also easy enough for anyone who just has a basic knowledge of how to use a computer. This format of this course is video based and the duration of the course is under 2hours long The examples are practical hands on easy to follow and resembles a real life environment. .What You Learn in this course: How to add new data into a databaseHow to remove data from a databaseHow to update existing data in a databaseHow to get data from a database and create a report from itHow to Get Unique Data Values from a database
