|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-sql-with-microsoft-sql-server/
课程评论：没有评论
**课程名称：** 用 Microsoft SQL Server 学习 SQL **课程概述：** 本课程将以快速、易学的方式教授您结构化查询语言（SQL）。您将下载并使用 Microsoft SQL Server 的免费试用版，并学会像专业人士一样使用它。数据库在当今世界至关重要，但对大多数人来说仍然是个谜。然而，只要掌握一些基本知识，使用数据库其实非常简单。 **课程内容：** * **数据库基础概念：** 了解什么是数据库、表、行、列以及数据类型。 * **Microsoft SQL Server 设置与使用：** 学习如何安装和使用 Microsoft SQL Server。 * **SQL 基础：** * `SELECT` 语句 * `WHERE`, `AND`, `OR`, `NOT` 条件 * `ORDER BY` 和 `GROUP BY` * **SQL 进阶：** * `HAVING` 和 `TOP` 子句 * `SELECT DISTINCT` * `UNION` 操作 * 常用函数 * **SQL 高级：** * `INSERT`, `UPDATE` 语句 * `DELETE` 和 `ALTER TABLE` * 表连接 (`JOIN`) * 主键 (`Primary Keys`) * 索引 (`Indexing`) * 以及更多高级主题 **学习目标：** 课程结束后，您将能够轻松、有趣地使用数据库和 SQL。
In this course I'll teach you Structured Query Language - SQL for short - the fast and easy way. We'll download and use the free trial version of Microsoft SQL Server and I'll teach you exactly how to use it like a pro. Databases are incredibly important in our modern world, and they remain a mystery to most people. But they're actually pretty easy to use if you know just a few things...and I'll teach you those things in this course. We'll start out by learning fundamental database concepts, like.what is a database, what is a table, what are rows and columns, and what are data types. After that I'll show you how to set up and use Microsoft SQL Server. Then we'll dive right in to SQL itself. I'll teach you basic concepts like - Select Statements - Where, And or Not - How to Order and Group By- And cool things like that. Then we'll move into slightly more difficult concepts like - Having and Top Clauses- Select Distinct - Union- And Functions Then we'll jump into more advanced concepts like - Insert and Update Statements- Deleting and Altering Tables- Joining Tables - Primary Keys- Indexing - And more! When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun. Join me today and I'll see you inside!
