|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/98-364-database-fundamentals-microsoft-sql-server/
课程评论：没有评论
**Coursera 课程总结：Pearson INF-201 信息技术专家数据库** 本课程是 Pearson IT Specialist Certification ITF-201 “数据库基础” 的入门课程，也称为 ITS-201 和 ITN-201。课程侧重于 Microsoft SQL Server 的 T-SQL，旨在帮助您在短时间内掌握创建表、查询、视图、存储过程等核心数据库技能。 **课程亮点：** * **零基础入门：** 无需任何先验知识，课程将从免费安装 SQL Server 开始。 * **核心 T-SQL 教学：** 深入讲解 SELECT 语句的六个子句 (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY)，并指导如何创建表、插入、更新和删除数据。 * **数据库规范化：** 解释数据在表中的存储方式，以及规范化对表结构设计的重要性。 * **数据约束：** 教授如何设置数据约束以确保数据准确性。 * **高级数据库对象：** 学习创建视图、存储过程和函数。 * **性能优化与安全：** 探讨如何使用索引提高查询速度，以及数据安全和备份策略。 * **实践导向：** 课程包含定期测验，巩固学习效果。 * **职业发展助力：** 完成课程后，您将具备良好的数据库基础知识，能够独立构建 SELECT 语句，并有机会为 IT Specialist 认证考试做准备。 **学员反馈：** 学员们普遍认为课程内容充实、有趣且实用，讲师讲解深入浅出，教学方式循序渐进，易于理解。 **学习目标：** 通过本课程的学习，您将对数据库的工作原理有一个全面的了解，并能够熟练运用 T-SQL 进行基本数据库操作和查询。
This course is the foundation for the Pearson IT Specialist Certification ITF-201 "Databases Fundamentals", which is also known as ITS-201 and ITN-201, and focuses on Microsoft SQL Server's T-SQL. Learn in just a few hours how to create tables, queries, views, procedures and more.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.What do people like you say about it?Seme says "Thank you very much for your valuable course. I really enjoyed this course. Packed a lot of information , I found it very interesting and useful. Thank you."Gasper says "Phillip always does a great job, this is my third course from him. Passionate and informed, I will take as many courses as I can from him."Jonas says "Explaining SQL on a very easyway! Takes you though everything you need to know nice and calm."We start off by installing for free on your Windows desktop or laptop SQL Server, and learning how the six clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.We'll examine how data is stored in tables, and see why normalisation is important for the proper building of tables.We'll then look at constraints, which allows you to set up rules for your data. Following this, how can we insert, update and delete data? We'll also create views, procedures and functions.Finally, we'll investigate how to speed up your queries using indexes, add security, and back up your data.No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!There are regular quizzes to help you remember the information, so you can be sure that you are learning.Once finished, you will have a good introductory knowledge of how databases work and be able to construct your own SELECT statements. And with a bit of practice, you could also go for the official IT Specialist exam - wouldn't that certificate look good on your CV or resume?
