Microsoft SQL Server Database Administration

Explore the SQL Server platform and its architecture. Learn the toolset, including the database engine, analysis and integration services, and management tools like SQL Server Management Studio.

Plan and prepare SQL Server systems by addressing architectures, 32/64 bit requirements, and pre-installation testing; optimize memory, CPU, and I/O using parallelism, buffer pool, and execution plans.

Learn to install and configure SQL Server with hardware and software prerequisites, edition choices, and operating system considerations. Cover file placement, tempdb optimization, upgrade paths, and unattended installation.

Install SQL Server 2016 by running as administrator, perform a new installation, enable database engine and optional services, and configure data and log directories for a named or default instance.

Install and configure SQL Server with one default and two named instances, locate installation folders and logs, and connect via Management Studio using SQL or Windows authentication.

Install SQL Server 2022, configure hardware prerequisites, select features, set a custom instance name, configure data, log, and backup directories, then choose authentication and install SQL Server Management Studio.

Learn to work with SQL Server databases, including primary MDF and secondary NDF data files, LDF logs, tempdb, and core system databases such as Master, Model, MSDB, and Resource.

Plan and implement SQL Server backup strategies by understanding recovery models, transaction logs, full and differential backups, media choices, retention, and testing for reliable data recovery.

Plan a transaction log backup strategy aligned with business needs using full, differential, and transactional backups. Schedule changes since the last full backup and adjust recovery models accordingly.

Learn how to plan and perform full, differential, and transaction log backups in SQL Server, manage backup sets and media sets, and apply compression, verification, and copy-only options.

Learn to plan SQL Server database restorations using full, differential, and log backups. Explore point-in-time and stop-at recovery, online and standby options, and system database considerations.

Learn how to import and export data between databases and files, using bulk copy and import/export tools, and optimize performance by disabling constraints, indexes, and triggers during bulk transfers.

Explore SQL Server Integration Services for import and export, configure data sources and destinations, and build data flows with ETL transformations using practical wizard-based workflows.

Learn how to perform bulk import and export with SQL Server, including bulk update and bulk insert, using flat files or wizards to move data between databases and Excel.

Learn how authentication and authorization secure SQL Server by using Windows authentication or SQL Server logins, mapping logins to database users, and granting permissions at the database level.

Assign server and database roles to new users by business need, applying the least privilege principle and using grant and deny options with roles like sysadmin and data writer.

Learn how to authorize SQL Server resources with grant and revoke rules across server, database, and schema levels. Emphasize least privilege, cascade, and column-level security using views and ownership chains.

Learn how to authorize users across server, database, schema, and table levels, control column security, and manage execute permissions for procedures and functions in SQL Server.

Learn why auditing SQL Server environments matters for security and resource monitoring, and how to configure server and database audits, including C2 audit mode and custom audits.

Master sql server auditing by implementing dml triggers for product changes and configuring server and database audits to capture select activity and schema access.