SQL Server 2005 Express for Beginners
1. What is a Database?
This introduction covers the questions and terminology SQL Server beginners need to create and manage databases, such as: What is a SQL Server database? How is a SQL Server database different from an Excel spreadsheet? What do SQL Server databases do in my website or software applications? What’s SQL Server Express’ relation to Visual Studio Express? What do terms like “ADO.NET” mean?
Duration: 28 minutes, 15 seconds
2. Understanding Database Tables and Records
SQL Server beginners will learn about tables and definitions of data types, properties, keys, etc. in this second video. Find out how table rows, columns, and fields interrelate and whether columns can be empty.
Duration: 24 minutes, 56 seconds
3. More about Column Data Types and Other Properties
SQL Server beginners will explore data integrity, learn which data types to use for what, and avoid common data type pitfalls.
Duration: 21 minutes, 37 seconds
4. Designing Relational Database Tables
Why are relational databases the most popular? SQL Server beginners will learn to differentiate between primary and foreign keys, design relational database tables, and learn about normalization rules and de-normalization.
Duration: 34 minutes, 10 seconds
5. Manipulating Database Data
SQL Server beginners will learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements.
This lesson requires Management Studio Express and MSXML
Duration: 40 minutes, 20 seconds
6. More Structured Query Language
SQL Server beginners will discover more SQL statements like sub-select and learn stored procedures and their counterparts in C# and VB methods.
Duration: 23 minutes, 13 seconds