|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-databases-beginners-quick-introduction/
课程评论：没有评论
课程名称：数据库SQL基础入门 课程概述：本课程是针对初学者的SQL（结构化查询语言）入门介绍。SQL是用于与数据库进行通信和操作的语言。在本课程中，您将学习到如何使用SQL进行C.R.U.D操作，C.R.U.D是创建（Create）、读取（Read）、更新（Update）和删除（Delete）的缩写，这些是SQL在数据库中执行的主要功能。虽然SQL还可以完成其他相关任务，但其主要用途集中在C.R.U.D操作上。课程以视频讲座的形式组织，内容条理清晰，方便学习，课程总时长不到两小时，建议按顺序观看每节讲座。 通过本课程，您将获得如何使用SQL创建、读取、更新和删除数据库中数据的知识。由于SQL是标准语言，它能够以相同的方式在不同类型的数据库上执行C.R.U.D操作。课程将帮助您理解如何利用SQL操作数据库，还将学习如何检索所需的相关数据并按照您希望的方式排列。 您将在本课程中学习到的内容包括： - 如何编写SELECT语句 - 如何创建表和视图 - 如何更新数据库中的现有记录 - 如何在数据库中插入或添加新记录 - 如何从数据库表中删除记录 - 如何创建数据库报告并导出到Excel - 如何限制和排序通过SELECT查询返回的数据 - 如何使用WHERE子句过滤数据 - 如何使用ORDER BY子句按照表格列的指定顺序排列检索到的数据 准备好开始您的SQL学习之旅吧！
This course is a beginners introduction to SQL which stands for structured query language. It is the language used to communicate and manipulate databases.In this course you will learn to C.R.U.D using SQL. C.R.U.D is an acronym for Create,Read,Update and Delete. These are the main functions that SQL can do on any database. There are other related tasks that SQL does or can do but the bulk of what it is used for is C.R.U.D.The course is 100% video lectures structured in an orderly and easy to follow manner. It is advisable that you follow the course in the order of the lectures. The course is just under two hours long.This course will give you the knowledge required to create ,read ,update and delete data from any database system using SQL. This is possible because SQL is a standard language and will perform C.R.U.D in the same way regardless of the type of database. This course will help you understand How to manipulate databases using SQL. Also you will learn how to retrieve only relevant data or information you need and order them in the way you want.What you will Learn in this course includes:How to write SELECT statementsHow to create a table and a viewHow to Update existing records in a databaseHow to Insert or add new records or data into a database.How to delete a record from a database tableHow to create a database report and export to excelHow to restrict and sort data returned by the SELECT queryHow to use the WHERE Clause to filter data How to use ORDER BY Clause to put retrieved data in order specified by table column
