This course is designed to help you continue learning about Oracle SQL and prepares you to take the Oracle SQL Certification Exam.
提供方
Oracle SQL Exam Prep
LearnQuest课程信息
3,252 次近期查看
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
初级
A basic knowled of Oracle SQL foundations
完成时间大约为7 小时
英语（English）
字幕：英语（English）
您将获得的技能
- Using SQL queries
- updating database tables
- Creating primary and foreign keys
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
初级
A basic knowled of Oracle SQL foundations
完成时间大约为7 小时
英语（English）
字幕：英语（English）
提供方
LearnQuest
LearnQuest is the preferred training partner to the world’s leading companies, organizations, and government agencies. Our team boasts 20+ years of experience designing, developing and delivering a full suite industry-leading technology education classes and training solutions across the globe. Our trainers, equipped with expert industry experience and an unparalleled commitment to quality, facilitate classes that are offered in various delivery formats so our clients can obtain the training they need when and where they need it.
授课大纲 - 您将从这门课程中学到什么
完成时间为 1 小时
SQL and Table Design
In this module, we'll introduce you to the course and discuss which topics we'll cover. We'll also explore why SQL is a powerful tool to use and some of it's uses. Then, we'll explore table design and schemas.
完成时间为 1 小时
5 个视频 （总计 25 分钟）, 2 个阅读材料, 1 个测验
完成时间为 2 小时
SQL Database Terms
In this module, we'll explore some of the key terms you'll need to know when building SQL Databases. We will compare and contrast the ANY and ALL operators, distinguish between COMMIT and ROLLBACK, and explore pseudocolumns. We will also give examples for some of these terms.
完成时间为 2 小时
6 个视频 （总计 33 分钟）, 2 个阅读材料, 1 个测验
完成时间为 1 小时
Key Constraints and the USING Clause
In this module, we'll review primary and foreign keys, delving a little more into their constraints. We'll also explore the USING clause and what it is used for.
完成时间为 1 小时
4 个视频 （总计 19 分钟）, 2 个阅读材料, 1 个测验
完成时间为 2 小时
Functions, Subqueries, Pseudocolumns, and Views
In this module, we'll take a look at INSTRING and SUBSTRING functions and demonstrate naming a column using an alias. We will also explore subqueries and take another look at pseudocolumns. Lastly, we'll discuss views and compare them with materialized views.
完成时间为 2 小时
5 个视频 （总计 33 分钟）, 2 个阅读材料, 1 个测验
完成时间为 1 小时
Practice Certification Quiz
The following ungraded quiz will help you practice what you have learned before taking the Oracle SQL Certification Exam.
完成时间为 1 小时
常见问题
我什么时候能够访问课程视频和作业？
我购买证书后会得到什么？
有助学金吗？
还有其他问题吗？请访问 学生帮助中心。
