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
This program provides an introduction to finance and accounting for those who have no prior knowledge of this business area. It is designed to train the participants to support operational and financial processes. Those attending this course will gain a clear understanding of the essential terminology of finance and accounting. They will also learn the principles and techniques of accounting systems through practical examples and exercises.
The overall aim of the program is to ensure that those who attend will be able to perform more effectively and efficiently within the workplace.
Document control and record management should play an important role in identity and access management by protecting sensitive documents from exposure to the wrong parties. They should also support simplified access when needed by allowing authorized parties to quickly search, find, and retrieve archived and active documents. This course provides a strong understanding of the concepts of Document Control and Records Management and develops the requirements to help Document Controllers, Records Managers, and other staff improve the control of critical documents across the organization. Using best practice and time-proven methodologies and techniques, the course enables participants to understand and implement key document control methods and improvement plans, and to understand the impact of wider information management issues and challenges.
Organizations typically start using electronic document management systems to transform paper-based operations after reaching an internal tipping point in which customer response times become too slow, departments don’t have enough bandwidth to solve recurring process bottlenecks, paper archiving becomes too costly or large-scale regulatory risks are exposed during a data breach or compliance fines.
For organizations that have defined but resource-intensive business processes, EDMS is an ideal fit. Document management helps organizations across industries sidestep this busy work entirely by eliminating manual document maintenance, reclaiming valuable staff time, and boosting the bottom-line.
The best leaders thoroughly understand themselves. Time and time again, research has shown that self-awareness and self-direction are two essential factors in leadership effectiveness. As leaders gain a better sense of themselves and a clearer plan to self-actualization.
Mastering the inter-related skills of communication, negotiation, and presentation is the key to success both for individuals building their careers and for the organizations in which they work. Drawing on classical learning, psycho-linguistic research, and ideas associated with NLP and Emotional Intelligence, this highly interactive and hands-on program helps participants explore and practice the principles and techniques they need to be effective communicators, negotiators, and presenters. Most importantly, it focuses on helping them apply these skills in the workplace as part of a process of continuous learning.