SQL Server Basics 2019

by Duke Training Centre

Learn everything you need to know about working proficiently with SQL Server Basics 2019, Administering MS SQL Server 2014  Database & Developing MS SQL Server Database.

AED 3250

Contact the Institutes

Fill this form
Duke Training Centre Logo

img Duration

50 Hrs

Course Details

Learn everything you need to know about working proficiently with SQL Server Basics 2019, Administering MS SQL Server 2014  Database & Developing MS SQL Server Database.

 

Level-1 Basics Module 1 :

  • Course Introduction
  • Course Goals
  • Course Outline
  • Course Map
  • SQL Server Certifications
  • What is SQL Server?
  • SQL Server Online Resources

 

Module 2 :

  • Introduction to SQL Server
  • What is DBMS/RDBMS
  • Evolution of database and its Ancient History
  • Different RDBMS available in Market
  • Versions of SQL Server
  • History of SQL Server
  • Editions of SQL Server
  • SQL Server Licensing and Pricing
  • Hardware and Software requirements of SQL Server
  • Tools of SQL Server (GUI and CUI)
  • Introduction to SQL Server Architecture (Basic Version)

 

Module 3 :

  • SQL Server 2005/2008/2012/2014/2016/2017/2019
  • Installations
  • Prerequisites of SQL Server Installation
  • Installing SQL Server 2005 and Service Packs
  • Installing SQL Server 2008R2/2012 and Service Packs
  • Installing SQL Server 2012/2014 and Service Packs
  • Installing SQL Server 2016/2017 and Service Packs
  • Default Instance and Named Instance
  • Instance Aware/Unaware Services & Service Accounts
  • Collation Settings
  • Authentication Modes and their Importance
  • Client-Server Understanding
  • Servers-Tools Importance
  • SQL Server Installation & Service Packs troubleshooting
  • Service Pack Vs Cumulative Updates Vs Hotfixes
  • Unattended Installations and Parameters
  • Slipstream Installations in SQL Server 2008R2 & later
  • SYSPREP Installation
  • Much more 
     

Duke Training Centre is a pioneer institute that deals in providing high-quality practical and technical education to the private sector of UAE. All the programs are designed by keeping in mind the career prospect opportunities for the participants.

Established in 2004, Duke Training Centre has provided training to the vast and diverse community of UAE that includes law offices, government offices, philanthropies and organizations from several other fields. 

 

Approved By:

  • ACTVET (Abu Dhabi Center for Technical Vocational Education & Training) 
  • Autodesk Authorised Training & Testing Centre

 

Training Fields: 
  • Language
  • Accounting 
  • Engineering & CAD Professional
  • Exam Preparation
  • IT Programming & Applications
  •  IT Network and Server Administration
  • Safety Courses
  • Management and Soft Skills
  • SAP
  • Project Management
  • Cambridge Diploma Programs
  • Web Designing
  • Medical Coding
  • Much More
  • Tourist Club Area Branch

    Suite#102, Baskin Robbins, Near Smokers Center Building, Nadisya, Hamdan Street (Tourist Club Area), Tourist Club Area, Abu Dhabi
  • Mussafah Branch

    Shabia 9, Mussafah, Abu Dhabi

Check out more SQL Server courses in UAE

Vision Institute Logo

Microsoft Certified Database Administrator MCDBA

This training covers all areas of database technology and Microsoft SQL Server which are used for storing, retaining and analyzing data or information. You will learn about designing, creating, implementing and managing SQL Server databases.

by Vision Institute
Learners Point Academy Logo

Oracle Apps Financials-R12 (Functional)

This training will teach you about the different financial concepts of Oracle Financial such as General Ledger, Payables, Purchasing, Fixed Assets,  Accounts Receivables, Order-Management, Cash Management, and other different Projects.

by Learners Point Academy
  • Price
  • Start Date
  • Duration
Vision Institute Logo

Oracle DBA

This training by Vision Institue is designed to give you an instant start guide on performing common day-to-day database administrative tasks. You will learn about the concepts of Oracle database and understand the common administrative tas

by Vision Institute
Learners Point Academy Logo

Oracle Apps HRMS

Learn about Oracle-Apps HRMS and understand how the HR Department and Payroll have been using this software to manage various HR information in pockets making them duplicate systems.

by Learners Point Academy
  • Price
  • Start Date
  • Duration
Vision Institute Logo

Oracle ERP

Learn Oracle ERP with Vision Institute led by expert & friendly instructors in a conducive learning environment. It covers a broad range of topics to help you understand and learn Oracle ERP & its system which is extended to the customer end

by Vision Institute

© 2025 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy