動画検索
関連広告
検索結果
Introduction
What is a Relational Database?
Introduction to SQL
What is Database Design?
Database Terms
Atomic Values
One-to-One Relationships
Many-to-Many Relationships
Designing One-to-Many Relationships
Designing Many-to-Many Relationships
Introduction to Keys
Look up Table
Surrogate Key and Natural Key
Foreign Key
Foreign Key Constraints
Review and Key Points....HA GET IT? KEY points!
Cardinality
Introduction to Database Normalization
2NF (Second Normal Form of Database Normalization)
Indexes (Clustered, Nonclustered, Composite Index)
Introduction to Joins
Inner Join on 3 Tables
Introduction to Outer Joins
JOIN with NOT NULL Columns
Self Join
Introduction
Why learn SQL?
What is SQL?
What is a database?
Relational database management systems
Install Microsoft SQL Server
Install SQL Server Management Studio
Connect to server
Object Explorer
Restore sample database
Tables
Primary keys
Database diagrams
Data types
Select
Filtering with where
Inner join & outer join
Order by
Functions including getdate, sum, count
Group by
Bonus: Query designer
Wrap up