|
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
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|