|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-2019-sql-for-the-beginners-with-50-exercices/
课程评论：没有评论
**Course Title:** SQL Server 2022 for complete beginners (7 hours of practice) **Course Overview:** This comprehensive course is designed for absolute beginners who want to learn SQL Server, with a focus on the latest version, SQL Server 2022. It covers new features like GREATEST, LEAST, WINDOWS functions, STRING_SPLIT, DATE_BUCKET, and GENERATE_SERIES. The course is highly practical, featuring 7 hours of demos and 30 minutes of theory, with videos kept under 10 minutes to ensure engagement. **Key Learning Objectives:** Upon completion of this course, you will be able to: * **Install and Configure:** Install SQL Server and Management Studio on your workstation. * **Database Fundamentals:** Understand the creation and definition of databases and tables. * **Data Manipulation:** * Select, update, delete, and insert data using `SELECT`, `INSERT`, `UPDATE`, `DELETE`. * Utilize column aliases, `LIKE` operator, and `TOP` clause. * Remove duplicates with `DISTINCT` and use comparison operators (`=`, `!=`, etc.). * Copy tables using `SELECT INTO`. * **Data Filtering and Sorting:** * Work with `IN`, `NOT IN`, `IS`, and `IS NOT` operators. * Sort data using `ORDER BY`. * Select a range of data using `BETWEEN`. * **Aggregate Functions:** * Apply aggregate functions like `MIN`, `MAX`, `AVG`, `COUNT`, and `SUM`. * Combine results using `GROUP BY` and filter grouped results with `HAVING`. * Use `PRINT` for output. * **Joins and Advanced T-SQL:** * Perform various types of joins: `INNER JOIN`, `LEFT/RIGHT JOIN`, `FULL OUTER JOIN`. * Explore advanced T-SQL functions: `IIF`, `CASE WHEN`, `SUBSTRING`, `OFFSET FETCH NEXT ROWS`. * Learn about `CHOOSE`, `TRIM/LTRIM/RTIM`, and `COALESCE` functions. * **Data Combining and Conversion:** * Understand `UNION` and `UNION ALL`. * Utilize `LEFT` and `RIGHT` functions. * Master data conversion functions: `CAST`, `CONVERT`, `TRY_CAST`, `TRY_CONVERT`, `TRY_PARSE`, `PARSE`. * **Database Objects:** * Create and define Views. * Create and define Stored Procedures. * **Problem Solving:** The course includes over 50 practice questions to reinforce learning. **Why Learn SQL Server?** SQL is a highly sought-after skill in the job market, with dedicated career paths for SQL Server administration and T-SQL querying. SQL Server's user-friendly nature allows for rapid competency development in specialized areas, making learners comfortable with the SQL language quickly after this course.
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 WHEN,SUBSTRING, OFFSET FETCH NEXT ROWS.Have you heard of the CHOOSE, TRIM/LTRIM/RTIM or COALLESCE function?Let's discover the specificities of UNION and UNION ALL, and the LEFT and RIGHT function.Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT, as well as TRY_PARSE and PARSE.The creation and definition of a view.The creation and definition of a Stored Procedure.This course includes more than 50 questions! This course is 7 hours of demo and 30 minutes of theory. Theory is in the classroom, not in this course:)Why should I use SQL technology?SQL is one of the most actively sought-after skills on the job market.Administering an SQL server and querying in TSQL today is a full-time job.Furthermore, SQL Server, because of its simplicity, allows you to quickly become competent in very specific subjects. Once this course is over, believe me that you will be much more comfortable with the SQL language.I also made sure that the videos don't exceed 10 minutes, so it won't be too soporific:)
