The 9 Best Study Tips For 70-461 Certification

70-461 Exam Preparation

  You can do this!  Pass exam 70-461. It may seem intimidating, but you can pass Exam 70-461 Querying SQL Server.  All it takes is a bit of planning and basic study tips. AsapScience explains in less than four minutes study habits you can use today to get the most out of your exam prep…

Continue Reading →

What is the Difference Between Cast and Convert?

Cast and Convert

In this article we’re going to explore the CAST and CONVERT functions to understand whether there are any significant differences worth knowing when we want to convert data from one type to another. Since CAST and CONVERT can be used interchangeably in most situations, you may be wondering if one is better than the other.…

Continue Reading →

What is the Difference between Inner and Outer Joins?

Single_Chromosome_Mutations.svg

Both inner and outer joins can be used to combine data from two or more tables; however, there are some key differences!  Read this article to find out each command’s strengths and when to use them. To get the most of this and our other lessons be sure to practice using the examples! All the…

Continue Reading →

What Is the Difference Between a Join and a UNION?

UnionAndJoin

Both Joins and UNIONS can be used to combine data from two or more tables.  Read this article to find out each command’s strengths and when to use them. To get the most of this and our other lessons be sure to practice using the examples! All the examples for this lesson are based on…

Continue Reading →

Introduction To SQL Server’s Date Functions

Calendar

SQL server’s date functions provide you a set of function that you can use to manipulate dates.  The function are used for a wide variety of operation such as adding weeks to a date, calculating the difference between two dates, or to decompose a date into its fundamental parts. If you not familiar with SQL…

Continue Reading →

Page 1 of 18