This session is for users who are new to writing T-SQL.
Are you new to SQL Server and not sure where to begin with T-SQL? Does it feel like a foreign language? The objective of this session is to go over simple T-SQL Statements and to show you how to build on them. We will focus on simple select statements and translating English into T-SQL. Once you have the Rosetta stone, you will find that T-SQL becomes like second nature. We will also focus on adding a simple where clause, order by and join. We will also create a simple backup script and learn about the built in intellisense in SQL Server Management Studio.
Why I Want to Present This Session:
I have a lot of people ask me where to start with T-SQL. Because SQL Server Management Studio allows you to do most things through the UI, writing T-SQL is becoming a lost art. Developing a basic understanding can greatly improve how your daily processes run.