SQL Server 2022 for complete beginners (7 hours of practice)

Partner: Udemy
Affiliate Name:
Area:
Description: This course also takes the new SQL Server version 2022 (new features such as GREATEST, LEAST, WINDOWS, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES are discussed)Do you know absolutely nothing about SQL Server and want to get started with this technology? Do you want to learn how to write your very first queries in Transact SQL, then this course is for you!?  ****************    In this course we will cover these different chapters *************************Install SQL Server and management studio on your workstation.The creation and definition of a databaseThe creation and definition of a tableSelect, update, delete and insert data (SELECT,INSERT,UPDATE,DELETE) Discover the column aliases and tackle the specificity and secrets of LIKE.Do you know the usefulness of the TOP ?Learn how to remove duplicates with the DISTINCT and discover the Comparison operators = != and so onCopying a table with the SELECT INTO.Let's talk about the IN, NOT IN, IS and IS NOT operators, and Sort your data with ORDER BY.Discover aggregate functions with MIN MAX and AVG and the two operators AND,OR.Let's discover the specificities of COUNT and SUM and how to SELECT a range of data with the BETWEENGroup several results with the GROUP BY and Let's discover the  HAVING and the PRINT.The joins with INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so onLet's go even further with Transact SQL with the IIF,CASE&nbsp
Category: IT & Software > Other IT & Software > SQL
Partner ID:
Price: 89.99
Commission:
Source: Impact
Go to Course