|
Course ID: 5373
| Course Duration: 1 Day
|
|
Course Dates:
|
| |
|
| |
SQL Querying - Level 1 Fundamentals of Querying Training Class
Course ID: 5373
|
|
| |
|
|
| |
|
|
| |
SQL Querying - Level 1 Fundamentals of Querying Training Seminar
Overview:
In this course, students learn how to compose SQL queries to retrieve information from the database.
Who Should Attend:
Any person with basic computer skills, familiar with concepts related to database structure and terminology, and wants 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.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Executing a Simple Query
Connect to the Database
Query the Database
Modify a Query
Save a Query
Execute a Saved Query
|
|
Lesson 2: Performing a Conditional Search
Search Using a Simple Condition
Compare Column Values
Search Using Multiple Conditions
Search for a Range of Values and Null Values
Retrieve Data Based on Patterns
|
Lesson 3: Working with Functions
Perform Date Calculations
Calculate Data
Manipulate String Values
|
Lesson 4: Organizing Data
Sort Data
Group Data
Filter Grouped Data
Summarize Grouped Data
|
Lesson 5: Retrieving Data from Multiple Tables
Combine Results of Two Queries
Retrieve Data by Joining Tables
Check for Unmatched Records
Retrieve Information from a Table Using Joins
|
|
Lesson 6: Presenting Query Results
Customize and Save the Query Result
Generate an HTML Report
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Windows XP - Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
SQL Querying - Level 1 Fundamentals of Querying Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5373
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
 Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |
|
|