SQL Server Programming and Stored Procedures Fundamentals

Learn SQL Server Programming by doing!

This course will assist you in achieving the objective of creating useful and powerful stored procedures. This is a step-by-step course. We will build on what we had learned in every new session. This course teaches you SQL Programming and Stored Procedure from scratch. No prior programming experience is required.

Why should you learn SQL even if you are not a Developer?

These days, almost everyone has to work with data in some form or another. Usually, it's through spreadsheets or databases, but if you can learn a little SQL you can become so much more powerful in your job.

Who is teaching you?

My name is Enrique Valencia. I’m a database professional based in Singapore. I’ve been a SQL Server DBA for 7 years. Now, I’m working on various open-source databases such as MySQL, MariaDB, PostgreSQL, Redis, Elasticsearch, and MongoDB. My focus is on SQL performance optimization, high availability, and automation.

I hope that you’ll enjoy this course as much as I did creating it!

Below is the list of topics that will be covered in this course.

• Stored Procedure Fundamentals - A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.

  
  

• Using Parameters in Stored Procedures - used to exchange data between stored procedures and functions and the application or tool that is called the stored procedure or function.

• Variables - an object that can hold a single data value of a specific type.

• Output Parameters & Return Values - two ways of returning result sets or data from a Stored Procedure to a calling program.

  
  

• IF Statements - Imposes conditions on the execution of a Transact-SQL statement.

  
  

• WHILE Loops - used to repeatedly execute a certain piece of SQL script.

  
  

• User Defined Functions - routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value.

  
  

• Temporary Tables - database table that exists temporarily on the database server.

  
  

• Table Variables - a special type of the local variable that helps to store data temporarily, similar to the temp table in SQL Server.

  
  

• Table Valued Functions - user-defined function that returns a table data type and also it can accept parameters.

  
  

• Common Table Expressions (CTEs) – a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.

  
  

• Dynamic SQL Scripts - a programming technique that enables you to build SQL statements dynamically at runtime.

  
  

• Transactions - a sequential group of statements or queries to perform single or multiple tasks in a database.

  
  

• DML Triggers - a special type of stored procedure that automatically takes effect when a data manipulation language (DML) event takes place that affects the table or view defined in the trigger.

  
  

• DDL Triggers - fire in response to a variety of Data Definition Language (DDL) events.