The T-SQL Toolbox [Beginner to Intermediate]

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-SQLand would like to learn moreStudents currently studying a database management course. Thank you and all the best, Kristian Buddy