FREE CLASS: Database Geek Speak
4:28
SSRS Explained in Under 5 Minutes
4:20
FREE CLASS: Installing Your SQL Labs
4:47
FREE CLASS: Joining Tables
9:07
9 жыл бұрын
Query Execution Plans
6:56
9 жыл бұрын
Quick Performance Tuning
7:11
9 жыл бұрын
Benefits of Common Table Expressions
5:56
Quick Basic Sub Queries
2:49
9 жыл бұрын
Hacker proof SQL Injection Tips
6:19
Dynamic SQL 1 in 5 Minutes
4:27
9 жыл бұрын
Correlated Sub Queries Quickly
4:09
9 жыл бұрын
Quick SQL MGMT Studio Tips
5:41
9 жыл бұрын
Welcome to Joes 2 Pros Academy!
3:33
11 жыл бұрын
Joes 2 Pros Academy is Here!
2:49
11 жыл бұрын
Beginning SSRS Joes 2 Pros Meet SSSRS
11:53
Beginning SSRS Why SSRS?
5:39
11 жыл бұрын
SQL 2012 AlwaysOn Log Shipping
5:25
11 жыл бұрын
SQL 2012 AlwaysON Failover Clustering
7:05
Lab10 1 CommonTableExpression
10:04
11 жыл бұрын
Пікірлер
@devarakondasankararao3802
@devarakondasankararao3802 Ай бұрын
Nice video sir
@devarakondasankararao3802
@devarakondasankararao3802 Ай бұрын
Nice explanation Sir
@fernandohood1886
@fernandohood1886 Ай бұрын
Brilliant.
@ChrisBridge-m6f
@ChrisBridge-m6f 6 ай бұрын
Extremely helpful. Thank you
@rtecunit602
@rtecunit602 7 ай бұрын
Your website isn't active. I purchased your CTE book and went to the joes2pros website to download the script, and i get a 404 error message. Can this be fixed, or can you provide the script for the CTE book?
@ahsanraco
@ahsanraco 8 ай бұрын
Thanks ❤❤❤
@mymoodz
@mymoodz 10 ай бұрын
I joined the Joes2Pros academy about month ago. and started training. but for the last one week, the site has been down. despite several emails, they have not restored it. No one picks up their help line. leaving a message here to see if anyone makes any effort to restore the website.
@ky.castillo
@ky.castillo 11 ай бұрын
huh
@umalmudi5284
@umalmudi5284 11 ай бұрын
First of all thnxxx so much for ur videos all r informative plzzzzz my request is when we fill second girl child in pmmvy form we write benefit for 2nd girl child and in living child column when we click for 2 it shows child is not born yet how to proceed
@TheBitles
@TheBitles Жыл бұрын
Claro, simple y al grando. Los TQM.
@noorhirjee2274
@noorhirjee2274 Жыл бұрын
Excellent
@NANA-lw3rs
@NANA-lw3rs Жыл бұрын
I know I am late; however, I'll try my luck. Do you have anything on aliases?
@monicabn3067
@monicabn3067 Жыл бұрын
Thank you ❤
@msashoyeb
@msashoyeb Жыл бұрын
💕💕
@dikgalemoja9763
@dikgalemoja9763 Жыл бұрын
I love you man! Thanks for the simple tutorial.
@monicabright2903
@monicabright2903 Жыл бұрын
Thank you, finally I understand how this GROUP BY and aggregate function thing works 😂... It's been quite confusing.
@vrajeshbadgujar
@vrajeshbadgujar Жыл бұрын
Thanks
@natesanbhararhi
@natesanbhararhi Жыл бұрын
Thank u
@shaikazas7855
@shaikazas7855 Жыл бұрын
tq so much it helped a lot even after 10 years
@liquidcode1704
@liquidcode1704 Жыл бұрын
DO's: implement this on your own local machine for your own research DONT's: use dynamic sql in an api
@xiyang9726
@xiyang9726 Жыл бұрын
Thank you so much, although it has been 11 years, some profs still don't know how to teach this
@elizabetht1382
@elizabetht1382 Жыл бұрын
Thank you for helping me 12 years later! This came out when I was a child, can't believe it's still relevant. That's awesome!
@devdootcompany5879
@devdootcompany5879 Жыл бұрын
Please help me to find solution that when I try code in mysql database it working best but I don't know how to use it in PHP to fetch in android app. SELECT cus_mobile, cus_name, SUM(sel_cost) FROM bus_selling_receive GROUP BY cus_mobile ORDER BY sel_cost DESC this code I want to use in php. How to use. when I try it not working. addtion showing 0.0. anyone help me to take value of sel_cost with GROUP BY -
@dougrobnyc
@dougrobnyc Жыл бұрын
You are a gifted teacher!
@akshaygiri2900
@akshaygiri2900 Жыл бұрын
Sir I want automatically execute query after 30 day please suggest any idea
@kidistgetachew7565
@kidistgetachew7565 2 жыл бұрын
Thank you
@esthermalik3615
@esthermalik3615 2 жыл бұрын
Pls I need your help on Query in SQL how can I reach you personally
@animeboy93
@animeboy93 2 жыл бұрын
Well that helped me
@Jeyakesan
@Jeyakesan 2 жыл бұрын
how to fetch if this is the case? <Item ProductCode="2" Quantity="1" UnitPrice="2.99"> Water Bottle </Item> I want output as 2 , 1 , 2.99 , Water Bottle in a row with "Water Bottle" under the column name "Descritpion" Also how to fetch if there multiple rows as such?
@omega454545
@omega454545 2 жыл бұрын
That simple drop down around the 2 min mark resolved 2 hours of confusion on my part. Thank you so much. I had been looking at all the training I did on W3. Thinking back to what I learned through others at work, Udemy, etc as I was doing this hands on for the first time wondering why it kept saying it couldn't do it. I had a feeling it was something really simple, and it was. You have my eternal thanks and gratitude.
@bprasad1950
@bprasad1950 2 жыл бұрын
Tq so much
@benbascheable
@benbascheable 2 жыл бұрын
I still don’t get it lmao
@benbascheable
@benbascheable 2 жыл бұрын
I still don’t get it lmao
@dawnhuttoe7204
@dawnhuttoe7204 2 жыл бұрын
So helpful. Thank you so much
@gotchihaeyo1825
@gotchihaeyo1825 2 жыл бұрын
I guess I understand how it works but why not explaining why we need it??
@mamneo2
@mamneo2 2 жыл бұрын
Incroyable.
@shabebelu1739
@shabebelu1739 Жыл бұрын
I can think with a use for it in reports. Using dynamic SQL to have a a flexible report that shows columns only when they have values in them.
@vickytatto2072
@vickytatto2072 2 жыл бұрын
Thank you so much!!!
@darshankokal4670
@darshankokal4670 2 жыл бұрын
Simple and to the point.
@rickydiaz4471
@rickydiaz4471 2 жыл бұрын
Easy to follow and understand, thanks.
@nicolasjimenezq369
@nicolasjimenezq369 2 жыл бұрын
Great explanation!
@MrAlgorhythm
@MrAlgorhythm 2 жыл бұрын
"Know your grain." Clearly explained, with a succinct phrase that helps the viewer think. Thank you.
@tensor2539
@tensor2539 2 жыл бұрын
thanks so much, great vid!
@adarshsunil7562
@adarshsunil7562 2 жыл бұрын
Where is replication concept video. It's not in the playlist
@mathejoh
@mathejoh 2 жыл бұрын
This video....is Gold! Helped me big time with an assignment!
@rizwansiraj7841
@rizwansiraj7841 2 жыл бұрын
Very much informative video on a short time.
@TATVCanada
@TATVCanada 2 жыл бұрын
About a thousand times better than any of the training sessions I've attended.
@wangtony5920
@wangtony5920 2 жыл бұрын
training tutorial they ask money from you so they will never tell u how to use it directly
@Ali3hamodi
@Ali3hamodi 2 жыл бұрын
So we basically having outer for loop iterating over LocationId from Location Table and the subquery will use that value coming from the outer loop to count the values.
@shaykhanas1428
@shaykhanas1428 2 жыл бұрын
Skill check jo karwaya hai tw bade bhai answer tou mention karo na end mein.
@CaribouDataScience
@CaribouDataScience 2 жыл бұрын
What playlist is this part of?
@hassanOnYoutube
@hassanOnYoutube 2 жыл бұрын
Love from Pakistan
@everythingcando132
@everythingcando132 2 жыл бұрын
To the point. No bakwas. 👍