+251 111 559769      info@hilcoe.net
     +251 111 559769      info@hilcoe.net

Database Programming and Administration

Course Descriptions:

This course covers: principles of database management system, data recovery and protection methods, the importance of structure query language – SQL in the manipulation of data.  The most popular database programming language. SQL (structured query language). QBE, and its application to retrieve, delete and modify information from different tables discussed in detail. Finally students will be given to develop a working database application as course fulfillment. Database administration skills covering installation, configuration and tuning a database, structure of database systems, administering servers, data types, performance, backup and recovery strategies, security and privileges, high availability and scalability concepts.

Objectives:

At the end of the course students will be able to:

  1. Understand concepts of database application architectures and develop a database applications using SQL Server
  2. Use Structured Query Language(SQL) for creating database objects and manipulate data
  3. Provide solutions using Transact SQL programming language
  4. Understand the concept of database transaction
  5. Perform basic database administration utilities
  1. Demonstrate how to manage database services and clients
  2. Demonstrate how to implement and configure a database environment
  3. Explain best practices for data management
  1. Demonstrate and apply database optimization, maintenance and recovery procedures

 

Course Content:

  • Overview of SQL Server
  • Structured Query Language (SQL)
  • Other Database Objects
  • Programming in T-SQL
  • Transactions
  • Database Management/ Administration
  • Database Administration
  • Structure of Database Systems
  • Installation and Configuration
  • Data Types and Character Sets
  • Basics of Communication to Databases
  • Performance
  • Backup and Recovery
  • Security and Privileges