Name: SQL Interview Questions
Price: 19.95 USD
ISBN: 9789389328462

BPB Online LLP

Prasad Kulkarni

SQL Interview Questions

US$ 19.95

Buy eBook Now Gift eBook

The publisher has enabled DRM protection, which means that you need to use the BookFusion iOS, Android or Web app to read this eBook. This eBook cannot be used outside of the BookFusion platform.

Description

Contents

Reviews

Let us break the SQL interview with the help of SQL Server interview questions.

Key Features
Database Basic Concepts
SQL Fundamentals
DDMS, SQL Statements, and Clauses
SQL Operators, Datatypes, and Keywords
SQL Functions, Wildcards and Dates
SQL Joins and CASE Statement
SQL DDL, DCL, and DTL Statements
SQL Stored procedures, Triggers, Views, and Transactions
SQL Keys, Indexes, Injection, and Constraints
SSRS, SSIS, SQL Cloud database (Azure), and JSON Support
New features of SQL 2016, 2017, and 2019
SQL Performance Improvement Tips
Fuzzy Interview Questions and Answers

Description
This book gives you a complete idea about the SQL database. It starts from a very basic concept like what is a database, its usage, types, creation, and data storage, security, sorting, and searching for a stored procedure. This book is a complete set of interview breaking questions and answers with live examples and plenty of screenshots. This book takes you on a journey to mastering the SQL database, including SQL datatypes, functions, triggers, and stored procedures. This book also covers the latest and new features of SQL 2016, 2017 and 2019 CTP with examples.
In the beginner section, we start with very basic concepts like what is a database, why to use a database, different types of database types, what is SQL, its usages, advantage and disadvantages, SQL datatypes, its different operators and how to use them with samples.
In the intermediate section, we will learn about the different SQL functions, SQL Joins (used to fetch values from multiple SQL tables) and SQL DDL, DCL, and DTL commands.
(About the last chapters) This is the advanced section of the book where we have provided an explanation of the SQL stored procedure, triggers and SQL view concepts, additionally, we have covered SQL core concepts like keys, indexes, injections and constraints. We have also introduced cutting-edge concepts like SSRS, SSIS, SQL Cloud database (Azure), JSON Support and a list of the new features of SQL 2016, 2017, CTP-2019 with SQL performance improvement tips. Finally, we have ended the book with a series of random SQL questions and answers.

What you will learn
After reading this book, you will be able to understand SQL database concepts, handle core database activities like data security, searching, migration, and sorting. You will be able to handle the database transactions, use different SQL datatypes, functions, triggers, and stored procedures to save and retrieve data from the database. You will also be able to understand advanced SQL concepts like SQL reporting services, integration services, cloud database and new features from the latest SQL versions like 2016, 2017, and 2019.

Who this book is for
This book is built in such a way that it is useful for all categories such as technical or non-technical readers. This book is perfect. If you are a fresher and you want to learn about SQL, or if you are a teacher and you want to spread SQL knowledge, this book is very helpful. If you want to crack the database interview or if you are working as a DBA and you want to upgrade your knowledge, or if you are backend developer, database tester, performance optimizer, or if your role is that of a database admin, SQL developer, data analyst, mobile app developer or if you are working on core SQL concepts, this book is just right for you.
This book is very useful as it contains many simple real-time scenarios for each concept. All functionalities are explained with real SQL screenshots and database records.

Table of Contents
1. Database and SQL Basics
2. DDMS SQL Statements and Clauses
3. SQL Operators, Keywords, and Datatypes
4. SQL Operators
5. SQL Functions, Wildcards, and Dates
6. SQL Joins and CASE Statement
7. SQL DDL, DCL, and DTL Statements
8. SQL Stored Procedures, Triggers, Views, and Transactions
9. SQL Keys, Indexes, Injections, and Constraints
10. SSRS, SSIS, SQL Cloud database (Azure), and JSON Support
11. New features of SQL 2016, 2017, and 2019
12. SQL Performance Improvement Tips and Fuzzy Interview Questions

