SQLServer SQL | Ahmed Samir El Khadrawy

Ahmed Samir El Khadrawy

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

Course Details

Course Lessons

  1. 1 | 1 Course Layout 00:08:59
  2. 2 | 2 SQL Server Overview 00:15:15
  3. 3 | 3 SQL Server Managment Studio Overview 00:11:58
  4. 4 | 4 TSQL Introduction 00:16:29
  5. 5 | 5 Logical Order of Operations in SELECT Statements 00:02:21
  6. 6 | 6 Writing SELECT Queries 00:19:14
  7. 7 | 7 Schema In SQL Server 00:06:03
  8. 8 | 8 CASE Expressions in SELECT 00:02:56
  9. 9 | 9 N Char in SQL 00:02:05
  10. 10 | 10 In Statment 00:09:48
  11. 11 | 11 Querying with Inner Joins 00:14:57
  12. 12 | 12 Querying with Outer Joins 00:09:10
  13. 13 | 13 Querying with Cross Joins and Self Joins 00:10:40
  14. 14 | 14 Working with SQL Server 2014 Data Types 00:19:24
  15. 15 | 15 Working with SQL Server 2014 Data Types Theory 00:12:52
  16. 16 | 16 Collation in SQL Server 00:03:11
  17. 17 | 17 N char in SQL Query 00:02:25
  18. 18 | 18 String Functions 00:04:11
  19. 19 | 19 DateTime Functions 00:04:29
  20. 20 | 20 Insert Data in SQL 00:08:22
  21. 21 | 21 Update Data in SQL 00:03:01
  22. 22 | 22 Delete Data in SQL 00:04:36
  23. 23 | 23 Data Modification Overview 00:08:50
  24. 24 | 24 Sequences in SQL 00:01:59
  25. 25 | 25 Built In Functions in SQL 00:27:23
  26. 26 | 26 Grouping and Aggregating Data 00:14:43
  27. 27 | 27 Grouping and Aggregating Data Review 00:02:18
  28. 28 | 28 Using Subqueries 00:13:00
  29. 29 | 29 Views in SQL 00:07:32
  30. 30 | 30 Stored Procedure in SQL 00:10:32
  31. 31 | 30 1 Output Parameters in Stored Procedure 00:04:15
  32. 32 | 30 2 Writing Queries with Dynamic SQL 00:02:57
  33. 33 | 31 User Define Function 00:08:10
  34. 34 | 32 Trigger in SQL 00:14:47
  35. 35 | 33 Passing Arguments to Derived Tables 00:02:12
  36. 36 | 34 How to Create Temp Table in SQL Server 00:04:13
  37. 37 | 35 Common Table Expressions 00:03:36
  38. 38 | 36 UNION Operator 00:03:22
  39. 39 | 37 Using EXCEPT and INTERSECT 00:02:38
  40. 40 | 38 CROSS APPLY and OUTER APPLY P1 00:00:39
  41. 41 | 39 T SQL Batches P1 00:00:39
  42. 42 | 40 T SQL Programming Demo 00:09:16
  43. 43 | 41 MERGE in SQL Server Demo 00:14:23
  44. 44 | 42 Try Catch and Error Handling in SQL Server Demo 00:15:37
  45. 45 | 43 @@Error in SQL Server Demo 00:01:47
  46. 46 | 44 Transactions in SQL Server 00:14:09
  47. 47 | 45 Inhance Query Performance small Notes 00:10:01
  48. 48 | 46 Cluster Index in SQL Server 00:19:47
  49. 49 | 47 Non Cluster Index in SQL Server 00:15:14
  50. 50 | 48 Metadata Query in SQL Overview 00:08:54
  51. 51 | 49 Partitioning Windows AND Ranking Functions in SQL 00:25:00
  52. 52 | 50 LAG Lead Offset Function 00:09:46
  53. 53 | 51 PIVOT and UNPIVOT 00:07:16
  54. 54 | 52 GROUPING SETS in SQL 00:05:01
  55. 55 | 53 CUBE and ROLLUP in SQL Server 00:05:18
    Student Reviews

    ( 4.5 Of 5 )

    3 reviews
    5 Stars
    0%
    4 Stars
    100%
    3 Stars
    0%
    2 Stars
    0%
    1 Star
    0%
    Y
    Youtube

    26-07-2022
    أ
    أحمد عيسى

    13-10-2024
    آ
    آية محمد

    07-08-2022
    SQL Query Full Course in Arabic

    SQL Query Course using MS SQL Server in Arabic