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 (Second Edition)
Duration
1 Day
Course
LO-094018
Available Formats
Classroom Training, Online Training
Course Description
Overview
Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.
This course, SQL Querying: Fundamentals (Second Edition), 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.
Students 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 onscreen.
- 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, 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 is highly recommended:
- Using Microsoft Windows 10
Topics
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify and Execute a Saved Query
- Search Using One or More Conditions
- Search for a Range of Values and NULL Values
- Search Data Based on String Patterns
- Perform Date Calculations
- Calculate Data Using Aggregate Functions
- Manipulate String Values
- Sort Data
- Rank Data
- Group Data
- Filter Grouped Data
- Summarize Grouped Data
- Use PIVOT and UNPIVOT Operators
- Combine the Results of Two Queries
- Compare the Results of Two Queries
- Retrieve Data by Joining Tables
- Generate a Text File
- Generate an XML File
Related Courses
-
Database Design: A Modern Approach
LO-094020- 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.