Home
Videos uploaded by user “Joey Blue”
Sql Training Online - Sql Count Function
 
03:52
Learn about the Count function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 SQL Count Function is used to give you a total number of records in your resultset or within a group of data. You would group the data using a group by clause in the SQL Statement. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 21127 Joey Blue
SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join
 
18:04
Learn how to create SQL Joins. The first 10 minutes teach you the basics. Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join. The second 10 minutes show you are few techniques that will help you as you start building joins. READ THE ORIGINAL ARTICLE WITH THE TABLE SCRIPS http://www.sqltrainingonline.com/sql-joins-tutorial-for-beginners/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 114998 Joey Blue
Sql Training Online - Cast Function
 
04:08
Learn about the Cast function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 cast function is used to convert or change a column datatype when you are querying or filtering in a SQL statement You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 14752 Joey Blue
How to use the SQL In Statement with Subquery - SQL Training Online
 
04:26
http://www.sqltrainingonline.com How to use the SQL In Statement with Subquery - SQL Training Online In this video, I show you how to use the SQL IN Statement with Subquery in SQL Server 2012. I will show you in 3 steps that build on each other: 1) Use the SQL OR operator. 2) Use the SQL IN operator. 3) Substicute a SQL Subquery into the IN Clause. And, that's it. You have now used the SQL IN statement with Subquery. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 7406 Joey Blue
SQL With - How to Use the With (CTE) Statement in SQL Server - SQL Training Online
 
06:33
http://www.sqltrainingonline.com SQL With - How to Use the WITH Statement/Common Table Expressions (CTE) in SQL Server - SQL Training Online In this video, I introduce the SQL WITH statement (also known as Common Table Expressions or CTE) and show you the basics of how it is used. The SQL WITH Statement is called Common Table Expressions or CTE for short in SQL Server The SQL WITH statement is used for 2 primary reasons: 1) To move Subqueries to make the SQL easier to read. 2) To do recursive queries in SQL Today, I just want to talk about the subquery piece. I first want to take a look at the Employee table in the SQL Training Online Simple Database. select * from employee To talk about the SQL WITH statement, I have to first talk about and show you a subquery. select * from ( select * from employee ) a So that is an example of a subquery. But, we want to talk about the SQL WITH, which allows you to move the subquery up and make the SQL a lot easier to read. Here is the same query using the WITH statement. WITH cteEmployee (employee_number,employee_name,manager) AS ( select employee_number,employee_name,manager from employee ) select * from cteEmployee You can see that we start with the WITH clause and then we can use any name we want to name our CTE. In this case, I use "cteEmployee". Then we need to specify the columns inside of parenthesis. Next comes the AS clause. And finally, we just SELECT from the cteEmployee table we created. And, that's it. But, I want to take it a step further and join the cteEmployee CTE back to the Employee table and get the Manager's name. Here is an example of that. WITH cteEmployee (employee_number,employee_name,manager) AS ( select employee_number,employee_name,manager from employee ) select cte.employee_number ,cte.employee_name ,cte.manager ,e.employee_name as manager_name from cteEmployee cte INNER JOIN employee e on cte.manager = e.employee_number That's it. That is the basic introduction into the SQL WITH statement in SQL Server. Microsoft also has some good examples on this. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 19694 Joey Blue
SQL Variable Declaration - How to Declare a Variable in SQL Server - SQL Training Online
 
03:23
http://www.sqltrainingonline.com SQL Variable Declaration - How to Declare a Variable in SQL Server - SQL Training Online In this video, I show you how to Declare a Variable in SQL Server using SQL Server Management Studio. How do you declare a variable in SQL Server? There are 3 things to know when declaring a SQL Server variable. 1) SQL Server Variables start with '@'. 2) You must use the DECLARE keyword. 3) You can use SET or SELECT to put data into the variable. So, know I want to show you an example. The first step is to create an empty variable. You do that with the DECLARE statement like this: DECLARE @my_int int; Here I have declared a variable that can store an integer. The next step is to put something into the variable. You can do that by using the SET or the SELECT statements. SET @my_int=3; In that example, the variable will store the integer 3. Then, the last step is to print out what is in the variable. You can do that with the SQL SELECT. SELECT @my_int; And that is it. But, you have to run the whole thing together for it to work. DECLARE @my_int int; SET @my_int=3; SELECT @my_int; Now, you can also change what is stored in the variable. In the following example, I change the value inside of the @my_int variable from 3 to 3+1 which equals 4. DECLARE @my_int int; SET @my_int=3; SET @[email protected]_int + 1; SELECT @my_int; And, the last thing I want to do is show you how to use the SELECT to populate the variable instead of the SET. DECLARE @my_int int; SELECT @my_int=3; SET @[email protected]_int + 1; SELECT @my_int; That's it. That is how you do a SQL Variable Declaration. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline http://youtu.be/u4R46wlwAwo
Views: 15007 Joey Blue
Delete Duplicates in SQL - SQL Training Online
 
