|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-essentials/
课程评论：没有评论
课程名称：Microsoft SQL Server Essentials 课程概述： Microsoft SQL Server Essentials 课程带您深入了解微软的 SQL Server 数据库，从基础知识开始学习。您将熟悉结构化查询语言（SQL）及其微软版本（T-SQL）。课程结束时，您应能： - 理解关系数据库的概念 - 熟悉 Microsoft SQL Server 环境 - 使用 Microsoft 的集成开发环境：SQL Server Management Studio - 学会通过图形用户界面（GUI）执行多种数据库任务 - 理解并编写 T-SQL，即微软的 SQL 版本 - 从零开始创建数据库，并处理现有数据库 - 创建数据库表并定义它们之间的关系 - 理解表约束的概念 - 创建主键、外键等 - 熟练使用 SQL Server Management Studio - 掌握数据定义语言（DDL） - 掌握数据操作语言（DML） - 编写简单到复杂的查询 - 学习使用 SQL Server 中的各种内置函数，如日期和字符串函数 - 学习如何使用不同的命令过滤查询 - 学习如何对查询结果进行聚合 - 处理触发器、视图和存储过程 - 学习如何使用 SQL Server Agent 调度作业 - 学习如何优化数据库查询以获得最佳执行效果 该课程非常适合想要开始后端开发、数据分析或全栈开发的初学者。您将学习从初学者到专业人士所需的所有知识，掌握 Microsoft SQL Server 的使用技巧。
Microsoft SQL Server Essentials takes you through the journey of learning about the SQL Server database from Microsoft from the ground up. You will become familiar with concepts such as the Structured Query Language (SQL) and Microsoft's version (T-SQL).At the end of the course, you should:- Understand the concept of a relational database- Become familiar with Microsoft SQL Server- Work with Microsoft's IDE: SQL Server Management Studio- Learn how to perform many database tasks using the Graphical User Interface (GUI) - Understand & write T-SQL which is Microsoft's version of SQL- Create databases from the ground up and work with existing database- Create database tables and define relationships between them- Understand the concept of table constraints- Create primary keys, foreign keys etc.- Get comfortable with SQL Server Management Studio- Master DDL - Data Definition Language- Master DML - Data Manipulation Language- Write simple to complex queries- Learn how to use the various built-in functions in SQL Server such as DATE and STRING functions- Learn how to filter queries with various commands- Learn how to aggregate your query results- Work with triggers, views and stored procedure- Learn how to schedule jobs using SQL Server Agent- Learn how to optimize your database queries for optimal executionThis course is ideal if you are getting started with backend development, data analytics or full stack development. You will learn everything you need to know in order to go from beginner to pro in Microsoft SQL Server.
