MS-SQL
SQL: Querying Training Class:
- Ways to Train:
- Live Classroom Class is delivered at a Centriq location with a live instructor actually in the classroom.
- Live Virtual Class Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
- HD Class Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
- Ways to Buy:
- Retail Class can be purchased directly via check, credit card, or PO.
- CV Centriq Vouchers Class is available for students using Centriq Vouchers.
- CP Centriq Choice Pass Eligible Class is available to students utilizing Centriq Choice Pass program.
| Start Date | End Date | Duration | Days | Start Time | End Time | Time Zone | Location | Ways to Train | Ways to Buy | Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Request a Date |
This two-day course will teach you to use SQL as a tool to retrieve the information you need from databases. You will work with queries to manipulate and index tables.
Audience
Students should have basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Prerequisites
- Access 2007, 2010, and 2013
- Basic understanding of Relational Database Design
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 to perform calculations on data
- Format an output, save a result, and generate a report
- Use subqueries to generate query output.
- Manipulate table data by inserting and updating records in a table and deleting records from a table.
- Manipulate the table structure.
- Create views, manipulate data through views, modify the view structure, and drop views.
- Create indices on table columns and drop inefficient indices.
- Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.
View the SQL: Querying Training Course Outline
Executing a Simple Query
- Topic A: Connect to the SQL Database
- Topic B: Query a Database
Performing a Conditional Search
- Topic A: Search Using One or More Conditions
- Topic B: Search for a Range of Values and NULL Values
- Topic C: Search Data Based on Patterns
Retrieving Data from Multiple Tables
- Topic A: Combine the Results of Two Queries
- Topic B: Compare the Results of Two Queries
- Topic C: Retrieve Data by Joining Tables
Organizing Data
- Topic A: Sort Data
- Topic B: Rank Data
- Topic C: Group Data
- Topic D: Filter Grouped Data
- Topic E: Summarize Grouped Data
Working with Functions
- Topic A: Perform Date Calculations
- Topic B: Calculate Data Using Aggregate Functions
- Topic C: Manipulate String Values
Working with Views
- Topic A: Create a View
- Topic B: Manipulate Data in Views
- Topic C: Create Aliases
- Topic D: Modify and Delete Views
Manipulating the Table Structure
- Topic A: Create a Table
- Topic B: Create a Table with Constraints
- Topic C: Modify a Table's Structure
- Topic D: Back Up Tables
- Topic E: Delete Tables
Using Subqueries to Perform Advanced Querying
- Topic A: Search Based on Unknown Values
- Topic B: Compare a Value with Unknown Values
- Topic C: Search Based on the Existence of Records
- Topic D: Generate Output Using Correlated Subqueries
Manipulating Table Data
- Topic A: Insert Data
- Topic B: Modify and Delete Data
Optional Topics:
Managing Transactions
- A: Create Transactions
- B: Commit Transactions