السعر: 2,625 درهم
  • مدة الدورة التدريبية: Upto 25 Hours
  • مواعيد الدورة: Part Time, Flexible

    تفاصيل الدورة


    Course Overview:
    • Explain SQL Server features and architecture
    • Store and retrieve data from SQL Server
    • Apply data integrity features to stored data
    • Use indexes and views 

    Course Contents:
    • List the features of SQL Server
    • Identify the operating systems that support SQL Server 2008
    • Describe SQL Server database architecture 
    • List database objects
    • Use the SELECT statement with different clauses
    • Use System Global Variables 
    • Use Unions and Subqueries to retrieve data from multiple tables 
    • Use Nested and Correlated Subqueries
    • Use Aggregate Functions to display summary data 
    • Use the GROUP BY clause to generate grouped information
    • Apply the HAVING clause to set a condition on grouped data
    • Use various SQL functions to query data
    • Identify and use various types of joins 
    • Define the DEFAULT and CHECK constraints
    • Define the PRIMARY KEY, UNIQUE and FOREIGN KEY constraints
    • Describe Rules 
    • Define Indexes 
    • Define and create Views
    • List the advantages of Views
    • List the guidelines for creating Views
    • Define stored procedures
    • Discuss types of stored procedures
    • Explain the process of creating, modifying and executing stored procedures
    • Use parameters in stored procedures
    • Define triggers
    • List the uses of triggers
    • List the guidelines for creating triggers
    تحديث بتاريخ 28 July, 2020

    نبذة عن معهد Rolla Computer and Management Training

    In this day and age, When information and technology is progressing day by day, importance of well-trained professionals has been two folds. Al Rolla Computers was established to produce Skilled professionals who not only meet the requirements of today but, in future as well. After taking enormous potential of information technology into consideration Al Rolla Computers has designed its programs in the light of latest information. Al Rolla computers is known as the center of the IT training for executives and students.

    We are one of the pioneer institute which offer Internationally Recognized Certifications in United Arab Emirates. It is great credit for Al Rolla Computers that have successfully trained Thousands of professionals and students through introducing most advance programs like " MCSE, MCP, **OCP, CIW, A++  and **CCNA". Our achievement, growth and development are proof our popularity and reputation for our high standard of education.

    عرض الجميع دورات Rolla Computer and Management Training
    دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على SQL Server ابتداءً من الآن. See all courses

    هل هذه الدورة التدريبية الاختيار المناسب لك؟

    قيِم هذه الصفحة

    لم تجد ما كنت تبحث عنه؟

    أو