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.

* 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: Location Cambridge Peterborough Brentwood Luton Ipswich Norwich Birmingham Leicester Northampton Hammersmith Chiswick Heathrow Milton Keynes Reading Kensington London Coventry Oxford Guildford

Num Students: 123456 78Over 8

=
To let us know you're not a machine enter the result:

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