Murach's SQL server 2019 for developers : training and reference /
SQL server 2019 for developers
Bryan Syverson, Joel Murach
- xviii, 676 pages : illustrations ; 26 cm
Includes index
An introduction to relational databases and SQL -- How to use the Management Studio -- How to retrieve data from a single table -- How to retrieve data from two or more tables -- How to code summary queries -- How to code subqueries -- How to insert, update, and delete data -- How to work with data types -- How to work with functions -- How to design a database -- How to create a database and its tables with SQL statements -- How to create a database and its tables with the Management Studio -- How to work with views -- How to code scripts -- How to code stored procedures, functions, and triggers -- How to manage transactions and locking -- How to manage database security -- How to work with XML -- How to work with BLOBs -- An introduction to CLR integration
9781943872572
SQL server
Client/server computing Database design Relational databases--Design SQL (Computer program language)