محاضر كورس SQLServer SQL
Ahmed Samir El Khadrawy
This is Chanel will help you to improve your experience in Information Systems field, my name is Ahmed Samir El Khadrawy from Egypt, Cairo - Maadi , I have a very good Experience in Information Systems
B.Sc. of Engineering
Diploma of Information Systems at AAST
Master of Information Systems at AAST (not finished yet)
Microsoft Certified Trainer since 2007
MCP, MCAD, MCSD
MCTS,MCPD Enterprise
MCSD Sharepoint
MCSA(Office 365)
MCSE (SharePoint Admin)
MCSD(Web Applic
تفاصيل الكورس
- عدد الدروس 55
- مدة الكورس 8س 7د
- لغة الكورس عربي
- عدد الطلاب 278
- يفضل الدراسة اولاً DBMS اساسيات
-
(74)
- ادرس الكورس مجانا
سجل فى الكورس لتحصل على شهادة اتمام معتمدة
دروس كورس SQLServer SQL
- 1 | 1 Course Layout 00:08:59
- 2 | 2 SQL Server Overview 00:15:15
- 3 | 3 SQL Server Managment Studio Overview 00:11:58
- 4 | 4 TSQL Introduction 00:16:29
- 5 | 5 Logical Order of Operations in SELECT Statements 00:02:21
- 6 | 6 Writing SELECT Queries 00:19:14
- 7 | 7 Schema In SQL Server 00:06:03
- 8 | 8 CASE Expressions in SELECT 00:02:56
- 9 | 9 N Char in SQL 00:02:05
- 10 | 10 In Statment 00:09:48
- 11 | 11 Querying with Inner Joins 00:14:57
- 12 | 12 Querying with Outer Joins 00:09:10
- 13 | 13 Querying with Cross Joins and Self Joins 00:10:40
- 14 | 14 Working with SQL Server 2014 Data Types 00:19:24
- 15 | 15 Working with SQL Server 2014 Data Types Theory 00:12:52
- 16 | 16 Collation in SQL Server 00:03:11
- 17 | 17 N char in SQL Query 00:02:25
- 18 | 18 String Functions 00:04:11
- 19 | 19 DateTime Functions 00:04:29
- 20 | 20 Insert Data in SQL 00:08:22
- 21 | 21 Update Data in SQL 00:03:01
- 22 | 22 Delete Data in SQL 00:04:36
- 23 | 23 Data Modification Overview 00:08:50
- 24 | 24 Sequences in SQL 00:01:59
- 25 | 25 Built In Functions in SQL 00:27:23
- 26 | 26 Grouping and Aggregating Data 00:14:43
- 27 | 27 Grouping and Aggregating Data Review 00:02:18
- 28 | 28 Using Subqueries 00:13:00
- 29 | 29 Views in SQL 00:07:32
- 30 | 30 Stored Procedure in SQL 00:10:32
- 31 | 30 1 Output Parameters in Stored Procedure 00:04:15
- 32 | 30 2 Writing Queries with Dynamic SQL 00:02:57
- 33 | 31 User Define Function 00:08:10
- 34 | 32 Trigger in SQL 00:14:47
- 35 | 33 Passing Arguments to Derived Tables 00:02:12
- 36 | 34 How to Create Temp Table in SQL Server 00:04:13
- 37 | 35 Common Table Expressions 00:03:36
- 38 | 36 UNION Operator 00:03:22
- 39 | 37 Using EXCEPT and INTERSECT 00:02:38
- 40 | 38 CROSS APPLY and OUTER APPLY P1 00:00:39
- 41 | 39 T SQL Batches P1 00:00:39
- 42 | 40 T SQL Programming Demo 00:09:16
- 43 | 41 MERGE in SQL Server Demo 00:14:23
- 44 | 42 Try Catch and Error Handling in SQL Server Demo 00:15:37
- 45 | 43 @@Error in SQL Server Demo 00:01:47
- 46 | 44 Transactions in SQL Server 00:14:09
- 47 | 45 Inhance Query Performance small Notes 00:10:01
- 48 | 46 Cluster Index in SQL Server 00:19:47
- 49 | 47 Non Cluster Index in SQL Server 00:15:14
- 50 | 48 Metadata Query in SQL Overview 00:08:54
- 51 | 49 Partitioning Windows AND Ranking Functions in SQL 00:25:00
- 52 | 50 LAG Lead Offset Function 00:09:46
- 53 | 51 PIVOT and UNPIVOT 00:07:16
- 54 | 52 GROUPING SETS in SQL 00:05:01
- 55 | 53 CUBE and ROLLUP in SQL Server 00:05:18
تقييمات الطلاب
بعض التقييمات
Muhanad Faisal
02-04-2024
Mohamed Ahmed
06-03-2024
Abdullah ELshuqairi
19-02-2024
Moustafa Sayed
27-01-2024
mayssa abdallah
19-08-2023
Amal Almutairi
22-06-2023
BENSALEM MOHAMED
18-03-2023
Ahmed
02-03-2023
Ibrahim Salem
04-02-2023