05:36
http://www.sqltrainingonline.com Delete Duplicates in SQL Server - SQL Training Online In this video, I show you two different techniques to remove duplicate records in a SQL Server 2012 table. I don't use the SQL distinct operators, but I actually group the data and apply unique row identifiers to make the SQL delete easier. Both of the SQL delete statements involve SQL Server CTE statements and use the Row_Number operator to assist in the process. With the operator, you can identify the duplicate rows You can get the sample script to run the test yourself at http://www.sqltrainingonline.com/how-to-remove-duplicate-rows-in-sql-server/. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 27703 Joey Blue
Sql Training Online - Sql Group By
 
04:19
Learn about the Group By clause in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 Group By Clause is used to group data together and is often used with functions like Sum, Average, Min, Max, Count in the SQL Statement. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 9382 Joey Blue
Sql Training Online - Sql Alias
 
03:55
Learn about the Alias functionality in the SQL Language. Visit http://www.SqlTrainingOnline.com for more FREE videos. The Microsoft SQL Server 2012 Alias allows you to put an alternative name on a column or table for the duration of your SQL query. You will often see this with the AS statement, although the AS statement is optinoal. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 16748 Joey Blue
SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online
 
05:08
http://www.sqltrainingonline.com SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online In this video, I show you how to copy data using the SQL INTO statement. Including a trick to copy only a table schema in SQL Server. How do you copy a whole table in SQL Server? You often see the SQL INTO statement when you are using INSERT, but there is a special INTO statement in SQL Server that is used with the SELECT statement that allows you to make a copy of a table for development, testing, or whatever purpose you can think of. So, to start, let's take a look at the SQL Training Online Simple DB employee table. You can see that we have 14 records Now, all we have to do to make a copy of the table is to simply add the SQL INTO clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE If we run that, you see that we made a copy of the table with all of the data. Now, I want to go ahead and empty the employee_test table and show you how to use the INSERT INTO. If you already have a copy of the table, (I will show you a shortcut in a minute on how to create a copy without data.) then you can use the following insert into statement: INSERT INTO EMPLOYEE_TEST SELECT * FROM EMPLOYEE After running that statement, you see that I have inserted data from the Employee table into the employee_test table. This is sometimes referred to as INSERT INTO SELECT. But, there is one trick that I have used throughout the years that is pretty cool. Sometimes, you want the table schema, but you don't want the data. Now, I know that you can use Management Studio to script out the table for you, but there is an easier way that is more flexible as far as I am concerned. That is to use the SELECT INTO FROM, but put the following in the WHERE clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE WHERE 1=2 The 1=2 makes is so not data will come over, but you get the new table with the right column types. Is that pretty cool? I have found many uses for this over the years. Let me know what you think bellow. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 22317 Joey Blue
Jet Driver - How to find the Microsoft Access (ODBC) in Windows 7 64 bit - SQL Training Online
 
