Gain insights into SQL and database fundamentals. Delve into data manipulation, administration, and normalization with practical tasks using SQL functions for backup, recovery, and user management.

Learn SQL - A Practical Guide for SQL Server and Database Fundamentals.png

sqldockerfile.tar.gz

sql_spa-copy

SQL is a must-know language for all types of roles, including development and data science. This course includes hands-on experience with the fundamentals of the SQL Server database including database administration.

The course covers the fundamentals of relational databases and database normalization. It offers a practical learning experience of retrieval, definition, manipulation, presentation and transformation of data through SQL functions. You will also learn database administration for backup, recovery and restore followed by managing the users, roles and privileges.

This course will teach you how to perform tasks related to SQL Server databases with hands-on experience. It covers the complete range of day-to-day operations.

A Practical Guide to SQL  and Database Fundamentals

# Stored procedures
**Stored procedures** are precompiled SQL syntax that can be used repeatedly by executing its name in SQL Server. If there’s a query we frequently run, we write it from scratch, save the file somewhere, and then open it to run it; then, consider creating a stored procedure out of that query.

We can do the same with a stored procedure like SQL syntax that we’ll write from scratch and pass in a value for our `WHERE` clause. We can pass in specific values to achieve the result that we’re looking for so that we don’t always have to pass a parameter into a stored procedure.

For example, let’s say that as part of the HR department, we must run a query once a month to verify which employees are salaried and non-salaried, in compliance with labor laws and company policy.

Instead of opening a file frequently or writing the code from scratch, we can call the stored procedure we saved in the database to retrieve the information. We would specify the proper value (where `1` is `TRUE` and `0` is `FALSE` in this case). 





Learn about the database components like stored procedures and triggers.


Stored Procedures and Triggers

Learn about the database components like stored procedures and triggers.

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Stored Procedures and Triggers

Stored procedures