How To Query A SQL Database
This is a two day, introductory training class on querying a SQL Server database using Microsoft SQL Server 2008. It will teach you SQL, the query language.
No prior knowledge of SQL Server databases is assumed.
This is a really good course for someone who wants to learn how to build reports and conduct ad-hoc queries against a database. You will learn the basics of the SQL language. The focus of this course is NOT on the details of database development or administration. Rather, this course is more for non-database developers and administrators who need to learn how to query a database for reporting and data mining purposes.
Objectives of this course:
- Identify the features of Transact-SQL and use the Transact-SQL utilities to query a SQL server.
- Retrieve data by using the SELECT statement.
- Modify data by using the INSERT, UPDATE, and DELETE statements.
- Summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses.
- Query multiple tables through the use of joins.
- Design subqueries.
- Work with full-text indexes.
- Describe the types of programming objects in Transact-SQL.
Course outline:
Lesson 1: Exploring Transact-SQL
Topic 1A: An Overview of SQL Server and Transact-SQL
Topic 1B: Programming in Transact-SQL
Lesson 2: Querying Data
Topic 2A: Using the SELECT Statement
Topic 2B: Formatting the Results Set
Lesson 3: Changing Data Through Queries
Topic 3A: Inserting Data
Topic 3B: Deleting Data
Topic 3C: Updating Data
Lesson 4: Summarizing Data
Topic 4A: Working with Aggregate Functions
Topic 4B: Grouping Data
Lesson 5: Joining Tables
Topic 5A: Querying Multiple Tables
Topic 5B: Implementing Advanced Table Joins
Lesson 6: Implementing Subqueries
Topic 6A: Designing Subqueries
Lesson 7: Working with Full-text Indexes
Topic 7A: Implementing the Microsoft Search Service
Topic 7B: Querying Full-text Indexes
Lesson 8: Programming Transact-SQL
Topic 8A: Creating and Managing Views
Topic 8B: Implementing Stored Procedures, Triggers, and User-defined Functions
Appendix A: The Movies Database Structure
Table DesignTopic