SQL Fundamentals ( SQL Server )

Course Objective :

A “SQL Server Fundamentals of SQL” course provides an introductory-level overview of SQL (Structured Query Language) with a focus on using SQL within the context of Microsoft SQL Server.

You will learn:

• Complete literal SELECT statements.
• Complete basic SELECT statements querying against a single table
• Filter data using the WHERE clause
• Sort data using the ORDER BY clause
• Learn about database design and normalization
• Using joins, return columns from multiple tables in the same query
• Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
• Complete SQL statements that use aggregate functions
• Group data together using the GROUP BY clause
• Filter groups of data using the HAVING clause

Target Audience :

Pre – Requisites :

It assumes little to no prior knowledge of databases or SQL, making it accessible to beginners. However, it can also serve as a refresher for those with some prior exposure to SQL Server. The course’s content and pace should be tailored to the specific needs and background of the target audience.

Course Outline :

Introduction to SQL Server

• Overview of Microsoft SQL Server and its editions.
• Understanding relational databases and the role of SQL in managing data.

Getting Started with SQL Server Management Studio (SSMS)

• Introduction to the SQL Server Management Studio (SSMS) interface.
• Connecting to SQL Server instances.
• Writing and executing basic SQL queries.

Basic SQL Queries

• Writing simple SELECT statements to retrieve data from tables.
• Sorting and filtering data using the WHERE and ORDER BY clauses.
• Using the DISTINCT keyword to retrieve unique values.
• Handling NULL values.

Data Modification

• Inserting new data into tables using the INSERT statement.
• Updating and deleting records with the UPDATE and DELETE statements.
• Understanding transactions and their importance in data integrity.

Working with Tables

• Creating tables with appropriate data types and constraints.
• Modifying table structures with the ALTER TABLE statement.
• Deleting tables using the DROP TABLE statement.

Joining Tables

• Understanding the concept of joins.
• Performing inner joins, left joins, right joins, and full outer joins.
• Using aliases to simplify queries.

Aggregating Data

• Grouping data with the GROUP BY clause.
• Applying aggregate functions (e.g., SUM, AVG, COUNT) to grouped data.
• Filtering grouped data using the HAVING clause.

Subqueries and Derived Tables

• Working with subqueries in SELECT, WHERE, and FROM clauses.
• Using correlated subqueries.
• Introduction to common table expressions (CTEs).

Views and Indexes

• Creating and managing views for data abstraction.
• Understanding indexes and their impact on query performance.

Introduction to Stored Procedures and Functions

• Overview of stored procedures and user-defined functions.
• Creating and executing basic stored procedures.
• Writing simple scalar functions.

Security and Permissions

• Managing security through logins and users.
• Assigning permissions and roles.
• Implementing basic security best practices.