Archive for March 2019

Single-table queries Elements of the SELECT statement –20 The FROM clause –18 underlined Delimiting identifier names The WHERE clause The GROUP BY clause The HAVING clause The SELECT clause The ORDER BY clause The TOP and OFFSET-FETCH filters The TOP filter The OFFSET-FETCH filter Predicates and operators CASE expressions NULLs All-at-one operations Working with character…

Background to T-SQL Querying and Programming Theoretical background SQL Set Theory Predicate Logic The relational model Propositions, predicates, and relations Missing values Constraints Normalization 1NF 2NF 3NF Types of Database systems Online transactional processing Data warehouses SQL Server Architecture The ABCs of Microsoft RDBMS flavors Box Appliance Cloud SQL Server instances Databases Database layout Schemas…