SQLServer Administration | 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 Lessons71
  • Course Period11h 34m
  • No.Students1
  • Languageعربي
  • No Prerequisite
  • (1)
  • Start Now for free

Course Lessons

  1. 1 | 0 Course Layout 00:04:50
  2. 2 | 1 SQL Server Service 00:14:57
  3. 3 | 2 Introduction to SQL Server 2014 Database Administration 00:16:31
  4. 4 | 3 SQL Server 2014 Administration Tools 00:11:51
  5. 5 | 4 How Data Is Stored in SQL Server 00:05:16
  6. 6 | 5 Creating and Managing Filegroups In SQL Server 00:15:20
  7. 7 | 6 Database Options in SQL Server 00:16:51
  8. 8 | 7 System Database in SQL Server 00:09:56
  9. 9 | 8 Genrate Script Button in SQL Server 00:01:22
  10. 10 | 9 Copy Or Move database options in SQL Server 00:08:10
  11. 11 | 10 Shrink database in SQL Server 00:06:21
  12. 12 | 11 Understanding SQL Server Recovery Models 00:18:34
  13. 13 | 12 Demo for log file behavior in the Full recovery model 00:07:28
  14. 14 | 13 Backup Types 00:14:59
  15. 15 | 14 Planning Backup Strategies 00:05:00
  16. 16 | 15 Demo Full Bacup 00:09:12
  17. 17 | 16 Demo Full to multiple backup sets to decrease backup time 00:03:32
  18. 18 | 17 backup Database Options in SQL Server 00:07:57
  19. 19 | 18 Restore differential Backup in SQL Server 00:08:33
  20. 20 | 19 Restore Transaction Log Backup in SQL Server 00:08:59
  21. 21 | 20 Restore at Point in SQL Server 00:13:16
  22. 22 | 21 Clear Transaction Log in SQL Server 00:04:08
  23. 23 | 22 Restore without data lose Tail Log 00:10:03
  24. 24 | 23 Introduction to SQL Server Security 00:17:30
  25. 25 | 24 Create logins in SQL Server 00:13:05
  26. 26 | 25 Managing Server Level Roles 00:11:59
  27. 27 | 26 Managing Database Users 00:08:09
  28. 28 | 28 Managing Database Users and Roles 00:11:32
  29. 29 | 30 Managing Application Roles 00:07:14
  30. 30 | 31Ownership Chains 00:03:09
  31. 31 | 32 Introduction to Transferring Data in SQL Server 00:05:40
  32. 32 | 33 Import and Export Wizard in SQL Server 00:10:18
  33. 33 | 34 SQL Server Integration Services Demo 00:16:37
  34. 34 | 35 Disable constraints to Inhance Bulk Insert 00:02:41
  35. 35 | 36 Demo for bcp Bulk Copy Program 00:06:31
  36. 36 | 37 Bulk Insert Demo 00:03:20
  37. 37 | 38 Open RowSet Demo 00:02:17
  38. 38 | 39 Activity Monitor Demo for Concurncey Problems Lock Deadlock Block 00:16:32
  39. 39 | 27 Managing dbo and guest Access 00:09:28
  40. 40 | 29 How to Add dbowner User for your application in SQL Server 00:01:42
  41. 41 | 40 Querying Dynamic Management Views 00:05:05
  42. 42 | 41 Introduction for SQL Server Agent 00:09:57
  43. 43 | 42 Operator in SQL Server Agent 00:09:57
  44. 44 | 43 Jobs in SQL Server Agent 00:18:55
  45. 45 | 44 View Jobs History in SQL Server Agent 00:05:38
  46. 46 | 45 Save Jobs as Script File 00:02:16
  47. 47 | 46 Job Step Security Contexts Proxy 00:09:27
  48. 48 | 47 Configuring Multi Server Jobs 00:04:25
  49. 49 | 48 Alert in SQL Server 00:03:06
  50. 50 | 49 1 Performance Condition Alert 00:16:15
  51. 51 | 49 2 Performance Condition Alert 00:11:35
  52. 52 | 50 Alert History 00:01:28
  53. 53 | 51 Use the DBCC CHECKDB command 00:17:18
  54. 54 | 52 Maintaining Indexes Introduction 00:11:45
  55. 55 | 53 Maintaining Indexes Demo 00:12:55
  56. 56 | 54 SQL Server Maintenance Plans Wizard 00:13:50
  57. 57 | 55 SQL Server Profile Demo 00:15:00
  58. 58 | 56 Database Engine Tuning Advisor Demo 00:07:30
  59. 59 | 57 Configure Database Mail in SQL Server Demo 00:11:43
  60. 60 | 58 SQL Server Auditing Data Server and DB 00:18:46
  61. 61 | 59 Buffer Pool Extension in SQL Server New Feature 00:06:57
  62. 62 | 60 What and Why Use Replication in SQL Server 00:02:53
  63. 63 | 61 Types of Replication in SQL ServerP1 00:08:27
  64. 64 | 62 How to Install SQL Server Production Enviroment 00:16:37
  65. 65 | 63 Implementing Replication Step1 Create a Publication Snapshot 00:18:24
  66. 66 | 63 Implementing Replication Step2 Create a Subscription Snapshot 00:15:07
  67. 67 | 64 Implementing Replication Transactional Pub 00:11:50
  68. 68 | 65 Monitor replication 00:05:23
  69. 69 | 66 How to Restore Master Database 00:13:33
  70. 70 | 67 Move the existing tempdb files to the new location in SQL Server 00:05:06
  71. 71 | 70 High Availability in SQL Server 00:12:44
    Student Reviews

    ( 5 Of 5 )

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

    29-07-2024