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

International Brighter Career Development (IBCD) Logo

MYSQL Programming

This program will teach you about managing and building SQL Server database. It will give you the skills, knowledge and ability required for SQL Server development.

by International Brighter Career Development (IBCD)
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
International Brighter Career Development (IBCD) Logo

SQL Programming

This course will teach you about managing and building SQL Server databases. It will give you the skills and knowledge of creating a SQL Server development.

by International Brighter Career Development (IBCD)
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
Level Up Learning Language & Computer Center Logo

Oracle Database Admin

Ministry Attested or Institute certificate will be provided. Overview of Oracle DBA tasks Instance Architecture Oracle Instance Internals Using SQL*Plus for DBA management Control file, UNDO and REDO management and so much more in this cours

by Level Up Learning Language & Computer Center
  • Price
  • Start Date
  • Duration

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