|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-training-for-beginners/
课程评论：没有评论
**课程名称：Microsoft SQL Server 2017 数据库入门培训** **课程概述：** 本课程专为对 Microsoft SQL Server 2017 感兴趣的初学者设计，旨在帮助学员轻松理解 SQL Server 的核心概念。课程强调，在 IT 行业中，SQL Server 开发人员的高薪来源于理解和恰当运用查询，而非仅仅是编写查询本身。本在线培训将从基础知识入手，逐步深入，通过定期的测验和实践练习，巩固学员的知识。 **课程内容亮点：** * **Microsoft SQL Server 2017 安装** * **SQL Server 数据库基础：** 创建、修改和删除数据库，以及处理数据库删除问题。 * **云数据库：** 探索 Amazon AWS 和 Microsoft Azure。 * **表操作：** 创建、修改和删除表。 * **数据操作：** 插入、更新和删除表中的数据，区分 TRUNCATE 和 DELETE。 * **数据检索：** 掌握 SELECT 语句，学习使用 WHERE 子句进行数据过滤，利用各种运算符、UNION/UNION ALL、EXISTS、ORDER BY、TOP、DISTINCT、GROUP BY 和 HAVING 子句进行高效检索。 * **高级表概念：** 理解主键、外键、唯一键、NULL 值、默认值和 CHECK 约束。 * **JOIN 操作：** 学习使用各种 JOIN 类型（INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, CROSS JOIN, SELF JOIN）编写复杂查询。 * **存储过程：** 学习创建、修改和删除存储过程，了解其优势和 SQL 注入的防范。 * **内置函数：** 掌握字符串、数字、日期、转换函数以及高级函数。 * **用户定义函数 (UDF)** * **临时表 (Temp Tables)** * **触发器 (Triggers)** * **视图 (Views)** * **异常处理 (Exception Handling)** * **数据导入：** 从 Excel、平面文件和其他 SQL Server 数据库导入数据，支持数据过滤。 * **数据导出：** 导出数据至 Excel、平面文件和 SQL Server 数据库，支持数据过滤。 * **批量插入 (Bulk Insert)** * **游标 (Cursors)** * **表变量 (Table Variables)** * **派生表、EXCEPT 运算符和通用表表达式 (CTE)** **学习保障：** 本课程提供 30 天无风险退款保证。学习后，您将能够充分理解 Microsoft SQL Server 的强大功能。
Microsoft SQL Server developers are earning higher salary in IT industry, but, it's not about writing queries it's about understanding and applying the right query at right time. This course will let you understand the SQL Server concepts in an easy way. This SQL course is for beginners who are interested to learn Microsoft SQL Server Database 2017. This Online SQL Server Training course takes some of the basics and then goes in depth. There are regular quizzes and self practice assignments to help you remember the information. Microsoft SQL Server 2017 Installation Introduction to SQL Server database and its structureDatabase -How to create database -How to modify database -How to delete database -Database delete issuesCloud Database- Amazon AWS- Microsoft Azure Tables - How to create table - How to modify table - How to delete table Data manipulation - How to insert data in tables - How to update data in tables - How to delete data in tables - Truncating data vs deleting Retrieving data - Select statement Filtering data retrieval - Filtering Data with the WHERE clause - Filtering Data with the WHERE clause using various Operators - UNION Operator and UNION ALL Operator - EXISTS Operator - Sorting Data with the ORDER BY Clause - SELECT TOP Clause - DISTINCT Statement - GROUP BY Statement - HAVING Clause Advance Table Concepts - Primary Key - Foreign Key - Unique Key - Null values - Default Values - CHECK constraint Joins Learn to write complex queries using different types of Joins in SQL Server - Inner Join - Left Outer Join - Right Outer Join - Full Outer Join - Cross Join - Self Join Stored Procedure - How to create, alter and drop stored procedure - SQL Injection - Advantages of stored procedure Built-in Functions - String Functions - Numeric Functions - Date Functions - Conversion Functions - Advanced Functions User defined Functions Temp Tables Triggers ViewsException HandlingImport - Import data from excel file - Import data from flat file - Import data from another SQL server database - Filter data while importing - Import data from MySQL Export - Export data to excel file - Export data to flat File - Export data to another SQL server database - Filter data while exportingBulk InsertCursorsTable VariableDerived tables and Except operatorCommon table expressions (CTE)You will make your money back from the price of this course. If you didn't like the course you really have nothing to lose. Udemy guarantees it with their no-risk 30 day money back guarantee. So come on inside and learn about what Microsoft SQL Server has to offer.
