• Normalization, Unions, Joins, and Locking in Microsoft SQL

    What is a normalized database? Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. What is a SQL union/join? Unions combine rows. Joins combine columns. UNION combines the results […]

  • Creating Custom Views in Microsoft SQL

    In part 3 I continue building on the table structure I learned about in part 2 of my training on How to Use Microsoft SQL by learning about creating custom views. Creating the Tables To learn how to setup a custom view in Microsoft SQL, we setup a second table so that we could join […]

  • Microsoft SQL Primary Keys

    I’m in the process of learning SQL and in so doing have started learning Microsoft SQL using Microsoft’s SQL Management Studio. It’s a free program that’s used to open, manage, and edit Microsoft SQL databases stored on a server running Microsoft SQL (quick note: SQL is a database language used to store data in tables […]