Home > Course Catalog > Databases > SQL Server 2008

SQL Server 2008 for Developers Training

This outline is also available in these languages: ??languagelist??

Course #:



Classroom, Online


3 days


1,755.00 USD

Professional Development Units:

Continuing Development Units:

Course Tier: ??Tier??

Per Student Kit Price: ??KitPricePerStudent??



We will shape this course to maximize value in your organization by meeting your implementations standards. Inquire for a complementary preliminary needs analysis by clicking the Contact Us button below.

Delivery Options:

Public Scheduled Classes - Register for classes below Search Catalog Sign Up to be notified
Self-Paced Training - Purchase below Search Catalog
Public Scheduled Webinar - Register below Sign Up to be notified
Webinar Recording - View Now

Custom Group Training - Request a proposal

See all
Purchase ??country-to-buy-from?? course Add to Cart Purchase
here's the message from the cart

To view the cart, you can click "View Cart" on the right side of the heading on each page
Client specified

Classes marked with a are Guaranteed to Run on the scheduled dates. Classes marked with a will be Guaranteed to Run with one more paid registration.

There are ??othercoursecount?? similar courses in different countries and/or formats.Click here to see them.

This course is available in these other formats: ??otherformatlist??

Need a customized class for your group? Contact Us.

No classes scheduled? Sign Up to be notified when new classes are added.

*Public Price per Student

This SQL course is an introduction to Microsoft’s SQL Server implementation of the SQL language and SQL Server Management Studio. You will learn how to query and update a SQL Server database, create simple database objects such as tables and views and to work proficiently with Management Studio.

Upon completion of this SQL course, students will be able to:
  • Query and manipulate data using Structured Query Language
  • Utilize common SQL Server functions
  • Use Aggregate functions count, max, min, sum and avg
  • Use Group By and Having to summarize information
  • Code sophisticated SQL using Joins and Sub Queries
  • Update data with insert, update and delete
  • Utilize Management Studio to query, update and create database objects

  • Developers

  • Familiarity with Computers

  1. Introduction
  2. Using SQL Server Management Studio
    • Starting
    • Running Query
    • Adding line numbers
    • Changing how results display
    • Using Object Explorer
    • Modify table
    • Script table
  3. Introduction to SQL
    • Select
    • Order by
    • Basic Where
    • In comparison
  4. Selection
    • Like
    • RegEx like
    • Calculations
    • Alias
    • Convert for date
    • Year, Month, Day functions
    • Between
    • Embedded Apostrophes
    • Null operation
  5. Dates
    • Getdate()
    • DateAdd
    • DateDiff
  6. More selection
    • Substring
    • Like escaped
    • Concatenation
    • Selecting constant
    • Search on Null
    • Top x
  7. Inner Join
    • Multiple tables on from
    • Table Join
    • Labels/alias for tables
    • Join Keyword
  8. Aggregate Functions
    • Count, Sum, Max, Min, Avg
    • Proper use of aggregate functions
    • Impact of where
  9. Group By
    • Using Group By
    • Having
    • Multiple Group By columns
    • Rollup
  10. Union
    • Definition
    • Order By
    • Union All
    • Intersect
    • Minus
  11. Subqueries
    • Simple
    • Using In comparison
    • Correlated/Complex Sub Query
    • Exists
    • Derived tables
    • Common Table Expressions
    • Cross Apply
    • Inner Apply
    • Function using Apply
  12. Miscellaneous Topics
    • IsNull
    • Coalesce
    • Case
    • Handling Case Sensitivity
    • Soundex
    • Collate
    • Rtrim/Ltrim
    • Left Join
    • Full Join
    • Pivot
    • Rank
    • Dense_Rank
    • Ntile
    • Row_number
  13. Create table and data modification
    • Create Table
    • Data types
    • Varchar(max)
    • Default
    • Insert
    • Drop
    • Merge
    • Truncate
    • Select Into
    • Insert Select
    • Temp Tables
    • Computed columns
    • Identity
    • Unique Identifier


This course is included in the following Roadmaps:

You may also be
interested in:

6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 200003594-NH

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to ...--> 6231 Maintaining a Microsoft SQL Server 2008 R2 Database 200003590-NH

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The ...-->

Become a LQ Partner

Guaranteed to Run

Enroll with confidence and no cancellations: view all GTR courses here

Transform Your Business and Invest Effectively in Your IT

LearnQuest Enterprise Architecture Course Series

Make the Extraordinary Possible

IBM STG Classes

Do you have an IBM EdPack?

Find out why you should transfer to a LearnPass

Check Out the LearnQuest Blog

Read More.

LearnQuest is an Authorized IBM Global Training Provider

Learn more about IBM training with LearnQuest


LearnQuest attends and exhibits regularly at industry events.

See what some of our clients have said about us

View client testimonials
View a list of LearnQuest clients.