|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-sql-certification-course-1z0-071/
课程评论：没有评论
课程名称：Oracle SQL - 完整开发者指南（2023） 课程概述： 本课程旨在全面教授Oracle SQL，适合希望成为数据库开发员的学习者。课程内容包括基本的关系数据库概念、SQL选择语句的构成以及SQL与数据库的关系等。课程包含多个更新和附加内容，例如18C XE和21C XE的安装指南、多租户架构、用户创建等。 学习内容包括： - SQL基本概念和查询操作 - 数据排序和限制返回行的技巧 - 数据转换、条件表达式和空值处理 - 多表连接、子查询的使用以及如何管理索引、视图和序列 - 使用分组函数、聚合数据、以及在不同时间区的日期管理 课程还提供了Oracle认证1Z0-071的准备，包括每个主题后的习题，帮助学员顺利通过认证考试。此外，课程没有任何SQL学习的先决条件，适合所有人群。讲师是一位拥有超过19年IT行业经验的数据库架构师，他将分享实际编码标准和行业最佳实践。 通过本课程，学员有望成为熟练的Oracle SQL开发者，年薪范围在60,000到100,000美元之间，并可以在IT行业中获得良好的职业发展。
Change History:Features added / updated. + Created the course on 07/16/2020.+ Added 18C XE installation Guide (Lecture: 5 Resource) on 01/07/2021.+ Added Multitenant Architecture + 21C XE installation + PDB, local & common user creation on 02/06/2023.+ Bonus lecture: Lecture: 85, 86 & 87+ Added 10 code challenges 03/12/2023.ORACLE UNIVERSITY COURSE (1Z0-071)Relational Database conceptsExplaining the theoretical and physical aspects of a relational databaseRelating clauses in SQL Select Statement to Components of an ERDExplaining the relationship between a database and SQLRestricting and Sorting DataApplying Rules of precedence for operators in an expressionLimiting Rows Returned in a SQL StatementUsing Substitution VariablesUsing the DEFINE and VERIFY commands.Sorting DataUsing Conversion Functions and Conditional ExpressionsApplying the NVL, NULLIF, and COALESCE functions to data.Understanding implicit and explicit data type conversionUsing the TO_CHAR, TO_NUMBER, and TO_DATE conversion functionsNesting multiple functionsDisplaying Data from Multiple TablesUsing Self-joinsUsing Various Types of JoinsUsing Non equijoinsUsing OUTER joinsUnderstanding and Using Cartesian ProductsUsing SET OperatorsMatching the SELECT statements.Using the ORDER BY clause in set operationsUsing The INTERSECT operator.Using The MINUS operatorUsing The UNION and UNION ALL operatorsManaging Indexes Synonyms and SequencesManaging IndexesManaging SynonymsManaging SequencesManaging ViewsManaging ViewsManaging Objects with Data Dictionary ViewsUsing data dictionary viewsRetrieving Data using the SQL SELECT StatementUsing Column aliasesUsing The SQL SELECT statement.Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keywordUsing Arithmetic expressions and NULL values in the SELECT statement.Using Single-Row Functions to Customize OutputManipulating strings with character functions in SQL SELECT and WERE clauses.Performing arithmetic with date dataManipulating numbers with the ROUND, TRUNC and MOD functionsManipulating dates with the date functionReporting Aggregated Data Using Group FunctionsRestricting Group ResultsCreating Groups of DataUsing Group FunctionsUsing Subqueries to Solve QueriesUsing Single Row SubqueriesUsing Multiple Row SubqueriesUpdate and delete rows using correlated subqueries.Managing Tables using DML statementsManaging Database TransactionsControlling transactionsPerform Insert, Update and Delete operations.Performing multi table InsertsPerforming Merge statementsUse DDL to manage tables and their relationships.Describing and Working with TablesDescribing and Working with Columns and Data TypesCreating tablesDropping columns and setting column UNUSEDTruncating tablesCreating and using Temporary TablesCreating and using external tablesManaging ConstraintsControlling User AccessDifferentiating system privileges from object privilegesGranting privileges on tablesDistinguishing between granting privileges and rolesManaging Data in Different Time ZonesWorking with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMPWorking with INTERVAL data typesThis course designed to learn Oracle SQL step by step and master it.Database Developer are mostly sought and highly paid job (60,000 - 100,000$ per year).You can learn SQL and clear Oracle certification 1Z0-071 (OCA- Oracle Certified Associate), It will give boast to your career as a Pro-SQL Programmer.1Z0-071 question after each topic will help you to clear the certification. It is also much easier to master the language as there is no prerequisite to learn SQL. I have around 19 years of real time IT experience as an Architect in Database related technologies. This course is prepared based steps by step approach with real time coding standards and best practices in the industry, what I have learned in my career.It will definitely helpful all the aspirant who wants to join IT industry as database developer.The Trainer is an Architect with over 19+ years of experience, he has spent 15+ years working with SQLAn Oracle Certified Professions (OCP)Oracle Technology Network (OTN) Points: 12,975 Level: MasterBe a Pro- Oracle SQL Developer Clear Oracle Certified Associate Exam A Complete SQL Bootcamp!