05:15
http://www.sqltrainingonline.com Jet Driver -- How to find the Microsoft Access Driver (ODBC) in Windows 7 64 bit - SQL Training Online In this video, I show you how to find the missing ODBC drivers in Windows 7. Where are the Windows 7 Jet Drivers? The Jet Driver is used for ODBC and allows you to interact with Microsoft Access, Microsoft Excel, and other ODBC sources that don't have OLEDB drivers. I went and looked for them today, and they were gone! You find the ODBC connections in Administrative Tools. When I opened them up, and clicked ADD, I only saw 4 drivers. The problem is because, by default, when you are using the 64 bit Windows 7, the ODBC Administrator that opens up is the 64 bit version. Well, the Jet Driver doesn't support 64 bit. This means you have to find the 32 bit ODBC Administrator. I found this article, which showed me the location of my 32 bit ODBC Administrator here: C:\Windows\SysWOW64\odbcad32.exe If you open that one up, click on the User DSN tab, and click Add, you will find all of the missing drivers. So, that's where they went. Now I see the Jet Driver. But, you don't want to go find them every time, do you? So, I will show you how to create a shortcut in your Administrative Tools. Open your windows explorer, and navigate to the following location: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools Make a copy of the Data Sources (ODBC) Rename the copy to Data Sources (ODBC) - 32 Bit Now go to the properties and change the Target and Start In and replace "system32" with "SysWOW64". And click OK. That's it. Now you have a shortcut in your Administrative Tools that will pull up the 32 bit version of the ODBC Administrator and you will see the Jet Driver. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 34516 Joey Blue
SQL Training Online - Excel to SQL Server - Part #1 - Introduction
 
02:34
Excel to SQL Part #1 is an Introduction of 3 ways (Import/Export, Bulk Insert, BCP) to move data from Excel to SQL Server. http://www.sqltrainingonline.com/free-training-excel-to-sql-server/ To view all 5 free online videos in this training series and to download all of the training materials including the Microsoft Excel File, Tab Delimited File, CSV File, SQL files and Bat script, visit: http://www.sqltrainingonline.com/free-training-excel-to-sql-server/
Views: 19331 Joey Blue
Sql Training Online - Sql Substring
 
02:50
Learn about the Substring function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 7719 Joey Blue
Sql Training Online - Sql Wildcard Filter
 
03:10
Learn about the wildcard filter in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 9645 Joey Blue
Sql Training Online - Sql Average Function
 
04:04
Learn about the Average (avg) function in the SQL Language. Visit http://www.SqlTrainingOnline.com for more FREE videos. The Microsoft SQL Server 2012 Average function (avg) allows you to get an average across all of the data in a result set or a group of data if you used the group by SQL clause in your query. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 11157 Joey Blue
How to Import Data from Microsoft Excel to Windows Azure SQL Database - SQL Training Online
 
10:04
http://www.sqltrainingonline.com How to Import Data from Microsoft Excel to Windows Azure SQL Database - SQL Training Online For the links to the samples used in the video, you can go here: http://www.sqltrainingonline.com/microsoft-excel-to-windows-azure-sql-in-10-minutes/ In this video, I walk you through setting up a Windows Azure SQL Database and then importing some Microsoft Excel data. I show you a trick to get the SQL Server Management Studio Import/Export Wizard to work for a Windows Azure connection. I show you how to setup a new Azure SQL Server. Then you will see how to open up a firewall port that allows you to connect using your local SQL Server Management Studio. Finally, I show you how to connect to a Microsoft Excel Workbook using excel connections and push that data over to your new tables in the SQL Server on Windows Azure. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 22796 Joey Blue
Sql Training Online - Sql As Statement
 
02:08
Learn about the "As" functionality in the SQL Language. Visit http://www.SqlTrainingOnline.com for more FREE videos. The Microsoft SQL Server 2012 As Statement is used to alias a column or a table. It is optional, so you might not see it in all of the SQL statements that you encounter. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 12733 Joey Blue
SQL Training Online - Excel to SQL Server - Part #5 - Automation
 
06:07
http://www.sqltrainingonline.com/free-training-excel-to-sql-server/ Excel to SQL Part #5 talks about turning your BCP command into a BAT script and scheduling it so that you can automate your movement of data from CSV to SQL Server. To view all 5 free online videos in this training series and to download all of the training materials including the Microsoft Excel File, Tab Delimited File, CSV File, SQL files and Bat script, visit: http://www.sqltrainingonline.com/free-training-excel-to-sql-server/
Views: 9617 Joey Blue
Sql Training Online - Sql Convert Function
 
02:50
Learn about the Convert function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 Convert function allows you to change the datatype of a column during a SQL query. Many times you would convert from a datetime or numeric datatype to a varchar. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 16937 Joey Blue
How to Test SQL Server Functions including Substring, Charindex - SQL Training Online
 
