SQL Server fundamentals: From data to infrastructure and licensing
Understand how data, performance, architecture, availability and licensing shape an efficient SQL Server solution.
This 1-day live training provides a practical introduction to databases and Microsoft SQL Server. It connects the business application and its data with infrastructure, performance, availability, virtualization, licensing models, lifecycle and cloud options.
You will understand
The difference between a business application, database, database engine and the infrastructure that hosts it.
How SQL Server fits into a physical, virtual, clustered or cloud environment.
Which workload factors influence performance, scale, edition and availability requirements.
How Server plus CAL and Per Core licensing differ at a conceptual level.
Why VM sizing, workload mobility, lifecycle and disaster recovery rights can influence both cost and risk.
Why attend?
SQL Server is often licensed or sized without a shared understanding of the workload behind it. A poorly designed virtual machine can create performance problems and unnecessary licensing cost, while unclear high-availability or disaster-recovery assumptions can create compliance gaps. This training connects database, infrastructure and licensing decisions.
By the end of the training session, you will
Map a business application to its database, SQL Server instance and hosting infrastructure.
Identify the main drivers of database performance and availability.
Understand the decision logic behind SQL Server Standard and Enterprise editions.
Compare Server plus CAL and Per Core licensing models and identify the required input data.
Evaluate virtualization, high availability, disaster recovery, lifecycle and cloud options as one solution.
Who's it for?
IT managers, database and infrastructure administrators, solution architects, application owners, SAM and ITAM professionals, procurement and IT finance teams, technical sales professionals and organizations planning a SQL Server upgrade or migration. No advanced prerequisites are required. Beginner / Entry level.