- Видео 134
- Просмотров 292 102
SQL University
Добавлен 8 фев 2013
Teach yourself SQL at your own pace.
1. Learn the basics: SELECT, INSERT, UPDATE, and DELETE
2. Learn Stored Procedures
3. Learn Analytical functions / Window Functions
This channel will often cover specialty items that are not available elsewhere or are not very easily located elsewhere.
1. Learn the basics: SELECT, INSERT, UPDATE, and DELETE
2. Learn Stored Procedures
3. Learn Analytical functions / Window Functions
This channel will often cover specialty items that are not available elsewhere or are not very easily located elsewhere.
Real-World example of using SQL Server to assist in making a puzzle book!!
This video is the beginning portion of a much larger video where I will cover how I used sql code to generate data for a puzzle book. In this particular video, I cover IF EXISTS, DROP TABLE, SELECT INTO, INSERT INTO, SYSOBJECTS, XTYPE, and certain errors that you will need to look out for.
Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
--******************************************************************************************************************************************************
-- This is the sql code that allowed me to come up with my 720 combination of 1 to 6.
--******************************************************...
Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
--******************************************************************************************************************************************************
-- This is the sql code that allowed me to come up with my 720 combination of 1 to 6.
--******************************************************...
Просмотров: 174
Видео
IF EXISTS, DROP TABLE, SELECT INTO, INSERT INTO, SYSOBJECTS, XTYPE
Просмотров 4813 месяца назад
This video is the beginning portion of a much larger video where I will cover how I used sql code to generate data for a puzzle book. In this particular video, I cover IF EXISTS, DROP TABLE, SELECT INTO, INSERT INTO, SYSOBJECTS, XTYPE, and certain errors that you will need to look out for. Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture...
SQL SERVER CASE SENSITIVITY TRICK
Просмотров 373Год назад
BEST SQL SERVER CASE SENSITIVITY TRICK CASE SENSITIVE: COLLATE SQL_Latin1_General_CP1_CS_AS CASE INSENSITIVE: COLLATE, SQL_Latin1_General_CP1_CI_AS (DEFAULT INSTALL OPTION) Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SERVER CASE SENSITIVITY TUTORIAL
Просмотров 115Год назад
DETERMINING SQL SERVER CASE SENSITIVITY TUTORIAL CASE SENSITIVE: COLLATE SQL_Latin1_General_CP1_CS_AS CASE INSENSITIVE: COLLATE, SQL_Latin1_General_CP1_CI_AS (DEFAULT INSTALL OPTION) Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SERVER CASE SENSITIVITY LESSON
Просмотров 92Год назад
CHECK SQL SERVER CASE SENSITIVITY LESSON CASE SENSITIVE: COLLATE SQL_Latin1_General_CP1_CS_AS CASE INSENSITIVE: COLLATE, SQL_Latin1_General_CP1_CI_AS (DEFAULT INSTALL OPTION) Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
HOW TO CREATE NEW SQL SERVER TABLE SCHEMA
Просмотров 549Год назад
Quick Lesson: CREATE NEW SCHEMA in SQL SERVER 1. Create Schema CREATE SCHEMA xyz 2. Transfer an object to the new schema ALTER SCHEMA xyz TRANSFER dbo.mytable Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SERVER CREATE NEW SCHEMA TUTORIAL
Просмотров 89Год назад
How you can quickly CREATE NEW SCHEMA in SQL SERVER 1. Create Schema CREATE SCHEMA xyz 2. Transfer an object to the new schema ALTER SCHEMA xyz TRANSFER dbo.mytable Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SERVER CREATE NEW SCHEMA LESSON
Просмотров 115Год назад
Your guide to CREATE NEW SCHEMA in SQL SERVER 1. Create Schema CREATE SCHEMA xyz 2. Transfer an object to the new schema ALTER SCHEMA xyz TRANSFER dbo.mytable Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SERVER: CHANGE TABLE SCHEMA
Просмотров 1 тыс.Год назад
How to change schema ownership in SQL SERVER 1. Transfer an object to the new schema ALTER SCHEMA xyz TRANSFER dbo.mytable Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SERVER CREATE NEW SCHEMA
Просмотров 820Год назад
How to CREATE NEW SCHEMA in SQL SERVER 1. Create Schema CREATE SCHEMA xyz 2. Transfer an object to the new schema ALTER SCHEMA xyz TRANSFER dbo.mytable Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SERVER CASE SENSITIVITY
Просмотров 495Год назад
HOW TO CHECK SQL SERVER CASE SENSITIVITY CASE SENSITIVE: COLLATE SQL_Latin1_General_CP1_CS_AS CASE INSENSITIVE: COLLATE, SQL_Latin1_General_CP1_CI_AS (DEFAULT INSTALL OPTION) Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL MAX, MIN , AVG FUNCTIONS along with GROUP BY and PARTITION BY
Просмотров 780Год назад
Showing the MAX(), MIN(), AVG() functions along with the GROUP BY clause and PARTITION BY analytical functionality. Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
REALLY FAST SQL CONCAT() FUNCTION TUTORIAL
Просмотров 58Год назад
REALLY FAST SQL CONCAT() FUNCTION TUTORIAL. SHOWS TWO WAYS TO CONCATENATE STRINGS. Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL SUM, AVG FUNCTIONS along with GROUP BY and PARTITION BY
Просмотров 219Год назад
Showing the SUM(), AVG() functions along with the GROUP BY clause and PARTITION BY analytical functionality. Link to my SQL Courses on Udemy: www.udemy.com/course/sql-server-fast-track-intro-to-queries/learn/lecture/4885630
SQL MAX, MIN and AVG FUNCTION and GROUP BY and PARTITION BY
Просмотров 107Год назад
SQL MAX, MIN and AVG FUNCTION and GROUP BY and PARTITION BY
SQL SUM FUNCTION along with GROUP BY and PARTITION BY
Просмотров 2 тыс.Год назад
SQL SUM FUNCTION along with GROUP BY and PARTITION BY
SQL SUM and AVG FUNCTION and GROUP BY and PARTITION BY
Просмотров 119Год назад
SQL SUM and AVG FUNCTION and GROUP BY and PARTITION BY
QUICK SQL CONCAT() FUNCTION TUTORIAL
Просмотров 3,9 тыс.Год назад
QUICK SQL CONCAT() FUNCTION TUTORIAL
SQL MAX, MIN & AVG FUNCTION WITH GROUP BY
Просмотров 188Год назад
SQL MAX, MIN & AVG FUNCTION WITH GROUP BY
SQL MAX() FUNCTION, MIN() FUNCTION, AVG() FUNCTION, SUM() FUNCTION GROUP BY
Просмотров 137Год назад
SQL MAX() FUNCTION, MIN() FUNCTION, AVG() FUNCTION, SUM() FUNCTION GROUP BY
SQL SUM FUNCTION and GROUP BY and PARTITION BY
Просмотров 505Год назад
SQL SUM FUNCTION and GROUP BY and PARTITION BY
SQL MAX() FUNCTION, MIN() FUNCTION, AVG() FUNCTION, GROUP BY
Просмотров 65Год назад
SQL MAX() FUNCTION, MIN() FUNCTION, AVG() FUNCTION, GROUP BY
SQL SUM() FUNCTION, AVG() FUNCTION, GROUP BY
Просмотров 176Год назад
SQL SUM() FUNCTION, AVG() FUNCTION, GROUP BY
SQL Server Table Creation Date and Schema Changes Report
Просмотров 62Год назад
SQL Server Table Creation Date and Schema Changes Report
love the low quality mic, somehow it makes me think that i am actually learning smth instead of doomscrolling
the Smitty/Committee joke was a criminal act, but I guess we can let it slide because that was a good explanation 😛 Thanks!
amazing job
Youre a hero. Thank you for the video
Great explanation. Love the anecdotes as well.
2nd Question: I want to build SQL Server Usage scanner in which I want to get information related to users, which user perform which query and how much time it took to complete the query start date end date etc
Take a look at the Profiler in SSMS
I have a question? which query I can use to get this
Can you be more specific?
Thank you!!
Thank you very useful.. one thing though .. the query - If exists (Select * from A) Drop table A will work only if there are any records in the table .. If you delete first from the table then it will not work as select * will not return data
Are you running it from SQL Server, or a different RDBMS?
A lot of words but little substance. This could easily be a 4 minute video
Thanks for the feedback!
Great video... try to post more often
@jazzista1967 I will. Thanks for the feedback!
you ought to do a stand up mister 😁
haha, right?! I get that ALL the time. Thanks!
There is a big difference between people who study a material and then teach, and people who teach from their own experiences. Good luck.
Thanks @aminabbaszadeh1066 ! It means a lot.
very informative, thank you.
Thanks Abdul!
Bro you are funny
Thanks @abdulazizmohammed6300, I try! (It's never rehearsed, it just happens!)
Amazing
Thank you!
Hi buddy, thank you so much for this simple to follow & very useful tutorial. Can you please do another one where we export a table or stored procedure table to a csv file. Thank you
you are amazing!
Thank you so much! What did you like the most about the video?
Great content. Why did you stop posting? Please create more like this! Now shorts are in trend as well
I will do just that!
Great explanations , thank you so much 🙏
Thank You for this video. i am clear with Next previous LAG(), LEAD() and Partition by :)
Excellent! Glad to hear it!
Funny, but Vida Blue played baseball, not football
True
great!!!
Thank You, Simon!
Thanks for the explanation of the term WINDOW in the SQL context and showing the Sum function in SQL. Excellent example. Do you have more aggregate function examples? Thumps up. Question: Is it possible to do a running total of all salaries? Just subscribed to your channel!
Thanks @jazzista1967! Check out this video for the running total: ruclips.net/video/KqemVaTTR-k/видео.html It's at about 10:50 into the video. Have fun!
The above referenced video covers: SQL SUM, AVG FUNCTIONS along with GROUP BY and PARTITION BY
Well done, Sir.
Great stuff!
that was good, i really enjoyed it. I find myself using partion by a lot at work its nice to know how it works with different things thanks
You don’t need to cast ints with concat
Explained like we are all stupid, like marketers. Great stuff. Really clear.
Thank You, @MountRushCollymore!
10/10 it was really helpful
got it very quickly thanks
Informative and funny
Thank You!
I love this guy
too many ads!
I wanna know what happens if we remove order by after partition by dept
@awesomeuploads118 You can certainly try that in certain database tools, however SQL Server throws an error. You can do it i snowflake for sure though.
I noticed people write a query " .....xxxxx (xxxxx) a" .. they dont write AS they just write the name outside the bracket and it picks up as an alias 🤔 is that a thing ?
Whats the chances that i left these sections to study for last and it happened to be in 1 video 😂
Tbh this is the best video on these sections that ive found on yt
This was awesome thanks
Thank you!
useless video
good video !
Hi, Thank you for the Video, How can I write with totals instead of running total?
To the point video!
Quick and dirty. I like it. Thanks
Clarity ,humor and Content superb 10/10
Thank you!
Thank You, Eben!
Absolute legend! You are an amazing teacher.
Thank you so much!
Can you say how can we get the total sum in all the columns instead of running sum
@shankarkr1603 Just do this: SELECT SUM(SALARY) FROM EMP
thank you that's a great video!
loved it. thank you so much.