تعلم SQL Server
مايكروسوفت إس كيو إل سيرفر Microsoft SQL Server هو برنامج لقواعد البيانات العلائقية من إنتاج مايكروسوفت
0.0(0 تقييم)
33 طالب ملتحق
عن الدورة
مايكروسوفت إس كيو إل سيرفر Microsoft SQL Server هو برنامج لقواعد البيانات العلائقية من إنتاج مايكروسوفت، لغة الاستعلام الرئيسية فيه هي SQL وT-SQL. ويتميز sql server بسهولة في التعامل من بعض الأنظمة الأخرى مثل oracle & access وهذا النظم يتخطى الأخطاء في الأكسس
محتوى الدورة
-
1 relational database management system00:04:43
-
2 relational database management system00:06:53
-
3 relational database management system00:06:26
-
4 OLAP & OLTP00:06:45
-
5 ACID atomicity, consistency, isolation, durability00:09:39
-
6 Data type00:03:41
-
7 DDL is Data Definition Language & DML is Data Manipulation Language00:02:14
-
8 Download & Install00:18:30
-
9 SQL Server Management Studio SSMS Download & Install00:01:35
-
10 SQL Server Management Studio SSMS Settings & Configuration00:05:15
-
11 SELECT Transact SQL 00:14:04
-
12 SELECT & Where Transact SQL 00:04:48
-
13 ALIASES create a temporary name for columns or tables 00:06:10
-
14 SELECT DISTINCT Statement 00:02:51
-
15 ALIASES create a temporary name for tables 00:03:19
-
16 SQL ORDER BY Keyword 00:04:46
-
17 SQL concatenate columns & CONCAT function 00:12:53
-
18 Multipart Names 00:08:38
-
19 IN, AND , LIKE 00:04:45
-
20 UNION Operator 00:05:14
-
21 EXCEPT and INTERSECT 00:06:34
-
22 paging results OFFSET : FETCH 00:08:10
-
23 CASE Transact SQL 00:09:11
-
24 PIVOT operator 00:06:08
-
25 Transact SQL JOINS 00:05:02
-
26 INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER, FULL OUTER ,CROSS JOIN 00:09:15
-
27 Built In Functions , SUM ,COUNT ,MIN ,MAX,AVG 00:05:45
-
28 GROUP BY 00:06:13
-
29 HAVING 00:04:39
-
30 INSERT INTO 00:10:13
-
31 INSERT INTO SELECT 00:05:15
-
32 SELECT INTO 00:04:30
-
33 UPDATE 00:12:16
-
34 DELETE 00:09:39
-
35 Stored Procedures 00:06:16
-
36 Stored Procedures 00:05:43
-
37 Stored Procedures with input parameter 00:06:11
-
38 Stored Procedures with output parameter 00:05:21
-
39 Table Variables 00:05:23
-
40 CTE stands for Common Table Expression 00:07:29
-
41 User Defined Functions UDF 00:07:44
-
42 User defined scalar functions 00:07:21
-
43 User defined table valued functions 00:12:43
-
44 Subqueries 00:03:25
-
45 Scalar Subqueries 00:05:17
-
46 Multi valued Subqueries 00:04:26
-
47 Correlated Subqueries 00:05:19
-
48 Format JSON Output using PATH & AUTO Mode 00:03:34
-
49 BETWEEN Operator 00:03:52
-
50 WHILE Loop 00:06:42
-
51 IF ELSE Statement 00:03:42
-
52 Create Database 00:12:17
-
53 Tables & Data types 00:15:58
-
54 Normalization 00:10:24
-
55 Schema 00:04:39
-
56 Schema 00:04:11
-
57 Creating Table 00:11:58
-
58 GUID uniqueidentifier & identity 00:21:41
-
59 ALTER TABLE ADD & DROP 00:10:51
-
60 ALTER TABLE graphically 00:01:22
-
61 Integrity & Constraints,Domain , Entity , Referential 00:05:41
-
62 Constraints , Primary key & Foreign key 00:04:45
-
63 Constraints , Primary key & Foreign key 00:06:33
-
64 Constraints , Primary key & Foreign key 00:17:17
-
65 Constraints ,Not Null , Check, Default, Unique , Primary , Foreign 00:05:36
-
66 In Memory Optimized Tables or In Memory OLTP 00:15:12
-
67 Natively Compiled Stored Procedures 00:04:54
-
68 Clustered Indexes 00:07:26
-
69 Nonclustered Indexes 00:07:04
-
70 Covering Indexes 00:03:47
-
71 Create Clustered & Nonclustered Indexes 00:03:47
-
72 Views are virtual tables 00:10:01
-
73 BEGIN TRAN, ROLLBACK TRAN, and COMMIT 00:07:13
-
74 Trigger is a special type of stored procedure 00:02:50
-
75 INSTEAD OF trigger 00:02:55
-
76 AFTER Triggers 00:07:22
-
77 Where to Go 00:02:47
المحاضرون
التقييمات
لا يوجد تقييمات
دورات ذات صلة
مساقات
خدماتنا
روابط
تابعنا على
وسائل الدفع
جميع الحقوق محفوظة مساقات © 2024
أحد مشاريع
