|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-basic-database-concepts/
课程评论：没有评论
课程名称：基础数据库概念入门 课程概述： 本课程旨在介绍数据库的基本概念。数据库广泛应用于各种软件应用和设备中，用于存储和检索信息，常见的应用有Facebook、Twitter、Instagram、Pinterest、Snapchat、Google等。各类机构如银行、医院、航空公司和超市都依赖于数据库来处理数据，甚至我们每个人的社保号码、医院记录号或银行账号也都存储在数据库中。本课程将探讨数据库的若干基本概念，包括主键、外键、模式、平面文件数据库和层次数据库等。我们日常生活中频繁地与数据库交互，比如查看电子邮件或在社交媒体上发帖。课程内容以视频为主，时长不足1小时。 学习内容： - 客户端-服务器计算的基本概念 - 数据库的定义 - 平面文件数据库的概念 - 平面层次数据库的理解 - 关系数据库管理系统（RDMS）的介绍 - 数据库模式的定义 - 主键与外键的概念 - SQL语言的基础知识 - SQL（结构化查询语言）的作用与功能 - SQL与数据库（如Oracle）的互动 - SQL的标准化历史与版本差异 - SQL能够执行的操作（查询、数据检索、插入、更新、删除等） - SQL的权限管理及视图创建 尽管SQL是ANSI/ISO标准，但各个SQL语言版本之间存在差异，大多数数据库程序还包含自己特有的扩展功能。
Databases are used in applications or devices with software that stores and retrieves information. Applications like Facebook, Twitter,Instagram,Pinterest,Snapchat,Google Hotmail Mobile phones and other portable devices all have the ability to store and retrieve data. They all are able to achieve this using a database. Places like Banks,Hospitals,Airlines Supermarkets all use databases to store and retrieve data or information. Things like your Social security number ,Hospital Records number or Bank account number are all stored in a database.There are several concepts associated with databases and we will explore some of them in this course. We will learn about primary keys,foreign keys,schemas,Flat file database,hierarchial databases.We interact with databases daily in our lives like when we read our emails or post something on Facebook or twitter. This course will teach you the very basics of some database concepts and the course is video based and less than1 hour. What You Learn in this course: What is a Client - Server ComputingWhat you will learn includesWhat is a database What is a Flat file database What is a Flat hierarchical databaseWhat is a RDMSWhat is a Database schemaWhat is a Primary KeyWhat is a Foreign keySQL is the language used to interact with databases like Oracle and othersSQL is a standard language for accessing and manipulating databases.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 viewsSQL is a Standard - BUT....Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!
