|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/t-sql-toolbox/
课程评论：没有评论
课程名称：T-SQL工具箱 [初学者到中级] 课程概述：该课程旨在帮助零基础的学习者掌握实用的数据库设计技能和T-SQL脚本知识。课程的内容基于作者作为T-SQL开发者的真实工作经验，旨在让学员了解在开始学习T-SQL之前应该掌握的关键知识点。 课程的特点： - 高度实用：课程内容结合实际开发经验，传授真实的应用技能。 - 高质量音频：课程采用RODE PODMIC录制，确保音频清晰流畅。 - 测验与作业：每个新主题都有测验和作业，帮助学员巩固所学知识。 课程结构： - 探索职业发展路径，激励学员持续提升T-SQL技能。 - 理解关系数据库的历史，了解其发展演变。 - 数据库设计理论：学习如何设计表格并利用约束条件。 - 理解基数（1-m、m-n、1-1）关系。 - 学习不同类型的连接，掌握如何限制或扩展数据集。 - 深入学习窗口函数的语法和理论，以便于灵活应用。 - 了解三种临时存储数据集的方法。 目标受众： - 希望提升技术能力的管理者 - 想要重温基础知识的分析师/工程师 - 对T-SQL感兴趣的任何人 - 当前正在学习数据库管理课程的学生 感谢您的关注，祝您学习愉快！ Kristian Buddy
This course is intended for those with little to no experience and who would like to learn practical database design skills + specific T-SQL scripting knowledge.The Benefits of this courseHighly practical The concepts shared throughout this course are related to my real-world experience as a T-SQL developer What I wish I would have known before starting T-SQLHigh-Quality AudioThis course is recorded with a RODE PODMIC - which is one of the highest quality microphones for auditory dictation Quizzes and AssignmentsThis course contains quizzes and assignments for each new topic introduced to ensure learning is fortified by the studentThe course structure Exploring Career Pathways Providing Incentive to continue your T-SQL developmentRelational database History Understanding how relational databases evolvedDatabase design theoryFundamental knowledge of how to design tables with the use of constraintsCardinality (1-m, m-n,1-1) relationshipsJoining other tablesLearning the difference between the main type of joins, to limit or expand our data set.Windows FunctionsDiving deep into the syntax and theory of windows functions. So the student can have a sound knowledge of how to implement windows functions.Storing Data temporarilyAt times T-SQL developers are required to hold onto a dataset for various reasons - I will explain 3 key ways to do so.The intended audience Managers who would like to become more technical Analysts/Engineers who would like to revisit the fundamentals. Anybody curious about T-SQL and would like to learn moreStudents currently studying a database management course.Thank you and all the best,Kristian Buddy
