Timestamps: 00:00:00 - Intro to Stored Routines 00:03:33 - Intro to Variables 00:09:19 - Variables 00:12:55 - Creating Variables within SELECT 00:17:42 - SQL Fiddle - CREATE DATABASE 00:25:20 - How to Create Variables with SELECT and SET 00:31:01 - Intro to Stored Procedures 00:37:25 - Procedure Syntax 00:41:48 - Database API (Application Programming Interface) 00:50:00 - CREATE PROCEDURE
@ardit99883 жыл бұрын
COOL!!!
@captainboon29784 жыл бұрын
You're a phenomenal teacher. You explained everything very well. In my opinion, I think what sets you above most other people is that you connect with your audience very well by seeming less corporate and more personal. Nice work.
@lindaburnside38322 жыл бұрын
You are an awesome teacher. I have some sql experience but was light on stored procedures. This is really helping.
@lindaburnside38322 жыл бұрын
I have a son named Caleb who is about your age. You're so young, but very knowledgeable.
@njoguman8754 жыл бұрын
Greetings from Nairobi Kenya,, the video helped a lot
@globalgrowth343 Жыл бұрын
Thank you so much
@akashthoriya4 жыл бұрын
Make the same video for Trigger too.
@oleskool49084 жыл бұрын
You have great content. I wish I was smart. I am so scared to learn SQL I think I am slow to learn. It seems so hard
@mikah40514 жыл бұрын
K Saint, I used to think the same thing about myself. Learn SQL in manageable chunks, like this video. Stick with it and remained focused and it slowly come together. SQL is an extremely high paying job and in big demand.
@petterah794 жыл бұрын
Hi Caleb, shouldn't variables in procedures be declared with datatype before set? Like DECLARE @variable1 DECIMAL(16,0); SET @varialbe1 = 10; ?