05:31
http://www.sqltrainingonline.com How to Test SQL Server Functions - SQL Training Online This SQL Server 2012 video teaches you how to test SQL Server Functions before you place them into a SQL Query. This technique makes it easier to work on larger and more complex SQL statements that include multiple functions like CAST, Convert, Substring, Charindex, etc. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 2843 Joey Blue
Sql Training Online - Sql Trim, Rtrim, Ltrim
 
02:56
Learn about the Trim, RTrim, LTrim functions in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 10547 Joey Blue
Sql Training Online - Sql CharIndex - Instring
 
03:27
Learn about the Instring and CharIndex functions in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 CharIndex or Instring is used to find a character withing a varchar column. It is a SQL function that can be used in the Where clause or the column list of a Sql query. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 5869 Joey Blue
SQL Null or Empty   How to Check for Null or Empty Column in SQL Server   SQL Training Online
 
03:41
http://www.sqltrainingonline.com SQL Null or Empty - How to Check for Null or Empty Column in SQL Server - SQL Training Online You can download the sample table script at http://www.sqltrainingonline.com/how-to-filter-for-sql-null-or-empty-string/. In this video, I show you how to filter for a SQL null or empty string. It can be difficult to filter a null because you can't simply compare with an equal sign. You have to use a special IS NULL clause to make the filter work. I also show you how to combine both the SQL Null and Empty String together in a special trick with the isnull SQL Server function. I use SQL Server 2012 to demonstrate the technique. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 16295 Joey Blue
SQL Training Online - Excel to SQL Server - Part #2 - Import Export Wizard
 
06:37
Excel to SQL Part #2 shows you how to use the Management Studio Import/Export wizard to move data from Microsoft Excel to SQL Server. http://www.sqltrainingonline.com/free-training-excel-to-sql-server/ To view all 5 free online videos in this training series and to download all of the training materials including the Microsoft Excel File, Tab Delimited File, CSV File, SQL files and Bat script, visit: http://www.sqltrainingonline.com/free-training-excel-to-sql-server/
Views: 26489 Joey Blue
Sql Training Online - Sql Sum Function
 
03:22
Learn about the Sum function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 7433 Joey Blue
Latitude and Longitude with the Geography Data Type - SQL Training Online
 
01:55
The Geography data type is used in many different SQL Server databases. It contains Latitude, Longitude, and many other properties and functions. In this video I show you how to extract the latitude and longitude from the Geography data type. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/geography-data-type-sql-server/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 3969 Joey Blue
SQL Union and Union All - SQL Training Online
 
03:00
Union and Union All are very similar, but if you don’t understand the differences, it can cause trouble. In this video I do a quick demonstration of the Union and Union All Function. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/sql-server-union-all/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 2122 Joey Blue
Sql Training Online - Sql Concatenate
 
03:30
Learn about the Concatenate function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 SQL Concatenate is another way of saying you want to put two different values or strings together in your SQL query or sql statement. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 8409 Joey Blue
SQL Training Online - Excel to SQL Server - Part #4 - BCP (Bulk Copy Program)
 
07:25
Excel to SQL Part #4 shows you how to use BCP to move data from Microsoft Excel into SQL Server. http://www.sqltrainingonline.com/free-training-excel-to-sql-server/ To view all 5 free online videos in this training series and to download all of the training materials including the Microsoft Excel File, Tab Delimited File, CSV File, SQL files and Bat script, visit: http://www.sqltrainingonline.com/free-training-excel-to-sql-server/
Views: 14381 Joey Blue
Learn SQL in 1 Hour - SQL Basics for Beginners
 
01:02:23
A crash course in SQL. How to write SQL from scratch in 1 hour. In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL. TABLE OF CONTENTS Skip Intro/Discuss Management Studio 3:27 Create Database 5:10 Create Table 7:26 Insert Data 10:29 Select Statement 17:43 Where Clause 19:00 Update Statement 22:25 Delete Statement 24:33 Adding Comments 27:41 Adding Columns 29:33 Drop Table 32:38 Add Primary Key 33:17 Create Products Table 36:00 Create Orders Table 38:54 Foreign Keys 45:37 Joins 50:30 Functions/Group By 56:50 READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/learn-basic-sql-course/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 708801 Joey Blue
Sql Training Online - Sql And Or Statements
 
