|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-beginners-introduction-to-sql/
课程评论：没有评论
课程名称：SQL完全初学者入门 课程概述：SQL（结构化查询语言）是用于查询和操作微软SQL服务器数据库的语言。SQL长期以来一直是最受欢迎的IT技能之一，随着数据增长的加速，对具备SQL技能的专业人士的需求也在不断增加。本课程为完全的初学者设计，适合没有SQL接触经验的人。课程内容非常基础，并注重实践操作，以介绍大家使用SQL。我们将使用SQL Server作为本课程的数据库引擎，微软SQL Server是一种强大的关系数据库管理系统，被众多规模不同的组织使用，包括许多财富500强公司。 在本课程中，我们将涵盖以下内容： - 下载和安装SQL Server - 数据库概念 - 下载示例数据库 - 附加示例数据库 - 创建视图 - 创建表 - 使用SELECT语句从数据库中检索和读取数据 - 更新数据库中的现有数据 - 从数据库中删除记录 - 使用别名 - 使用ORDER BY子句排序数据（升序和多列排序） - 添加新记录 - 更新现有记录 - 删除记录 - 表连接（内连接、左外连接、右外连接） SQL是所有关系数据库操作的基石，充分发挥其潜力需要对语言有深刻的理解。在本课程中，您将学习如何使用SQL的全部潜力，为SQL Server数据库编写简单查询。
SQL -Structural Query language is the language used to interrogate and manipulate Microsoft SQL Server Databases. SQL is one of the most in demand IT Skills and has been that way for quite a long time. Data growth is increasing and so also is the demand for professionals with SQL skills. This course is a complete beginners course for those who have had no exposure to SQL.It is a very basic and practical hands on course to introduce you to SQL.We will be using SQL Server as our database engine for this course.Microsoft SQL Server is robust relational database management system used by so many organizations of various sizes including top fortune 100 companies. In this course we will cover Download and Install SQL ServerDatabase conceptsDownload sample databaseAttach sample databaseCreate a viewCreate a tableRetrieve and reading data from a database using SELECT StatementUpdating existing data in the databaseDeleting records from a database Use Aliases Use order by clauseSort data by ascending order Sort data by multiple columns Add new records Update existing records Delete recordsJoining TablesInner joins Left outer joins Right Outer joins SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases.
