|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-l/
课程评论：没有评论
**课程名称：** SQL 入门实战训练营 **课程概述：** 在当今信息爆炸的时代,有效管理海量数据至关重要。关系型数据库管理系统 (RDBMS) 应运而生，它们是管理数据库的利器。数据库就像一个存储信息和数据的仓库，信息以表格的形式存储，表格又由列（代表数据字段，如姓氏）和行（代表单个记录，如“安德森”）组成，这与 Excel 电子表格非常相似。数据库管理员或数据分析师需要借助 SQL (Structured Query Language) 来与数据库进行交互。SQL 是一种国际通用的、用于操作数据库的语言。 通过 SQL，你可以执行多种操作，包括： * 创建数据库 * 创建表 * 创建视图 (View) * 更新记录 * 删除记录 * 添加记录 * 读取表中的数据 * 自动化任务 本课程是一门 SQL 的基础入门课程，将重点讲解 SQL 在数据库中的核心功能，特别是 CRUD 操作 (Create, Read, Update, Delete)，这占到了你日常数据库操作的85%以上。本课程是成为数据库管理员或开发者的绝佳起点。 **课程学习内容包括：** * 数据库基础概念 * 如何创建表 * 如何创建视图 * 如何在表中更新数据 * 如何向表中添加数据 * 如何删除表中的记录 * 如何使用别名 (Aliases) 我们期待你的加入！
There is so much information around today and there has to be efficient mechanism in place to manage tthe huge volume of data. This is where relational database management systems -RDBMS comes in handy. An RDBMS is used to manage databases. What is a database? This is where information or data is stored. Databases actually stored information or data inside tables which in turn consists of columns and rows just like an excel spreadsheet. The columns represents the data fields for example LastName while the rows represents individual records like Anderson. Database administrators or data analyst need to interact with the data from the database from time to time and the way they do that is by using SQL. What is SQL - It stands for structural query language. It is an internationally used lanaguage used to manipulate databases. With SQL you can do the following and much more: Create a databaseCreate a tablecreate a viewUpdate a recordDelete a record Add a recordRead data from a tableAutomate tasks This course is a basic introductory course to SQL that will teach you the basic functions it is used for on a database such as Create Read Update and Delete collectively referred to as C.R.U.D. Over 85 percent of what you will do on a database will be CRUD related. If you want to become a database administrator or developer this course will be a good starting point. What you learn on the course include: Basic database conceptsHow to create a TableHow to create a viewHow to update data in a tableHow to add data into a tableHow to delete records in a tableHow to use Aliases I look forward to you signing up to the course.