03:26
Learn about the "And" and "Or" filter in the SQL Language. Visit http://www.SqlTrainingOnline.com for more FREE videos. The Microsoft SQL Server 2012 And/Or are boolean operators that allow you to put multiple filters on the where clause of the SQL statement or query. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 12520 Joey Blue
Sql Training Online - Sql Max Function
 
02:38
Learn about the Maximum (max) function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 7251 Joey Blue
Sql Training Online - Sql Having
 
03:18
Learn about the Having filter in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 Having Clause is used with the Group By clause to filter results after the grouping has been completed. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 7594 Joey Blue
Sql Training Online - Sql Order By - Sorting
 
05:15
Learn about the Order By clause to sort in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 8287 Joey Blue
SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online
 
08:41
http://www.sqltrainingonline.com SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online In this video, I show you how to do a SQL Date Comparison in SQL Server when your Datetime has an actual time in it. I also include the latest trick that will make this easier if you are using SQL Server 2008 or SQL Server 2012. How do you compare a Datetime in SQL Server? A SQL Datetime stores both Date and Time. So when you are filtering using the SQL Where clause, you have to know if you Datetime is storing the time also. Let's take a look at the employee table in SQL Training Online Simple DB The column we are looking at is the hire date. I want to go after the person who was hired on February, 22 2005. So, I use the following SQL. select * from employee where hire_date='02/22/2005' Now, this works because we don't have any times stored in this column. But, if I change the record from 2005-02-22 00:00:00.000 to 2005-02-22 08:22:25.000 and rerun the query, you see that I don't get any results. That is because the value of 02/22/2005 is really 2005-02-22 00:00:00.000 and I just changed the hire_date to include a time other than 00:00:00.000. So, I have to tweak my query to use a greater than and less than sign. This works. But, to really understand what is going on, let me show you what SQL Server really sees. There are other ways, and in this StackOverflow article you can read more about these other ways. But, I want to point out a few. If you are working in SQL Server 2005 or earlier, the following is supposed to be the fastest performing way to do this. select datediff(dd,0, hire_date),* from employee where dateadd(dd,0, datediff(dd,0, hire_date)) = '2005-02-22' But, if you are working in SQL Server 2008 or SQL Server 2012, they have introduced an actual Date datatype that doesn't include the Time portion. Since this is the case, you can use the CAST function to remove the time from the Datetime. Here is the SQL to do that. select * from employee where CAST(hire_date AS Date) = '2005-02-22' And that's it. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 27275 Joey Blue
Sql Training Online - Sql Distinct
 
01:53
Learn about the Distinct statement in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 SQL distinct clause is used to remove duplicates in your resultset. You use it in the SQL column list. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 18753 Joey Blue
SQL Training Online - Excel to SQL Server - Part #3 - Bulk Insert
 
12:26
Excel to SQL Part #3 shows you how to use Bulk Insert to move data from Excel to SQL Server. http://www.sqltrainingonline.com/free-training-excel-to-sql-server/ To view all 5 free online videos in this training series and to download all of the training materials including the Microsoft Excel File, Tab Delimited File, CSV File, SQL files and Bat script, visit: http://www.sqltrainingonline.com/free-training-excel-to-sql-server/
Views: 26129 Joey Blue
Sql Training Online - Sql Between
 
03:10
Learn about the Between filter in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 Between operator allows you to filter on a range in the Where clause of your SQL statement. It is the same as a greater than or equal to and a less than or equal to. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 9778 Joey Blue
Sql Training Online - Sql Left Outer Join
 
04:19
Learn about the Left Outer Join in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 8969 Joey Blue
Sql Training Online - Sql Functions
 
02:36
Learn about Functions in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos. The Microsoft SQL Server 2012 SQL Functions are used transform data (such as convert or cast) or to group data (such as sum, min, max, average, count). They are used in the SQL statement and often used with the Group By clause. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 12348 Joey Blue
Sql Training Online - Sql Like Filter
 
03:20
Learn about the "Like" filter in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 7771 Joey Blue
SQL Isdate Function as a Filter with Cast - SQL Training Online
 
