SQL Server: Learn T-SQL in 9 hours (ITS-201, 98-364)

Published on February 1st, 2024 and Last Verified on July 17th, 2024,
Unlimited monthly offer

Course Name : SQL Server: Learn T-SQL in 9 hours (ITS-201, 98-364)
Short description : For SELECT queries, views, procedures, indexes, backups. IT Specialist OD 201 (previously 98-364). Helps with DP-600
Duration : 9 hours on-demand video, 23 articles & 11 downloadable resources
Avg Rating : 4.7
Original Price : $119.99
Discouont Price : 89%OFF
Provider : Udemy
Course Type : Self Paced Online Course. Lifetime Access

Instructed by Phillip Burton

After completing the course, you will…

  • Create tables in a database, normalize the tables, and ALTER columns in the table.
  • Know what data type to use in various situations.
  • retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
  • JOIN two tables together, finding missing data.
  • INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
  • Create constraints, views, procedures and triggers
  • Create backups and restore data, and investigate security

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.

Recommended Courses

  1. MS SQL Server 2019. Programación de Bases de Datos con T-SQL
  2. SQL for Data Analysis – with SQL Server
  3. SQL Server T-SQL Veri Yönetimi ve Raporlama Eğitimi
  4. SQL and Transact-SQL (T-SQL) For Beginners
Deal Score+2
Course Coupon Club
Logo
Follow us on Telegram Join us on FB