Microsoft SQL Server هو نظام لإدارة قواعد البيانات العلائقية تم تطويره بواسطة Microsoft. بصفته خادم قاعدة بيانات، فهو منتج برمجي بوظيفة أساسية لتخزين البيانات واستردادها حسب طلب تطبيقات البرامج الأخرى - والتي قد تعمل إما على نفس الكمبيوتر أو على كمبيوتر آخر عبر الشبكة.
في نهاية هذه الدورة سيتمكن المشاركون من:
شرح محركات تخزين MS SQL
شرح معاملات قاعدة البيانات
الحصول على بيانات تعريف قاعدة البيانات
وصف أدوات MS SQL GUI
مراقبة أداء قاعدة البيانات
إجراء النسخ الاحتياطي واستعادة قاعدة البيانات
تصدير واستيراد بيانات قاعدة البيانات
وصف ميزات وفوائد MS SQL
شرح أساسيات قواعد البيانات العلائقية
تصميم قاعدة بيانات فعالة
إنشاء قاعدة بيانات وجداول باستخدام SQL تعديل أو حذف كيانات قاعدة البيانات
ضم البيانات من جداول متعددة
استخدم وظائف MS SQL المدمجة
قادة الفرق الذين يسعون للتطوير المهني في MS SQL
قائد فريق تكنولوجيا المعلومات.
مطور MS SQL
مدير تكنولوجيا المعلومات
مدراء قسم تكنولوجيا المعلومات.
مدراء المشروع.
Basic SELECT Statement Practice Problems
Microsoft SQL Server and T-SQL (Microsoft SQL) variant language
Differences between MS SQL and Python
Structured Query Language (SQL)
Nested Queries in MS SQL
Operation Vs Nested query in DBMS
Database Objects in DBMS
Nested Queries in MS SQL
Indexing in Databases
SQL elevator pitch technical message.
MS SQL Server Keys, Constraints, and Indexes
MS SQL Server Database Administration
SQL Server Programming
Auditing the execution of Code Template Mappings
SQL Server Comparison Operators
SQL Server Joins
SSMS and MySQL Workbench
Creating SQL loader mappings to Extract Data from Flat Files.
Creating SAP extraction mappings
Retrieving data from the SAP System
Creating Code Template (CT) mappings
Setting options for Code Templates in Code Template Mappings
Participants will learn about the field of communication for development in this course (C4D). In order to encourage participation and engagement with kids, families, communities, and networks for positive social and behavioral change in both development and humanitarian contexts, C4D is an evidence-based strategy that makes use of a variety of communication tools, channels, and approaches. It incorporates knowledge and ideas from social, behavioral, and communication sciences.
In order to meet these new challenges and take advantage of chances for innovation to bring about behavior and social change, participants in this three-day course will need new and improved communication competencies.
Too often company executives and professionals spend most of their time fixing day-to-day problems. They react to problems, rather than focusing on what they would like the company to be and then on making it happen. This program focuses on changing the way we think from reacting (responding to day-to-day problems, fixing and repairing) to developing plans for what we want to have happened and then implementing the plans.
We all operate in an increasingly complex commercial and professional environment that requires us to negotiate on a daily basis not only with customers, clients, suppliers and contractor, but also with managers, fellow employees and colleagues within our own organisation.
‘Mastering Negotiation Skills’ is a five-day course designed to explain the negotiation process in detail and demonstrate how to use it effectively, giving delegates the negotiation skills and strategies they need to succeed in today’s challenging commercial environment.
"Going back to basics". This is the main theme of this highly interactive course which aims to help participants recognize the need to simplify their organizational processes and procedures. The course will provide the participants with international best practices which will help them understand the causes of complexity and identify areas for improvement by focusing on eliminating waste, simplifying procedures, and standardizing and automating opportunities. Participants in this practical course will also learn tools to map and diagram processes and procedures revealing issues and opportunities for improvement. Various hands-on tools will present participants with the opportunity to transfer this knowledge to their organization and expect immediate results.
Day in, day out, Executive Secretaries and provide high-level support for top executives. They work usually with very little supervision, anticipating needs, and managing the day to day demands of busy and challenging workloads competently and often with little acknowledgment or encouragement!
This training course seeks to develop and stretch the skill-set of EAs This training course will help them to understand how to work with different leadership styles and at the same time develop the competence, confidence, and mindset to achieve excellence and to recognize their value to their organizations.
Certified Hotel Administrator (CHA) is a credential that recognizes your competence and talents in the hotel industry. It honors General Managers and Hospitality Executives’ leadership and management abilities and provides them with more prospects for advancement. CHA Certified Hotel Administrator credential is one of the most prestigious certifications available.