Query Transact-SQL (T-SQL) 2016/2019: For data modification

Buy for 19.99$
Course description
This course is narrowly focused on a specific portion of Transact-SQL. The course covers data modification topics namely INSERT, UPDATE, and DELETE by using different T-SQL statements. It discusses many scenarios of data modification including from stored procedure result set(s), joins, subqueries, nondeterministic updates (and how to handle them), UPDATE based on a variable, table expressions, as well as the concept of UPDATE All-at-Once. The course is fully hands-on using a supplied sample database. For your convenience and smooth learning experience, a custom user interface has been provided for you to execute all your SQL codes outside of SQL Server Management Studio (SSMS)To receive the full benefit from this course you must meet the following requirements: You must have some working experience with T-SQLA familiarity with SSMS is an advantage but not strictly required (you can write and execute your SQL codes exclusively in the custom interface)Must have access to a SQL Server instance (2016/2019)Have some understanding of filtering and sorting dataAn understanding of creating tables and enforcing data integrity through T-SQLEvery lesson of the course comes with quizzes that test your understanding of the topics. At the end of each section you test your knowledge with review questions (answers are provided). We also provide two Case Scenarios that test your understanding of the topics covered in the whole course.




We have 57985 courses
0 reviews
0 Rating

Udemy is one of the top online learning platforms founded in 2010 currently offering over 175,000 free and paid courses.

Related topics:

On our website for searching online courses, you are able to get a course Query Transact-SQL (T-SQL) 2016/2019: For data modification for a fee: 19.99. Current training belongs to category SQL from a supplier Udemy, and fits for the difficulty level: any level of expertise. Experienced teacher with pleasure will help you in implementing new career horizons. You can check out feedback of other users about this online course or share your opinion to help other students make a decision

How to get new skills with Skillcombo?

Explore courses that align with your interests, dive into detailed descriptions, and browse through reviews to confidently choose your next learning path. Easily use our filters for level, duration, language, and price to find the right option for your goals.

  • 15+ popular course providers
  • 60000+ online courses in catalog
  • 1000+ IT subjects