|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-2019-go-from-a-to-z-10-h-of-class/
课程评论：没有评论
本課程為 SQL Server 2022 的詳盡大師班，涵蓋 16 個主題，總時長約 28 小時，並特別介紹 SQL Server 2022 的新功能，包括 GREATEST、LEAST、WINDOWS、STRING_SPLIT、DATE_BUCKET 和 GENERATE_SERIES。 課程內容分為四大主要部分： **第一部分：Transact SQL 入門與進階 (10 小時)** * SQL Server 和 Management Studio 的安裝 * 資料庫與資料表的建立和定義 * 資料操作：SELECT, UPDATE, INSERT, DELETE * 進階查詢技巧：LIKE, TOP, DISTINCT, 比較運算子, SELECT INTO, IN, NOT IN, IS, IS NOT, ORDER BY * 聚合函數：MIN, MAX, AVG, COUNT, SUM, BETWEEN, GROUP BY * JOIN 操作：INNER JOIN, LEFT/RIGHT JOIN, FULL OUTER JOIN * UNION 和 UNION ALL, LEFT 和 RIGHT 函數 * 進階 T-SQL 語法：IIF, CASE WHEN, OFFSET FETCH NEXT ROWS, CHOOSE * 轉換函數：CAST, CONVERT, TRY_CAST, TRY_CONVERT * 日期函數：DATEADD, DATEDIFF, GETDATE(), EOMONTH * 進階 T-SQL 函數：IF/ELSE, STRING_SPLIT, STUFF, MERGE * 物件創建：View, Stored Procedure, Function, Schema, Trigger * 排序函數：ROW_NUMBER, OVER, PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG, LEAD, DENSE_RANK, RANK, NTILE * CTE (Common Table Expression) 與衍生資料表 * 臨時表、變數表與全域表的區別 **第二部分：SQL Server 完整管理 (11 小時)** * 備份與還原策略 (3 小時) * 偵測與修復資料庫損毀 (2 小時) * 資料庫配置與修改 (3 小時)，涵蓋 Autogrow 設定、TRUSTWORTHY 和 DB_CHAINING 等選項 * 安全與權限管理 (2 小時) * 隔離模式：READ COMMITTED, SERIALIZABLE, SNAPSHOT * 約束類型：PK, FK, CHECK, UNIQUE * SEQUENCES 和 IDENTITY * 變更資料擷取 (CDC), 列層級安全性 (Row Level Security), 動態資料遮罩 (DDM), 時間性資料 (Temporal Data) **第三部分：SQL Server 效能優化 (4 小時)** * 索引的實作與效能提升 * SARGABLE 查詢的撰寫技巧 **第四部分：SQL Server 面試準備** * 40 個常見的理論問題與解答，涵蓋主要概念，如主鍵、索引、OLAP vs OLTP、COALESCE 函數，以及如何移除重複資料。 此外，課程還包含 PowerShell 管理、預存程序效能優化、SQL Azure 等額外模組，並提供超過 100 個練習題及解答。此課程總計提供超過 30-40 小時的學習內容，旨在幫助學員成為 SQL Server 的專家，並為實際工作和面試做好準備。
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)Welcome to the richest and most comprehensive course on the Udemy platform about SQL Server.This course lists the 16 courses in my catalogue: SQL Server for complete beginners (7 hours of practice + 80 practical exercises)Learn the in-demand job of developer SQLThe Complete SQL Server 2019 Database Administration CourseSQL Server 2019: Administration SQL Server Part 1SQL Server 2019: Administration SQL Server Part 2SQL Server 2019: Administration SQL Server Part 3The complete course about BACKUP and RESTOREDetecting and Correcting Database CorruptionSQL Server: Configuring and modifying a database on SQL99 queries to master SQL in less than 4 hours!SQL Server: The complete course on IndexesLearn the in-demand job of DBA SQL ServerSQL Server: Security and Privilege ManagementCome and challenge the Transact SQL with these 50 exercisesJoins, partition functions, and CTE in Transact SQL 2019.Prepare your future interview on SQL Server (with these 40 questions and 40 answers! )I challenge you to find in a single course these 3 very important chapters on SQL Server: ◉ Chapter 1: Transact SQL for the absolute beginner and also experienced developers (10 hours of class)Let's start by installing SQL Server and management studio on your workstation.The creation and definition of a database and a table.Let's start playing with data with SELECT,UPDATE,INSERT and DELETEDiscover the column aliases and tackle the specificity and secrets of LIKE and TOP.Learn how to remove duplicates with the DISTINCT and discover the Comparison operators =!= and Copying 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 specificity of COUNT and SUM and how to SELECT a range of data with the BETWEEN and Group several results with the GROUP BYA long chapter of 1h30 minutes on JOINS with INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on..Let's discover the specificity of UNION and UNION ALL, and the LEFT and RIGHT function.Let's go even further with Transact SQL with the IIF,CASE WHEN,OFFSET FETCH NEXT ROWS and CHOOSE.Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT.Let's approach the DATE type functions with DATEADD,DATEDIFF,GETDATE (), EOMONTH...Let's deepen our knowledge of TSQL even more With IF/ELSE, STRING SPLIT,STUFF,MERGE…The creation and definition of a view and Stored Procedure,function, schéma and trigger.A very long chapter of 1h30 minutes on RANKING functions such as ROW_NUMBER, OVER and PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG and LEAD,ROW_NUMBER, DENSE _RANK, RANK, NTILE.We will discover a one hour course on CTE (common table expression). So powerful and so little known (I still don't understand by the way) and the derived table.Do you know the difference between Temporary tables, Variable tables and Global tables?◉ Chapter 2: The complete administration of a SQL Server (11 hours of class) Tackle BACKUP and RESTORE for 3 hours, we will see in detail in this course, how to set up a robust and reliable strategy, to guarantee your data on a production server.In another 2 hour course, we will learn how to detect and repair corruption on a database. Did you know that Microsoft logs over 1000 support cases per day regarding corruption! And you, how would you react in case of corruption?We will also discuss during 3 hours, the configuration and modification of your database on SQL. Did you know that a bad Autogrow set on your database, can make you lose 60% of your performance? Do you know the TRUSTWORTHY or DB_CHAINING option? Everything is covered in this course, and believe me, you will be surprised at the number of options on a DB that SQL Server offers. Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.We will cover a long chapter on the different isolation modes (READ COMMITED, SERIALIZABLE, SNAPSHOT...), we will also see the different types of constraints (PK,FK,CHECK,UNIQUE...), as well as SEQUENCES, and IDENTITY.We will also discuss the change data capture (CDC), many new features released on SQL Server 2016 such as Row Level Security, Dynamic Data Masking (DDM), Temporal Data.◉ Chapter 3: How to improve performance on your production SQL server (4 hours) If we are talking about performance, we will of course be talking about indexes. This is a good thing because it will be covered in this chapter for 4 hours. A good implementation of your indexes can really save your performance on your SQL server. I strongly advise you to look at this chapter, to perhaps avoid going into huge costs of buying servers, which may not be necessary.Do you know SARGABLE queries? I let you discover it in this chapter, to rewrite your SQL queries, in a better way, and thus of course, better performance.◉ Chapter 4: Come and take a virtual interview through these 40 questions and 40 theoretical answers.Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.You are a Java developer or Python for example, you go to an interview, you don't really know what to review beforehand, this is a summary of the most frequently asked questions.For example: What is a primary key ? what is an index? What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?There will be many new sections added in 2021, of course if you have already purchased this course, these new modules will be free for you: How to administer your SQL server with powershell? (3 hours of class)Improve the performance of stored procedures (2 hours of class)Let's go together on SQL Azure! (3 hours of class)Of course there are more than 100 exercises and corrections in this course. This course will have an estimated duration of between 30 and 40 hours once completed.
