SQL Fundamentals of Querying

A One Day Training Course
Overview
Students will learn what SQL is and how they can query a database to answer business questions.

Who Should Attend
Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with such terms as computer memory, data files, and program files. Students should also be familiar with the components that make up a personal computer, including input, output and storage devices.

Prerequisites
A basic knowledge of concepts related to database structure and terminology, such as fields (or columns) and records (or rows) is helpful.

Content
Lesson 1: Introduction to databases and SQL
Lesson 2: Introduction to the SELECT statement
Lesson 3: Calculating data
Lesson 4: Selecting specific rows
Lesson 5: Working with other operators
Lesson 6: Grouping data
Lesson 7: Multi-table queries
Lesson 8: Other SQL front-end applications
Appendices
The sample database

Advanced SQL Querying

A One Day Training Course
Overview
To develop the delegate’s use of SQL to and advanced level. this course introduces data manipulation language and database definition language.

Who Should Attend
You should attend this course if you wish to have a good understanding of all DML statements (SELECT, INSERT,
UPDATE, DELETE) and all of the DDL statements needed to build database objects (CREATE, DROP, ALTER). This course also covers the use of views, access control, transaction control, advanced select queries and using SQL scripts.

Prerequisites
Delegates for this course should have a good basic understanding of SQL select statements. This course assumes knowledge of SQL to the level of our Introduction course.

Content
Lesson 1: Querying with unions and advanced joins Querying multiple
tables with unions Advanced Joins Calculating with COMPUTE
Lesson 2: Querying with subqueries Subqueries
Lesson 3: Adding data Inserting data SELECT INTO
Lesson 4: Updating and removing data Updating records Deleting records Deleting the contents of tables
Lesson 5: Manipulating tables and views Creating tables Modifying tables Deleting tables Adding and removing views
Lesson 6: Manipulating indexes Adding and removing indexes
Lesson 7: Ensuring data integrity with transactions Transactions
Lesson 8: Creating databases Creating a database with SQL Deleting a database

Visio 2013 Introduction

Duration
1 Day

Overview
The Introduction to Visio 2013 training course covers how to create professional diagrams to simplify complex information.

Objectives
You will learn how to create drawings like flowcharts and business process diagrams, work with shapes, text, art and objects and manage pages.

Who Should Attend
New and exisiting users of Visio who want to learn how the product is used efficently in the production of complex flow charts and business process diagrams.

Content

Getting Started with Visio
• Identify the Components of the Visio 2013 Interface
• Customise the Visio Interface
• Create a New Drawing
• Save a Drawing
• Open a Drawing
• Print and Share your Drawing

Creating a New Drawing
• Understand the Shapes Pane
• Add Shapes to a Drawing
• Connect Shapes
• Use Drag and Drop, Cut, Copy and Paste & Undo and Redo

Working with Shapes and Formatting Shapes
• Select Shapes
• Move, Rotate, Resize, Duplicate and Delete Shapes
• Apply a Shape Style
• Change the Fill and Line Colour
• Add Effect

Arrange Shapes
• Use Auto Align and Auto Space
• Change the Layout of the Page
• Rotate the Diagram

Format Text
• Change the Font Face, Size and Colour
• Apply Text Effects
• Use the Text Dialog
• Change Text Alignment
• Rotate Text

Insert Art & Objects
• Insert Online and Local Pictures
• Insert Charts
• Insert CAD Drawings
• Insert Text Boxes

Format the Page
• Change the Theme of the Current Page
• Choose a Variant for the Current Page
• Apply a Page Background
• Add Borders and Titles

Manage Pages
• Insert Pages
• Browse through Pages
• Rename and Delete Pages
• Create Background Pages

The Finishing Touches
• Check Spelling
• Modify Page Size and Orientation
• Use Page Setup
• Add Headers and Footers