Videos uploaded by user “Joes2Pros SQL Trainings”
How to Join 3 tables in 1 SQL query
Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit http://www.joes2pros.com Offer expires July 1, 2015 From the newly released 2 Disc DVD set (SQL Queries Joes 2 Pros Vol2) this video shows how to join 3 tables in 1 query.
Views: 251249 Joes2Pros SQL Trainings
Installing SQL Server 2008 Video Tutorial - Joes2pros
Get your first month for just $1 with code YOUTUBE1. Visit www.joes2pros.com Must redeem by July 1, 2015. This is a tutorial on Installing SQL Server 2008 using SQL Developer. By Visiting the Joes2Pros web site you can see videos on how other editions of SQL server are installed.
Views: 164295 Joes2Pros SQL Trainings
Introduction to creating Basic stored procedures in SQL Server 2008
Get your first month for just $1 with code YOUTUBE1. Visit www.joes2pros.com Must redeem by July 1, 2015. This is a great way for taking basic query knowledge and learning how to create stored procedures.
Views: 234653 Joes2Pros SQL Trainings
SQL Outer Joins (Using a Left,Right, and full Join)
From chapter 3.2 of Beginning SQL Joes 2 Pros (www.joes2pros.com). Learn how to find matches and exceptions with outer joins.
Database Design Tutorial on SQL Many-To-Many Relationships.
From Volume II of the SQL Joes 2 Pros Exam Prep Series for Exam 70-433. How to design Many-to-Many relationship.
Views: 101442 Joes2Pros SQL Trainings
Dynamic SQL 1 in 5 Minutes
Morelan describes Dynamic SQL as putting a puzzle together and when the pieces are together you finally see what it says. To do this you need to run the statement and produce results, Morelan covers this and how to do it throughout the video. If you thought this short blog was helpful, check out our Developer 2012 volume 4 14.1 class for a deeper dive into Dynamic SQL. We strive to be your leading authority in SQL so please give us feedback if you need to see something more. Be sure to tune in next week, we are going to be discussing SQL Injections. For our previous blogs, please refer to the archive. See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/
SQL Aggregation queries using Group By, Sum, Count and Having
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 169023 Joes2Pros SQL Trainings
Everything on Inner Join Queries in Under 10 Minutes!
Get your first month for just $1 with code YOUTUBE1. Visit www.joes2pros.com Must redeem by July 1, 2015. From chapter 3.1 of Beginning SQL Joes 2 Pros. Learn how to use basic inner joins to see two tables in one results set. Download the lab files here - http://bit.ly/1JKMoja
Views: 141721 Joes2Pros SQL Trainings
SQL 2008 Finding Duplicates Records Lab 5.1
SQL Finding Duplicates by Rick Morelan
SQL query tutorial (wildcard queries)
From chapter 2.2 of Beginning SQL Joes 2 Pros (www.joes2pros.com). How to use range and pattern matches in a basic single table query in SQL server 2005 and 2008. Full Video is a free download at www.Joes2Pros.com along with a PDF book sample.
Benefits of Common Table Expressions
On this episode of Joes 2 Pros SQL server unlocked series we present a topic for anyone who has ever been exposed to SQL Server, Common Table Expressions. A CTE is memory resident table. You are pulling from that query and giving it a name. This table adds enhancements to the old tables. It allows you to open up to new people without having an increased security risk. This is extremely beneficial for anyone who is exposed to SQL Server as keeping your content safe is a top concern for most organizations. In this video, he will take you through a very real example from a department store quarterly reporting. He wants to do a seasonal reporting from all the departments of a store excluding snow sports and cooking. He shows you how to make the code more simple and reduce human error. Having CTE knowledge will be greatly beneficial to you in your everyday career. Please be sure to follow along our blog series. Stay tuned next week to learn more about Dynamic SQL. To learn more about he benefits of common table expressions view our course Developer 2012 Volume 2 Video 10.1. See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/
Clustered Index Basics for SQL Server
This topic from Chapter 8 of the "SQL Architecture Basics Joes 2 Pros" Book or Video DVD on Amazon. You can see what a clustered index is and how to create it.
Introduction to SQL Constraints
From Chapter 1 of the upcoming SQL Programming Joes 2 Pros (Vol4) Book. This is a lesson on the types of contraints you can use in SQL server and how it helps with Data Integrity. This book will be published on June 29th 2011.
Query Execution Plans
SQL Server Unlocked Series- Query Execution Plans In this video, we will be discussing query execution plans and how to use them properly. In this video, Morelan starts out with an analogy relating SQL Server to your kid. I know this sounds pretty far-fetched, but he has a point, so give it a chance. He goes on to describe how you want SQL Server to perform to the best of its ability, same as you would want your kids to do, hence why we use query execution plans. Additionally, If you lose something such as your keys, you probably want a tool that shows you how to find that item, if you set up your SQL server right, this is just the tool- not to find the keys but to find data. All-in-all SQL server can save you time if you use it right and you know how to use it right. This mini-series is a good starter on how to do so. Have a look at the video, and if you want to learn more, take our class Developer 2012 Volume 3 Video 9.1. See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/
SQL Query Time Saver Tricks (Query writing tips with table and field aliasing) ch4.1
From Chapter 4.1 of Book 1 (Beginning SQL Joes 2 Pros). This video shows you how to make writing complicated queries easier with aliasing. This includes the best way to write multiple table queries.
SQL Server Tutorial - Introduction to 2008 (Beginning Query lesson on Single Table Queries)
Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit www.joes2pros.com Offer expires July 1, 2015 From Chapter 2.1 of Beginning SQL Joes 2 Pros (www.joes2pros.com). How to use exact criteria matches in a basic single table query in SQL server 2005 and 2008.
Views: 320485 Joes2Pros SQL Trainings
Introduction to SQL (Beginning Database Training) "Geek Speak" Joes2Pros ch1.2
From chapter 1 of Beginning SQL Joes 2 Pros (www.joes2pros.com). Learn the basic terms or Geek Speak used by SQL Server database professionals.
Basic Subqueries in SQL Server
From Chapter 11 of SQL Queries Joes 2 Pros ® Volumne 2. This shows how to use a basic subquery.
Best Way to Write Basic SQL Queries
SQL Server Query writing strategies is something I have yet to find in any book. When enthusiastic SQL students do this, they experience a revelation. The number of errors drops significantly and the speed at writing complex queries increases immediately. Knowing how to narrow down what we are looking for amongst a vast list of choices helps immensely. Grabbing the right tables first and then the fields second is akin to grabbing the right menu before ordering an item from it. In fact, one student named Tim took this back to his team of SQL developers and they immediately implemented this process. We are all used to following steps. Most of the time, actions are sequential from top to bottom or left to right. Other times we complete things in phases. The two phases we are going to use in this exercise apply to joining tables. This is easy to implement as we only need remember to organize first and clean up second. When visiting a new restaurant, we will ask to see the menu, because we want to see all they have to offer. The odds are that we might be interested in half of the items, but only need a few dishes for our group at the table. Looking at the menu is like starting a query with a ‘SELECT *’ statement. Once we have looked at all the fields, we narrow our choice(s) to only the items we want at the time. Sometimes restaurants have multiple menus. My favorite restaurant has a kids’ menu, an adult menu, a gluten-free menu and a drink menu. These menus were each gathered at our table. Ultimately, in my head, a selection was narrowed to what was needed. Phase I: Organize. When building a new query from many tables, we often find ourselves wondering, “Where do I start?” First, lay the steps out by identifying which tables contain the essential data. Second, get all the table joins working with a basic ‘SELECT *’ statement. Third, add any basic filtering criteria. Phase II: Itemize. Once all joins and criteria, such as SELECT, FROM and WHERE are working, we are ready for Phase II. This entails going back and changing our ‘SELECT *’ to an itemized SELECT field list as the final step. Let’s explore how this two-phase process of Organize and then Itemize can be a big time-saver. We are going to use one of the challenges from the last lab. In Lab 3.2 (Outer Joins), Skill Check 2, we needed to get four fields from two different tables. If we were to list all four desired fields and test one table at time, we will get an error as seen on the right side of the figure below. In the figure below we write a SELECT statement and part of the FROM clause. When completed, the FROM clause will have two tables, but for now we just want to get the Location table working. By using the ‘SELECT *’ strategy, we remove any possible errors from line 1. From there, we can focus on the more complicated logic used for joining tables together. We can add tables one at a time until everything is working. This is the Organize phase. NOTE: SELECT * never results in an Error message stating “invalid column name”, however; a SELECT list with itemized field(s) can have this error. After our query is organized and working, we can go back and itemize the SELECT field list to display only the fields that are necessary. This is done during Phase II (Itemize). The steps for this system are broken down as follows: Since SELECT is always the first statement in a query, it’s natural to want to write the field names before writing the FROM clause. However; we can save time and trouble by using the ‘*’ until the entire query is working properly. When this is complete, it is very easy to itemize the field list, with the confidence of knowing it will not cause any problems. Exercise: Simple membership for a club: Table1 (id_Member,name_Member, email_member, title, age, company) Table2 (id_Club,club_name, club_Location, address) Table3 (id_club, id_member,membership_date) Q1: Show all member names, email, age, and company from Table1 Q2: Show all club name, location, and address data Q3: Show member name, club name, club location (hint: Use joins and all 3 tables) You can find all other classes related to this video here: http://www.joes2pros.com/joes2pros/Course/Introduction_To_Microsoft_SQL_Server Enroll Today & Get the First Month for only $1! Use code: YOUTUBE1
Views: 213953 Joes2Pros SQL Trainings
Quick SQL MGMT Studio Tips
SQL Server Unlocked- SQL Server Management Studio tips Thanks for coming back for another episode of our Joes 2 Pros SQL Server Unlocked Series. In this episode we discuss some different tips and tricks to get SQL Server Management Studio to work for you. As you may already know, SQL Server Management Studio allows you to access, configure, manage, administer, and develop all components of SQL Server. In this example Morelan compares SQL Server Management Studio Tool to driving your car and more so, knowing how to operate your car. He first dives into a real basic example you and troubleshoots a common problem a lot of people run into when first jumping into their management tool. He later dives into some other tips that make collaborations easier as well as other tools to save you time. We hope you are enjoying our blog series. If you want to learn more about SQL Server Management tips, have a look at Volume 1 lab 2.1, as this lab covers some additional aspects. Please let us know if you have questions and stay tuned for next time! See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/
SQL Database File Structures (MDF & LDF)
This is the first lesson of Vol 3 in the SQL Joes 2 Pros SQL Dev series (SQL Architecture Basics Joes 2 Pros). Learn where SQL stores its data on your system and what affect size and placement. The full video and next video on how to use NDF files can be found at the Joes2Pros web site.
Aggregations Made Easy in just 5 minutes
SQL Aggregations Made Easy with SQL Server Unlocked Welcome to our first edition of our SQL Server unlocked Series. In this video our hosts Rick Morelan and Bally Kehal discuss how to make sql aggregations simple. Morelan has written over 15 book discussing database administration and SQL Server and prior to becoming the CTO and Tech expert at Social27, Kehal worked at Microsoft for a number of years. Morelan begins with a country vs. state population analogy which leads into the topic of discussion, invoices. To refresh your memory, aggregate functions make an important impact in SQL as they perform a calculation on a set of values, and then return just one value. As an important sidenote, aggregate functions typically ignore null values and they are used often with the GROUP BY clause of the SELECT statement In the video, he shows you how to change the grain of a large collection of invoices per customer and the amount of transactions that customer has. At the end of the day, aggregations are an essential part to SQL Server and sometimes something that may seem more difficult than necessary. Databases have different ways of implementing things and rules don’t always apply the same way. Watch the video to learn more. If you enjoyed what you learned this week. Stay tuned for our next week’s blog “Easy Aggregation Tricks” and view our class Developer 2012 Volume 2 Video 4.1. See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/blog/2015/05/01/aggregations-made-easy/
Learn Expert Aggregations Tricks in 5 Minutes
See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/
SQL Queries with Expression Fields (How to put Calculated Columns in a Query)
From chapter 3 of Volume 2 of SQL Queries Joes 2 Pros. This shows how to put calculations as new fields in your queries. You can follow along for free even if you don't have the book. To get the JProCo database on your system watch my other video on "Installing Your Joes2Pros Labs".
Quick Basic Sub Queries
Welcome back to Joes 2 Pros SQL Server Unlocked Series. Today we will be discussing our easiest topic yet, Basic Subqueries. Basic subqueries are an important part of SQL Server. Watch Morelan’s easy-to-follow demonstration to learn how to perform basic subqueries. He will show you from start to finish how to perform a basic sub query in an easy to digest presentation. Once you have this mastered, have a look at our Developer 2012 Volume 4 video 14.2 to learn more. Do you like the content of our blog and want to learn more? Have a look at our previous posts as well as check out some free content in our academy. Feel inspired or have questions? Leave us a comment below! See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/