You are here
Home > 2017 > June

70-761 Exam Ref. Book Review

QUERYING DATA WITH TRANSACT-SQL 70-761 BOOK REVIEW Title: Querying data with Transact-SQL Exam Ref 70-761 Author:  Itzik Ben-Gan Publication Date: April 2017 Publication House: Published with the authorization of Microsoft Corporation by: Pearson Education, Inc. About Author: Itzik Ben-Gan is a T-sql instructor and co-founder of solidQ. Itzik has given many events focusing on T-SQL

Update Statement

UPDATE STATEMENT In this post we will discuss about update statement in SQL server 2016. UPDATE: SQL support the update statement to allow us to modify or change the existing data in a tables. The update statement in SQL either update all the rows from a table or a selected set of

Learn SQL Part-3

LEARN SQL: PART-3 In this post we will discuss DEFAULT, CHECK,UNIQUE constraints with example. DEFAULT: Default constraint inserts the default value into a column when you do not provide value for column. At the time of table creation default value is assigned to column. the datatype of the value should match the

Learn SQL Part-2

LEARN SQL: PART-2 In this post we will discuss constraints in SQL server. SQL constraints are used to specify rules for storing data in to table. Constraints defined rules that must be applied to data before storing them into database/table to ensure integrity. Only data, which satisfies the conditions will be

Learn SQL Part-1

LEARN SQL: PART-1 First we will understand some important points in sql like data,schema,database,tables etc... What is data? A data can be facts related to any object in this world. Ex: a person can have name, phone no, birthdate, gender etc. What is database? Database means to store information about a business. It a systematic

SQL QUIZ PART-3

Welcome to SQL quiz. we have list of questions and there is no time limit for giving the answer. this quiz improve your SQL and database knowledge.We have divided SQL quiz into three parts.     Keep Visiting TechwithR.com for more upcoming top technical articles. Detail course about DBA visit TechNet Consultancy You can

SQL QUIZ PART-2

Welcome to SQL quiz. we have list of questions and there is no time limit for giving the answer. this quiz improve your SQL and database knowledge.We have divided SQL quiz into three parts.     for sql next quiz go to sql-quiz-part-3 Keep Visiting TechwithR.com for more upcoming top technical articles. Detail course about

Top