title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
SQL Querying: Fundamentals
Duration
1 Day
Course
LO-094005
Available Formats
Classroom Training, Online Training
Course Description
Overview
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.Objectives
In this course, you will compose SQL queries to retrieve desired information from a database.
You will:
- Connect to the SQL Server database and execute a simple query.
- Include a search condition in a simple query.
- Use various functions to perform calculations on data.
- Organize the data obtained from a query before it is displayed on-screen.
- Retrieve data from multiple tables.
- Export the results of a query.
Audience
This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Prerequisites
-
Basic end-user computer skills and some familiarity with database terminology and structure are required. Completion of one of the following Logical Operations courses or equivalent knowledge and skill are highly recommended:
- Using Microsoft® Windows® 8.1
- Microsoft® Windows® 8 Transition from Windows® 7
Topics
Lesson 1: Executing a Simple Query
- Topic A: Connect to the SQL Database
- Topic B: Query a Database
- Topic C: Save a Query
- Topic D: Modify and Execute a Saved Query
- Topic A: Search Using One or More Conditions
- Topic B: Search for a Range of Values and NULL Values
- Topic C: Search Data Based on Patterns
- Topic A: Perform Date Calculations
- Topic B: Calculate Data Using Aggregate Functions
- Topic C: Manipulate String Values
- Topic A: Sort Data
- Topic B: Rank Data
- Topic C: Group Data
- Topic D: Filter Grouped Data
- Topic E: Summarize Grouped Data
- Topic F: Use PIVOT and UNPIVOT Operators
- Topic A: Combine the Results of Two Queries
- Topic B: Compare the Results of Two Queries
- Topic C: Retrieve Data by Joining Tables
- Topic A: Generate a Text File
- Topic B: Generate an XML File
Related Courses
-
SQL Querying: Advanced
LO-094006- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.