Home > Course Catalog > Databases > SQL Server 2008

SQL Server 2008 for Developers Training

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

Course #:

DBSQ-321

Format:

Classroom, Online

Duration:

3 days

Price*:

1,695.00 USD

Professional Development Units:

Continuing Development Units:

Course Tier: ??Tier??

Per Student Kit Price: ??KitPricePerStudent??

ibm

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
Format
  PDF
Self-Paced
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
Close


 
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

??Testimonials??


This course is included in the following Roadmaps: