How does SQL see a SELECT statement? Which part gets evaluated first? Why should I care? Find out here, find out fast!
1 - From
2 - Where
3 - Group by
4 - Having
5 - Select
6 - Order by
Duration : 0:2:5
This is the fourth part in our series on SQL. In this guide we cover the SQL Insert statement.
Duration : 0:2:49
http://www.learningsqlserver2008.com/
If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background and the database we will use AdventureWorks2008. We start off with the SELECT statement which is used to return data. The basic syntax is discuss with an e.g. from Person and SalesOrderHeader table. We move onto the INSERT statement using the Person table in the database. The next two statements are UPDATE and DELETE which are very powerful. Using a where clause is extremely important here. We show you how to change data in Person table. (Running time is 32 mins)
Duration : 0:9:17