SQL - Level 1 Fundamentals of Querying
Learning Method: Instructor-led Classroom Learning
Duration: 1.00 Day
Overview:
You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define instructions. 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.
Prerequisites:
To ensure your success, we recommend you first take the courses on, or have equivalent skills and knowledge of either: Windows XP: Introduction, Windows XP Professional: Level 1 and Windows XP Professional: Level 2
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.
Course Outline
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
