SQL Server Database Administrator (DBA)

تعلم ادارة قواعد البيانات على "أس كيو أل سيرفر" من الالف الى الياء
5.0 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
30 students enrolled
$19
$130
85% off
Take This Course
  • Lectures 50
  • Length 10 hours
  • Skill Level Intermediate Level
  • Languages Arabic
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 Arabic

Course Description

SQL Server لقد غطينا في هذا المساق كل ما يلزمك لادارة قواعد البيانات على .

حيث ستجد في هذا المساق الشرح الكافي لكل ما يلزم في هذا المجال حيث عتمدنا ترتيب مايكروسوفت للمواضيع التي يجب تغطيتها في هذا المجال وتوسعنا في ذلك وكذلك ستجد التطبيق العملي لكل موضوع تمت تغطيته.

من ميزات هذا المساق انه عباره عن تسجيل لدوره حقيقية بحيث يحوي كل النقاشات التي تدور بين المدرب والطلاب والتي تثري الماده بشكل كبير.

لا يلزمك سوى المعرفة الاساسية في قواعد البيانات و

T-SQL

للتحاق في هذا المساق.

What are the requirements?

  • معرفة عامة عن ميكروسوفت ويندوز
  • معرفة عامة في قواعد البيانات وال (Transact-SQL)

What am I going to get from this course?

  • install and configuer SQL Server
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data. Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.

What is the target audience?

  • هذا الدوره تفيد كل شخص يريد ان يتعلم الطرق والاجراءات و العمليات التي يجب ان يقوم بها لادارة قواعد البيانات على SQL Server والحصول على اعلى اداء ممكن للخادم (server) من خلال متابعة الخادم (server) ومعرفة ما يحتاج اليه من تطوير بستخدام احدث الطرق والادوات المعتمدة من ميكروسوفت.
  • هذه الدوره تستهدف الاشخاص المبتدئين في ادارة قواعد البيانات للوصول بهم الى الحتراف في ذلك

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction & SQL Server Installation
Course Introduction & Course Structure
Preview
07:56
SQL Server Instances
Preview
05:05
SQL Server Editions, Versions, and Tools
Preview
05:04
SQL Server Download, and Installation - part 1
14:47
SQL Server Download, and Installation - part 2
12:48
Section 2: Planning and Implementing a Backup Strategy
Covered Topics & Overview of SQL Transaction Logs
11:03
Transaction Log File Structure
14:07
Working with Recovery Models
15:51
Capacity Planning for Transaction Logs
09:33
Demonstration: Logs and Full Recover
15:34
Backup Types
16:13
Reviewing for Previous Topics
17:39
Determining Recovery Objectives
02:49
(Full Database, Transaction Log, Differential, Partial) Backup Strategies
10:12
Overview of Media Sets, Media Families, and Backup sets, with demo
19:43
Full Example
16:04
Introduction CHECKSUM Functions
02:50
Demo to explain Pros and cons for using one or multi file for backup strategies
06:32
Performing (Database, Transaction Log, Partial & File group, Copy-only) Backups
09:01
Retention and Testing Policy for Backups, Ensuring Backup Integrity - CHECKSUM
19:57
Viewing Backup History
07:15
Mirrored Media Sets
02:19
Retrieving Backup Metadata
08:26
Section 3: Restoring SQL Server Database
Phases of the Restore Process, Types of Restores
12:50
Restoring a Full Database Backup
11:55
Restoring a Differential Backup
09:08
Demo for Full and Differential
10:32
Restoring Transaction Log Backups with Demo
17:47
Restoring Transaction Log Backups with Demo - Continuation
11:45
Restoring File or Filegroup, Partial Backup & Piecemeal Restore Part 1
10:23
Restoring File or Filegroup, Partial Backup & Piecemeal Restore Part 1-Contin.
16:46
Restoring File or Filegroup, Partial Backup & Piecemeal Restore Part 2
18:09
Restoring File or Filegroup, Partial Backup & Piecemeal Restore Part 2-Contin.
16:05
Restoring Data Pages
05:32
Point-in-Time Recovery, STOPAT Option, STOPATMARK Option
09:01
Point-in-Time Recovery, STOPAT Option, STOPATMARK Option - Continuation
19:17
Section 4: Monitoring SQL Server
SQL Server Monitoring Overview, Monitoring Tools for SQL Server
05:54
Activity Monitor
12:44
Review
08:29
Performance Monitor
17:45
SQL Server Profiler, Database Engine Tuning Advisor - Part 1
15:35
SQL Server Profiler, Database Engine Tuning Advisor - Part 2
16:09
SQL Server Profiler, Database Engine Tuning Advisor - Part 3
01:58
Review by Complete Demo
08:02
Section 5: Indexes and Automatic Backup
Indexes (Clustered & non-Clustered)
18:49
automatic backup(Create a database backup job, Create a maintenance backup plan)
19:51
Section 6: SQL Server Security
Overview Security - SQL Server Securables, Principals, and Permissions
15:12
Managing Server-Level Security
12:59
Managing Database-Level Principals
09:08
Database-Level Permissions
18:17

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mohammad Qalalwa, Senior Director Software development

لقد امضيت 15 + من الخبره في تطوير التطبيقات حيث قمت بانشاء وادرارة عشرات المشاريع الضخمة في مختلف المجالات المالية والادارية والطبية، وكذلك كان لدي خبره طويلة جدا في مجال التدريب حيث عقدت ما يزيد عن 100 دورة في مختلف تقنيات مايكروسوفت وبخاصة

.NET (C#, ASP Form, MVC, WCF Service,Entity Framework , TFS, WPF, Silverlight), SQL Server, Business Intelligence (Data warehouse, SSIS, SSAS, SSRS ), SharePoint, Cloud Solution.

مع العديد من المؤسسات العالمية

Mercy Crops, FAW, USAID, UNODC

حاصل على العديد من شهادات مايكروسوفت

Instructor Biography

Arresha Studios, Training Professionals

Arresha Studios, Provide professional training courses in English and Arabic. also we provide software development services.

Arresha as Studios was founded in 2014.

Arresha Studios Main Services:

1. Provide professional training.

2. Software development.

3. UX/UI design.


Ready to start learning?
Take This Course