Home
Courses
- Microsoft Excel
- Microsoft Word
- Microsoft Access
- Microsoft PowerPoint
- Microsoft Outlook
- Microsoft Office
- Microsoft Visio
- Microsoft Publisher
- All Courses
Book
GoExcel
Services
Contact
Clients

SQL Training Courses

Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.

SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places within a database.

AJ Training offer a range of hands on training courses and workshops delivered at our Rotherham training suite or on site at your location.

Levels

Introduction

Overview of SQL Server
Using Tables
Working with Data
Working with Functions
Using Multiple Tables
Modifying Data
SQL Commands More details..

SQL Training Courses Introduction

This 2-day course will provide delegates with the knowledge and skills required to retrieve and manipulate data held inside relational databases using the SQL querying language. Delegates will gain knowledge to manipulate data held in a standard relational database using basic SQL. There are no pre-requisites, however, delegates would be assumed to have good general IT skills.

Overview of SQL Server
A small introduction to the SQL Schema and what we use Databases for.
• Introducing Databases
• What Is SQL?
• SQL Server Management Studio (SSMS)

Using Tables
Create and modify tables to store millions of rows of data.
• Create a table
• Delete tables (DROP)
• Change existing tables
• Different data types

Working with Data
Learn how to retrieve data from tables using a variety of techniques.
• Data Retrieval
• Sorting Data
• Simple Filtering
• Combining Filters
• Calculated Fields

Working with Functions
Use more advanced functions to gather a wider array of information from your database.
• Using basic maths
• Working with dates
• Understanding GROUP BY

Using Multiple Tables
Use SQL to gather data from multiple tables within a database.
• Table Joins
• Using Sub-Queries
• Union Queries

Modifying Data
Combine previous and new commands to insert and manipulate data within a database.
• Adding New Data
• Updating Data
• Deleting Data

More SQL
Use SQL Commands to further drill-down into data and produce specific results.
• IN
• DISTINCT
• Sub-Queries

SQL Training Courses Pre-course Questionaire

Please assess each statement and select 'YES' if it lists a process you understand, if in doubt select 'NO'.

AJ Training - Level Selector Confirmation

Thanks , your score has been emailed to you.

If there is anything we can help with in the meantime, please call 01709 352307 or email: info@ajtraining.net.

SQL Training Courses Pre-course Questionaire

Based on your answers, the most appropriate course for you would be:-

text

Click here to see a list of scheduled courses.

Prices

One Company

£925.00

per day

At our Rotherham training suite
Up to 8 delegates
Lunch and refreshments provided
Option to tailor content, add £100

Enquire Now

On-site Training

£985.00

per day + travel costs

Training at your chosen location
Up to 8 delegates
Equipment Included
Option to tailor content, add £100

Price Estimate

Scheduled Course

£245.00

per delegate, per day

At our Rotherham training suite
Equipped training room
Lunch and refreshments provided

Book Now

Price Estimate

AJ Training standard rate is £985.00 + VAT. *

This includes:

Up to 8 delegates
Equipment Included
Option to tailor content, add £100

* Rate excludes travel expenses, for an approximate on site price please add your details below.

Get Quote


Name :
Company :
Telephone Number :
Email Address :		**
Confirm Email Address :		** * Address details dont match

Request exact quotation

AJ Training - Booking Form

All bookings will be invoiced and payment is due 10 Days before the course date.

Following your booking you will receive an email confirming the details including course start times and location, we will attach a course overview, pre course questionaire, directions and an invoice.

Should you require assistance or wish to book multiple courses,
please call 01709 352307 or email info@ajtraining.net, we will be happy to help.

All bookings will be charged at the advertised rates.

Date Required :
Name :
Company :
Telephone Number :
Email Address :		**
Confirm Email Address :		** * Address details dont match

Book Now

AJ Training - Schedule Course Booking

All bookings will be invoiced and payment is due 10 Days before the course date.

Following your booking you will receive an email confirming the details including course start times and location, we will attach a course overview, pre course questionaire, directions and an invoice.

Should you require assistance or wish to book multiple courses
please call 01709 352307 or email info@ajtraining.net and we will be happy to help.

All bookings will be charged at the advertised rates. The prices shown are per delegate, per day and exclude VAT.

