|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/oracle-sql-practice
课程评论：没有评论
课程名称：Oracle SQL实践课程 课程概述：本课程专为SQL初学者设计，旨在复习SQL语句，包括创建表、添加列和修改表。我们将重点讨论使用ALTER语句，学习者将通过完成练习来实践DDL和DML语句。 课程大纲： 1. **SQL复习** - 描述：在本模块中，我们将首先讨论您将在本实践课程中学到的内容。然后，我们将回顾各种SQL语句的类型，并探讨如何开发数据模型。同时，我们将指导您如何安装SQL Plus和Oracle SQL Developer，以便您能够跟随我们的活动。 2. **数据定义语言（DDL）和数据操作语言（DML）** - 描述：在这个模块中，我们将回顾如何创建表格、向其添加列及一些最佳实践。同时，我们还将学习使用ALTER语句来修改数据库，最后将重点关注DML语句的使用。 3. **实践编写SQL代码** - 描述：在本模块中，我们将进行测试。您将能够创建表格并对其进行修改，以检验您迄今为止所学的知识。如果您在自己的机器上安装了SQLPlus，请使用它，或访问https://livesql.oracle.com/以便在线测试您的代码。 这个课程提供实用的练习机会，帮助学习者巩固SQL技能，为未来的数据库管理和开发打下坚实基础。
Name:SQL Review
Description:In this module, first, we will discuss what you will learn in this practice course. Then, we'll review types of SQL statements and take a look at developing a Data Model. We'll also walk through how to install SQL Plus and Oracle SQL Developer so you can follow along with some of our activities.
Name:Data Definition Language (DDL) and Data Manipulation Language (DML)
Description:In this module, we will review creating tables and adding columns to them as well as some best practices. We will also review using alter statements to modify our database. Lastly, we'll look at DML statements.
Name:Practice Writing SQL Code
Description:In this module, we'll put you to the test. You'll be able to create tables and modify them to test what you've learned to this point. Use SQLPlus if you installed it on you own machine, or go to https://livesql.oracle.com/ if you need an online way to test your code.
This course is designed for SQL beginners to review SQL statements, including creating tables, adding columns, and modifying tables. We'll look at using alter statements and learners will practice using DDL and DML statements completing exercises.
