SQL Training – Functions (70-461)

In this presentation we will be training on TSQL Functions, there will be three sections.

• —Date and Time Functions
• —Logical Functions
• —User Defined Functions

Here is the link to the Google On Air Broadcast where you can watch live (or recorded later) for free.

https://plus.google.com/events/cb0pj9ghp5elt6i241kstphcvr0

Here are the slides.

And here is the broadcast at YouTube:

This session will be about 90 minutes, I will be presenting Date and Time Functions, along with the Logical Functions, and Aaron will be presenting User Defined Functions.

The Date and Time functions section will include GETDATE(), DATEPART(), DATEADD(), DATEDIFF(), EOMONTH (2012), along with a variety of DATE/TIME FROMPARTS Functions. Following that will be the logical functions which includes CASE, IIF, CHOOSE, and COALESCE. ISNULL is usually covered in this section, but we already covered that in an earlier session.

The slides and sample code are available for download here: Functions.zip.

See Also:

• Last Weeks Training: Using Cursors, along with String Functions
• Free SQL Query Training
• Rounding or Truncating Date Time Calculations in TSQL

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!