Computer Tutoring Logo
Est. 2002
Menu Button

Adobe
Macromedia
Microsoft
General
Web Design
Handling Information
Print & Desktop Publishing

Testimonials

Bournville Village Trust

"Fascinating, thoroughly enjoyed it, SQL makes a lot more sense to me - I just need some time to practice now!"

Rugby School

"Informative, clearly presented and very helpful. It was good to have a trainer of high expertise who was willing to answer specific questions across a variety of fields and software applications."

Just Energy

"Coming from having no background knowledge to SQL I have really benefited from this training course and having the documentation I can't wait to start putting this into practice and learning further"

Locations

SQL Querying Fundamentals Norwich Beginners

Norwich train station and castle

Norwich

Cavell House
Stannard Place
St. Crispins Rd
Norwich
NR3 1YE
UNITED KINGDOM

The centre is located beside the inner ring road, which links directly with all main arterial routes exiting Norfolk. Norwich has train networks nearby that have direct links to London Liverpool Street (2 Hours) and Cambridge (1 Hour). Ideally situated for your Beginners SQL Querying Fundamentals

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


Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

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

The FullerAckerman Database

Beginners SQL Querying Fundamentals Norwich Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

How many people will attend:
Do you want us to bring laptops to you?
Do you want to use our offices?
£ *
Per Person

* Price is per day and exclusive of VAT.

Total day course price: £ .

Is this the outline for you? Use the form below to register your interest

If you are interested in this course fill out the following form for further details:

First Name:
Last Name:
Email:
Tel:
Location:
Num Students:
=
To let us know you're not a machine enter the result:

You may also be interested in:

Fundamentals of Databases Using MySQL Training Course - Beginners

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


SQL Querying Fundamentals Norwich Beginners