EN |

11. Database Administration

Previous 11 / 15 Next

11. Database Administration Prof. Diploma in Software Engineering (Programming) Diploma in Information Technology


Database

This course is the foundation for all SQL Server-related disciplines, such as Database Administration, Database Development and Business Intelligence.

Students will be equipped with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.

Contents:

 1.

 MS SQL 2014 Installation

 2.

 Introduction to SQL and RDBMS

 3.

 Database, Table, Columns, Records and Fields

 4.

 Primary Key, Foreign Key and Relationship

 5.

 Relationship Types

 6.

 Database Normalization

 7.

 Data Types

 8.

 SQL Constraints

 9.

 Manipulating Data

 10.

 Joining Tables

 11.

 Union and Aggregation

 12.

 Backup and Restore Database

 

Project:

Creating an application using MS SQL to manage data. The application should produce useful reports for the use of management level. 

Research:
Latest MS SQL technology


Other Related Subject

Please leave your enquiry here, we will reply as soon as possible.
Name*  
Company Name  
Product Interested  
Quantity  
Email*  
Contact No.*  
Ship to Name  
Shipping Address  
Messages*  
   

Switch to Mobile Version
available in
1
Hello! Thanks for visiting my site. Please press Start button to Contact with Admin :)

Start