|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-course-for-beginner/
课程评论：没有评论
Coursera 数据库入门 SQL 课程总结 这门 Coursera 课程专为希望成为 Oracle DBA 的初学者设计，着重强调了 SQL 和 Unix 在职业生涯初期对于 Oracle DBA 的重要性。课程将深入讲解 SQL 的基本概念，帮助学员掌握结构化查询语言的知识。 **核心内容：** * **SQL 基础：** * SQL (Structured Query Language) 的定义和作用，以及其作为 ANSI 和 ISO 标准的地位。 * SQL 的核心功能，包括执行查询、检索数据、插入、更新和删除记录、创建数据库和表、创建存储过程和视图，以及设置权限。 * **关系型数据库管理系统 (RDBMS)：** * RDBMS 的概念及其作为现代数据库系统（如 MS SQL Server, IBM DB2, Oracle, MySQL, Microsoft Access）基础的重要性。 * RDBMS 中数据的存储方式，强调数据以名为“表”的数据库对象存储，而表则由相关的列和行组成。 **课程目标：** 本课程旨在为初级 Oracle DBA 面试做好准备，确保学员具备必要的 SQL 知识，以应对面试官可能提出的关于 SQL 的问题。
I created this course to help freshers start day career as Oracle DBA. SQL and Unix is really important to start career as Oracle DBA.In this course I have explain about the basic concept of SQL. this course will help you to get the knowledge about structured query language.whenever you go for an interview as a fresher Oracle DBA there is a chances that interviewer can expect that you have a knowledge about SQL.What is SQL?SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987What Can SQL do?SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsRDBMSRDBMS stands for Relational Database Management System.RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.
