Learning Microsoft Transact - SQL
What you will learn
create new databases and tables using Transact SQL.
query and modify data within a T-SQL database.
perform basic programming and optimization tasks within an SQL database.
Charts
Comidoc Review
Our Verdict
This 7-hour Transact-SQL course is a great introduction to creating, querying, and programming SQL databases using the Microsoft extension language. While there are minor issues like spelling errors and outdated examples, it excels in conveying concepts through clear explanations followed by practical examples. Covering key areas such as database creation, data manipulation, and basic programming tasks, this course is ideal for beginners or those looking to brush up on Transact-SQL skills.\n\nDespite the absence of real-life examples and a deeper focus on some topics, most users have reported that they found the content very useful and managed to apply what they learned in their workplace. However, there is room for improvement with updated materials, addressing compatibility issues, providing more hands-on exercises, and delving further into specific commands like SELECT.\n\nIn all, it's a solid starting point to understand T-SQL, but experienced users may require more advanced or specialized resources depending on their goals.
What We Liked
- The instructor's clear explanations and practical examples make it easy to grasp concepts.
- Covers a wide range of Transact-SQL topics, providing a solid foundation for beginners.
- Ideal for supplementing formal education or learning as a refresher.
- Real-world applications and relevance of T-SQL are well presented throughout the course.
Potential Drawbacks
- Spelling errors in the transcript may confuse non-native English speakers.
- Limited depth in some areas, such as the SELECT command; a deeper dive would be beneficial.
- Lack of hands-on exercises or real-life examples for better retention and practice.
- Outdated course materials may cause compatibility issues with newer software versions.