Introduces the learners to SQL Server 2008 and the SQL Server Management Studio.
This course introduces the user to SQL Server 2008 and the SQL Server Management Studio. It covers the basics from creating databases and tables to learning how to query multiple tables. Once those basics are covered, the final exercise is understanding and creating Views and simple Stored Procedures. This course is designed to get the user up and running with SQL Server as quickly as possible.
- Create databases and tables
- Learn how to query multiple tables
Basic Microsoft Windows training or equivalent experience. Prior database knowledge is useful, but not required.
Who is this course intended for?
This course is designed to get the user up and running with SQL Server as quickly as possible.
|Getting Started with SQL Server|
|Overview: What is SQL Server?||00:00:00|
|Connecting to the Server||00:00:00|
|Working in the Management Studio||00:00:00|
|Understanding Windows, Community, and Help Tabs||00:00:00|
|Using Object Explorer||00:00:00|
|Opening a Table||00:00:00|
|Creating a Database and Tables|
|Creating Databases with the Database Wizard||00:00:00|
|Creating Tables Manually||00:00:00|
|Understanding the 7 Basic Data Type Categories||00:00:00|
|Using the Table we Created||00:00:00|
|Creating Tables Using T-SQL||00:00:00|
|Working with Tables|
|Altering the Table Design||00:00:00|
|The Basic SELECT Statement||00:00:00|
|The FROM Clause||00:00:00|
|The WHERE Clause||00:00:00|
|The ORDER Clause||00:00:00|
|MS-SQL Query Method||00:00:00|
|Using a WHERE Clause to Link Tables||00:00:00|
|Joining Tables: Inner Join||00:00:00|
|Ambiguous Column Name||00:00:00|
|Joining Tables: Left Outer Join||00:00:00|
|Joining Tables: Right Outer Join||00:00:00|
|A Tip for Building a New Query||00:00:00|
|Views and Stored Procedures|
|Creating a View||00:00:00|
|Creating a View Using T-SQL||00:00:00|
|Creating Simple Stored Procedures||00:00:00|
|Executing Stored Procedures||00:00:00|
No Reviews found for this course.