Sql Server Videos (23) - Page 1

Watch free Video tutorials by the selected registered members. If you also want to share video tutorials, please let us know for approval.

23 records found.
 
Learn SQL basics step by step. 
Last updated on: 18 Dec 2018 03:44:42 AM by Questpond | Views: 713 | Category: Sql Server
In this 1 hour tutorial we will learn about SQL query basic writings lesson by lesson. It will cover 30 SQL statements on Select, Update, Insert and Delete operations.
Database Normalization beginners tutorial. 
Last updated on: 24 Sep 2018 12:37:01 AM by Questpond | Views: 1296 | Category: Sql Server
In this tutorial will try to understand the detailed concepts of Database Normalization, Normal Forms, Database Design Problems, Duplicate and Redundancy, Atomic and Repeating groups, Design issues of Partial Dependency, Transitional Dependency and many to many design.
Explain Columnstore index in SQL Server. 
Last updated on: 08 Sep 2017 02:52:09 AM by Questpond | Views: 1186 | Category: Sql Server
In this video tutorial will try to understand about Columnstore index in SQL and the use of it.
Learn SQL Server step by step tutorial - Part 1 ( Beginner series) 
Last updated on: 10 Dec 2016 07:31:26 AM by Questpond | Views: 1678 | Category: Sql Server
In this video we will learn SQL Server step by step in 16 hours.
Learn MSBI ( Microsoft Business Intelligence ) in 4 days ( SSIS , SSAS and SSRS) 
Last updated on: 16 May 2015 06:14:30 AM by Questpond | Views: 5442 | Category: Sql Server
This is a full 1 hour of MSBI (Microsoft Business Intelligence ) training which has the following Agenda :- 1. BI life cycle 2. Role of SSIS , SSAS and SSRS 3. Tools needed to start MSBI 4. Uploading a simple CSV file in to SQL using SSIS ( ETL demo) 5. Data flow and Control flow 6. How to see errors in MSBI 7. Project structure of MSBI project 8. Revision and exercise.
  • MSBI Demo Class 
    Last updated on: 18 Jul 2014 04:37:31 AM by Kapilbisp | Views: 1710 | Category: Sql Server
    Introduction to MSBI
    Differences between ISNULL and NULLIF - sql server interview questions 
    Last updated on: 12 Dec 2013 09:52:47 AM by Sqldev | Views: 18787 | Category: Sql Server
    Hi friends, in this session I am gonna discuss the differences between ISNULL and NULLIF. Both ISNULL and NULLIF are built in system functions in sql server. Lot of people get confused between these 2 system functions. Lets discuss about each of these system functions separately so that you will get better idea. 1st lets discuss about ISNULL. ISNULL: ISNUL is a system function which replaces NULL with the specified replacement value. The functionalityof ISNULL is : 1. 1st it will Evaluate the expression which is in parameter 1. 2. it will compare the evaluated expression with null. if the paramter 1 = NULL ? 3. If parameter1 is equal to null i.e., if parameter 1 is null, then isnull function returns replacement value. if parameter1is not NULL, then ISNULL function returns parameter1 I hope we are clear on ISNULL. Lets move on to the next system function, that is NULLIF. NULLIF: NULLIF is a system function which returns a null value if the two speci ...
    Differences between primary key and unique key - SQL Server Interview Questions 
    Last updated on: 28 Nov 2013 11:47:28 AM by Sqldev | Views: 24131 | Category: Sql Server
    Hi Friends, In this in this session we are going to learn the differences between primary key and unique key This is one of the most frequently asked sql server interview questions. Before we discuss the difference between primary key and unique key, let's see what a primary key is and what a unique key is. Primary Key: Primary key is a key which uniquely identifies each row/record in the table. This implies if you have a primary key on a table, you can identify each and every row in that table uniquely using primary key. Unique Key: Unique key constraint enforces the uniqueness on the columns in which it is defined. That is Unique key will make sure only unique values are allowed in the columns in which it is defined. Similarities: Both Primary key and unique Key enforces uniqueness on the columns on which they are defined. • Primary key and unique Key columns allow only unique values. • Primary key and unique Key columns will avoid duplicates • Both Primary ...
    SSIS Lesson 3 - Extra data from a sql server table into a Flat file using SSIS import and Export wizard 
    Last updated on: 04 Oct 2013 10:44:39 AM by Sqldev | Views: 2690 | Category: Sql Server
    Hi friends, I was busy with some personal works these day. So, I couldn't share my knowldge with u. I am back with a new video tutorial on SSIS. Here is my latest ssis video tutorial on how to extract data from a sql server table into a flat file:
    SQL Server interview question :- Find the second highest salary ? 
    Last updated on: 01 Apr 2013 12:21:01 AM by Questpond | Views: 6736 | Category: Sql Server
    Many times during SQL server interviews , many of them ask this tricky question "Find the second highest or 3rd highest from a given table" or probably they can also vice versa saying "Find the second or third lowest from a given table". In this video we will try to answer the same.
    SSIS Tutorial 2 - Load data from excel file into sql server table 
    Last updated on: 04 Oct 2013 10:50:19 AM by Sqldev | Views: 4304 | Category: Sql Server
    Hi friends, this video will demonstrate how to create a new SSIS package using SSIS import and export wizard. In this ssis tutorial, example to load data from excel into sql server table is very well explained. Hope this ssis tutorial will help you learning ssis.
    SSIS tutorial 1 - Introduction to SSIS 
    Last updated on: 04 Oct 2013 10:49:25 AM by Sqldev | Views: 4628 | Category: Sql Server
    Hi friends, This ssis video tutorial will give you brief introduction to ssis and will guide you about how to start ssis.