70-461, 761: Querying Microsoft SQL Server with Transact-SQL

Get a Free Week of Skillshare

89%OFF Coupon code for 70-461, 761: Querying Microsoft SQL Server with Transact-SQL Udemy Course. This is an exclusive discount coupon from the course instructor, it will be active for few days. Check ENROLL NOW button to get a maximum discount. We manually verified coupon code on July 6th, 2024 .

From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, and 2022
Instructed by Phillip Burton 28.5 hours on-demand video, 3 coding exercises & 30 articles, 27 downloadable resources

After completing the course, you will…

  • Create tables in a database and ALTER columns in the table.
  • Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
  • retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
  • JOIN two or more tables together, finding missing data.
  • INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
  • Create constraints, views and triggers
  • Use UNION, CASE, MERGE, procedures and error checking
  • Apply ranking and analytic functions, grouping, geography and geometry database
  • Create subqueries and CTEs, PIVOTs, UDFs, APPLYs, synonyms.
  • Manipulate XMLs and JSONs.
  • Learn about transactions, optimise queries and row-based v set-based operations

Who this course is for:

  • This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to learn T-SQL.
  • This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.

Similar Udemy Course Coupons

Deal Score-2
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.

Gain access to over 11,000+ courses for just $16.58 [₹850] per month

Choose between monthly or annual billing cycles, with the freedom to cancel at any time.

The future belongs to learners. Udemy online courses as low as $13.99

New customer offer! Top courses from $14.99 when you first visit Udemy

Gain the skills you need to reach your next career milestone for as little as $11.99

Course Coupon Club
Logo
Follow us on Telegram Join us on FB