Microsoft SQL Server Notes for Professionals
GoalKicker
More than 280 pages of T-SQL tips. Topics include data types, common table expressions, window functions, JSON and XML handling, indexes, stored procedures, triggers, and backup and restore.
Loading the book...
Keep reading
-
Next in this topic
Oracle Database Notes for ProfessionalsA hands-on reference for SQL in Oracle. It covers joins, hierarchical queries, string and date functions, sequences, partitioning, indexes, and the basics of PL/SQL.
Verified PDF · Secure download - Database Design, 2nd Edition
An open textbook on designing relational databases. It teaches data modeling, entity-relationship diagrams, integrity rules, functional dependencies, and normalization, and closes with SQL exercises.
Verified PDF · Secure download - Relational Databases and Microsoft Access 365
Learn relational design by building real databases in Access. The book covers tables and keys, queries, forms and reports, entity-relationship modeling, mapping ERDs to tables, and normalization.
Verified PDF · Secure download - Database Explorations
Essays on The Third Manifesto by two pioneers of relational theory. They examine types, relation variables, missing information, normal forms, and the design of the Tutorial D language.
Verified PDF · Secure download - MySQL Notes for Professionals
Nearly 200 pages of practical MySQL know-how: data types, joins, indexes, stored routines, triggers, replication, backups with mysqldump, user permissions, and performance tuning.
Verified PDF · Secure download
