Database Management System

 

My SQL Server

Introduction to RDBMS, introduction to PostgreSQL, understanding SQL with PostgreSQL Data types, DDL statements in PostgreSQL, DML statements in PostgreSQL, using Sub Queries, using Views, Operators Functions, PostgreSQL, advanced features, authentication and encryption.

Duration6 Months

About this course

You can learn how to implement and manage database solutions, migrate to the cloud with the ability to scale on demand, work with powerful reporting features, and see how SQL Server integrates with SharePoint. Plus, because our SQL Server online training is available on your schedule, you can take classes when, where, and how it suits you best.

Course Syllabus

  • Introduction to RDBMS
  • Introduction to PostgreSQL
  • Understanding SQL with PostgreSQL
  • Data types
  • DDL statements in PostgreSQL
  • DML statements in PostgreSQL
  • Using sub queries
  • Using views
  • Operators Functions
  • PostgreSQL Advanced features Authentication and encryption

MS-Access

Microsoft Access is a computer application used to create and manage computer-based databases on desktop computers and/or on connected computers (a network). Microsoft Access can be used for personal information management (PIM) in a small business to organize and manage data or in an enterprise to communicate with servers.

About this course

Microsoft Access is an important information management tool that allows users to create databases to store various kinds of information for reference, reporting and analysis. It is a flexible program that allows the performance of simple end-user tasks as well as mission critical operations. Access users can create tables, queries, forms, and reports, and connect them together with macros.

Course Syllabus

  • Introduction to DBMS
  • Difference between DBMS and RDBMS
  • Logical Concepts of database
  • Tables
  • Editing Records
  • Deleting Records
  • Viewing databases
  • Structure sorting and indexing
  • Forms
  • Report Generation
  • Queries