About the Author
Prasad Kulkarni is a Microsoft MVP reconnect, Technical leader, Author, Agile Scrum Master and Blogger. He has 13 years of core experience in Microsoft technologies such as SQL, ASP.NET, MVC, ASP.NET Core, VB.NET, SQL server, word Automation, Office development etc. and other technologies such as HTML, CSS, jQuery, JavaScript, Bootstrap, and XML etc. He is very passionate about Microsoft .NET technology. He likes to write articles and blogs on different aspects of SQL stuff and .NET, also like to help developers resolve their issues and boost them on Microsoft Technologies.
Prasad has impressive certifications as Microsoft Certified Professional (MCP), Microsoft Certified Technology Specialist (MCTS) and Agile Scrum Master, Prasad was also awarded the most valuable member at dotnetspider, most popular curator, most active curator, and featured curator at Microsoft Curah, and editor at dotnetspider, he has awarded for his articles on codeproject.

LinkedIn Profile: https://in.linkedin.com/in/prasad-kulkarni-389152a5

Language

English

ISBN

9789389328462

structured query language

sql interview questions

mssql

mssqlserver

database administrator

Cover Page

Title Page

Dedication

About the Author

About the Reviewer

Acknowledgement

Preface

Errata

Table of Contents

1. Database and SQL Basics

Introduction

Data, database, and DBMS

Usage of database

Different types of DBMS

Navigational DBMS (Hierarchical DBMS)

Network DBMS

Relational DBMS (RDBMS)

Object-oriented database management (OODBMS)

Object-relational database management system (ORDBMS)

No-SQL databases

Structured Query Language (SQL)

Data Definition Language (DDL)

Data Manipulation Language (DML)

Data Control Language (DCL)

Transaction Control Language (TCL)

Usage of SQL

SQL query execution plan

SQL tables

Advantages and disadvantages of SQL

Rapid fire questions and answers

Conclusion

Do you know (lights on fact?)

2. SQL Statements, Keywords, and Datatype

Prerequisite for this chapter

Structure

SQL keywords

SQL datatypes

Numerical SQL datatypes

Exact numeric

Approximate numeric

The string and char SQL datatypes

Character string

Unicode string

Binary string

Date and time SQL datatypes

Date

Time

Datetime

Miscellaneous SQL datatypes

SQL statements

DDL statement

Create

Alter

Drop

Truncate

DML statement

Insert

Update

Delete

Select

Conclusion

Rapid fire questions and answers

Do you know (lights on fact?)

3. SQL Statements and Clauses

Introduction

Structure

Objective

Data Control Language (DCL) statement

GRANT command

Transaction Control Language (TCL) statement

COMMIT command

ROLLBACK command

SAVE command

WHERE clause

FROM clause

DISTINCT clause

ORDER BY clause

GROUP BY clause

HAVING clause

Conclusion

Rapid-fire questions and answers

Do you know (lights on fact?)

4. SQL Operators

Introduction

Structure

Objective

Types of operators

Arithmetic operators

+ (for addition)

- (for subtraction)

* (for multiplication)

* (for division)

% (for modulo)

Comparison operators

= (Equals)

> (Greater than)

< (Less than)

>= (Greater than or equal to)

>= (Less than or equal to)

<> (Not equal to)

ANSI_NULL

SOME

Logical operators

AND operator

OR operator

BETWEEN operator

IN operator

ALL operator

ANY operator

EXISTS operator

NOT operator

Assignment operators

Bitwise operators

Set operator

EXCEPT

INTERSECT

UNION

String concatenation operator

Conclusion

Rapid fire questions and answers

Do you know (lights on fact?)

5. SQL Functions and Wildcards

Structure

Objective

SQL functions

Configuration functions

SET DATE FIRST

@@DATEFIRST

@@DBTS

@@LANGUAGE

@@LANGID

@@MAX_CONNECTIONS

@@LOCK_TIMEOUT

@@MAX_PRECISION

@@REMSERVER

@@SERVERNAME

@@ SERVICENAME

@@VERSION

@@TEXTSIZE

Conversion functions

CAST

CONVERT

TRY_CAST

Cursor functions

Logical functions

Mathematical functions

ABS

CEILING

COS

COT

EXP

FLOOR

LOG

LOG10

POWER

RAND

ROUND

SQUARE

SQRT

TAN

Aggregate functions

AVG

COUNT

MAX

MIN

SUM

Metadata functions

COL_LENGTH

APP_NAME()

DB_NAME()

Security functions

CURRENT_USER

HAS_DBACCESS

IS_MEMBER

String functions

ASCII

LEFT

LEN

LOWER

Wildcards in SQL

% character

_ character

[] character

Conclusion

Rapid fire questions and answers

