• معلومات الكورس

  • عدد الدروس 55
  • مدة الكورس 00:52:21
  • لغة الكورس عربي
  • تاريخ النشر 2016-09-04
  • عدد الطلاب 41
  • موضوع الكورس MS SQL
  • مقدم الكورس Ahmed Samir El Khadrawy
  • (48 ) | 5/5

    SQL Query Full Course in Arabic كورس مجانى كامل للمبتدئين | Ahmed Samir El Khadrawy، معتمد اون لاين من تيرا كورسات بأسم كورس SQL

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

    تم حساب التقييم التالي بناء على تقييمات مستخدمي موقع تيرا كورسات وتقييمات مستخدمي موقع اليوتيوب من خلال خاصية like و dislike.

    (48)