Stored Procedure

Here is an example of a stored procedure in PostgreSQL to add a new row to the movies table:

CREATE FUNCTION add_movie(_title TEXT, _year_released INT, _genre TEXT)
RETURNS void AS
$$
BEGIN
INSERT INTO movies(title, year_released, genre)
VALUES(_title, _year_released, _genre);
END;
$$
LANGUAGE 'plpgsql';

To call the function:

SELECT add_movie('Moonlight', 2016, 'Drama');

To see a list of your functions:

\df

To delete a function:

DROP FUNCTION add_movie(_title TEXT, _year_released INT, _genre TEXT);

Has treehouse built a course on writing Stored Procedures yet?

Is there a course on writing Stored Procedures yet ???

While this is not a Treehouse Course, I took this PluralSight course on Stored Procedures and it is very good. I've found it to be fun, but also educational. I have a coworker who is very knowledgeable about stored procedures and this course is covering even the "gotchas" that he mentioned. Start here if you want to learn them, at least until Treehouse adds some courses: https://www.pluralsight.com/courses/sql-server-database-programming-stored-procedures

mahfoudhebkar2 , Krish Penumarty see above.