SQL Fundamentals ( SQL Server )

Duration: 1 days

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 :

This course is designed to cater to a broad range of participants who want to establish a strong foundation in SQL within the SQL Server ecosystem.

  • Beginners with No Database Experience
  • Database Beginners with SQL Server Exposure
  • Database Administrators (DBAs)
  • Data Analysts
  • Developers
  • IT Professionals and System Administrators
  • Business Professionals
  • Students and Enthusiasts
  • Career Changers
  • Small Business Owners

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.