|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-from-scratch-using-oracle-sql-developer-and-toad/
课程评论：没有评论
**课程名称：** 从零开始学习 Oracle SQL Developer 和 TOAD 的 SQL **课程概述：** 该课程旨在教授学员 SQL（结构化查询语言）这一极具价值的技能。在当今数据驱动的商业环境中，SQL 专业的熟练人才供不应求，因此市场需求和薪资水平都相当可观。SQL 是用于查询和操作数据库的国际标准语言，被 Oracle、Microsoft、MySQL 等各类数据库厂商普遍支持，并且在核心操作（如 CREATE, SELECT, UPDATE, DELETE, WHERE, FROM 等关键字）上保持一致性。 本课程将从基础知识出发，逐步深入，帮助学员掌握成为一名 SQL 专业人士所需的技能，并能够自信地担任数据分析师，甚至进一步发展为数据库管理员。 **主要学习内容：** * 数据库基础概念 * SQL 子语言：DDL（数据定义语言）和 DML（数据操纵语言） * 聚合函数 * 逻辑运算符 * 集合运算符 * 表连接（Table Joins） * 分析函数（Analytic Functions） * 单行函数（Single Row Functions） * 创建表（Creating Tables） * 创建视图（Creating Views） * 创建序列（Creating Sequences） * 创建索引（Creating Indexes） * 使用别名（Using Aliases） * 使用子查询（Using Sub Queries） * NULL 值处理 * 数据限制和分页（Restricting and Limiting Data） **课程目标：** 完成本课程后，学员将能够熟练地编写 SQL 查询，执行数据库的四项核心操作：创建（CREATE）、读取（READ）、更新（UPDATE）和删除（DELETE）数据。
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 and SQL Developer TOOL Some of what you will learn on this course includes: Database conceptsSQL SUB Languages -DDL and DMLAggregate FunctionsLogical OperatorsSET OperatorsTable JoinsAnalytic FunctionsSingle Row FunctionsCreating TablesCreating ViewsCreating SequencesCreating IndexesUsing AliasesUsing Sub QueriesNULL ValuesRestricting and Limiting Data By the end of this course you will confidently be able to write SQL queriesto create,read,update and delete data which are the key functions that are performedon a database.
