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.