A Practical course to learning T-SQL
Description
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 course
- Highly 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-SQL
- High-Quality Audio
- This course is recorded with a RODE PODMIC - which is one of the highest quality microphones for auditory dictation
- Quizzes and Assignments
- This course contains quizzes and assignments for each new topic introduced to ensure learning is fortified by the student
- Exploring Career Pathways
- Providing Incentive to continue your T-SQL development
- Relational database History
- Understanding how relational databases evolved
- Database design theory
- Fundamental knowledge of how to design tables with the use of constraints
- Cardinality (1-m, m-n,1-1) relationships
- Joining other tables
- Learning the difference between the main type of joins, to limit or expand our data set.
- Windows Functions
- Diving 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 temporarily
- At 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 more
- Students currently studying a database management course.
Thank you and all the best,
Kristian Buddy
Who this course is for:
- Data Engineers
- Business/Data Analysts
- Business Intelligence Analyst
- Managers who would like to level up their skill in T-SQL
- Anyone who is curious about T-SQL
