Our Querying Data with Transact-SQL: 761 course teaches you how to retrieve, insert and delete data from a relational database using Transact-SQL. Learn to query data from single and joined tables, use query filters to retrieve specific data, create insert statements for placing data from multiple tables into a single table and update table data. Develop the ability to maintain data integrity when removing or deleting records from a database. Explore the concepts of creating and using stored procedures. This introductory database administration course can be used as part of your study material for the Microsoft Certified Solutions Associate (MCSA) SQL 2016 database certifications.
Also check out our online course: COMP 9691 Querying Data with Transact-SQL: 761 (Distance Learning)