|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-build-sql-queries-with-logical-and-set-operator/
课程评论：没有评论
**Coursera课程总结：SQL查询构建（逻辑与集合运算符）** 本课程是为SQL初学者设计的实用入门课程，旨在帮助学员掌握使用逻辑运算符和集合运算符构建SQL查询的技能。 **课程重点：** * **SQL基础：** 了解SQL（也称为Sequel）作为与Oracle数据库交互和数据操作的标准语言。 * **逻辑运算符：** 学习并实践使用以下逻辑运算符来构建条件查询： * `ANY` * `OR` * `IN` * `ISNULL` * `NOT` * `AND` * **集合运算符：** 学习并实践使用以下集合运算符来组合和比较来自不同查询的结果集： * `INTERSECT` * `UNION` * `UNION ALL` * `MINUS` **课程技能收获：** 通过本课程的学习，学员将能够： * 熟练构建包含逻辑和集合运算符的SQL查询。 * （虽然大纲未提供，但课程概述提及）备份与恢复数据库。 * （虽然大纲未提供，但课程概述提及）管理数据库用户访问和安全。 * （虽然大纲未提供，但课程概述提及）恢复被删除的表。 * （虽然大纲未提供，但课程概述提及）使用Oracle的闪回（Flashback）技术。 本课程特别适合想要提升数据处理和数据库管理技能的初学者。
Oracle is a relational database management system used by a lot of fortune 100 companies for their data solutions.SQL -Structural query language is the language used to interact and manipulate the data stored inside oracle database. SQL is also referred to as sequel by a lot of technical professionals. For you to be able to effectively work with databases you must be comfortable building simple to complexSQL queries to interact with databases. In this beginners practical hands-on course you will learn how to build SQL queries with both logical and SET operators. if you are new to writing SQL queries, this introductory course will help build up your skills. Inthis course , we'll cover the basics of how incorporate logical and set operators in your queries. The logical operators we will be using to build our SQL queries include: • ANY • OR • IN • ISNULL • NOT • AND The SET operators we will be using to build our SQL queries include: • INTERSECT • UNION • UNION ALL • MINUS After the end of this course , you will know how to: • Backup and restore a database • Manage database user access and security • Recover dropped tables • Use Oracle flashback technology.
