SQL Server 2014 Development Essentials

Microsoft SQL Server is an enterprise database server that is the cornerstone of modern business applications, and is at the centre of the business processes of many leading organizations. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. A variety of new in-memory features enable you to design high performance database applications that can improve the performance of your applications, making them as much as ten times more efficient in some cases. Whether you are thinking about becoming a database developer, architect, or administrator, or you are a seasoned database expert, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2014. Starting from the beginning, this book gives you an insight into the key stages of the SQL Server database process, provides in-depth knowledge of SQL Server database architecture, and provides you with tips to design new databases. By sequentially working through the steps in each chapter, you will gain hands-on experience of designing, creating, and deploying SQL Server databases and objects. You will learn how to use SQL Server 2014 Management Studio and advanced Transact-SQL queries to retrieve data from SQL Server databases. You will also learn how to add, modify, and delete data stored within a database. You will use Transact-SQL statements to create and manage advanced database objects that include scalar and table-valued functions, views, stored procedures, and triggers. Finally, you will learn about how SQL Server works, how indexes and statistics improve query performance, and the new SQL Server 2014 in-memory technologies.