This course is designed for SQL beginners to review SQL statements, including creating tables, adding columns, and modifying tables. We'll look at using alter statements and learners will practice using DDL and DML statements completing exercises.
提供方
Oracle SQL Practice Course
LearnQuest课程信息
1,594 次近期查看
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
中级
完成时间大约为7 小时
英语（English）
字幕：英语（English）
您将获得的技能
- Data Modeling
- DML statements
- DDL statements
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
中级
完成时间大约为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.
授课大纲 - 您将从这门课程中学到什么
完成时间为 2 小时
SQL Review
In this module, first, we will discuss what you will learn in this practice course. Then, we'll review types of SQL statements and take a look at developing a Data Model. We'll also walk through how to install SQL Plus and Oracle SQL Developer so you can follow along with some of our activities.
完成时间为 2 小时
4 个视频 （总计 15 分钟）, 4 个阅读材料, 1 个测验
完成时间为 2 小时
Data Definition Language (DDL) and Data Manipulation Language (DML)
In this module, we will review creating tables and adding columns to them as well as some best practices. We will also review using alter statements to modify our database. Lastly, we'll look at DML statements.
完成时间为 2 小时
5 个视频 （总计 28 分钟）, 3 个阅读材料, 1 个测验
完成时间为 3 小时
Practice Writing SQL Code
In this module, we'll put you to the test. You'll be able to create tables and modify them to test what you've learned to this point. Use SQLPlus if you installed it on you own machine, or go to https://livesql.oracle.com/ if you need an online way to test your code.
完成时间为 3 小时
2 个阅读材料
常见问题
我什么时候能够访问课程视频和作业？
我购买证书后会得到什么？
有助学金吗？
还有其他问题吗？请访问 学生帮助中心。
