SQL Querying Fundamentals Training Course Beginners Leicester

Leicester Beginners SQL Querying Fundamentals Course Overview

Leicester boasts a multicultural atmosphere and is famous for its association with King Richard III.

1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom

The centre at Grove Park is conveniently located immediately off the junction with the M1 and M69 Motorways. The central location provides an ideal base for not just Leicester companies but also national businesses looking for an accessible UK base. Leicester City Centre is a 10 minute drive and the motorways are less than 5 minutes away. A great venue for your Beginners SQL Querying Fundamentals Training Course.

Alternatively if you live in and around Leicester and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

There are many other computer training courses in Leicester. Please take the time to look through them.

Course Duration: 1 Day

Course Prerequisites for your training in Leicester

There are no course prerequisites for this course. However, it would be a good idea to have at least what we would call an intermediate level of Excel knowledge. This would include understanding PivotTables, VLookup.

Complete Course Outline

SQL Querying: Fundamentals

Executing a Simple Query

• Connect to the SQL Database
• Query a Database
• Save a Query
• Modify and Execute a Saved Query

Performing a Conditional Search

• Search Using One or More Conditions
• Search for a Range of Values and NULL Values
• Search Data Based on Patterns

Working with Functions

• Perform Date Calculations
• Calculate Data Using Aggregate Functions
• Manipulate String Values

Organizing Data

• Sort Data
• Rank Data
• Group Data
• Filter Grouped Data
• Summarize Grouped Data
• Use PIVOT and UNPIVOT Operators

Retrieving Data from Multiple Tables

• Combine the Results of Two Queries
• Compare the Results of Two Queries
• Retrieve Data by Joining Tables

Exporting Query Results

• Generate a Text File
• Generate an XML File

You may also be interested in these training courses:

Fundamentals of Databases Using MySQL Training Course - Beginners

Power BI Training Course

Organising Data Training Course - Beginners

Microsoft Access 2013 Training Course - Beginners

Microsoft Access 2013 Training Course - Intermediate

Adobe Acrobat X Pro Training Course Beginners

Microsoft Excel 2013 Training Course Beginners

Microsoft Excel 2013 Training Course - Intermediate

Microsoft Excel VBA 2010 Training Course - Beginners