Subscribe For Free Updates!

We'll not spam mate! We promise.

Mar 20, 2011

Relational data base




  • One of the great paradoxes of writing C# -- to move forward, we'll have to temporarily move away from C# and on to understanding relational databases, and specifically SQL Server 2008 Express Edition. Bob explains what a database is, why databases are important, explains (IBM researcher) Codd's thought work in the 1970's which changed how data can be more efficiently and reliably stored. Topics include first-looks at databases, tables, columns, rows, fields, constraints, relationships, normalization primary / foreign keys and more.

  • This video demonstrates how to use the tools built into Visual C# 2010 Express Edition (as well as all editions of the Visual Studio IDE) to create a new SQL Server 2008 Express Edition database, how to add tables with columns, add data (rows) and more.

  • Bob delves deeper into the high level topic of "data integrity" by exploring it's two material agents in SQL Server: data types and constraints. Bob provides a list of SQL Server datatypes that every developer should commit to memory, with the intent to learn more about other data types later.

  • In this video, Bob demonstrates how to create a Database Diagram in Visual C# 2010 Express Edition with the ultimate aim of using it to easily create a foreign key relationship between two tables. Along the way, much about the Diagram itself is discussed.

  • Normalization is the process of deciding how to split data up into the right tables. In this video Bob looks at the first two "forms" of normalization with a couple of sample tables. He also discusses why most developers only choose to normalize to second or third normal form, and why too much normalization is not necessarily a good thing.

  • Today's Visual Studio IDE overview focuses further on the built-in tools to manage and work with databases. First, we explore the Query window and see how to visually create a query as well as the back-end Structured Query Language that is generated as a result. Second, we look at the Database Explorer window ad pluck out a few additional features we had not discovered before.

  • Day 6's homework assignment is all about creating a database, tables and a foreign key constraint using only the built-in tools in the Visual C# 2010 Express Edition IDE.

  • Can't remember a step in building a database, tables and a foreign key constraint using a Database Diagram? No problem … Bob will remind you how in this video.

  • Plese Feel Free to Socializer This Post
    SHARE IT →


    Post a Comment

    Become a Fan

    visual studio learn