• LOGIN
  • No products in the cart.

Introduces the learners to SQL Server 2008 and the SQL Server Management Studio.


Course Description

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.


Learning Outcomes

  • Create databases and tables
  • Learn how to query multiple tables

Pre-requisites

Basic Microsoft Windows training or equivalent experience. Prior database knowledge is useful, but not required.


Who is this course intended for?

This course is designed to get the user up and running with SQL Server as quickly as possible. 

Course Curriculum

Introduction
Introduction 00:00:00
Getting Started with SQL Server
Overview: What is SQL Server? 00:00:00
Connecting to the Server 00:00:00
Working in the Management Studio 00:00:00
Template Explorer 00:00:00
Using Tools 00:00:00
Understanding Windows, Community, and Help Tabs 00:00:00
Using Toolbars 00:00:00
Using Object Explorer 00:00:00
Opening a Table 00:00:00
Transacting SQL 00:00:00
Creating a Database and Tables
Creating Databases with the Database Wizard 00:00:00
Creating Tables Manually 00:00:00
Understanding the 7 Basic Data Type Categories 00:00:00
Using the Table we Created 00:00:00
Creating Tables Using T-SQL 00:00:00
Working with Tables
Adding Constraints 00:00:00
Understanding Indexes 00:00:00
Altering the Table Design 00:00:00
SELECT Statements
The Basic SELECT Statement 00:00:00
The FROM Clause 00:00:00
The WHERE Clause 00:00:00
The ORDER Clause 00:00:00
Multi-Table Queries
MS-SQL Query Method 00:00:00
Using a WHERE Clause to Link Tables 00:00:00
Ansi-SQL Method 00:00:00
Joining Tables: Inner Join 00:00:00
Query Designer 00:00:00
Ambiguous Column Name 00:00:00
Table Aliases 00:00:00
Joining Tables: Left Outer Join 00:00:00
Joining Tables: Right Outer Join 00:00:00
A Tip for Building a New Query 00:00:00
Views and Stored Procedures
Overview 00:00:00
Creating a View 00:00:00
Creating a View Using T-SQL 00:00:00
Creating Simple Stored Procedures 00:00:00
Using Arguments 00:00:00
Executing Stored Procedures 00:00:00
Conclusion
Course Recap 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • $99.00 $10.00
  • UNLIMITED ACCESS
  • Course Certificate
STUDENTS ENROLLED

    Related Courses

    © Learnsector