Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

SQL Querying - Level 1 Fundamentals of Querying*

kurz

Základní info

Duration
Classroom Learning - 1 Day(s)
Online LIVE - 1 Day(s)

Overview
This course, students will learn to use SQL as a tool to retrieve the information you need from databases.

Who Should Attend
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.

At Course Completion
Upon successful completion of this course, students will be able to:
- connect to the SQL Server database and execute a simple query.
- include a search condition in a simple query.
- use various functions based on the data types to perform calculations on data.
- organize the data obtained from the query before it is displayed on the screen.
- retrieve data by combining information from multiple tables.
- format the output, save the result, and generate a report.

Prerequisite(s) or equivalent knowledge

Using Microsoft Windows 8.1

Windows 8 Transition from Windows 7

Suggested Next Steps

SQL Querying - Level 2 Advanced Querying

Outline

Lesson 1: Executing a Simple Query

Connect to the SQL Database
Query a Database
Save a Query
Modify a Query

Lesson 2: Performing a Conditional Search

Search Using One or More Conditions
Search for a Range of Values and NULL Values
Search Data Based on Patterns

Lesson 3: Working with Functions

Perform Date Calculations
Calculate Data Using Aggregate Functions
Manipulate String Values

Lesson 4: Organizing Data

Sort Data
Rank Data
Group Data
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Tables

Combine Results of Two Queries
Compare the Results of Two Queries
Retrieve Data by Joining Tables

Lesson 6: Exporting Query Results

Generate a Text File
Generate an XML File