Course Code: fundamentalsqlserver2017
Duration: 35 hours
Prerequisites:

Background in Database Concept

Overview:

After completing this course, students will be able to:

  • Understand Core Database Concepts
  • Create Database Objects
  • Manipulate Data
  • Understand Data Storage
  • Administer a Database
Course Outline:

Module 1: Understanding Core Database Concepts

•Introduction core database concepts
•Define databases
•Example of relational database tables
•Introduce common database terminology
•Relational Concepts
•Normalization
•Referential Integrity
•Constraints

Module 2: Creating Database Objects

•Data types
•Data Objects
•DLL (Data Definition Language) Statements
•Creating Scripts

Module 3: Manipulating Data

•Using DML (data manipulation language) Statements
•Using SELECT Statement
•Using INSERT, UPDATE, and DELETE to manage data
•Indexes
•Triggers

Module 4: Understanding Data Storage

•Designing Tables
•Creating and Modifying Tables
•Viewing Tables
•Deleting a Table

Module 5: Administering a Database

•SQL Server Security
•Securing Database and Objects
•Performing Database Backups
•Performing Database Restores
Sites Published:

United Arab Emirates - Database Administration Fundamentals for MS SQL Server

Qatar - Database Administration Fundamentals for MS SQL Server

Egypt - Database Administration Fundamentals for MS SQL Server

Saudi Arabia - Database Administration Fundamentals for MS SQL Server

South Africa - Database Administration Fundamentals for MS SQL Server

Brasil - Database Administration Fundamentals for MS SQL Server

Canada - Database Administration Fundamentals for MS SQL Server

中国 - Database Administration Fundamentals for MS SQL Server

香港 - Database Administration Fundamentals for MS SQL Server

澳門 - Database Administration Fundamentals for MS SQL Server

台灣 - Database Administration Fundamentals for MS SQL Server

USA - Database Administration Fundamentals for MS SQL Server

Österreich - Database Administration Fundamentals for MS SQL Server

Schweiz - Database Administration Fundamentals for MS SQL Server

Deutschland - Database Administration Fundamentals for MS SQL Server

Czech Republic - Database Administration Fundamentals for MS SQL Server

Denmark - Database Administration Fundamentals for MS SQL Server

Estonia - Database Administration Fundamentals for MS SQL Server

Finland - Database Administration Fundamentals for MS SQL Server

Greece - Database Administration Fundamentals for MS SQL Server

Magyarország - Database Administration Fundamentals for MS SQL Server

Ireland - Database Administration Fundamentals for MS SQL Server

Luxembourg - Database Administration Fundamentals for MS SQL Server

Latvia - Database Administration Fundamentals for MS SQL Server

España - Database Administration Fundamentals for MS SQL Server

Italia - Database Administration Fundamentals for MS SQL Server

Lithuania - Database Administration Fundamentals for MS SQL Server

Nederland - Database Administration Fundamentals for MS SQL Server

Norway - Database Administration Fundamentals for MS SQL Server

Portugal - Database Administration Fundamentals for MS SQL Server

România - Database Administration Fundamentals for MS SQL Server

Sverige - Database Administration Fundamentals for MS SQL Server

Türkiye - Database Administration Fundamentals for MS SQL Server

Malta - Database Administration Fundamentals for MS SQL Server

Belgique - Database Administration Fundamentals for MS SQL Server

France - Database Administration Fundamentals for MS SQL Server

日本 - Database Administration Fundamentals for MS SQL Server

Australia - Database Administration Fundamentals for MS SQL Server

Malaysia - Database Administration Fundamentals for MS SQL Server

New Zealand - Database Administration Fundamentals for MS SQL Server

Philippines - Database Administration Fundamentals for MS SQL Server

Singapore - Database Administration Fundamentals for MS SQL Server

Thailand - Database Administration Fundamentals for MS SQL Server

Vietnam - Database Administration Fundamentals for MS SQL Server

India - Database Administration Fundamentals for MS SQL Server

Argentina - Database Administration Fundamentals for MS SQL Server

Chile - Database Administration Fundamentals for MS SQL Server

Costa Rica - Database Administration Fundamentals for MS SQL Server

Ecuador - Database Administration Fundamentals for MS SQL Server

Guatemala - Database Administration Fundamentals for MS SQL Server

Colombia - Database Administration Fundamentals for MS SQL Server

México - Database Administration Fundamentals for MS SQL Server

Panama - Database Administration Fundamentals for MS SQL Server

Peru - Database Administration Fundamentals for MS SQL Server

Uruguay - Database Administration Fundamentals for MS SQL Server

Venezuela - Database Administration Fundamentals for MS SQL Server

Polska - Database Administration Fundamentals for MS SQL Server

United Kingdom - Database Administration Fundamentals for MS SQL Server

South Korea - Database Administration Fundamentals for MS SQL Server

Pakistan - Database Administration Fundamentals for MS SQL Server

Sri Lanka - Database Administration Fundamentals for MS SQL Server

Bulgaria - Database Administration Fundamentals for MS SQL Server

Bolivia - Database Administration Fundamentals for MS SQL Server

Indonesia - Database Administration Fundamentals for MS SQL Server

Kazakhstan - Database Administration Fundamentals for MS SQL Server

Moldova - Database Administration Fundamentals for MS SQL Server

Morocco - Database Administration Fundamentals for MS SQL Server

Tunisia - Database Administration Fundamentals for MS SQL Server

Kuwait - Database Administration Fundamentals for MS SQL Server

Oman - Database Administration Fundamentals for MS SQL Server

Slovakia - Database Administration Fundamentals for MS SQL Server

Kenya - Database Administration Fundamentals for MS SQL Server

Nigeria - Database Administration Fundamentals for MS SQL Server

Botswana - Database Administration Fundamentals for MS SQL Server

Slovenia - Database Administration Fundamentals for MS SQL Server

Croatia - Database Administration Fundamentals for MS SQL Server

Serbia - Database Administration Fundamentals for MS SQL Server

Bhutan - Database Administration Fundamentals for MS SQL Server

Nepal - Database Administration Fundamentals for MS SQL Server

Uzbekistan - Database Administration Fundamentals for MS SQL Server