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.
- 1 Database basics: tables, keys, reads and writes →
- 2 SQL Server fundamentals and learning path →
- 3 SQL Server structure: instances, databases and schemas →
- 4 Getting started with SSMS: connecting to SQL Server →
- 5 SQL Server access: logins, users, roles and permissions →
- 6 T-SQL basics: SELECT, WHERE, NULL and JOIN results →
- 7 Transactions explained: COMMIT, ROLLBACK and autocommit →
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.
- What is Amazon RDS? Managed responsibilities and database engines →
- RDS for SQL Server: management, permissions and a learning path →
- Connecting to RDS for SQL Server: VPC, TLS and SSMS →
- SQL Server backup and restore: recovery models and log continuity →
- SQL Server on AWS: choosing RDS, RDS Custom or EC2 →
- Restore RDS for SQL Server: snapshots, point-in-time recovery and native restore →
- RDS Multi-AZ vs read replicas: availability, reads and failover →
- Estimate RDS costs: SQL Server charges, licensing and stopped instances →
- Migrate SQL Server to AWS: choose a method and plan cutover →
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.