Microsoft SQL Server

Course Outline:

Important topics that will be covered:

SQL Overview:

• Outlining SQL as the Cornerstone of database activity
• Introduction to RDBMS
• Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Building The Database Schema:

• Creating tables and columns
• Building tables with CREATE TABLE
• Modifying table structure with ALTER TABLE
• Adding columns to an existing table
• Removing tables with DROP TABLE

Executing a Simple Query:

• Connect to the SQL Database using SQL Server Management Studio
• Query a Database using the SELECT Statement
• Save a Query Script to a File
• Modify and Execute a Saved Query

Protecting Data Integrity With Constraints:

• How to create Primary Key and Foreign Key
• Enabling and disabling constraints Removing constraints with ALTER TABLE
• Improving performance with indexes

Manipulating Data:

• Modifying table contents
• Adding table rows with INSERT
• Changing row content with an UPDATE
• Removing rows with DELETE

Performing a Conditional Search:

• Use the WHERE Clause to Search and Filter Data using One or More Conditions
• Use the WHERE Clause to Search for a Range of Values with BETWEEN and IN Clauses

How to Handle NULL Values in Data:

• Search Text Data Based on Patterns using the LIKE Operator

Working with Functions:

• Format and Manipulate Dates using Date Functions
• Summarize Data using Aggregate Functions Like COUNT, SUM, AVG, MIN, MAX
• Use Functions to Manipulate String Values

Organizing Data:

• Sort Data using the ORDER BY Clause
• Group Data with the GROUP BY Clause
• Filter Grouped Data using the HAVING Clause

 
Retrieving Data from Multiple Tables:

• Query Data from Multiple Tables using the JOIN Clause
• Combine the Results of Two Queries with the UNION Statement
• Compare the Results of Two Queries with the INTERSECT and EXCEPT Statements

Developing In-Line And Stored Views:

• Stored Procedures
• Selecting data from a query result set
• Subqueries in the FROM clause
• Creating views in a database