Murach’s SQL Server 2016 for Developers

Murach’s SQL Server 2016 for Developers
English | Size: 104.60 MB
Category: CBTs

If you’re an application developer, or you’re training to be one, this 2016 edition of Murach’s classic SQL Server book is made for you.
To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that you’ll use every day. Then, it shows you how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature.

Section 1: An introduction to SQL

In this section, you’ll learn the concepts and terms you need for working with any database. You’ll also learn how to use Microsoft SQL Server 2016 and the Management Studio to run SQL statements on your own PC.

Section 2: The essential SQL skills

In this section, you’ll learn all the skills for retrieving data from a database and for adding, updating, and deleting that data. These skills move from the simple to the complex so you won’t have any trouble if you’re a SQL novice. And they present skills like using outer joins, summary queries, and subqueries that will raise your SQL expertise if you already have SQL experience.

Section 3: Database design and implementation

In this section, you’ll learn how to design a database and how to implement that design by using either SQL statements or the Management Studio. When you’re done, you’ll be able to design and implement your own databases. But even if you’re never called upon to do that, this section will give you the perspective that will make you a better SQL programmer.

Section 4: Advanced SQL skills

In this section, you’ll learn the skills for working with database features like views, scripts, stored procedures, functions, triggers, cursors, and transactions. You’ll also learn how to manage database security, and you’ll learn how to use the features for working with XML and BLOB data. These are the features that give a database management system much of its power. Then, this section ends with an introduction to CLR integration, a feature that allows you to create database objects using the C# or Visual Basic language.

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.