|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/kick-off-your-sql-skills-with-oracle-database-sql-workshop/
课程评论：没有评论
课程名称：提升您的SQL技能：Oracle数据库SQL研讨会 课程概述：本课程为学生提供了关于关系数据库（如Oracle数据库技术）的介绍，重点学习强大的SQL编程语言。学生将掌握基本的SQL技能，从而能够对单个和多个表进行查询，处理表中的数据，并创建数据库对象。在当今的商业环境中，数据的重要性不言而喻，因此掌握SQL是一项非常有用的技能。由于熟练的SQL专业人才稀缺，相关职位的需求和薪资水平相对较高。 SQL（结构化查询语言）是一种国际标准语言，用于查询和操作数据库。不同的数据库供应商，如Oracle、Microsoft和MySQL等，都支持SQL并以相似的方式执行某些操作。关键字如CREATE、SELECT、UPDATE、DELETE、WHERE和FROM等在不同的数据库供应商中也有相似的用法。本课程将教授您成为一名SQL专业人士所需的技能。掌握这些技能后，您可以自信地担任数据分析师，甚至晋升为数据库管理员。 课程将从基础开始，逐步深入至更高级的SQL内容，使用TOAD作为主要环境工具。学生将学习到以下内容： - 识别SQL语句的定义 - 理解Oracle关系数据库 - 使用TOAD连接到Oracle数据库并执行SQL任务 - 在关系表中操作数据 - 从多个表中显示数据 - 使用DESCRIBE命令创建排序及限制的数据报告 - 使用SELECT语句从表中检索行和列数据 具体内容包括： - 如何使用SELECT语句检索数据 - 如何限制和排序数据 - 如何使用单行函数 - 如何通过联接显示来自多个表的数据 - 如何使用集合运算符 - 如何使用数据定义语言 - 如何使用数据操作语言 - 如何使用各种条件子句 通过本课程，学生将充分掌握SQL的基本及应用技巧，为未来的职业发展打下坚实基础。
This Oracle Database SQL Workshop course offers students an introduction to relational databases like Oracle Database technology. Students will learn the concepts of relational databases and the powerful SQL programming language. This course provides theessential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables,and create database objects. Learning SQL is a very useful skill to have as every business and organisation is so dependent on data. There are not enough skilled SQL professionals hence the demand and pay rate for SQL professionals is quite high. SQL stands for structured query language. It is an international standard languageused to query and manipulate databases. There are different types of database vendors like Oracle, Microsoft ,MySQL and so on. They all support SQL andperforms certain operations in the same way. Keywords like CREATE,SELECT,UPDATE,DELETE,WHERE and FROM are used the same way with various database vendors. This course will teach you the skills you need to get your foot in the door as an SQL professional. With the skills you learn on this course you can work confidently as a data analyst or even progress to be a database administrator.This course will take from scratch to more advanced SQL using TOAD Students will Learn To:Identify what a SQL statement is.Understand the Oracle Relational Database.Use TOAD to connect to Oracle database and perform SQL tasksManipulate data in relational tables Display data from multiple tablesUse of the DESCRIBE commandCreate reports of sorted and restricted dataRetrieve row and column data from tables with the SELECT statementStudents will use TOAD as the main environment tool for writing SQL. How to retrieve data using SELECT StatementHow to restrict and sort dataHow to use Single Row functionsHow to display data from multiple tables using joinsHow to use SET operatorsHow to use Data Definition LanguageHow to use Data Manipulation LanguageHow to use Clauses
