Microsoft SQL Server Series: Intro to Querying MS SQL Server
- Description
- Curriculum
- FAQ
- Reviews
The purpose of this course is to give students a broad understanding of SQL Server. The course does not study features in detail, but is very useful in providing a broad knowledge that students might otherwise not encounter. For example, they probably only use one, or perhaps two, different editions of SQL Server in their jobs, but an understanding of functionality is useful when planning a new deployment.
Transact-SQL, or T-SQL, is the language in which you will write queries for Microsoft SQL Server. In this course, you will learn that T-SQL has many elements in common with other computer languages, such as commands, variables, functions, and operators. You will also learn that T-SQL contains some unique elements that may require adjustment if your background includes experience with procedural languages. To make the most of your effort in writing T-SQL queries, you will also learn the process by which SQL Server evaluates your queries. Understanding the logical order of operations of SELECT statements will be vital to learning how to write effective queries.
Objectives
After completing this module, you will be able to:
· Describe the architecture of SQL Server.
· Describe the editions of SQL Server.
· Work with SQL Server Management Studio.
· The elements of T-SQL and their role in writing queries.
· The use of sets in SQL Server.
· The use of predicate logic in SQL Server.
· The logical order of operations in SELECT statements.
-
1
Relational Databases -
2
About the Course Sample Database. Client Server Databases. Queries
-
3
SQL Server Versions
-
4
Starting SSMS. Connecting to SQL Server. Working with Object Explorer
-
5
Working with Script Files and Projects
-
6
Executing Queries
-
7
Demonstration: Introducing Microsoft SQL Server
-
8
Lab Tasks: Working with SQL Server Tools
1. Start SSMS, but do not connect to an instance of SQL Server.
2. Close the Object Explorer and Solution Explorer windows.
3. Using the View menu, show the Object Explorer and Solution Explorer windows in SSMS.
Task 2: Configure the Editor Settings
1. On the Tools menu, choose Options to open the Options window in SSMS and change the
font size to 14 for the text editor.
2. Change several additional settings in the Options window:
o Disable IntelliSense.
o Change the tab size to 6 spaces for T-SQL.
o Enable the option to include column headers when copying the result from the grid.
Look under Query Results, SQL Server, Results to Grid for the check box Include column headers
when copying or saving the results.
The main tasks for exercise 2 are as follows:
1. Create a Project
2. Add an Additional Query File
3. Reopen the Created Project
Task 1: Create a Project
1. Create a new project called MyFirstProject and store it in the folder D:LabfilesLab01Starter.
2. Add a new query file to the created project and name it MyFirstQueryFile.sql.
3. Save the project and the query file by clicking the Save All option.
Task 2: Add an Additional Query File
1. Add an additional query file called MySecondQueryFile.sql to the created project and save it.
2. Open Windows Explorer, navigate to the project folder, and observe the created files in the
file system.
3. Back in SSMS, using Solution Explorer, remove the query file MySecondQueryFile.sql from the
created project. (Choose the Remove option, not Delete.)
4. Again, look in the file system. Is the file MySecondQueryFile.sql still there?
5. Back in SSMS, remove the file MyFirstQueryFile.sql and choose the Delete option. Observe the
files in Windows Explorer. What is different this time?
Task 3: Reopen the Created Project
1. Save the project, close SSMS, reopen SSMS, and open the project MyFirstProject.
2. Drag the query file MySecondQueryFile.sql from Windows Explorer to the Queries folder
under the project MyFirstProject in Solution Explorer. (Note: If the Solution Explorer window is not
visible, enable it as you did in exercise 1).
3. Save the project.
-
9
Lab Answers: Working with SQL Server Tools
-
10
Introducing T-SQL
-
11
Predicates and Operators
-
12
Functions and Variables
-
13
Expressions and Control of Flow
-
14
Comments and Batch Separators
-
15
Demo: Use T-SQL
-
16
Set Theory and SQL Server
-
17
Predicate Logic and SQL Server
-
18
Logics of SELECT Statements
-
19
Logical Query Processing
-
20
Demo: Logical Query Processing
-
21
Hands-On Lab: Introduction to T-SQL Querying
