Computer Tutoring Logo
Est. 2002
Menu Button

SQL Querying Fundamentals Beginners

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 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

SQL Querying Fundamentals Beginners