Course :
Course Date :
Number of Places :
Name :
Company :
Telephone Number :
Email :	**
Confirm Email :	** * Type mismatch

	Book Now

AJ Training - Schedule Course Booking

There are currently no scheduled courses. Please fill out the details below and we would be happy to scheduled a course around your availability.

Should you require assistance or wish to book multiple courses,
please call 01709 352307 or email info@ajtraining.net, we will be happy to help.

All bookings will be charged at the advertised rates. The prices shown are per delegate, per day and exclude VAT.

Course :
Requested Date :
Number of Places :
Name :
Company :
Telephone Number :
Email :	**
Confirm Email :	** * Type mismatch

	Book Now

AJ Training - Enquiry Form

Please complete the form below to enquire about one company / bespoke courses.

All bookings will be charged at the advertised rates. The prices shown are per day and exclude VAT.

Course :
Requested Date :
Name :
Company :
Telephone Number :
Email :
Confirm Email :

	Enquire Now

AJ Training - Elearning

Our experienced training team have designed each package from the ground up, to ensure it delivers on content and is simple to follow. We always include both video and exercises to help you along the way.

Each of our paid courses comes with our full support, if you get stuck, want to check your understanding or require any additional information, this is all part of the service and our team are here to help!

eLearning package per user @ £39.99 Plus VAT
12 months online access

Course
Excel Introduction
Excel Intermediate
Excel Advanced

Outlook All in One Covers all levels in one course


PowerPoint All in One Covers all levels in one course

Word Introduction
Word Intermediate
Word Advanced

Buy now using the above PAYPAL links, once your payment is received we will email you your access details.

Business Packages

Although eLearning packages offer a great stand alone product we also offer anyone who attends a standard course the option of adding the complementing eLearning package for only £25.00.

For more information or multiuser access please :
Call : 01709 352307
Visit : Contact us page
Email : info@ajtraining.net

All trainer delivered courses include

Certificate of attendance
e-Mail support
Course notes

AJ Respond to all online bookings within 3 working hours, we will email you back to confirm prices, availability and content of the requested course.
Once confirmed we will forward joining instructions along with an invoice payable 10 days before the course date.

AJ Scheduled Course List

There are currently no active courses. Please call 01709 352307 or email info@ajtraining.net and we would be happy to schedule additional dates.

AJ Training - Booking Form

Number of Places :
Name :
Company :
Telephone Number :
Email :	**
Confirm Email :	** * Type mismatch

	Book Now

AJ Training - Booking Form

Please complete the form below. If you have a date in mind please let us know by completing the "request date".

We will be in touch shortly to discuss your training needs and proposed date for the scheduled course.

Should you require assistance or wish to book multiple courses,
please call 01709 352307 or email info@ajtraining.net, we will be happy to help.

All bookings will be charged at the advertised rates. Prices quoted are per deletgate, per day.

Course :
Request Date :
Number of Places :
Name :
Company :
Telephone Number :
Email :	**
Confirm Email :	** * Type mismatch

	Book Now

AJ Training - Booking Confirmation

Thank you for your .

If there is anything we can help with in the meantime, please call 01709 352307 or email: info@ajtraining.net.

Contact us

AJ Training
Phone: 01709 352307
Email: info@ajtraining.net
Professional IT services with a personal touch
Company Registered in England
Registered Number : 7535586
VAT Number : GB 109 9831 86
Privacy Policy

Additional Info

eLearning
Level Selector

Popular Courses

Microsoft Excel
Microsoft Word
Microsoft Outlook
Microsoft Access
Microsoft Powerpoint

AJ Training - Mailing Confirmation

Thank you for subscribing to our mailing list.

Your request is now being processed.

If there is anything we can help with in the meantime, please call 01709 352307 or email: info@ajtraining.net.

Microsoft Online Help

Microsoft Excel
Microsoft Access
Microsoft Outlook
Microsoft Project
Microsoft Word
Microsoft PowerPoint
Microsoft Publisher
Microsoft Visio

About us

We have been helping businesses since 2006, we are proud to have helped thousands of clients. Thanks to valued feedback and recommendations from our customers we are continuing to offer everything from the basics to advanced training to an ever increasing client base.

AJ Training National Training Site