|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-development-for-beginners/
课程评论：没有评论
课程名称：《完整的Oracle SQL课程 - 复习》 课程概述： 本课程是关于结构化查询语言（SQL）的全面介绍，基于Oracle数据库在Windows 10中的SQL实现，内容覆盖Oracle 12c数据库及其开发工具。课程包含超过220节讲座，并包含数据库管理的额外讲座，适合希望获得Oracle数据库12c SQL认证的学员。所有视频课程均配有完整的字幕。 关于课程内容： 本课程最初旨在面向初学者，当我逐步完善课程内容后，决定将其改名为《完整的Oracle SQL课程》，以涵盖Oracle SQL考试1Z0-071的大部分主题。课程从初级课程开始，逐步深入到各级别。 关于SQL： SQL是与数据库系统交互的标准语言，具有多个十年的历史，在关系数据库管理系统（RDBMS）中占据主导地位。尽管有许多其他语言已逐渐消失，SQL仍然持续发展并稳居主流。 关于Oracle数据库： Oracle数据库是RDBMS领域中重要的数据库系统之一，其他包括Microsoft SQL Server和MySQL等。不同的数据库系统在SQL的实现上存在细微的差别，但整体上，SQL在各个平台上相对标准化。因此，掌握Oracle SQL的人也可以较容易地学习其他数据库系统。 课程大纲： 课程从介绍Oracle RDBMS环境开始，然后深入各种SQL语句类型（如DDL、DML和TCL），并探讨SQL语句、条件、排序、函数和分组等多种内容。此外，课程还提供必需的数据库管理技巧，并覆盖Oracle SQL认证考试1Z0-071的大部分主题。 关于认证： Oracle提供的认证在全球广受认可，其中包含Oracle数据库12c SQL认证。虽然本课程涵盖了考试的主要主题，但并不仅仅是备考的唯一资料，建议学员参考Oracle推荐的书籍。 讲师信息： 本课程的讲师萨姆·德哈纳赛卡（Mr. Sam Dhanasekaran）拥有超过20年的IT经验，主要包括数据库支持、IT支持和招聘相关工作。 预览信息： 课程的公共预览部分开放了比要求更多的课程，建议学员详细浏览，以了解讲师的讲解风格和技术知识。 字幕/闭合字幕： 所有视频讲座均配有字幕，学员可以根据需要开启。 通过本课程的学习，您将为成为Oracle SQL开发人员和获取Oracle SQL认证打下坚实的基础。
Quick Info:Latest update: Jan 2024More than 220 LecturesVery Comprehensive with extra lectures on Database AdministrationMay help in obtaining Oracle Database 12c SQL Certification.With FULL Subtitles for all the video lessonsAbout This Course:Welcome to the course, The Complete Oracle SQL Course.This course introduces SQL, which is an acronym for 'Structured Query Language', to its students. This is based on Oracle's SQL implementation for Oracle Databases. The lessons are based on Oracle 12c Database and SQL Developer Tools running in Windows 10.This course may help you in taking a step towards..in becoming an 'Oracle SQL Developer'in achieving 'Oracle SQL Certification'About the Name of this Course:When I started out to create this course, I wanted to create a Beginner Level Oracle SQL course. So I named it as 'SQL Development for Beginners'.However as I progressed, I decided to make it much more comprehensive and cover most of the topics in the curriculum of Oracle SQL exam 1Z0-071. And so I renamed it to, The Complete Oracle SQL Course.So, this course starts with Beginner Level lessons and progresses into next levels.About SQL:SQL is used to interact with Database Systems. As per ANSI (American National Standards Institute), SQL is the standard language for Relational Database Management Systems.SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existed two decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.About Oracle Database:Oracle Database is one of the prominent Database Systems in the RDBMS (Relational Database Management Systems) segment. Some of the other prominent Database Systems areMicrosoft SQL ServerMySQLSybase ASE.They also use SQL to interact with their Database Systems. While there are subtle differences between each of their SQL implementations, a SQL as a whole, is generally very standard. So a person with SQL knowledge in one platform such as Oracle, may find it easier to learn and code for other Database Systems such as Microsoft SQL or MySQL. The point is, once you learn SQL, then your reach into the job market is very wide.About the Curriculum:The curriculum has been carefully designed to introduce the Oracle RDBMS environment first.Then it moves on to various types of SQL Statements such as DDL, DML and TCL.And next, it goes to the depths of various SQL Statements, Conditions, Sorting, Functions, Grouping etc..It also gives Database Administration tips, as needed.It is also covers most of the topics from the Oracle SQL Certification Exam 1Z0-071 Oracle Certification:Oracle awards certain certifications that are recognized globallyOne such certification is Oracle Database 12c SQL Certified AssociateThe exam for that certification is (currently as of May 2016), 1Z0-071.The topics in this course covers most of the topics for that exam.Oracle Certification - Declarations While this course covers most of the topics for that exam, this course is not a sole material for that exam. Additional materials such as Oracle's recommended Books may be needed.This course is NOT an official course from Oracle Corporation.This course has been developed individually by its author.About the Instructor:The instructor of this course, Mr.Sam Dhanasekaran, has more than 20 years of IT experience. It predominantly includes Database Support, IT Support and Recruiting.About Previews:More lessons have been opened for public previews than the required amount. Please take your time to go through all of them. This will give you an idea about the instructor's presentation style, technical knowledge etc.Subtitles/Closed Captions:All the video based lectures contain subtitles or closed-captions. You would be able to enable them if needed.