04:02
SQL Isdate Function checks if a varchar field is a valid date. If you use it in a where clause, you might need this little trick to make everything work. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/how-to-filter-using-sql-isdate-function-and-cast/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 1963 Joey Blue
Sql Training Online - Sql Min Function
 
03:07
Learn about the Minimum (min) function in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 6144 Joey Blue
SQL Moving Average - SQL Server Training, Subquery, Datediff, Dateadd
 
09:26
Moving Average in SQL can be inefficient leading people to say that you should use a cursor. This video shows a SQL Server method that is set-based and is faster than the cursor method. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/sql-moving-average/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SqlTrainingOnline.com FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 5868 Joey Blue
Year-to-Date using Partition By with Windowing - SQL Training Online
 
05:43
You can use the Partition By Function in SQL Server to get a Year-to-Date and Month-to_Date calculation. In this video I show you how to create a Year-to-Date value using the Windowing Partition By Function in TSQL. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/year-to-date-using-the-partition-by-function-with-windowing-in-sql-server/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 2044 Joey Blue
How to Use Datetime in SQL - SQL Training Online
 
05:10
http://www.sqltrainingonline.com How to use a Datatime in SQL. The datetime is actually made up of two different pieces: 1) Date 2) Time This can be demonstrated using the SQL Cast function on a string to convert it to a datetime. Here is some SQL for the Date portion: select cast('20121019' as datetime) Here is some SQL for the Time portion: select cast('10:05:00' as datetime) Now, you can also simply use the built-in getdate() function to bring back the current system time. select getdate() And finally, I want to bring back a datetime from an actual table. In this case, we will use the employee table from the SQL Training Online Simple DB: select hire_date from employee If we want to convert the result to a more formatted string, we will use the TSQL CONVERT function: select convert(varchar,hire_date,104) from employee In this example, we are converting from a datetime to a varchar (string). The result will be in the format of 104. To translate 104 to a datetime format, you will want to look at the MSDN Documentation. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 14335 Joey Blue
SQL Concat Function in SQL Server 2012 - SQL Training Online
 
02:55
SQL Server 2012 has a new CONCAT function that makes it easier to put strings together. I demonstrate how to use it in this video. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/how-to-use-the-sql-server-string-concat-function/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 2868 Joey Blue
SQL Add - How to Use Addition in SQL Server - SQL Training Online
 
03:58
http://www.sqltrainingonline.com SQL Add - How to Use Addition in SQL Server - SQL Training Online The SQL Add, or the Addition operator is used to add two numbers. I first want to take a look at the Employee table in the SQL Training Online Simple Database. select * from employee In particular, I want to look at the Salary and Commission columns. We can add those two columns together by using the plus sign (+), or addition operator in SQL: select salary ,commision ,salary + commision from employee But, since there can be nulls in the commission column, we need to handle that with the isnull function: select salary ,isnull(commision,0) as commision ,salary + isnull(commision,0) as total_compensation from employee Next, I want to show you how to add with a datetime. When you use the SQL Add operator, SQL Server will actually add the number in days. Here is an example: select hire_date ,hire_date + 2 as training_date from employee This example will add 2 days to the hire_date. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 2305 Joey Blue
Database Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training Online
 
35:40
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 the normal forms together. TABLE OF CONTENTS 1st Normal Form 1:07 2nd Normal Form 4:18 3rd Normal Form 9:44 4th Normal Form 13:50 Normalizing Customer Orders 17:33 Customer Table (2NF) 20:35 Product Table (2NF) 21:55 Order Header vs Order Lines 24:20 Product Table (3NF) 29:05 Customer Table (1NF, 4NF) 31:25 DOWNLOAD THE EXCEL FILE HERE http://www.sqltrainingonline.com/SQLNormalizationExcel READ THE ORIGINAL ARTICLE WITH EXCEL FILE HERE http://www.sqltrainingonline.com/sql-database-normalization/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR VIDEOS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 6481 Joey Blue
SQL Format Function - SQL Training Online
 
03:19
The Format Function can help you change how a date or decimal is displayed. In this video I do a quick demonstration of the Format Function. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/sql-server-format-function/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 1334 Joey Blue

Durham report pdf
How do i report a road/traffic incident to the police
Kilcunda fishing report 2019
Representation of women in advertising in india
Application letter for public health internship