SQL Server: From Beginner to Mastery (2nd Edition)

This volume in the Software Development Video Lecture Series focuses on SQL Server and is written for complete beginners. Using SQL Server 2012 as the teaching environment, it systematically introduces the common techniques of database development and management. The book is organized into four parts—Fundamentals, Core Techniques, Advanced Applications, and Project Practice—totaling 20 chapters. The Fundamentals part begins with database systems, the three-level schema, data models, and relational normalization, then introduces the features, installation and uninstallation, service startup, and server registration of SQL Server 2012, and explains how to create, modify, and delete databases; create and manage data tables; insert, update, and delete data; use various constraints (primary key, unique, check, default, foreign key); and establish one-to-one, one-to-many, and many-to-many relationships. The Core Techniques part centers on T-SQL, covering constants, variables, comment markers, operators and wildcards, flow-control statements, and common commands; it then systematically reviews aggregate, mathematical, string, date-and-time, and conversion functions; moves on to advanced query topics such as SELECT query basics, subqueries and nested queries, and join queries; and introduces views, stored procedures, and triggers. The Advanced Applications part covers cursors, indexes and data integrity, transactions and locks, routine maintenance of SQL Server 2012 (detach and attach, import and export, backup and restore), and database security mechanisms. The Project Practice part uses three cases—a library management system built with Visual C++, an enterprise HR management system built with C#, and an enterprise inventory management system built with Java—to demonstrate how databases work with upper-layer applications. The book includes numerous examples with code comments, along with synchronized instructional videos and exercises.