|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-sql-from-beginning-to-advance-level-2025/
课程评论：没有评论
课程名称：Oracle SQL：从入门到高级水平（2025） 课程概述： 本课程旨在全面介绍Oracle数据库及其相关操作，适合不同水平的学习者。课程内容涵盖了Oracle数据库的基础知识、安装与设置、SQL语法与数据操作等各个层面。 主要内容包括： 1. **Oracle数据库介绍**： - 数据库及其历史背景 - Oracle数据库的安装与配置 - 使用SQL Developer进行数据库连接 2. **SQL基础与表的创建**： - SQL语法及其种类（DQL, DML, DDL, DCL, TCL） - 数据类型及其使用 - 使用SELECT语句检索数据 - 创建、修改及删除表的DDL命令 3. **数据操作语言（DML）**： - 数据插入、更新与删除 - Merge命令的使用 - 数据库中的各种操作符（算术、关系、逻辑等） 4. **连接与联结（Joins）**： - 多表数据检索与表别名、列别名 - 不同类型的连接及其使用（内连接、外连接等） 5. **内置函数与聚合函数**： - 单行与多行函数的介绍 - 使用HAVING和GROUP BY子句进行数据分组分析 6. **子查询与分析函数**： - 子查询的种类与使用 - 分析函数（如Rank和Lead等）的应用 7. **集合运算符与数据字典**： - 集合运算符的使用（UNION, INTERSECT等） - Oracle数据字典、索引、视图及其它相关主题 8. **约束与系统变量**： - 数据完整性约束的设置 - 系统变量的使用与配置 本课程适合希望深入了解Oracle SQL的学习者，为您提供了从基础到高级的完整知识体系，帮助您掌握数据库管理和SQL语言的各个方面。
Introduction of Oracle DatabaseWhat is a DatabaseIntroduction Oracle DatabaseHistory of Oracle DatabaseInstallation of Oracle DatabaseDownloading and Installation of and 21C Oracle DatabaseDownloading and setup of SQL Developer-23Logging on to the Oracle Database using SQL*Plus and introduction of SQL Developer (tool to develop of SQL statements)Setup the Test / work environmentIntroduction of SQL and Creating Tables in Oracle DatabaseIntroduction to SQLTypes the types of SQL statements - DQL, DML, DDL, DCL and TCLData types in Oracle databaseRetrieving data using SELECT statement i.e. displaying data from a table for all Columns and Specific ColumnsIntroduction of dummy tableTypes of Operators in Oracle database - Arithmetic, Relational, Logical, Special OperatorsDDL commandsIntroduction to DDL commands in Oracle databaseCreating Tables in Oracle Database using CREATE statementDisplaying the table structure (DESCRIBE) in command SQL*Plus and in SQL DeveloperAltering / modifying table i.e. adding a new column in the tableModifying the column data type in the tableRenaming and deleting the column of the tableRenaming the tableDropping the table using DROP commandRecyclebin and Flashback to recover dropped tableDML statements (Data retrieving)Introduction to DML statements in Oracle databaseInserting data in the tableUpdating the data using UPDATE in the table - updating records in certain criteria or updating the whole tableDeleting the data using DELETE in the table - single record or deleting whole table dataMerge commandDifference in Delete and truncate statementsSQL OperatorsWhat is Dual table?What is SQL Operator?Arithmetic OperatorsComparison Operators / Relational OperatorsLogical Operator - AND, OR etc.What is NULL?Special Operator - IN / NOT IN, BETWEEN / NOT BETWEEN, IS NULL / IS NOT NULL, LIKE / NOT LIKE, ANY / ALLIntroduction of Joins i.e. retrieving data from multiple tablesTable alias and column aliasIntroduction of joinsOracle 8i joins - Equi or Inner, Non-Equi, Self, Outer JoinsOracle 9i / ANSI joinso Inner joino Left Outer joino Right Outer joino Full outer joino Natural joino Cross joinIntroduction of Built-in FunctionsIntroduction of FunctionsTypes of single row functionso String functionso Numeric functionso Date functionsConversion functionso Convert date type string to Date valueo Convert number type to character / string typeo Convert date type to character / string typeAggregate Functions (Multiple Rows Functions) in SQLDISTINCT keyword in SELECT statementIntroduction of Aggregate FunctionsTypes of Aggregate Functionso Count()o Maximum - MAX()o Minimum - MIN()o Average - AVG()o Sum()Introduction of Group By clauseIntroduction of Having clauseRollup, Cube and ListAgg FunctionsSub-QueriesROWNUMROWIDTypes of Sub-QueriesExists and Not Exists OperatorAnalytical FunctionsTypes of Analytical Functionso Rank(), Dense_Rank() and Row_number()o Lag() and Lead()o First_Value() and Last_Value()o Grouping() and Grouping_id()Set OperatorsTypes of Set operators - UNION, UNION ALL, INTERSECT, MINUSOracle Data Dictionary and other topicsIntroduction of Oracle Data DictionaryIntroduction of Index in Oracle DatabaseIntroduction of Sequence in Oracle DatabaseIntroduction of View in Oracle DatabaseIntroduction of Materialized View in Oracle DatabaseIntroduction of Synonym in Oracle DatabaseDecode and Case statementMerge statementVirtual ColumnPivotingHierarchical QuerySet System Variableso LINESIZEo NUMWIDTHo NUMFORMATo PAGESIZEo ECHO ON/OFFo FEEDBACK ON/OFFo HEADING ON/OFFo PAUSE ON / OFFo VERIFY ON / OFFo Date FormatConstraintsIntroduction of Constraints in Oracle Databaseo NOT NULLo DEFAULTo UNIQUEo CHECKo PRIMARY KEYo FOREIGN KEY (Referential Integrity)
