- Видео 79
- Просмотров 6 979 647
Joey Blue
США
Добавлен 11 май 2012
Joey has been working with Business Intelligence, Relational Databases, Analytics Tools, and Reporting Tools for over 24 years.
He founded and works as a consultant with Embark Blue, helping small and large companies get better and more timely information for decision making.
If you have any questions, or need any help, you can contact Joey through LinkedIn, Facebook, or www.EmbarkBlue.com.
This channel is focused on teaching different SQL techniques as well as documenting current projects that Joey is working on. To find more videos and information you can also visit www.SQLTrainingOnline.com.
He founded and works as a consultant with Embark Blue, helping small and large companies get better and more timely information for decision making.
If you have any questions, or need any help, you can contact Joey through LinkedIn, Facebook, or www.EmbarkBlue.com.
This channel is focused on teaching different SQL techniques as well as documenting current projects that Joey is working on. To find more videos and information you can also visit www.SQLTrainingOnline.com.
SQL Cross Join | Quick Tips Ep63
Demonstration of the SQL Cross Join also known as the Cartesian Join. We start with an simple example and then move into a real world example of Budget Allocation across months. The demonstration is done in SQL Server using SQL Server Management Studio.
SQL Cross Join | Quick Tips Episode #63
TABLE OF CONTENTS
0:00 - Intro
0:07 - Cross Join Introduction
0:56 - Cross Join Syntax - Example
1:50 - Beware of the Cartesian Product
2:41 - Real World Example - Budget Allocation
RUclips NEWS UPDATES
ruclips.net/user/sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
ruclips.net/user/sqltrainingonline
SUBSCRIBE TO OUR EMAIL L...
SQL Cross Join | Quick Tips Episode #63
TABLE OF CONTENTS
0:00 - Intro
0:07 - Cross Join Introduction
0:56 - Cross Join Syntax - Example
1:50 - Beware of the Cartesian Product
2:41 - Real World Example - Budget Allocation
RUclips NEWS UPDATES
ruclips.net/user/sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
ruclips.net/user/sqltrainingonline
SUBSCRIBE TO OUR EMAIL L...
Просмотров: 28 927
Видео
SQL Create Table | Quick Tips Ep62
Просмотров 14 тыс.3 года назад
We cover the questions you need to ask when creating a table in SQL. Where should you put the table? What should you name the table and columns? What data types should you use? How big will the table be? And, more questions like these will be answered in this video. SQL Create Table | Quick Tips Episode #62 TABLE OF CONTENTS 0:00 - Intro 0:19 - Create Table Syntax 1:47 - Outline 3:11 - Where to...
SQL Server Management Studio (SSMS) | Full Course
Просмотров 545 тыс.3 года назад
In this comprehensive video you will learn the features of SQL Server Management Studio (SSMS). You will start with connecting SSMS to SQL Server and then start navigating and writing SQL queries. You will learn about the many feature of SQL Server Management Studio. Install SQL Server Developer Edition: ruclips.net/video/05ZivSteGJg/видео.html Install SQL Server Management Studio (SSMS) ruclip...
SQL CASE Statement | Quick Tips Ep61
Просмотров 12 тыс.3 года назад
In this video I show you 3 different ways to use the SQL Case Statement. I demonstrate the Simple CASE expression, the Searched CASE expression, and add in some other decoding and bucketing. The demonstration uses SQL Server and SQL Server Management Studio (SSMS). SQL CASE Statement | Quick Tips Episode #61 TABLE OF CONTENTS 0:00 - Intro 0:47 - Simple CASE Expression Example 3:50 - Searched CA...
SQL Recursive Join with CTE Part 2 | Quick Tips Ep60
Просмотров 6 тыс.3 года назад
In this video I show you how to execute a recursive join against an Accounting Chart of Account table to expose the hierarchy of accounts. I demonstrate recursion and walk you through the different parts of recursive join. The demonstration uses SQL Server and SQL Server Management Studio (SSMS). SQL Recursive Join with CTE Part 2 | Quick Tips Episode #60 TABLE OF CONTENTS 0:00 - Intro 1:14 - L...
SQL Recursion with CTE Part 1 | Quick Tips Ep59
Просмотров 28 тыс.3 года назад
In this video I show you how to execute a recursive CTE (Common Table Expression) against Employee table. I demonstrate recursion and walk you through the different parts of recursive join. The demonstration uses SQL Server and SQL Server Management Studio (SSMS). SQL Recursion with CTE Part 1 | Quick Tips Episode #59 TABLE OF CONTENTS 0:00 - Intro 0:20 - Regular CTE Example 1:15 - Recursive CT...
SQL Self Join | Quick Tips Ep58
Просмотров 10 тыс.3 года назад
In this video I show you how to execute a Self Join in SQL and I discuss when you would use the Self Join. The demonstration uses SQL Server and SQL Server Management Studio (SSMS). SQL Self Join | Quick Tips Episode #58 TABLE OF CONTENTS 0:00 - Intro 1:00 - Self Join Data Walkthrough 2:54 - Self Join Example with an Inner Join 5:25 - Other Type of Data with a Self Join 6:10 - Self Join Cleanup...
Breaking Down 4 SQL Jobs on Glassdoor | Data Jobs Ep2
Просмотров 2,8 тыс.3 года назад
In this video I walk through 4 random SQL Jobs on Glassdoor. We explore the jobs requirements and discuss what each of the skills mean. We also research the underlying company. The jobs include a Business Operations Analyst, Business Analyst, Web Developer, and a Business Intelligence Intern. Breaking Down 4 SQL Jobs on Glassdoor | Data Jobs Episode #2 TABLE OF CONTENTS 0:00 - Intro 0:35 - Busi...
SQL Q&A - Jobs, Date Format, Moving Average | Q&A Series Ep1
Просмотров 2,5 тыс.3 года назад
In this video I answer your questions from the RUclips comments. We discuss SQL Server Management Studio (SSMS) connections, Data Analyst Jobs, Import/Export Text files, Database Normalization, SSMS Query Issues, and Moving Averages. SQL Questions and Answers - Jobs, Date Format, Moving Average | Q&A Series Ep1 TABLE OF CONTENTS 00:00 - Intro 00:14 - Q1 - Missing Edit, Delete Feature in SSMS 02...
Installing Microsoft SQL Server Management Studio (SSMS) | Installation Series Ep2
Просмотров 88 тыс.3 года назад
In this video I walk through installing Microsoft SQL Server Management Studio so that you can practice your SQL skills. Installing Microsoft SQL Server Management Studio (SSMS) | Installation Series Ep2 TABLE OF CONTENTS 00:00 - Intro 00:20 - Download SQL Server Management Studio (SSMS) 01:15 - Begin Installation of SSMS 02:28 - Open SSMS 03:00 - Connect to SQL Server from SSMS by ServerName, ...
Installing Microsoft SQL Server Developer | Installation Series Ep1
Просмотров 30 тыс.3 года назад
In this video I walk through installing Microsoft SQL Server Developer Edition so that you can practice your SQL skills. Installing Microsoft SQL Server Developer | Installation Series Ep1 TABLE OF CONTENTS 00:00 - Intro 00:15 - Download SQL Server Developer Edition 01:24 - Start Installation Download 02:02 - Installation Phase Begins 02:28 - Test Connection RUclips NEWS UPDATES ruclips.net/use...
SQL Pivot and Unpivot | Quick Tips Ep57
Просмотров 11 тыс.3 года назад
In this video I show how to use the SQL Pivot and Unpivot. I will walk you through what it is, demonstrate how to use it on a small dataset, then demonstrate how you might use it in everyday programming. SQL Pivot and Unpivot | Quick Tips Episode #57 TABLE OF CONTENTS 00:00 - Intro 00:57 - PIVOT and UNPIVOT example in Excel 02:34 - PIVOT in SQL 06:34 - SELECT INTO Example 07:03 - UNPIVOT in SQL...
SQL Server sp_help | Quick Tips Ep56
Просмотров 3,2 тыс.3 года назад
In this video I show how to use the SQL Server sp_help procedure to enhance your development. I will walk you through what it is and how you can use it on Tables, Views, and Stored Procedures. I will also show you how to use the shortcut keys ALT F1 to speed up your development. Finally, I show you how to use is in the development cycle by modifying a view. SQL Server sp_help | Quick Tips Episo...
Breaking Down 3 SQL Jobs on LinkedIn | Data Jobs Ep1
Просмотров 2 тыс.3 года назад
In this video I walk through 3 random SQL Jobs on LinkedIn. We explore the jobs requirements and discuss what each of the skills mean. We also research the underlying company. The jobs include a SQL Programmer, SQL Developer/Architect, and a SQL Database Admin. Exploring 3 SQL Jobs on LinkedIn | Data Jobs Episode #1 TABLE OF CONTENTS 00:00 - Intro 0:16 - LinkedIn Search 1:05 - SQL Programmer Jo...
Database Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training Online
Просмотров 189 тыс.5 лет назад
Database Normal Forms with Examples. In this video I show you how to normalize your relational database. What is covered: 1st Normal Form and Atomic Values 2nd Normal Form and Partial Dependence 3rd Normal Form and Transitive Dependence 4th Normal Form and Multi-Value Facts I start with smaller examples for 1NF, 2NF, 3NF, and 4NF. Then I move into a more comprehensive example that uses all of t...
SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join
Просмотров 669 тыс.6 лет назад
SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join
Zillow House Price Analysis from CSV Archive - #PowerBI 002
Просмотров 5 тыс.6 лет назад
Zillow House Price Analysis from CSV Archive - #PowerBI 002
Learn SQL in 1 Hour - SQL Basics for Beginners
Просмотров 3,7 млн6 лет назад
Learn SQL in 1 Hour - SQL Basics for Beginners
Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset - Quick Tips Ep55
Просмотров 6 тыс.6 лет назад
Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset - Quick Tips Ep55
Clickbank Product Analysis from the XML Feed - #PowerBI 001
Просмотров 6 тыс.6 лет назад
Clickbank Product Analysis from the XML Feed - #PowerBI 001
Latitude and Longitude with the Geography Data Type - SQL Training Online - Quick Tips Ep54
Просмотров 21 тыс.6 лет назад
Latitude and Longitude with the Geography Data Type - SQL Training Online - Quick Tips Ep54
Year-to-Date using Partition By with Windowing - SQL Training Online - Quick Tips Ep53
Просмотров 17 тыс.6 лет назад
Year-to-Date using Partition By with Windowing - SQL Training Online - Quick Tips Ep53
Prior Day Profit using the Lag Function - SQL Training Online - Quick Tips Ep52
Просмотров 5 тыс.6 лет назад
Prior Day Profit using the Lag Function - SQL Training Online - Quick Tips Ep52
Moving Average with Windowing - SQL Training Online - Quick Tips Ep51
Просмотров 13 тыс.6 лет назад
Moving Average with Windowing - SQL Training Online - Quick Tips Ep51
SQL Format Function - SQL Training Online - Quick Tips Ep50
Просмотров 10 тыс.6 лет назад
SQL Format Function - SQL Training Online - Quick Tips Ep50
SQL Union and Union All - SQL Training Online - Quick Tips Ep49
Просмотров 29 тыс.6 лет назад
SQL Union and Union All - SQL Training Online - Quick Tips Ep49
SQL Concat Function in SQL Server - SQL Training Online - Quick Tips Ep48
Просмотров 7 тыс.11 лет назад
SQL Concat Function in SQL Server - SQL Training Online - Quick Tips Ep48
SQL Isdate Function as a Filter with Cast - SQL Training Online - Quick Tips Ep47
Просмотров 7 тыс.11 лет назад
SQL Isdate Function as a Filter with Cast - SQL Training Online - Quick Tips Ep47
SQL Moving Average - SQL Server Training, Subquery, Datediff, Dateadd - Quick Tips Ep46
Просмотров 16 тыс.11 лет назад
SQL Moving Average - SQL Server Training, Subquery, Datediff, Dateadd - Quick Tips Ep46
Import HTML Table Data To SQL Server with Copy Paste - Quick Tips Ep45
Просмотров 19 тыс.11 лет назад
Import HTML Table Data To SQL Server with Copy Paste - Quick Tips Ep45
I'm quite happy with your Udemy course-it's very good! Our goals are to increase enrollments, foster positive feedback, and optimize income. I'm excited to come up with unique tactics to elevate your course even further.
Thank you
Very informative and understable 🎉
thanks for this short and precise tutorial, its understanding
Thanks 🙏
Very helpful. Thank you!
Thanks so much Joey Blue, you are such a great teacher. Full of details explanation.
Highly practical, thanks alot.
Great video, really helpful! Does anyone knows a well structured Book or website about SSMS? I know "Learning SQL" from Alan Beaulieu but this one utilizes MySQL... Thank you very much!
I followed most of this video but when you got to the Foreign key it all got a bit confusing. It didn't help with having IDs and Ids and going back to correct some mistake. You should have showed what the Orders Table looked like with the Foreign keys. I'm sorry but I didn't get it.
This is very helpful. Thanks!
awesome video. Thank you very much for sharing.
cool
❤❤❤❤🎉
I have an 1.30h flight then straight to an interview. This better work !
thanks for the tutorial
helped a 🙂lot thank you💯❤
pls explain why are you deleting the 21st data in order id..
cant imagine this video just uploaded in 2018
how to add years and months to change
great explain, great
In this video 20:16 how did you sort product key. if we double click on that will it save all the rows
provided a baisc overview of SSMS, just what I needed. Thanks
Super useful! Concise, thorough go through of SSMS features. Just what I am looking for! Thanks.
Can we start at a low spot whre something is NULL in the hierarchy and work up util we get a vaule up the hierarchy?
hey ,if you reading comment,i want to know about soound and like in same query
Is it useful for cse student
very good video, so good explanation about the joins.
it was very helpful; thank you.
How is sqi different from html?
SERENE - Nicely done.
Excellent ! no more videos like that for practicing advanced topics on sql ?
Useful intro to SSMS - thanks for the upload 😀
Thank you so much
Great Video! Thanks
Best explanation of sql case I’ve found!
what do i do when i keep gettting an error when i'm trying to connect to my local server with my computer name ?
How can we get the files
How can we download SQL server in windows 7
After a long long time of procrastinating to understand the joins, finally, thanks a lot
thank you
Thank you ❤❤
That's very helpful. I thank you a lot!
This is unbelievably helpful
Thanks a lot, man!!!!!
It is good.
No want is talking about the unique software he is using
How do you get the curved arrow.?