• How to Optimize MySQL Queries with Query Profiler by Devart
    Articles,  Blog

    How to Optimize MySQL Queries with Query Profiler by Devart

    Welcome to dbForge Studio for MySQL Tutorials. Let’s learn how to optimize your queries in a visual mode without much effort, using the Query Profiler tool. On the Start Page, click Query Profiler. Let’s create a query that sums the salary and calculates the average value for a particular employee. As you can see, the Join condition is promted. To expand columns, press Tab key, and change the output columns. For this query the SUM and the Average functions are avalible, The Where expression is promted. As you see, the Columns list, and the Group By expression are also avalible. Now let’s execute the query and see the profiling results.…

  • SQL Server interview questions :- What are Sub Query and Co-related Queries ?
    Articles,  Blog

    SQL Server interview questions :- What are Sub Query and Co-related Queries ?

    In this video will talk about what is a subquery what are co-related queries and what’s a difference between subquery and co related queries so first let start the subquery subquery also termed as nested queries subquery is nothing but it’s a query inside a query many times you know you would like to you have series of SQL chained you know where output of one query is sent as the input to the other query for filtering and manipulation for example you can see in the figure you know we have two tables one table has the employee salary and the second table has phone numbers now let say…

  • Articles

    Getting Started with T-SQL Queries using SQL Server Management Studio

    Hi. I’m Jason Roth. In the previous videos, we installed SQL Server 2008 and began using SQL Server Management Studio. In this video, I’m going to show you how to write basic database queries in SQL Server 2008. I’m also going to provide some tips and tricks along the way. Let’s start by launching SSMS. On the “Start Menu”, expand “Microsoft SQL Server 2008 R2”, and then click “SQL Server Management Studio”. Type the name of your SQL Server instance, and then click Connect. In our first video, “What is a Relational Database?”, we introduced a fictional database that contained experiment data. This database has three tables: Experiements, Runs, and…