SQL Interview Questions: A complete question bank to crack your ANN SQL interview with real-time examples
暫譯: SQL 面試問題：完整的問題庫，助你成功通過 ANN SQL 面試，並附有實際範例
Kulkarni, Prasad
- 出版商: BPB Publications
- 出版日期: 2019-11-04
- 售價: $1,210
- 貴賓價: 9.5 折 $1,150
- 語言: 英文
- 頁數: 308
- 裝訂: Quality Paper - also called trade paper
- ISBN: 9389328462
- ISBN-13: 9789389328462
-
相關分類:
SQL、面試技巧
無法訂購
相關主題
商品描述
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.
What will you 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. Your LinkedIn Profile: https: //in.linkedin.com/in/prasad-kulkarni-389152a5
Key Features
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.
What will you 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. Your LinkedIn Profile: https: //in.linkedin.com/in/prasad-kulkarni-389152a5
商品描述(中文翻譯)
讓我們透過 SQL Server 面試問題來破解 SQL 面試。
主要特點
描述
本書提供了有關 SQL 資料庫的完整概念。它從非常基本的概念開始，例如什麼是資料庫、其用途、類型、創建、數據存儲、安全性、排序和查詢儲存過程。本書是一套完整的面試破解問題和答案，並附有實例和大量截圖。本書帶您踏上掌握 SQL 資料庫的旅程，包括 SQL 資料類型、函數、觸發器和儲存過程。本書還涵蓋了 SQL 2016、2017 和 2019 CTP 的最新和新特性，並附有示例。
您將學到什麼
閱讀本書後，您將能夠理解 SQL 資料庫概念，處理核心資料庫活動，如數據安全、查詢、遷移和排序。您將能夠處理資料庫交易，使用不同的 SQL 資料類型、函數、觸發器和儲存過程來保存和檢索資料。您還將能夠理解高級 SQL 概念，如 SQL 報告服務、整合服務、雲端資料庫以及最新 SQL 版本（如 2016、2017 和 2019）的新特性。
本書適合誰
本書的編寫方式使其對所有類別的讀者（技術或非技術）都有用。本書非常適合。如果您是新手並想學習 SQL，或者如果您是教師並希望傳播 SQL 知識，本書將非常有幫助。如果您想破解資料庫面試，或者如果您是 DBA 並希望提升您的知識，或者如果您是後端開發人員、資料庫測試員、性能優化員，或者您的角色是資料庫管理員、SQL 開發人員、數據分析師、移動應用開發人員，或者如果您正在處理核心 SQL 概念，本書正是為您而寫。本書非常有用，因為它包含了每個概念的許多簡單實時場景。所有功能都用實際的 SQL 截圖和資料庫記錄進行解釋。目錄
1. 資料庫和 SQL 基礎
2. DDMS SQL 語句和子句
3. SQL 運算子、關鍵字和資料類型
4. SQL 運算子
5. SQL 函數、通配符和日期
6. SQL 連接和 CASE 語句
7. SQL DDL、DCL 和 DTL 語句
8. SQL 儲存過程、觸發器、視圖和交易
9. SQL 鍵、索引、注入和約束
10. SSRS、SSIS、SQL 雲端資料庫 (Azure) 和 JSON 支援
11. SQL 2016、2017 和 2019 的新特性
12. SQL 性能改善技巧和模糊面試問題 關於作者
Prasad Kulkarni 是 Microsoft MVP、技術領導者、作者、敏捷 Scrum Master 和部落客。他在 Microsoft 技術（如 SQL、ASP.NET、MVC、ASP.NET Core、VB.NET、SQL Server、Word 自動化、Office 開發等）和其他技術（如 HTML、CSS、jQuery、JavaScript、Bootstrap 和 XML 等）方面擁有 13 年的核心經驗。他對 Microsoft .NET 技術充滿熱情。您的 LinkedIn 個人檔案: https://in.linkedin.com/in/prasad-kulkarni-389152a5
