Untitled Document

SQL Introduction

Description

Structured Query Language (SQL) is the language use to work with databases and the information stored within them. In this course students will learn to query a database to SELECT the data with which they want to work. Students will use SQL to create, edit and delete data tables. Students will learn to create views, functions, and stored procedures. Students will need access to a database that uses SQL commands. The book for the course includes a trial edition of Microsoft's SQL Server 2000.

Objectives

Students will install the SQL Server demo and explore the basics of relational databases.
Students will write SQL statements to retrieve data from single and related tables.
Students will write SQL statements to create summary queries and subqueries.
Students will write SQL queries to edit data in the database.
Students will design a database and use the Enterprise Manager to manage the database.
Students will create views of their SQL data and code SQL scripts.
Students will write stored procedures, functions and triggers.
Students will write SQL cursors to retrieve and modify data.
Students will write SQL code to manage transactions and to secure the database.
Students will create an SQL project to demonstrate what they have learned in this course.

Book

Choose the book which matches your software version. SQL 2005 is the latest version.

Murach's SQL Server 2008 for Developers

Author: Bryan Syverson, Joel Murach
Publisher: Murach
ISBN: 1890774510

Murach's SQL Server 2005 for Developers

Author: Bryan Syverson, Joel Murach
Publisher: Murach
ISBN: 1890774391

Murach's SQL for SQL Server

Author: Bryan Syverson
Publisher: Murach
ISBN: 1-890774-16-2

Lesson 1: Getting Started

Read Appendices A and B and Chapters 1 and 2.

Lesson 2: Retrieving Data from Tables

Read Chapters 3 and 4.

Lesson 3: Creating Subqueries and Summary Queries

Read Chapters 5 and 6.

Lesson 4: Inserting, Updating and Deleting Data

Read Chapters 7 and 8.

Lesson 5: How to Design and Manage a Database

Read Chapters 9 - 11.

Lesson 6: Working with Views and Coding Scripts

Read Chapters 12 and 13.

Lesson 7: Stored Procedures, Functions and Triggers

Read Chapter 14.

Lesson 8: Cursors

Read Chapter 15.

Lesson 9: Managing Transactions and Security

Read Chapters 16 and 17.

Lesson 10: Putting to All Together

Review Chapters 1 - 17.