|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-oracle-sql-development-bootcamp-2021/
课程评论：没有评论
**Coursera 课程总结：The Complete Oracle SQL Bootcamp 2024** 本课程专为希望成为专业的 Oracle SQL 开发者并准备参加 Oracle SQL 认证考试 1Z0-071 (Oracle Certified Associate) 的学员设计。无论您是 Oracle SQL 新手还是希望提升现有技能的专业人士，本课程都将提供深入、专业的讲解。 **课程亮点：** * **零基础入门：** 即便您是 Oracle SQL 的初学者，课程也会详细讲解所有 SQL 的细节，帮助您轻松掌握。 * **技能深度提升：** 如果您已具备 SQL 基础，本课程将涵盖所有重要主题，帮助您深化和拓展您的技能。 * **实战练习驱动：** 所有课程内容都包含实践操作和解决方案。学员可以暂停视频，独立完成练习后再观看解决方案，加深理解和记忆。 * **职业发展导向：** 课程旨在帮助您获得更好的工作机会，成为一名合格的 Oracle SQL 开发者。 **课程内容涵盖（但不限于）：** * Oracle Database Express 18c 的详细下载与安装 * Oracle SQL Developer 的下载与安装 * 使用 SQL Developer 和 SQLPlus 连接 Oracle 数据库 * 使用 SELECT 语句检索数据 * 数据限制与过滤 * 数据排序 * 使用替换变量 * 使用单行函数自定义输出 * 使用分组函数进行聚合数据报告 * 使用 JOIN 连接多表查询 * 使用子查询解决复杂查询（第一部分） * 使用集合运算符 * 使用 DML 语句（INSERT, UPDATE, DELETE）进行数据操作 * 使用 DDL 语句创建表 * 使用数据字典视图管理对象 * 创建视图（详细讲解） * 创建序列、同义词和索引 * 管理 Schema 对象 * 使用子查询检索数据（第二部分） * 使用子查询操纵数据 * 用户访问控制（详细讲解） * 使用 DML 进行数据操作（第二部分） * 处理不同时区的数据 **学习建议：** 请务必在观看解决方案之前，自己尝试解决课程中的每一个实践练习，以最大化学习效果。
Welcome to the Complete Oracle SQL Bootcamp 2024. If you want to get ready and become a professional Oracle SQL Developer and Prepare for an Oracle SQL Certification Exam 1Z0-071: Oracle Certified Associate (OCA), then this course is the best for you.Do you want to get a better job?Are you bored with watching a lot of stuff, but could not learn anything?Are you looking for a really professional course?Then this is best Oracle SQL course you are looking for.You have come to the right place!If you are new to Oracle SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve you skills, this course explains all the details including all of the subjects.Get this course, and go get a better job!In this course, all the subjects are explained in a professional way.All practices and solutions are in the lessons. you can pause the video and complete the practice before resuming to watch the solution. Make sure you solve the practice on your own before moving on to the solution!Topics covered in this course:Downloading and installing Oracle database express 18c in detailsDownloading and installing Oracle SQL DeveloperConnecting to Oracle Database using SQL Developer and SQLPlusRetrieving data using the select statementRestricting / Filtering DataSorting DataUsing Substitution VariablesUsing Single-Row Functions to Customize OutputReporting Aggregated Data Using the Group FunctionsDisplaying Data from multiple tables using joinsUsing Subqueries to Solve Queries Part IUsing the Set OperatorsManipulating tables using DML Statements ( Insert, Update, Delete )Using Data Definition Language / Creating tablesManaging objects with data dictionary viewsCreating Views in detailsCreating sequences, synonyms, and indexesManaging Schema ObjectsRetrieving Data By Using Subqueries Part IIManipulating Data By Using SubqueriesControlling User Access in detailsManipulating Data using DML Part IIManaging Data in Different Time Zones
