Training on Databases Integrations and Programming

One of our primary function is systems development and our knowledge for training in the area of database and programming sets us ahead of the rest. We use our practical knowledge and skills to provide top class training and after course support.

Microsoft Training Courses

SQL Server Database Course content

This course is intended for SQL Server database administrators, implementers, system engineers and developers who are responsible for writing queries.

After completing this course, delegates will be able to:

• Describe the uses of and ways to execute the Transact-SQL language
• Use querying tool
• Write SELECT queries to retrieve data
• Group and summarise data by using Transact-SQL
• Join data from multiple tables
• Write queries that retrieve and modify data by using subqueries
• Modify data in tables
• Query text fields with full-text search
• Describe how to create programming objects
• Use various techniques when working with complex queries

Before attending this course, you must have:

• Knowledge of data integrity concepts
• Core Windows Server skills
• Relational database design skills
• Programming skills

Visual Basic Database Course Content

This course builds on the subjects discussed in the previous levels of Excel. We have split this course into two separate days to enable participants to get the most out of their training. By the end of this level participants will be able to:

• Visual Basic Environment Introduction
• Visual Basic Controls ( Events, Properties, Text, Methods, Forms, Focus)
• Visual Basic Definitions ( General, Event, Function, Sub procedures and Modules)
• Creating Forms ( Create Your Spreadsheet Wizards / Auto Fill Spreadsheet)
• Using Variables ( Text Handling / Property / Functions / Strings / Variants )

Access Database Course Content

The first stage aims to give users the knowledge and confidence to start using and understanding Access databases. This part explains the differences between flat and relational databases with primary and foreign keys. This will help the user to learn and understand database structures and start producing linked Tables – Queries – Forms – Reports. Even people with previous Access experience will gain invaluable, practical knowledge from the experience and expertise of our PCS trainers.

• Relational Databases (1 - 1 / 1 - Many/ Simple Working Relationships)
• Creating ( List Boxes / Combo Boxes / Combo box Queries)
• Creating Forms ( Tabular / Columnar / Sub forms )
• Importing & Exporting ( Excel / Other Databases)
• Queries (Forms Using Queries)
• Reports (Using Queries / Group)
• Switchboard (Pros & using Wizard / PCS switchboard )
• Professional Database (Pop-up Forms/ Toolbars)