1Page 1 of 1Record 1 to 7 of 7

Latest Entries

Favourite
VOTE 0

SQL Tutorial Lesson 21: Formatting Text and Numbers

Tutorial » By SQL Tutor On Jul 22, 2012 11:34:36 PM ,

In this lesson, you will learn how to format the text and numbers.

Categories : SQL | Tags : t-sql, Format, SQL Basic
Favourite
VOTE 0

SQL Tutorial Lesson 20: Converting and Concatenating Values

Tutorial » By SQL Tutor On Jul 12, 2012 7:56:13 PM ,

In our last lesson, we developed a stored procedure that does some pretty cool things. It combines a lot of concepts we've learned thus far and even gives the user some feedback about what's happening. However, there are still some things we could do to make it work a little better.

Categories : SQL | Tags : t-sql, SQL Basic
Favourite
VOTE 0

SQL Tutorial Lesson 19: Linear Programming: IF - ELSE

Tutorial » By SQL Tutor On Jul 12, 2012 12:36:49 AM ,

As you've realized by now, SQL is very different than most programming languages. Most programming languages deal with sets of linear instructions that kick off when something happens. For example, a user clicks a button that says print, a series of commands kick off to print the document. It might also check to see if the printer is on or available before proceeding.

Categories : SQL | Tags : t-sql, SQL Basic
Favourite
VOTE 0

SQL Tutorial Lesson 18: Stored Procedures

Tutorial » By SQL Tutor On Jul 04, 2012 2:15:27 AM ,

If you know a little bit about SQL server, you might have been wandering why we have not spoke about stored procedures until now. Stored procedures are a powerful way to create reusable packages of SQL code that live in your database. We didn’t get into it earlier because stored procedures are basically just a wrapper for everything we’ve learned so far.

Categories : SQL | Tags : t-sql, stored procedure, SQL Basic
Favourite
VOTE 0

SQL Tutorial Lesson 17: The Non-Clustered Index

Tutorial » By SQL Tutor On Jun 29, 2012 1:46:55 AM ,

Non-clustered indexes are a very important component in SQL server. We’ve discussed them briefly in a previous chapter. They basically act like an index in the back of a book. They give you a quick shortcut to find data that’s organized in an alternative way. Today, we’ll learn how they work and how SQL utilizes them. This will help us understand where to put them when designing a database.

Categories : SQL | Tags : t-sql, SQL Basic, Non-Clustered Index
Favourite
VOTE 0

SQL Tutorial Lesson 15: Under the Hood of SQL Server

Tutorial » By SQL Tutor On May 19, 2012 2:53:33 AM ,

This lesson will focus on a basic understanding of how the SQL server engine works.

Categories : SQL | Tags : SQL Basic
Favourite
VOTE 0

SQL Tutorial Lesson 13: All About Temp Tables

Tutorial » By SQL Tutor On May 17, 2012 7:11:53 AM ,

In this lesson, you will learn about temp tables.

Categories : SQL | Tags : SQL Basic
1Page 1 of 1Record 1 to 7 of 7