MS SQL Server 2022 Express with SSMS
SQL Server Express LocalDB – SQL Server | Microsoft Learn Basic and install When done install SSMS from the same tab. Download and install Done start ssms hostname\sqlexpress, domain\user and trust server certificate
Normalization
https://vertabelo.com/blog/how-to-remember-database-normal-forms/ Normal Forms: A Recap The key, the whole key, and nothing but the key, so help me Codd. The key stands for 1NF: all tables must have a (primary) key because all records in the table must be unique.The whole key stands for 2NF: no functional dependencies on part of the key are allowed.Nothing […]
OD20761C – Querying Data with Transact-SQL
Database diagram used for some learning (Bikestore) The rest is here: https://github.com/spawnmarvel/t-sql https://github.com/spawnmarvel/t-sql In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used. Run just portions of the query, mark the section and execute: docs […]
MS SQL Server 2016 Express with SSMS
Update, get the one with localdb SQL Server Express LocalDB – SQL Server | Microsoft Learn Then get SSMS Then you can connect: Choose master on options Download MS SQL Server 2016 Express: https://www.microsoft.com/en-us/download/confirmation.aspx?id=56840 Install also the SSMS tool from the install, or download it from MS. https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 SQL Server Management Studio (SSMS) is an […]