SQL and Database for Analysts – Increase your team value

Learn basic SQL so you can communicate better with DBAs and Developers, and increase your value as a team member.

Created by: Tom Gillies
Business Analyst and Educator

What Will I Learn?

• By the end of the course you will have created databases, containing several tables and associated objects.
• You will have added, updated and deleted data in those tables.
• You will have created report queries which retrieve and manipulate that data.
• You will have changed what a user is allowed to see and do in a database.

Requirements

• The primary requirement for this course is an inquisitive, analytical mind. You want to "understand how things work."
• You do not need to be a programmer or mathematician. What little programming or mathematics is needed, I will explain during the course.
• If you are going to do the exercises, then you will need a PC capable of running MS SQL Server, and have Administrator authority to install software.
• You will find the course easier if you have experience using a text editor such as Notepad, or Word, and a spreadsheet such as Excel. You should also know how to create and use subdirectories in the Windows directory structure.

Target audience

• Business Analysts
• Technical Analysts
• IT Specialists