Course Overview
This course introduces the user to SQL Server 2008 and the SQL Server Management Studio. It covers the basics from creating databases and tables to learning how to query multiple tables. Once those basics are covered, the final exercise is understanding and creating Views and simple Stored Procedures. This course is designed to get the user up and running with SQL Server as quickly as possible.
Course Objectives
Getting Started with SQL Server, Creating a Database and Tables, Working with Tables, SELECT Statements, Multi-Table Queries, Views and Stored Procedures
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
1 - Introduction
2 - Getting Started with SQL Server
- Overview: What is SQL Server?
- Connecting to the Server
- Working in the Management Studio
- Template Explorer
- Using Tools
- Understanding Window, Community, and Help Tabs
- Using Toolbars
- Using Object Explorer
- Opening a Table
- Transacting SQL
3 - Creating a Database and Tables
- Creating Databases with the Database Wizard
- Creating Tables Manually
- Understanding the 7 Basic Data Type Categories
- Using the Table We Created
- Creating Tables Using T-SQL
4 - Working with Tables
- Adding Constraints
- Understanding Indexes
- Altering the Table Design
5 - SELECT Statements
- The Basic SELECT Statement
- The FROM Clause
- The WHERE Clause
- The ORDER Clause
6 - Multi-Table Queries
- MS-SQL Query Method
- Using a WHERE Clause to Link Tables
- Ansi-SQL Method
- Joining Tables: Inner Join
- Query Designer
- Ambiguous Column Name
- Table Aliases
- Joining Tables: Left Outer Join
- Joining Tables: Right Outer Join
- A Tip for Building a New Query
7 - Views and Stored Procedures
- Overview
- Creating a View
- Creating a View Using T-SQL
- Creating Simple Stored Procedures
- Using Arguments
- Executing Stored Procedures
8 - Conclusion