Do you know (lights on facts?)

6. SQL Dates Joins and Case

Introduction

Structure

Objective

SQL date related functions

SYSDATETIME

SYSDATETIMEOFFSET

SYSUTCDATETIME

CURRENT_TIMESTAMP

GETDATE

DATENAME

DATEPART

YEAR/MONTH/DAY

DATEDIFF

DATEDIFF_BIG

DATEADD

ISDATE

SQL joins

Inner join

Left-outer join

Right-outer join

Full-outer join

Cross join

CASE statement in SQL

Conclusion

Rapid fire questions and answers

Do you know (lights on facts?)

7. SQL DDL, DCL, and DTL Statements

Structure

Objective

DDL, DCL, and DTL statements

CREATE statement

DROP statement

ALTER statement

TRUNCATE statement

GRANT statement

REVOKE statement

COMMIT TRANSACTION statement

ROLLBACK TRANSACTION statement

Attaching and de-attaching a database

Attaching a database

Using SQL Management Studio

Using SQL Query analyzer

De-attaching a database

Using SQL Management Studio

Using SQL Query analyzer

Conclusion

Rapid fire questions and answers

Do you know (lights on facts?)

8. SQL Stored Procedure and Triggers

Structure

Objective

SQL stored procedure

Types of SQL stored procedure

System/inbuilt stored procedure

Catalog SP

Db Engine SP

Security SP

User defined stored procedure

Temporary procedure

Creating stored procedure (SP)

Modifying stored procedure (SP)

Deleting stored procedure (SP)

Executing stored procedure (SP)

Renaming stored procedure (SP)

SQL triggers

DML triggers

Creating a trigger

Executing trigger

Deleting and renamingtrigger

DDL triggers

Conclusion

Questions

Do you know (lights on facts?)

9. SQL Views, Keys, Indexes, Injections, and Constraints

Structure

Objective

SQL view

Types of SQL view

Indexed views

Partitioned views

System views

Creating a SQL view

Updatable view

Partitioned view

Modifying view

Deleting view

Deleting a view using SQL Management Studio

Deleting view using SQL Query analyzer

Identity column

Using SQL Management Studio

Using SQL Query analyzer

@@identity

SQL keys and its types

Primary key

Using SQL Management Studio

Using SQL Query analyzer

Candidate key

Unique key

Composite key

Foreign key

Using SQL Management Studio

Using SQL query analyzer

Superkey

Alternate key

SQL indexes and its types

Clustered index

Non-clustered index

SQL injection

How SQL injection attack carried out?

Using OR 1=1 condition

Using “or” “=”

Using batch SQL queries

Preventing SQL injection

SQL constraints

Conclusion

Questions

Do you know (lights on facts?)

10. SSRS, SSIS, SQL Cloud Database (Azure) and JSON Support

Structure

Objective

SQL reporting services (SSRS)

Mobile reports

SSRS benefits and drawbacks

Alternative to SSRS

Usage of SSRS

SQL Integration Services (SSIS)

SSIS architecture

Data flow

Control flow

SSIS package

Usage of SSIS

Cloud DB (Azure DB)

JSON support

Conclusion

Questions

Do you know (lights on facts?)

11. New Features of SQL 2016, 2017, 2019

Introduction

Structure

Objective

New features of SQL 2016

SQL Server edition

Secure encryption

Data masking

Support to JSON

Auto temp DB

Secure your row

Stretch database concept for cloud DB

Query store

Temporal database

Working with R

New features of SQL 2017

Automatic tuning

Correct identity

Graph database

Cross database connectivity

DTA (database tuning advisor)

Machine learning

Wide-ranging Linux support

New string functions introduced in SQL 2017

STRING_AGG

TRIM

CONCAT_WS

TRANSLATE

Features of SQL 2019

Index encrypted columns

Transparent data encryption scan

SSL/TLS certificates

Big Data cluster

New graph function shortest path

Partition tables and indexes

OPTIMIZE_FOR_SEQUENTIAL_KEY

Build and rebuild online clustered column store index

Hybrid buffer pool

Query external tables

VERBOSE_TRUNCATION_WARNINGS

Accelerated database recovery

Conclusion

Questions

Do you know (lights on facts?)

12. Fuzzy Interview Questions and SQL Performance Tips

Structure

Objective

Performance improvement tips for SQL server

SQL tips

Fuzzy interview questions and answers

Index