|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-you-can-master-the-fundamentals-of-transact-sql/
课程评论：没有评论
课程名称：如何掌握 Transact-SQL 的基本原理 课程概述： 本课程旨在帮助学习者掌握 Transact-SQL（T-SQL）的基本知识，适合初学者和希望提升 SQL Server 技能的人士。课程内容包括数据库管理、用户管理、备份等方面的基础知识，重点讲解 T-SQL 的使用，包括数据定义语言（DDL）和数据操作语言（DML）的核心概念。 课程亮点： - 通过实际案例学习 T-SQL 的基本原理。 - 介绍使用设计视图帮助定义联接的技巧。 - 提供模块结束的总结和术语，便于未来参考。 - 包含模块结束测验，加深学习效果。 学员评价： 多位学员对课程给予了高度评价，认为讲解清晰、易于理解，并对课程的实用性和丰富的内容表示满意。许多学员认为，该课程是入门 T-SQL 的绝佳选择，并且适合希望获得 MS SQL Server 认证的学习者。 本课程不仅是学习数据库开发的第一步，还能帮助学员识别因代码编写不当所导致的性能问题。感谢您对《从基础开始的实时 T-SQL》的关注，期待在课程中见到您。
COURSE REVIEWS: "This is a great course- I would fully recommend completing it. Course highlights: Great tip on using design view when using joins as this can help define which column you should be joining on. End of module summary/terminology which you can print out for future reference and use End of module quiz Thank you very much!" - Benjamin "Finest experience with Udemy they explain each and everything so clearly." - Manu"I needed a quick introduction into T-SQL, and that's exactly what I got. A lot of useful information in a short period of time. Great course!" - Olga"Great Instructor" - Kolawole"An amazing course!" -Alfred "The course is great for beginners." -Shelli "Amazing experience. got clear idea about how db works and store procedure. Thank you very much, Mike." - Ujjawal"A great introduction to T-SQL. It's amazing that instruction of this quality is available for free. Many thanks." - IP"Short but covers a lot." - Tamuka"Great." - Ketan"It was a quick course, but a lot was covered." - Brandon"Thank you Mike! I love the course, it is good for beginners. please go ahead and enroll for the course." - Anuja "For understanding the basics of T-SQL this course is good." - Matti"I have done three of Mike's SQL courses and learned a lot. I think these courses would be great for anyone new to SQL Server. I imagine this would be great preparation for those thinking about getting an MS SQL Server certification too." - Keith B"The explanation was very simple and easy to understand." - MansoorCOURSE OVERVIEWSQL Server is a combination of two core items The first is the administration side of the house. Creating databases, managing logins and users, backups,… etc.The second part of the equation is that of developing code in a language called Structured Query Language. Microsoft's flavor of SQL is called Transact-SQL. Transact was designed primarily to work with relational databases. Transact is the language used to talk to SQL Server. When we want to create a database a database we use DDL or Data Definition Language. I'm defining an object when I use the statement with the code. When we want to see data inside a table we use DML or Data Manipulation Language. I'm not creating an object I'm manipulating the data inside that object. In this course we are going to learn the basics of Transact-SQL or T-SQL. We will cover the fundamentals of Transact using real world examples. Additionally, we will discuss some of the best practices associated with crafting clean, high performance code. You'll learn why stored procedures are so important to well-designed applications and why ad hoc queries aren't. The knowledge you gain from the course will not only help you learn to develop but will also give you a great first step to learning how to pinpoint performance issues due to poorly written code. Thanks for your interest in "Real World Transact-SQL from the Ground Up."See you in the course.
