INFRASTRUCTURE LEARNINGINFRASTRUCTURE LEARNING
インフラ大全インフラ大全IT INFRASTRUCTURE / LEARNING
Infrastructure learning guide
Find a lesson or lab/

Esc to close · Search terms stay on your device

LEARNING日本語
DATABASES / SQL SERVER

Database learning guide

From organizing data to connecting, reading and updating in SQL Server. A document-list example connects data structure with the conditions for each operation.

Learn SQL Server from database foundations

Follow tables and keys → engine and tools → structure → SSMS → permissions → query results → commit and rollback. One document dataset connects the lessons; no server is required.

There are 7 available lessons.

For connection questions, choose SSMS and access control. To predict rows, study T-SQL; to understand committed changes, continue to transactions.

SQL Server versions and learning environments

SQL Server performance and concurrency

SQL Server connection troubleshooting

Optional study: relational and NoSQL models

After the foundations: recovery and AWS

Review recovery and RDS/SQL Server responsibilities, then continue to connections, deployment, availability, costs and migration to AWS.

Optional: compare and investigate AWS databases

Explore designs beyond SQL Server: DynamoDB keys, Aurora architecture, selection requirements and engine-specific connection investigation.

Choose your goal

Coverage and later study

These lessons cover shared database foundations and SQL Server basics. Continue to backup/restore and RDS management, connectivity and deployment comparisons. Continue by purpose to indexes/plans, locking/deadlocks, version choices and connection failures. Other database products will likewise separate connections, access and data conditions.

Start at the beginning or choose a goal. These lessons reason about fictional tables; no installation, credentials or paid resources are needed.

Browse other subjects →