Best seller

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

Udemy
Deal Score+2
Deal Score+2
70-461, 761 Querying Microsoft SQL Server with Transact-SQL Udemy Coupon

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

From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, and 2022

Created by Philip Burton | 29.5 hours on-demand video course

This 70-461, 761: Querying Microsoft SQL Server with Transact-SQL course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012” and 70-761 “Querying Data with Transact-SQL”. Please note – these certificates are no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.

What you’ll learn

  • 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

Microsoft Applied Skills:Model-driven Power Apps & Dataverse New

Microsoft Applied Skills:Model-driven Power Apps & Dataverse Create Dataverse tables and solutions to store …

PL-300 certification: Microsoft Power BI Data Analyst Best seller

PL-300 certification: Microsoft Power BI Data Analyst Learn skills for Microsoft PL-300 certification using the …

SQL Server Integration Services (SSIS) – An Introduction Best seller

SQL Server Integration Services (SSIS) – An Introduction Learn the basics of SQL Server Integration Services …

Tableau Data Analyst/Specialist Desktop Certification Best seller

Tableau Data Analyst/Specialist Desktop Certification From beginners to skills needed for Data Analyst or …

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.
Josh Smith
Josh Smith

The Couponos team has over ten years of experience finding free and 100%-off Udemy Coupons. We add over 200 coupons daily and verify them constantly to ensure that we only offer fully working coupon codes. We are experts in finding new offers as soon as they become available. They're usually only offered for a limited usage period, so you must act quickly.

      Udemy Coupon & Discounts - May 2024

      A big sale for your big opportunity Save up to 85% on courses.


      A big sale for your big opportunity Save up to 85% on courses.
      Coupons ME
      Logo