Generated by All in One SEO v5.0.0.1, this is an llms.txt file, used by LLMs to index the site. # SQL DBA School Microsoft SQL DBA Classes Online ## Sitemaps - [XML Sitemap](https://sqldbaschool.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Blog](https://sqldbaschool.com/blog/) - Find Professional Insights and Tutorials. Learn tips and best practices from our SQL DBA School instructors and customers Blogs. - [SQL Training Courses Online (2026): Best Path to DBA](https://sqldbaschool.com/sql-training-courses-online/) - Learn how to choose the right online SQL course, build real SQL Server skills (T-SQL, backups, tuning), and prep for DBA roles and certs. - [Microsoft SQL Training and Certification (2026 Job-Ready Guide)](https://sqldbaschool.com/microsoft-sql-training-and-certification-2026/) - Master Microsoft SQL Server in 2026 with a job-ready training & certification —hands-on labs, portfolio projects, interview prep, & trusted Microsoft resources - [Remote SQL Database Administrator Jobs in the USA (2026 Guide)](https://sqldbaschool.com/remote-sql-database-administrator-jobs-usa/) - Explore remote SQL Database Administrator jobs in the USA: skills, tools, salary ranges, resumes, interviews, and a proven plan to get hired faster. - [SQL DBA Jobs: Apply Online + Get Matched Faster (2026)](https://sqldbaschool.com/sql-dba-jobs-apply-online-get-matched-faster-2026/) - A recruiter-backed guide to applying for SQL Server DBA jobs online: proof pack, resume bullets, DP-300 signal, and the apply-once match process. - [SQL Server Wait Stats Cheat Sheet (2026): Top Waits, What They Mean, What to Fix](https://sqldbaschool.com/sql-server-wait-stats-cheat-sheet-2026/) - Understand SQL Server wait stats fast: top waits explained, read-only scripts, a triage map, and proven next steps to fix bottlenecks safely. - [SQL Server Timeouts Runbook (2026) | DBA Triage Checklist](https://sqldbaschool.com/sql-server-timeout-blocking-incident-runbook-2026/) - Real DBA runbook for SQL Server timeouts: 15-minute triage checklist, read-only scripts, blocker detection, Query Store fixes, post-incident hardening—fast. - [SQL Server Health Check Downloadable Checklist (DBA Runbook for 2026)](https://sqldbaschool.com/sql-server-health-check-downloadable-checklist/) - Download a DBA-ready SQL Server health check checklist (daily/weekly/monthly) with safe scripts, evidence logging, and a printable runbook template. - [SQL Server DBA Training & Certification (2026 Roadmap)](https://sqldbaschool.com/sql-server-dba-training-and-certification/) - A practical, job-ready roadmap for SQL Server DBA training and certification—labs, portfolio projects, DP-300 plan, and hiring tips. - [DBAs' Challenge: Managing Large Data Volumes in SQL Server](https://sqldbaschool.com/dba-challenge-managing-large-data-volumes-in-sql-server/) - Learn proven DBA strategies for VLDBs: partitioning, archiving, compression, indexing, backups, and scaling—plus a practical runbook. - [Troubleshooting Common SQL Server Performance Issues: A DBA's Perspective](https://sqldbaschool.com/troubleshooting-common-sql-server-performance-issues-a-dba-perspective/) - A DBA-grade SQL Server performance troubleshooting playbook: triage steps, DMVs, Query Store, waits, blocking, tempdb, I/O bottlenecks, and fixes. - [Best Practices for SQL Server Maintenance Plan Implementation](https://sqldbaschool.com/sql-server-maintenance-plan-best-practices/) - Implement SQL Server maintenance plans the right way: backups, CHECKDB, index/statistics strategy, scheduling, alerts, retention, and pitfalls to avoid. - [SQL Training Free in 2026 – Learn SQL & Get Hired Faster](https://sqldbaschool.com/sql-training-free-get-hired-2026/) - Looking for SQL training free? Learn SQL the right way in 2026 with hands-on labs, portfolio projects, and a clear path to SQL jobs. - [The Complete 2026 Roadmap to Land a Remote SQL DBA Job (with Labs, Checklists, and Portfolio Templates)](https://sqldbaschool.com/remote-sql-dba-jobs-roadmap-2026/) - Master backups, HA/DR, Query Store, and cloud operations. Use our labs, checklists, and portfolio templates—then apply once at SQL DBA School to get matched. - [SQL Jobs in 2026: Roles Hiring + Get Hired Faster](https://sqldbaschool.com/sql-jobs-2026-roles-hiring-get-hired/) - Learn which SQL roles are hiring in 2026, what employers screen first, and the fastest way to get interviews with a proof-based resume + portfolio. - [SQL DBA Careers in 2026: Complete Guide to Skills, Portfolio, Pay—and How to Get Hired Fast](https://sqldbaschool.com/sql-dba-careers-2026-complete-guide/) - Become a SQL DBA in 2026. Learn essential skills, build a proof-based portfolio, prep for interviews, see pay ranges, & apply once to get matched to live roles - [Best Practices for SQL Server Maintenance Plan Implementation](https://sqldbaschool.com/best-practices-for-sql-server-maintenance-plan-implementation/) - Explore best practices for SQL Server Maintenance Plan implementation. Understand backup routines, integrity checks, index maintenance, and regular monitoring. - [The Role of AI in Microsoft SQL Server Database Administration](https://sqldbaschool.com/the-role-of-ai-in-microsoft-sql-server-database-administration/) - Uncover how AI revolutionizes SQL Server DB Administration with automated tuning, predictive capacity planning, anomaly detection, and index management. - [SQL Server vs MySQL vs Oracle: A Comparative Analysis for DBAs](https://sqldbaschool.com/sql-server-vs-mysql-vs-oracle-a-comparative-analysis-for-dbas/) - "Compare SQL Server, MySQL, and Oracle from a DBA's perspective. Understand their performance, scalability, cost, and ease of use to make informed choices. - [The DBA's Survival Guide for SQL Server Database Upgrade](https://sqldbaschool.com/the-dba-survival-guide-for-sql-server-database-upgrade/) - Navigate SQL Server database upgrades with this guide. Learn about planning, testing, execution, post-upgrade activities, and best practices for DBAs. - [Demystifying SQL Server High Availability and Disaster Recovery Solutions](https://sqldbaschool.com/demystifying-sql-server-high-availability-and-disaster-recovery-solutions/) - Dive into SQL Server HA and DR solutions. Understand Failover Clustering, Availability Groups, Log Shipping, and factors to consider when choosing a solution. - [Integrating Microsoft SQL Server with Other Database Systems: A DBA's Guide](https://sqldbaschool.com/integrating-microsoft-sql-server-with-other-database-systems-a-dbas-guide/) - Explore strategies for integrating SQL Server with other databases. Understand tools like SSIS, linked servers, and best practices secure data integration. - [SQL Server Cloud Migration](https://sqldbaschool.com/sql-server-cloud-migration/) - Uncover opportunities and challenges in SQL Server Cloud Migration for DBAs. Gain insights into skill development, automation benefits, security, & performance - [Exploring SQL Server Query Optimization Techniques](https://sqldbaschool.com/exploring-sql-server-query-optimization-techniques/) - Learn how to speed up your SQL Server data retrieval with query optimization techniques, such as efficient indexing, precise queries, and regular updates." - [Microsoft Rolls Out Role-Based Certifications in 2019: A Game-Changer in IT Professions](https://sqldbaschool.com/microsoft-rolls-out-role-based-certifications-in-2019-a-game-changer-in-it-professions/) - Microsoft's 2019 game-changer: Role-Based Certifications. Understand its alignment with job roles, benefits for IT professionals, and impact on skill updates. - [Mastering Microsoft SQL Server Essential DBA Skills](https://sqldbaschool.com/mastering-microsoft-sql-server-essential-dba-skills/) - Dive into essential DBA skills for mastering SQL Server. Learn about server architecture, T-SQL, indexing, backup procedures, security, and automation. - [SQL Server Performance Tuning: A Step-by-step Guide for DBAs](https://sqldbaschool.com/sql-server-performance-tuning-a-step-by-step-guide-for-dbas/) - Improve SQL Server's efficiency with our step-by-step guide. Learn to establish performance baselines, optimize indexes, tune queries, and monitor continuously. - [Understanding the Impact of Database Indexing in SQL Server](https://sqldbaschool.com/impact-of-database-indexing-in-sql-server/) - Explore the role and impact of indexing in SQL Server. Understand indexing types, its effect on data retrieval, query optimization, and its drawbacks. - [How to Improve SQL Server Security: Best Practices for DBAs](https://sqldbaschool.com/how-to-improve-sql-server-security-best-practices-for-dba/) - Discover ways to bolster SQL Server security. Learn about secure authentication, server hardening, data protection, monitoring practices, &robust backup plans - [Top 10 Tips for Microsoft SQL Server Database Administration](https://sqldbaschool.com/top-10-tips-for-efficient-microsoft-sql-server-database-administration/) - Master SQL Server DBA skills with top tips: Implement a backup strategy, monitor performance, automate tasks, manage indexes, and stay updated. - [The Art of SQL Server Backup and Recovery Strategies](https://sqldbaschool.com/the-art-of-sql-server-backup-and-recovery-strategies/) - Dive into the DBA's art of SQL Server backup and recovery. Learn about backup types, recovery models, disaster plans, and effective restore strategies." - [A Comprehensive Guide to Microsoft SQL Server 2023](https://sqldbaschool.com/a-comprehensive-guide-to-microsoft-sql-server-2023/) - Learn the new features of Microsoft SQL Server 2023: performance boosts, advanced security, Azure integration, AI-powered Query Processing, & improved big data. - [Role of a DBA in Microsoft SQL Server Performance](https://sqldbaschool.com/title-the-role-of-a-dba-in-managing-microsoft-sql-server-performance/) - Explore the role of a DBA in Microsoft SQL Server performance. Learn about database design, query tuning, monitoring, capacity planning, and more." - [DBAs' Challenge: Managing Large Data Volumes in SQL Server](https://sqldbaschool.com/dba-challenge-managing-large-data-volumes-in-sql-server/) - Learn proven DBA strategies for VLDBs: partitioning, archiving, compression, indexing, backups, and scaling—plus a practical runbook. ## Pages - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Home](https://sqldbaschool.com/) - Learn SQL Server with hands-on DBA courses, real labs, portfolio projects, interview prep, and clear career paths for beginners and IT professionals. - [Careers at SQL DBA School — Apply for IT Jobs (Remote & On-Site)](https://sqldbaschool.com/careers-at-sql-dba-school/) - Explore career opportunities with SQL DBA School. Apply online to get matched with top SQL Server DBA jobs. Remote and on-site roles available. - [Hire SQL DBA Candidates | SQL DBA Recruiting Partner](https://sqldbaschool.com/sql-dba-recruiting-hiring-partner/) - Need SQL Server DBA talent? Connect with SQL DBA School to access trained SQL, DBA, cloud, and database professionals from junior to 20+ years experience. - [Contact](https://sqldbaschool.com/contact/) - Reach the SQL DBA School team. Apply for IT jobs, partner with us, or get help with courses, and support. Average reply in 1 business day via form or email - [Advance My Career | SQL DBA Career Growth Roadmap Guide](https://sqldbaschool.com/advance-my-career/) - Advance your SQL DBA career with performance tuning, cloud skills, portfolio proof, interview prep, and a clear roadmap toward higher-value database roles. - [Become a SQL DBA | Job-Ready SQL Server DBA Career Path](https://sqldbaschool.com/become-a-sql-dba/) - SQL DBA Career Path Become a SQL DBA With Skills Employers Can Actually Trust Learn the SQL Server administration skills that matter in real environments: backups and restores, monitoring, performance tuning, security, HA/DR, automation, documentation, and incident response—then build a portfolio that proves you can do the work. Hands-on labs Portfolio evidence Interview preparation Career - [Learn SQL From Zero | Beginner SQL DBA Career Path Plan](https://sqldbaschool.com/learn-sql-from-zero/) - Learn SQL from the beginning through clear lessons, hands-on labs, portfolio projects, and career guidance that builds toward SQL Server DBA job readiness. - [Remote SQL DBA Salary (2026): Junior–Senior & Contract Rates](https://sqldbaschool.com/remote-sql-dba-salary/) - See 2026 salary bands for remote SQL DBAs—junior, mid, senior, and contract rates. Factors that change pay, cloud premiums, and how to negotiate. Apply Now. - [Remote SQL DBA Jobs – Apply Online from Anywhere](https://sqldbaschool.com/remote-sql-dba-jobs-apply-online/) - Work from home as a SQL Server DBA. Entry-level to senior, cloud DBA roles, resume help, interview prep—apply today and get matched fast. - [SQL DBA Jobs – Apply Now to Get Hired Fast](https://sqldbaschool.com/sql-dba-jobs-apply-now/) - Apply now for remote and on-site SQL DBA jobs through SQL DBA School. Entry-level to senior roles with full hiring support and employer connections. - [IT Jobs — SQL DBA School (Apply Once)](https://sqldbaschool.com/jobs/) - Browse remote & on-site roles in SQL DBA, Cloud/DevOps, Software, Security, and Data. Search, filter, and apply once to get matched quickly. - [SQL Course with Certificate (2026): Learn SQL, Get Certified, Get Hired](https://sqldbaschool.com/sql-course-with-certificate/) - SQL course with certificate for 2026: free, hands-on SQL Server labs, backups, tuning, and a resume-ready certificate path—plus guidance to apply for jobs. - [SQL Jobs in Atlanta, GA: Roles Hiring Now, Required Skills, and How to Apply in 2026](https://sqldbaschool.com/sql-jobs-atlanta-ga/) - Looking for SQL jobs in Atlanta, GA? Explore SQL Server DBA, SQL developer, and data roles, learn what employers expect in 2026, and apply to get matched. - [SQL DBA Jobs in Atlanta | Training + Placement Support](https://sqldbaschool.com/sql-dba-jobs-atlanta-placement/) - Get job-ready for SQL Server DBA roles in Atlanta with lab-first training, resume + interview prep, and placement support. Start with a proven roadmap. - [Courses](https://sqldbaschool.com/courses/) - Browse SQL DBA School courses: SQL Server DBA, T-SQL, performance tuning, backups lab-first lessons with scripts and portfolio projects. Start today. Free. - [Important Resources to SQL Server 2019](https://sqldbaschool.com/sql-downloads/) - Download SQL Server, SSMS, Azure Data Studio, sample databases, drivers, and DBA tools—plus install tips and official links in one place. - [SQL Jobs — Remote & On-Site | Apply Once, Get Matched](https://sqldbaschool.com/sql-jobs/) - Find vetted SQL jobs—DBA, Developer, Data, Cloud. Apply once at SQL DBA School and get matched to remote or on-site roles. Interview prep and referrals included - [FAQs](https://sqldbaschool.com/faqs/) - Get clear answers on training, remote jobs, placement support, pricing, schedules, and eligibility. Apply once—get matched to real roles. - [FAQs](https://sqldbaschool.com/faqs/) - Get clear answers on training, remote jobs, placement support, pricing, schedules, and eligibility. Apply once—get matched to real roles. - [About Us](https://sqldbaschool.com/about-us/) - We teach and place SQL talent. Hands-on SQL Server & DBA training, interview prep, and direct hiring referrals for remote and on-site IT roles since 2013. - [AWS RDS SQL DBA Remote Jobs (2026 Guide)](https://sqldbaschool.com/aws-rds-sql-dba-remote-jobs/) - Get hired for AWS RDS/Aurora DBA roles. Migration playbooks, performance, HA, security, and cost optimization—plus salary bands and how to apply once. - [Azure SQL DBA Remote Jobs (2026 Guide)](https://sqldbaschool.com/azure-sql-dba-remote-jobs/) - Hire or get hired for Azure SQL DBA remote roles. Skills checklist, MI vs DB, performance, security, migration playbooks, salary bands, and how to apply once. - [Junior Remote SQL DBA (No Experience) — 2026 Guide](https://sqldbaschool.com/junior-remote-sql-dba-no-experience/) - Break into SQL DBA remotely with no experience. Skills, home lab, resume tips, interview prep, salary ranges, and how to get matched to real roles. - [SQL Server DBA Secrets: Questions That Set You Apart](https://sqldbaschool.com/sql-server-dba-interview-questions-sql-server-dba-interview-questions-and-answers/) - Explore SQL DBA School's curated SQL Dinterview questions & answers, helping aspiring database administrators ace interviews with confidence and expertise. - [SQL Server DBA Interview Questions Part-2](https://sqldbaschool.com/sql-server-dba-interview-questions-part-2/) - [SQL DBA Script All In One](https://sqldbaschool.com/sql-server-dba-scripts-all-in-one/) - [DBA's Essential 100 SQL Commands](https://sqldbaschool.com/100-syntax-what-dba-should-know-in-detail/) - [Instructors](https://sqldbaschool.com/instructors/) - [Instructor](https://sqldbaschool.com/instructor/) - [Term Conditions](https://sqldbaschool.com/lp-term-conditions/) - [sql learning resources](https://sqldbaschool.com/sql-learning-resources/) - [sql learning resources](https://sqldbaschool.com/sql-learning-resources/) - [Dashboard](https://sqldbaschool.com/profile/) - [SQL server Study Material Section-5](https://sqldbaschool.com/sql-server-study-material-section-5/) - [SQL SERVER 2019 DEVELOPER (TSQL)](https://sqldbaschool.com/sql-server-2019-developer-tsql/) - [SQL SERVER 2019 DBA](https://sqldbaschool.com/sql-server-2019-dba/) - [SQL Query Performance Tuning-2](https://sqldbaschool.com/sql-query-performance-tuning-2/) - [SQL Query Performance Tuning- 3](https://sqldbaschool.com/sql-query-performance-tuning-3/) - [SQL Commands List](https://sqldbaschool.com/sql-commands-list/) - [MySQL Commands](https://sqldbaschool.com/mysql-commands/) - [Become a Teacher](https://sqldbaschool.com/become-a-teacher/) - Create, host teach sql courses, sql training, and provide sql classes and videos online. Leverage our teaching resources to build successful courses - [Account](https://sqldbaschool.com/account/) - [User Register](https://sqldbaschool.com/user-register/) - [User Login](https://sqldbaschool.com/user-login/) - [Forgot Password](https://sqldbaschool.com/forgot-password/) - [Reset Password](https://sqldbaschool.com/reset-password/) - [User Account](https://sqldbaschool.com/user-account/) - [SQL server Study Material Section-3](https://sqldbaschool.com/sql-server-study-material-section-3/) - [SQL server Study Material Section-2](https://sqldbaschool.com/sql-server-study-material-section-2/) - [Checkout](https://sqldbaschool.com/checkout-2/) - [Register](https://sqldbaschool.com/register/) - [Activate](https://sqldbaschool.com/activate/) - [Activity](https://sqldbaschool.com/activity/) - [Members](https://sqldbaschool.com/members/) - [Membership Billing](https://sqldbaschool.com/membership-account/membership-billing/) - [Membership Cancel](https://sqldbaschool.com/membership-account/membership-cancel/) - [Membership Checkout](https://sqldbaschool.com/membership-account/membership-checkout/) - [Membership Confirmation](https://sqldbaschool.com/membership-account/membership-confirmation/) - [Membership Invoice](https://sqldbaschool.com/membership-account/membership-invoice/) - [Membership Levels](https://sqldbaschool.com/membership-account/membership-levels/) - [Membership Account](https://sqldbaschool.com/membership-account/) - [LP Become A Teacher](https://sqldbaschool.com/lp-become-a-teacher/) - [LP Profile](https://sqldbaschool.com/lp-profile/) - [LP Checkout](https://sqldbaschool.com/lp-checkout/) - [Gallery](https://sqldbaschool.com/gallery/) - Explore SQL DBA School Gallery for more information how to take sql dba courses and for microsoft sql certification. - [Portfolio Grid](https://sqldbaschool.com/portfolio-grid/) - [Portfolio Multigrid](https://sqldbaschool.com/portfolio-multigrid/) - [Portfolio Masonry](https://sqldbaschool.com/portfolio-masonry/) - [Shop](https://sqldbaschool.com/shop/) - [Site-Wide Activity](https://sqldbaschool.com/activity-2/) - [Members](https://sqldbaschool.com/members-2/) ## Events - [Good Intentions or Good Results?](https://sqldbaschool.com/events/good-intentions-or-good-results/) - [Eduma Autumn 2017](https://sqldbaschool.com/events/eduma-autumn-2015/) - [Summer School 2015](https://sqldbaschool.com/events/summer-school-2015/) - [Build Education Website Using WordPress](https://sqldbaschool.com/events/build-education-website-using-wordpress/) - [Elegant Light Box Paper Cut Dioramas](https://sqldbaschool.com/events/elegant-light-box-paper-cut-dioramas-1/) - [Eduma Summer 2017](https://sqldbaschool.com/events/eduma-summer-2017/) - [Eduma Autumn 2016](https://sqldbaschool.com/events/eduma-autumn-2016/) - [Education Autumn Tour 2016](https://sqldbaschool.com/events/education-autumn-tour-2016/) ## Courses - [Complete Microsoft SQL Server Database Administration (DBA) Course](https://sqldbaschool.com/course/complete-sql-server-dba-course/) - [SQL Server Performance Tuning Course](https://sqldbaschool.com/course/sql-server-performance-tuning/) - Master SQL Server performance tuning with real DBA workflows: indexing, query plans, monitoring, wait stats, memory/CPU, and troubleshooting. Earn a certificate - [Database Foundations Administration](https://sqldbaschool.com/course/database-foundations-administration/) - [SQL Server 2014 Essential Training](https://sqldbaschool.com/course/sql-server-2014-essential-training/) - [SQL Tips Tricks and Techniques](https://sqldbaschool.com/course/sql-tips-tricks-and-techniques/) - [SQL Server 2012 Designing Database Solution](https://sqldbaschool.com/course/sql-server-2012-designing-database-solution/) - [SQL Language?](https://sqldbaschool.com/course/what-is-the-sql-language/) - Basic SQL Commands - The List of Database Queries and Statements You Should Know - [Microsoft SQL Server 2016 Training](https://sqldbaschool.com/course/microsoft-sql-server-2016-online-training/) - [Advanced SQL for Query Tuning and Performance Optimization](https://sqldbaschool.com/course/advanced-sql-for-query-tuning-and-performance-optimization/) - [Microsoft SQL Server 2019 Essential Training](https://sqldbaschool.com/course/microsoft-sql-server-2019-essential-training/) - [Learning Microsoft SQL Server 2019](https://sqldbaschool.com/course/learning-microsoft-sql-server-2019/) - [SQL Server 2017 What is New](https://sqldbaschool.com/course/sql-server-2017-what-is-new/) - [Microsoft SQL Server 2016 Essential Training](https://sqldbaschool.com/course/microsoft-sql-server-2016-essential-training/) - [Learning SQL Server 2017](https://sqldbaschool.com/course/learning-sql-server-2017/) - [Installing SQL Server 2012](https://sqldbaschool.com/course/installing-sql-server-2012/) - [MySQL Installation and Configuration](https://sqldbaschool.com/course/mysql-installation-and-configuration/) - [Introduction to SQL](https://sqldbaschool.com/course/introduction-to-sql/) ## Lessons - [Lab: Apply a “baseline configuration” and document every change](https://sqldbaschool.com/lessons/lab-apply-a-baseline-configuration-and-document-every-change/) - [Database options: compatibility level, AUTO_CLOSE, AUTO_SHRINK (what NOT to use)](https://sqldbaschool.com/lessons/database-options-compatibility-level-auto_close-auto_shrink-what-not-to-use/) - [Lesson 6: SQL Server Agent Basics (Jobs, Operators, Schedules)](https://sqldbaschool.com/lessons/sql-server-agent-basics-jobs-operators-schedules/) - [tempdb best practices (file count strategy, growth, contention reduction)](https://sqldbaschool.com/lessons/tempdb-best-practices-file-count-strategy-growth-contention-reduction/) - [File growth strategy (autogrowth sizing, instant file initialization concept)](https://sqldbaschool.com/lessons/file-growth-strategy-autogrowth-sizing-instant-file-initialization-concept/) - [Memory configuration (min/max server memory; OS reserved)](https://sqldbaschool.com/lessons/memory-configuration-min-max-server-memory-os-reserved/) - [MAXDOP and Cost Threshold for Parallelism (how to set correctly)](https://sqldbaschool.com/lessons/maxdop-and-cost-threshold-for-parallelism-how-to-set-correctly/) - [Lesson 1: Server Configuration Philosophy (Stable Defaults + Controlled Changes)](https://sqldbaschool.com/lessons/server-configuration-philosophy-stable-defaults-controlled-changes/) - [Lab: Inspect internal metadata (DMVs introduction safely)](https://sqldbaschool.com/lessons/lab-inspect-internal-metadata-dmvs-introduction-safely/) - [Lesson 7: System Databases — master / model / msdb / tempdb (Do’s and Don’ts)](https://sqldbaschool.com/lessons/system-databases-master-model-msdb-tempdb-dos-and-donts/) - [Lesson 6: tempdb Purpose and Common Bottlenecks](https://sqldbaschool.com/lessons/tempdb-purpose-and-common-bottlenecks/) - [Lesson 5: Buffer Pool and Memory Grants (Why Queries “Spill”](https://sqldbaschool.com/lessons/buffer-pool-and-memory-grants-why-queries-spill/) - [Transaction log internals (log records, VLFs, log truncation)](https://sqldbaschool.com/lessons/transaction-log-internals-log-records-vlfs-log-truncation/) - [Lesson 3: Pages, Extents, and Why They Matter to I/O](https://sqldbaschool.com/lessons/pages-extents-and-why-they-matter-to-i-o/) - [Lesson 2: Databases vs Instances (What Lives Where)](https://sqldbaschool.com/lessons/databases-vs-instances-what-lives-where/) - [Lesson 1: SQL Server Process Model and Services Overview](https://sqldbaschool.com/lessons/sql-server-process-model-and-services-overview/) - [Lab: Build a “clean install checklist” students can reuse](https://sqldbaschool.com/lessons/lab-build-a-clean-install-checklist-students-can-reuse/) - [Lesson 7: Configure File Locations — Data / Log / tempdb Separation (Best Practice)](https://sqldbaschool.com/lessons/configure-file-locations-data-log-tempdb-separation-best-practice/) - [Lesson 6: Install SSMS and Essential Tooling](https://sqldbaschool.com/lessons/install-ssms-and-essential-tooling/) - [Lesson 5: Install SQL Server (Edition Guidance + Components)](https://sqldbaschool.com/lessons/install-sql-server-edition-guidance-components/) - [Lesson 4: Service Accounts Strategy (What to Do in Lab vs Production)](https://sqldbaschool.com/lessons/service-accounts-strategy-what-to-do-in-lab-vs-production/) - [Lesson 3: Install Windows Server (or Windows 11 Pro Lab) and Harden Basics](https://sqldbaschool.com/lessons/install-windows-server-or-windows-11-pro-lab-and-harden-basics/) - [Lesson 2: Virtualization Options (VMware / VirtualBox / Hyper-V) — Choose One](https://sqldbaschool.com/lessons/virtualization-options-vmware-virtualbox-hyper-v-choose-one/) - [Lesson 1: Hardware and Sizing Basics (CPU, Memory, Storage Tiers)](https://sqldbaschool.com/lessons/hardware-and-sizing-basics-cpu-memory-storage-tiers/) - [Lab: Build a Stored Procedure with Validation + Error Handling](https://sqldbaschool.com/lessons/lab-build-a-stored-procedure-with-validation-error-handling/) - [Lesson 7: Stored Procedures (Parameters, Output Parameters, Return Codes)](https://sqldbaschool.com/lessons/stored-procedures-parameters-output-parameters-return-codes/) - [Lesson 6: Transactions in T-SQL (BEGIN/COMMIT/ROLLBACK Patterns)](https://sqldbaschool.com/lessons/transactions-in-t-sql-begin-commit-rollback-patterns/) - [Lesson 5: Error Handling (TRY/CATCH) and Defensive DBA Scripts](https://sqldbaschool.com/lessons/error-handling-try-catch-and-defensive-dba-scripts/) - [Lesson 4: Date/Time Handling Pitfalls (GETDATE vs SYSDATETIME, Time Zones)](https://sqldbaschool.com/lessons/date-time-handling-pitfalls-getdate-vs-sysdatetime-time-zones/) - [Lesson 3: CASE Expressions and Robust Business Logic](https://sqldbaschool.com/lessons/case-expressions-and-robust-business-logic/) - [Lesson 2: Window Functions (ROW_NUMBER, RANK, SUM OVER)](https://sqldbaschool.com/lessons/window-functions-row_number-rank-sum-over/) - [Lesson 1: Common Table Expressions (CTEs)](https://sqldbaschool.com/lessons/common-table-expressions-ctes/) - [Lesson 8 (Lab): Build DBA-Style “Report Queries” Using AdventureWorks](https://sqldbaschool.com/lessons/lab-build-dba-style-report-queries-using-adventureworks/) - [Lesson 7: Temp Tables vs Table Variables (Practical DBA Usage)](https://sqldbaschool.com/lessons/temp-tables-vs-table-variables-practical-dba-usage/) - [Lesson 6: INSERT / UPDATE / DELETE and Safe Patterns (Write Operations the DBA Way)](https://sqldbaschool.com/lessons/insert-update-delete-and-safe-patterns-write-operations-the-dba-way/) - [Lesson 4: Joins (INNER/LEFT/RIGHT/FULL) and Common Join Mistakes](https://sqldbaschool.com/lessons/joins-inner-left-right-full-and-common-join-mistakes/) - [Lesson 5: Subqueries vs Joins (When Each Is Appropriate)](https://sqldbaschool.com/lessons/subqueries-vs-joins-when-each-is-appropriate/) - [Lesson 2: WHERE, ORDER BY, TOP, DISTINCT, and NULL Handling (DBA Accuracy Skills)](https://sqldbaschool.com/lessons/where-order-by-top-distinct-and-null-handling-dba-accuracy-skills/) - [Lesson 1: SELECT Fundamentals (Projection, Filtering, Sorting)](https://sqldbaschool.com/lessons/select-fundamentals-projection-filtering-sorting/) - [Lesson 3: GROUP BY, HAVING, and Aggregate Functions (Turning Rows into Answers)](https://sqldbaschool.com/lessons/group-by-having-and-aggregate-functions-turning-rows-into-answers/) - [Lesson 8 (Lab): Design a Small Schema and Enforce Constraints Properly](https://sqldbaschool.com/lessons/lesson-8-lab-design-a-small-schema-and-enforce-constraints-properly/) - [Lesson 7: Index Concepts (Why Indexes Are Data Structures, Not Magic)](https://sqldbaschool.com/lessons/lesson-7-index-concepts-why-indexes-are-data-structures-not-magic/) - [Lesson 6: Normalization (What to Normalize, What to Denormalize—and When)](https://sqldbaschool.com/lessons/lesson-6-normalization-what-to-normalize-what-to-denormalize-and-when/) - [Lesson 5: Transactions and ACID in Practice (And What Breaks It)](https://sqldbaschool.com/lessons/lesson-5-transactions-and-acid-in-practice-and-what-breaks-it/) - [Lesson 4: Relationships and Referential Integrity (How Tables Connect Safely)](https://sqldbaschool.com/lessons/lesson-4-relationships-and-referential-integrity-how-tables-connect-safely/) - [Lesson 2: Tables, rows, columns, constraints (what DBAs must enforce)](https://sqldbaschool.com/lessons/tables-rows-columns-constraints-what-dbas-must-enforce/) - [Lesson 1: Data vs. Information: How Databases Support Applications](https://sqldbaschool.com/lessons/data-vs-information-how-databases-support-applications/) - [Lesson 3: Keys (PK/FK/UNIQUE/CHECK) — Why They Prevent Data Disasters](https://sqldbaschool.com/lessons/lesson-3-keys-pk-fk-unique-check-why-they-prevent-data-disasters/) - [Lesson](https://sqldbaschool.com/lessons/lesson-2-1-data-vs-information-what-dbas-protect/) - [LESSON 7 — The Habits That Make You Employable (Your DBA Professional Standards)](https://sqldbaschool.com/lessons/lesson-7-the-habits-that-make-you-employable-your-dba-professional-standards/) - [LESSON 6 — Build Your DBA Workspace (Scripts, Evidence, Notes)](https://sqldbaschool.com/lessons/lesson-6-build-your-dba-workspace-scripts-evidence-notes/) - [LESSON 5 — Change Management (How DBAs Avoid Breaking Production)](https://sqldbaschool.com/lessons/lesson-5-change-management-how-dbas-avoid-breaking-production/) - [LESSON 4 — DBA Communication That Sounds Professional (Even Under Pressure)](https://sqldbaschool.com/lessons/lesson-1-4-change-management-for-dbas-how-to-avoid-breaking-production/) - [LESSON 3 — The DBA Evidence-First Workflow (Your Professional System)](https://sqldbaschool.com/lessons/lesson-1-3-the-dba-workflow-evidence-first-troubleshooting-your-professional-system/) - [LESSON 1 — How to Use This Course (Self-Paced Learning That Actually Works)](https://sqldbaschool.com/lessons/lesson-1-1-welcome-how-this-course-makes-you-job-ready/) - [LESSON 2 — What a SQL Server DBA Actually Does (Real Responsibilities)](https://sqldbaschool.com/lessons/lesson-1-2-what-a-sql-server-dba-actually-does-real-world-responsibilities/) - [Case Studies and Real-World Scenarios](https://sqldbaschool.com/lessons/case-studies-and-real-world-scenarios/) - [Troubleshooting Common Performance Problems](https://sqldbaschool.com/lessons/troubleshooting-common-performance-problems/) - [Best Practices for SQL Server Performance Tuning](https://sqldbaschool.com/lessons/best-practices-for-sql-server-performance-tuning/) - [Automating and Scheduling Maintenance Tasks in SQL Server](https://sqldbaschool.com/lessons/automating-and-scheduling-maintenance-tasks-in-sql-server/) - [Locking, Blocking, and Concurrency in SQL Server](https://sqldbaschool.com/lessons/locking-blocking-and-concurrency/) - [SQL Server Storage and I/O Performance](https://sqldbaschool.com/lessons/sql-server-storage-and-i-o-performance/) - [Performance Monitoring Tools and Techniques in SQL Server](https://sqldbaschool.com/lessons/performance-monitoring-tools-and-techniques-in-sql-server/) - [SQL Server Security and Compliance.](https://sqldbaschool.com/lessons/sql-server-security-and-compliance/) - [SQL Server High Availability and Disaster Recovery](https://sqldbaschool.com/lessons/sql-server-high-availability-and-disaster-recovery/) - [Database Engine Tuning Advisor in SQL Server](https://sqldbaschool.com/lessons/database-engine-tuning-advisor-in-sql-server/) - [Statistics and Cardinality Estimation in SQL Server](https://sqldbaschool.com/lessons/statistics-and-cardinality-estimation-in-sql-server/) - [SQL Server Profiler and Trace Analysis](https://sqldbaschool.com/lessons/sql-server-profiler-and-trace-analysis/) - [Managing Memory and Processor Resources in SQL Server](https://sqldbaschool.com/lessons/managing-memory-and-processor-resources-in-sql-server/) - [Advanced SQL Server Configurations and Best Practices for Performance Tuning](https://sqldbaschool.com/lessons/advanced-sql-server-configurations-and-best-practices-for-performance-tuning/) - [Monitoring and Troubleshooting SQL Server Performance](https://sqldbaschool.com/lessons/monitoring-and-troubleshooting-sql-server-performance/) - [Query Optimization Techniques](https://sqldbaschool.com/lessons/query-optimization-techniques/) - [SQL Server Indexing](https://sqldbaschool.com/lessons/sql-server-indexing/) - [Understanding Database Architecture](https://sqldbaschool.com/lessons/understanding-database-architecture/) - [Introduction to SQL Server Performance Tuning](https://sqldbaschool.com/lessons/introduction-to-sql-server-performance-tuning/) - [Data Mining and Business Intelligence.](https://sqldbaschool.com/lessons/data-mining-and-business-intelligence/) - [Introduction to NoSQL Databases](https://sqldbaschool.com/lessons/introduction-to-nosql-databases/) - [- NoSQL Databases and Data Warehousing.](https://sqldbaschool.com/lessons/advanced-topics-nosql-databases-and-data-warehousing/) - [Database Security and Integrity](https://sqldbaschool.com/lessons/database-security-and-integrity/) - [Database Administration](https://sqldbaschool.com/lessons/database-administration/) - [SQL and Database Querying](https://sqldbaschool.com/lessons/sql-and-database-querying/) - [Database Design and Data Modeling](https://sqldbaschool.com/lessons/database-design-and-data-modeling/) - [Understanding Data Models](https://sqldbaschool.com/lessons/understanding-data-models/) - [Introduction to Database Systems](https://sqldbaschool.com/lessons/introduction-to-database-systems/) - [Generate Backup And Script File In SQL Server 2014](https://sqldbaschool.com/lessons/generate-backup-and-script-file-in-sql-server-2014/) - [Taking Script From Database In SQL Server In Different Mode](https://sqldbaschool.com/lessons/taking-script-from-database-in-sql-server-in-different-mode/) - [Passing Table to a Function Parameter in SQL Server 2012](https://sqldbaschool.com/lessons/passing-table-to-a-function-parameter-in-sql-server-2012/) - [Creating Various Types of Tables in SQL Server 2012](https://sqldbaschool.com/lessons/creating-various-types-of-tables-in-sql-server-2012/) - [Creating Duplicate Table With New Name From Existing Table in SQL Server 2012](https://sqldbaschool.com/lessons/creating-duplicate-table-with-new-name-from-existing-table-in-sql-server-2012/) - [Copy Table Schema and Data From One Database to Another Database in SQL Server](https://sqldbaschool.com/lessons/copy-table-schema-and-data-from-one-database-to-another-database-in-sql-server/) - [Copy Table With Data From One Database to Another in SQL Server 2012](https://sqldbaschool.com/lessons/copy-table-with-data-from-one-database-to-another-in-sql-server-2012/) - [How to Generate Database Script with Table Data From SQL Server](https://sqldbaschool.com/lessons/how-to-generate-database-script-with-table-data-from-sql-server/) - [Most Used SQL Queries](https://sqldbaschool.com/lessons/most-used-sql-queries/) - [Delete Files with a SQL Job in SQL Server 2008](https://sqldbaschool.com/lessons/delete-files-with-a-sql-job-in-sql-server-2008/) - [How To Recover Deleted Rows In SQL Server](https://sqldbaschool.com/lessons/how-to-recover-deleted-rows-in-sql-server/) - [Delete All Table Data Within a Database in SQL Server](https://sqldbaschool.com/lessons/delete-all-table-data-within-a-database-in-sql-server/) - [How to Track User That Dropped/Deleted TSQL on SQL Server Objects](https://sqldbaschool.com/lessons/how-to-track-user-that-dropped-deleted-tsql-on-sql-server-objects/) - [Daily Shrink Database Log Automatically Using Jobs In SQL Server](https://sqldbaschool.com/lessons/daily-shrink-database-log-automatically-using-jobs-in-sql-server/) - [Resolving “Cannot Install SQL Server 2014 Service Pack 2” Error](https://sqldbaschool.com/lessons/resolving-cannot-install-sql-server-2014-service-pack-2-error/) - [Requirements to Install SQL Server 2014](https://sqldbaschool.com/lessons/requirements-to-install-sql-server-2014/) - [Natively Compiled Stored Procedures in SQL Server 2014](https://sqldbaschool.com/lessons/natively-compiled-stored-procedures-in-sql-server-2014/) - [Grant Execute Or View Permission To Stored Procedures In SQL Server](https://sqldbaschool.com/lessons/grant-execute-or-view-permission-to-stored-procedures-in-sql-server/) - [Views & Stored Procedure in SQL Server](https://sqldbaschool.com/lessons/views-stored-procedure-in-sql-server/) - [How to Enable Remote Connections in SQL Server 2005](https://sqldbaschool.com/lessons/how-to-enable-remote-connections-in-sql-server-2005/) - [Enable/Disable Constraints in SQL Server](https://sqldbaschool.com/lessons/enable-disable-constraints-in-sql-server/) - [Enabling SQL Server Optimizer Hotfixes](https://sqldbaschool.com/lessons/enabling-sql-server-optimizer-hotfixes/) - [FETCH In SQL](https://sqldbaschool.com/lessons/fetch-in-sql/) - [SQL Commands Update](https://sqldbaschool.com/lessons/sql-commands-update/) - [SQL Alter Command](https://sqldbaschool.com/lessons/sql-alter-command/) - [Ternary Operator In SQL](https://sqldbaschool.com/lessons/ternary-operator-in-sql/) - [SQL Logical Operators](https://sqldbaschool.com/lessons/sql-logical-operators/) - [SQL String Operators](https://sqldbaschool.com/lessons/sql-string-operators/) - [SQL Arithmetic Operators](https://sqldbaschool.com/lessons/sql-arithmetic-operators/) - [Create and Schedule a Job in SQL Server](https://sqldbaschool.com/lessons/create-and-schedule-a-job-in-sql-server/) - [SQL Data Types](https://sqldbaschool.com/lessons/sql-data-types/) - [SQL Server Storage Basics: Database Filegroups](https://sqldbaschool.com/lessons/basics-of-database-administration-in-sql-server-part-6/) - [SQL Server Storage Basics: Database Files](https://sqldbaschool.com/lessons/sql-server-users-explained-2/) - [SQL Server Users](https://sqldbaschool.com/lessons/sql-server-users-explained/) - [SQL Server Logins](https://sqldbaschool.com/lessons/sql-server-logins/) - [SQL Server Authentication Modes](https://sqldbaschool.com/lessons/sql-server-authentication-modes/) - [Distributed Databases in SQL Server](https://sqldbaschool.com/lessons/distributed-databases-in-sql-server/) - [Databases in SQL Server](https://sqldbaschool.com/lessons/databases-in-sql-server/) - [SQL Server Management Studio (SSMS)](https://sqldbaschool.com/lessons/sql-server-management-studio-ssms/) - [What Is SQL Server](https://sqldbaschool.com/lessons/what-is-sql-server-5/) - [Uses Of SQL](https://sqldbaschool.com/lessons/uses-of-sql/) - [IS SQL Microsoft?](https://sqldbaschool.com/lessons/is-sql-microsoft/) - [Careers In SQL](https://sqldbaschool.com/lessons/careers-in-sql/) - [SQL Management Tools](https://sqldbaschool.com/lessons/sql-management-tools/) - [What Is SQL Developer](https://sqldbaschool.com/lessons/what-is-sql-developer/) - [SQL Keywords](https://sqldbaschool.com/lessons/sql-keywords/) - [SQL Constraints](https://sqldbaschool.com/lessons/sql-constraints/) - [Composite Key In SQL](https://sqldbaschool.com/lessons/v-4/) - [Transactions In SQL](https://sqldbaschool.com/lessons/transactions-in-sql/) - [Understanding Transactions in SQL Server](https://sqldbaschool.com/lessons/understanding-transactions-in-sql-server/) - [First Normal Form](https://sqldbaschool.com/lessons/first-normal-form/) - [SQL Server Data Types](https://sqldbaschool.com/lessons/sql-server-data-types/) - [SQL Administration](https://sqldbaschool.com/lessons/sql-administration/) - [Cheat Sheet SQL](https://sqldbaschool.com/lessons/cheat-sheet-sql/) - [SQL Variables](https://sqldbaschool.com/lessons/sql-variables/) - [How To Install SQL Server](https://sqldbaschool.com/lessons/v-3/) - [Understanding Databases](https://sqldbaschool.com/lessons/understanding-databases/) - [In-Memory OLTP in SQL Server](https://sqldbaschool.com/lessons/in-memory-oltp-in-sql-server/) - [Different SQL Server Recovery Models](https://sqldbaschool.com/lessons/different-sql-server-recovery-models/) - [SQL Server FULL Recovery Model Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/sql-server-full-recovery-model-step-by-step-tutorial-with-examples/) - [SQL Server BULK-LOGGED Recovery Model Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/sql-server-bulk-logged-recovery-model-step-by-step-tutorial-with-examples/) - [Different Types of SQL Server Backups](https://sqldbaschool.com/lessons/different-types-of-sql-server-backups/) - [Permissions Required to Take Database Backup in SQL Server](https://sqldbaschool.com/lessons/permissions-required-to-take-database-backup-in-sql-server/) - [FULL Database Backups in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/full-database-backups-in-sql-server-step-by-step-tutorial-with-examples/) - [DIFFERENTIAL Database Backups in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/differential-database-backups-in-sql-server-step-by-step-tutorial-with-examples/) - [TRANSACTION LOG Backups in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/transaction-log-backups-in-sql-server-step-by-step-tutorial-with-examples/) - [COPY_ONLY Backup in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/copy_only-backup-in-sql-server-step-by-step-tutorial-with-examples/) - [MIRRORED Backup in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/mirrored-backup-in-sql-server-step-by-step-tutorial-with-examples/) - [FILE Backup in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/file-backup-in-sql-server-step-by-step-tutorial-with-examples/) - [FILEGROUP Backup in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/filegroup-backup-in-sql-server-step-by-step-tutorial-with-examples/) - [PARTIAL Backup in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/partial-backup-in-sql-server-step-by-step-tutorial-with-examples/) - [TAIL-LOG Backup in SQL Server Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/tail-log-backup-in-sql-server-step-by-step-tutorial-with-examples/) - [SQL Server SIMPLE Recovery Model Step by Step Tutorial with Examples](https://sqldbaschool.com/lessons/sql-server-simple-recovery-model-step-by-step-tutorial-with-examples/) - [Relational Database Management Concept](https://sqldbaschool.com/lessons/relational-database-management-concept/) - [What is a Database](https://sqldbaschool.com/lessons/what-is-a-database/) - [SERVERPROPERTY Function T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/serverproperty-function-t-sql-enhancement-in-sql-server-2016/) - [FORMATMESSAGE Statement T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/formatmessage-statement-t-sql-enhancement-in-sql-server-2016/) - [STRING_SPLIT Function and STRING_ESCAPE Function in SQL Server 2016](https://sqldbaschool.com/lessons/string_split-function-and-string_escape-function-in-sql-server-2016/) - [COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/compress-and-decompress-t-sql-enhancement-in-sql-server-2016/) - [ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/alter-database-set-autogrow_all_files-t-sql-enhancement-in-sql-server-2016/) - [ALTER DATABASE SET AUTOGROW_SINGLE_FILE T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/alter-database-set-autogrow_single_file-t-sql-enhancement-in-sql-server-2016/) - [MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/maxdop-for-dbcc-checkdb-dbcc-checktable-and-dbcc-checkfilegroup-t-sql-enhancement-in-sql-server-2016/) - [ALTER TABLE WITH (ONLINE=ON | OFF) T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/alter-table-with-onlineon-off-t-sql-enhancement-in-sql-server-2016/) - [DROP IF EXISTS T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/drop-if-exists-t-sql-enhancement-in-sql-server-2016/) - [TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016](https://sqldbaschool.com/lessons/truncate-table-with-partitions-t-sql-enhancement-in-sql-server-2016/) - [Restore a Database](https://sqldbaschool.com/lessons/restore-a-database/) - [Backup a Database](https://sqldbaschool.com/lessons/backup-a-database/) - [Create a Stored Procedure](https://sqldbaschool.com/lessons/create-a-stored-procedure/) - [Create a View](https://sqldbaschool.com/lessons/create-a-view-2/) - [Create a Query](https://sqldbaschool.com/lessons/create-a-query/) - [SQL CREATE DATABASE](https://sqldbaschool.com/lessons/sql-create-database/) - [DROP Database](https://sqldbaschool.com/lessons/drop-database/) - [RENAME Database](https://sqldbaschool.com/lessons/rename-database/) - [Copy Table](https://sqldbaschool.com/lessons/copy-table/) - [TRUNCATE Table](https://sqldbaschool.com/lessons/truncate-table/) - [ALTER Table](https://sqldbaschool.com/lessons/alter-table/) - [DROP DATABASE](https://sqldbaschool.com/lessons/drop-database-2/) - [CREATE Database](https://sqldbaschool.com/lessons/create-database/) - [SELECT Database](https://sqldbaschool.com/lessons/select-database/) - [SQL Aliases](https://sqldbaschool.com/lessons/sql-aliases/) - [SQL Limit](https://sqldbaschool.com/lessons/sql-limit/) - [SQL Insert Into Select](https://sqldbaschool.com/lessons/sql-insert-into-select/) - [SQL Select Into](https://sqldbaschool.com/lessons/sql-select-into/) - [SQL Between](https://sqldbaschool.com/lessons/sql-between/) - [SQL Server subquery](https://sqldbaschool.com/lessons/sql-server-subquery/) - [SQL Commit And Rollback](https://sqldbaschool.com/lessons/sql-commit-and-rollback/) - [SQL Except](https://sqldbaschool.com/lessons/sql-except/) - [SQL Intersect](https://sqldbaschool.com/lessons/sql-intersect/) - [SQL Union, SQL Union All](https://sqldbaschool.com/lessons/sql-union-sql-union-all/) - [SQL NULL](https://sqldbaschool.com/lessons/sql-null/) - [SQL IN and NOT IN Operators](https://sqldbaschool.com/lessons/sql-in-and-not-in-operators/) - [SQL Like Operator](https://sqldbaschool.com/lessons/sql-like/) - [Composite Key in SQL](https://sqldbaschool.com/lessons/composite-key-in-sql/) - [SQL Queries](https://sqldbaschool.com/lessons/sql-queries/) - [Different types of keys](https://sqldbaschool.com/lessons/different-types-of-keys/) - [Date Functions](https://sqldbaschool.com/lessons/date-functions/) - [SQL Count](https://sqldbaschool.com/lessons/sql-count/) - [SQL Aggregate](https://sqldbaschool.com/lessons/sql-aggregate/) - [SQL Constraint](https://sqldbaschool.com/lessons/sql-constraint/) - [SQL Wildcard](https://sqldbaschool.com/lessons/sql-wildcard/) - [SQL Order By](https://sqldbaschool.com/lessons/sql-order-by/) - [SQL Distinct](https://sqldbaschool.com/lessons/sql-distinct/) - [SQL Where Clause](https://sqldbaschool.com/lessons/sql-where-clause-2/) - [All Command SQL Syntax](https://sqldbaschool.com/lessons/sql-syntax/) - [SQL Select](https://sqldbaschool.com/lessons/sql-select/) - [SQL Functions](https://sqldbaschool.com/lessons/sql-function/) - [Complex SQL Queries?](https://sqldbaschool.com/lessons/what-is-complex-sql-queries/) - [Delete Query in SQL](https://sqldbaschool.com/lessons/delete-query-in-sql/) - [Update Query in SQL](https://sqldbaschool.com/lessons/what-is-update-query-in-sql/) - [Insert Query in SQL](https://sqldbaschool.com/lessons/what-is-the-sql-insert-query/) - [Candidate Key in SQL](https://sqldbaschool.com/lessons/candidate-key-in-sql/) - [Primary Key in SQL](https://sqldbaschool.com/lessons/primary-key-in-sql-2/) - [Foreign Key in SQL](https://sqldbaschool.com/lessons/foreign-key-in-sql-2/) - [SQL Syntax](https://sqldbaschool.com/lessons/various-sql-syntax/) - [SQL Keywords](https://sqldbaschool.com/lessons/sql-keywords-2/) - [SQL - Database Tunning](https://sqldbaschool.com/lessons/sql-database-tunning/) - [SQL - RDBMS Databases](https://sqldbaschool.com/lessons/sql-rdbms-databases/) - [SQL Server Tools for Database](https://sqldbaschool.com/lessons/sql-server-tools-for-database/) - [SQL - Useful Functions](https://sqldbaschool.com/lessons/sql-useful-functions/) - [SQL - Injection](https://sqldbaschool.com/lessons/sql-injection/) - [SQL - Handling Duplicates](https://sqldbaschool.com/lessons/sql-handling-duplicates/) - [SQL - Using Sequences](https://sqldbaschool.com/lessons/sql-using-sequences/) - [SQL - Sub Queries](https://sqldbaschool.com/lessons/sql-sub-queries/) - [SQL - Clone Tables](https://sqldbaschool.com/lessons/sql-clone-tables/) - [SQL - Temporary Tables](https://sqldbaschool.com/lessons/sql-temporary-tables/) - [SQL - Date Functions](https://sqldbaschool.com/lessons/sql-date-functions/) - [SQL - Wildcard Operators](https://sqldbaschool.com/lessons/sql-wildcard-operators/) - [SQL - Transactions](https://sqldbaschool.com/lessons/sql-transactions/) - [SQL - Having Clause](https://sqldbaschool.com/lessons/sql-having-clause-2/) - [SQL - Using Views](https://sqldbaschool.com/lessons/sql-using-views/) - [SQL - TRUNCATE TABLE Command](https://sqldbaschool.com/lessons/sql-truncate-table-command/) - [SQL - ALTER TABLE Command](https://sqldbaschool.com/lessons/sql-alter-table-command/) - [SQL - Indexes](https://sqldbaschool.com/lessons/sql-indexes/) - [SQL - Alias Syntax](https://sqldbaschool.com/lessons/sql-alias-syntax/) - [SQL - NULL Values](https://sqldbaschool.com/lessons/sql-null-values/) - [SQL - UNIONS CLAUSE](https://sqldbaschool.com/lessons/sql-unions-clause/) - [SQL - Using Joins](https://sqldbaschool.com/lessons/sql-using-joins/) - [SQL - Constraints](https://sqldbaschool.com/lessons/sql-constraints-2/) - [SQL - Data Types](https://sqldbaschool.com/lessons/sql-data-types-2/) - [SQL - Overview](https://sqldbaschool.com/lessons/sql-overview/) - [SQL - RDBMS Concepts](https://sqldbaschool.com/lessons/sql-rdbms-concepts/) - [SQL - Expressions](https://sqldbaschool.com/lessons/sql-expressions/) - [Operator in SQL](https://sqldbaschool.com/lessons/operator-in-sql/) - [SQL Server Edition Feature Comparison](https://sqldbaschool.com/lessons/sql-server-edition-feature-comparison-2/) - [2019 SQL Server Edition Feature Comparison](https://sqldbaschool.com/lessons/sql-server-edition-feature-comparison/) - [MS SQL Server - Editions](https://sqldbaschool.com/lessons/ms-sql-server-editions/) - [Different methods to identify the SQL Server version number](https://sqldbaschool.com/lessons/different-methods-to-identify-the-sql-server-version-number/) - [Upgrade SQL Server 2016 to 2017](https://sqldbaschool.com/lessons/upgrade-sql-server-2016-to-2017/) - [New Engine Features in SQL Server 2017](https://sqldbaschool.com/lessons/new-engine-features-in-sql-server-2017/) - [Differences between Versions of Windows SQL Server](https://sqldbaschool.com/lessons/differences-between-versions-of-windows-sql-server/) - [Microsoft SQL Server Editions download from 2008 to 2019](https://sqldbaschool.com/lessons/microsoft-sql-server-editions-download-from/) - [Configuration](https://sqldbaschool.com/lessons/configuration/) - [Top 10 New Features Of SQL Server 2019](https://sqldbaschool.com/lessons/top-10-new-features-of-sql-server-2019/) - [Operating Systems Requirements.](https://sqldbaschool.com/lessons/operating-systems-requirements/) - [Install SQL Server 2019 (Express) on Windows Server Core and activate remote management](https://sqldbaschool.com/lessons/install-sql-server-2019-express-on-windows-server-core-and-activate-remote-management/) - [SQL Server 2019 installation on Windows](https://sqldbaschool.com/lessons/sql-server-2019-installation-on-windows/) - [Important features of 2019 SQL Server](https://sqldbaschool.com/lessons/important-features-of-2019-sql-server/) - [Overview of SQL Server Ports](https://sqldbaschool.com/lessons/overview-of-sql-server-ports/) - [SQL Server network configuration](https://sqldbaschool.com/lessons/sql-server-network-configuration/) - [OpenIng SQL Server Configuration Manager in 2017](https://sqldbaschool.com/lessons/sql-server-security-settings-using-the-surface-area-configuration-tool/) - [SQL Server Concepts](https://sqldbaschool.com/lessons/sql-server-concepts/) - [MS SQL Server - Overview](https://sqldbaschool.com/lessons/ms-sql-server-overview/) - [How do I find SQL Server version?](https://sqldbaschool.com/lessons/how-do-i-find-sql-server-version/) - [Quick Summary of SQL Server Editions](https://sqldbaschool.com/lessons/quick-summary-of-sql-server-editions/) - [Prerequisite for installing SQL Server 2017](https://sqldbaschool.com/lessons/prerequisite-for-installing-sql-server-2017/) - [Load Sample Database](https://sqldbaschool.com/lessons/load-sample-database/) - [SQL Server Sample Database](https://sqldbaschool.com/lessons/sql-server-sample-database/) - [Connect to the SQL Server](https://sqldbaschool.com/lessons/connect-to-the-sql-server/) - [Install SQL Server 2017](https://sqldbaschool.com/lessons/install-sql-server-2017/) - [SQL Clauses](https://sqldbaschool.com/lessons/sql-clauses/) - [SQL Interview Questions](https://sqldbaschool.com/lessons/sql-interview-questions/) - [Types Of Joins In SQL](https://sqldbaschool.com/lessons/types-of-joins-in-sql/) - [SQL Date Function](https://sqldbaschool.com/lessons/sql-date-function/) - [SQL Keys](https://sqldbaschool.com/lessons/sql-keys/) - [SQL Insert Query](https://sqldbaschool.com/lessons/sql-insert-query/) - [SQL Commands](https://sqldbaschool.com/lessons/sql-commands/) - [SQL Operators](https://sqldbaschool.com/lessons/sql-operators/) - [SQL Server Interview Questions](https://sqldbaschool.com/lessons/sql-server-interview-questions/) - [SQL Joins Interview Questions](https://sqldbaschool.com/lessons/sql-joins-interview-questions/) - [Advance SQL Interview Questions](https://sqldbaschool.com/lessons/advance-sql-interview-questions/) - [Natural Join SQL](https://sqldbaschool.com/lessons/natural-join-sql/) - [SQL Self Join](https://sqldbaschool.com/lessons/sql-self-join/) - [SQL Full Join](https://sqldbaschool.com/lessons/sql-full-join/) - [SQL Outer Join](https://sqldbaschool.com/lessons/sql-outer-join/) - [SQL Cross Join](https://sqldbaschool.com/lessons/sql-cross-join/) - [SQL Right Join](https://sqldbaschool.com/lessons/sql-right-join/) - [SQL Left Join](https://sqldbaschool.com/lessons/sql-left-join/) - [SQL Delete Join](https://sqldbaschool.com/lessons/sql-delete-join/) - [SQL Join Two Tables](https://sqldbaschool.com/lessons/sql-join-two-tables/) - [SQL Inner Join](https://sqldbaschool.com/lessons/sql-inner-join/) - [Types Of Joins In SQL Server](https://sqldbaschool.com/lessons/types-of-joins-in-sql-server/) - [SQL CTE](https://sqldbaschool.com/lessons/sql-cte/) - [SQL RANK()](https://sqldbaschool.com/lessons/sql-rank/) - [CUBE In SQL](https://sqldbaschool.com/lessons/cube-in-sql/) - [SQL Server Substring](https://sqldbaschool.com/lessons/sql-server-substring/) - [TOP In SQL](https://sqldbaschool.com/lessons/top-in-sql/) - [LTRIM() In SQL](https://sqldbaschool.com/lessons/ltrim-in-sql/) - [BETWEEN In SQL](https://sqldbaschool.com/lessons/between-in-sql/) - [LIKE Query In SQL](https://sqldbaschool.com/lessons/like-query-in-sql/) - [ANY In SQL](https://sqldbaschool.com/lessons/any-in-sql/) - [SQL TO_DATE()](https://sqldbaschool.com/lessons/sql-to_date/) - [SQL Timestamp](https://sqldbaschool.com/lessons/sql-timestamp/) - [SQL String Functions](https://sqldbaschool.com/lessons/sql-string-functions/) - [SQL DATEADD()](https://sqldbaschool.com/lessons/sql-dateadd/) - [Alternate Key In SQL](https://sqldbaschool.com/lessons/alternate-key-in-sql/) - [Unique Key In SQL](https://sqldbaschool.com/lessons/unique-key-in-sql/) - [Foreign Key In SQL](https://sqldbaschool.com/lessons/foreign-key-in-sql/) - [Primary Key In SQL](https://sqldbaschool.com/lessons/primary-key-in-sql/) - [SQL Subquery](https://sqldbaschool.com/lessons/sql-subquery/) - [SQL SELECT RANDOM](https://sqldbaschool.com/lessons/sql-select-random/) - [SQL SELECT Query](https://sqldbaschool.com/lessons/sql-select-query/) - [ORDER BY Clause In SQL](https://sqldbaschool.com/lessons/order-by-clause-in-sql/) - [GROUP BY Clause In SQL](https://sqldbaschool.com/lessons/group-by-clause-in-sql/) - [SQL HAVING Clause](https://sqldbaschool.com/lessons/sql-having-clause/) - [SQL With Clause](https://sqldbaschool.com/lessons/sql-with-clause/) - [SQL WHERE Clause](https://sqldbaschool.com/lessons/sql-where-clause/) - [SQL Minus](https://sqldbaschool.com/lessons/sql-minus/) - [SQL LIKE Clause](https://sqldbaschool.com/lessons/sql-like-clause/) - [SQL IN Operator](https://sqldbaschool.com/lessons/sql-in-operator/) - [Careers In SQL Server](https://sqldbaschool.com/lessons/careers-in-sql-server/) - [MySQL Queries](https://sqldbaschool.com/lessons/mysql-queries/) - [Cheat Sheet MySQL](https://sqldbaschool.com/lessons/cheat-sheet-mysql/) - [MySQL Administration](https://sqldbaschool.com/lessons/mysql-administration/) - [MySQL Constraints](https://sqldbaschool.com/lessons/mysql-constraints/) - [Wildcards In MySQL](https://sqldbaschool.com/lessons/wildcards-in-mysql/) - [What Is MySQL Schema](https://sqldbaschool.com/lessons/what-is-mysql-schema/) - [MySQL Operators](https://sqldbaschool.com/lessons/mysql-operators/) - [Views In MySQL](https://sqldbaschool.com/lessons/views-in-mysql/) - [MySQL Commands](https://sqldbaschool.com/lessons/mysql-commands/) - [MySQL OpenSource](https://sqldbaschool.com/lessons/mysql-opensource/) - [How To Install MySQL](https://sqldbaschool.com/lessons/how-to-install-mysql/) - [MySQL Server](https://sqldbaschool.com/lessons/mysql-server/) - [Is MySQL Programming Language](https://sqldbaschool.com/lessons/is-mysql-programming-language/) - [What Is MySQL](https://sqldbaschool.com/lessons/what-is-mysql/) - [Introduction To MySQL](https://sqldbaschool.com/lessons/introduction-to-mysql/) - [DBMS Interview Questions](https://sqldbaschool.com/lessons/dbms-interview-questions/) - [RDBMS Interview Questions](https://sqldbaschool.com/lessons/rdbms-interview-questions/) - [MySQL Database Repair](https://sqldbaschool.com/lessons/mysql-database-repair/) - [How To Connect Database To MySQL](https://sqldbaschool.com/lessons/how-to-connect-database-to-mysql/) - [MySQL Relational Database](https://sqldbaschool.com/lessons/mysql-relational-database/) - [What Is MySQL Database](https://sqldbaschool.com/lessons/what-is-mysql-database/) - [Types of Keys in DBMS](https://sqldbaschool.com/lessons/dbms-keys/) - [DBMS Architecture](https://sqldbaschool.com/lessons/dbms-architecture/) - [What Is Data Processing](https://sqldbaschool.com/lessons/what-is-data-processing/) - [What Is Data Modeling](https://sqldbaschool.com/lessons/what-is-data-modeling/) - [MYSQL Interview Questions](https://sqldbaschool.com/lessons/interview-questions/) - [Joins In MySQL](https://sqldbaschool.com/lessons/joins-in-mysql/) - [MySQL Aggregate Function](https://sqldbaschool.com/lessons/mysql-aggregate-function/) - [Backup and Restore SQL Server](https://sqldbaschool.com/lessons/backup-and-restore-sql-server/) - [Basic SQL Commands - The List of Database Queries and Statements You Should Know](https://sqldbaschool.com/lessons/what-is-sql-language/) - [Understanding security fundamentals](https://sqldbaschool.com/lessons/understanding-security-fundamentals/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know-8/) - [Challenges explained](https://sqldbaschool.com/lessons/challenges-explained/) - [Using the exercise files](https://sqldbaschool.com/lessons/using-the-exercise-files-5/) - [Preparing for the MTA Exam 98-364](https://sqldbaschool.com/lessons/preparing-for-the-mta-exam-98-364/) - [Weclome](https://sqldbaschool.com/lessons/weclome/) - [To sump up and Next steps](https://sqldbaschool.com/lessons/to-sump-up-and-next-steps/) - [SUMMARY](https://sqldbaschool.com/lessons/summary/) - [Create a view of the data](https://sqldbaschool.com/lessons/create-a-view-of-the-data-5/) - [Add data with an INSERT statement](https://sqldbaschool.com/lessons/add-data-with-an-insert-statement-3/) - [Write an UPDATE statement](https://sqldbaschool.com/lessons/write-an-update-statement-4/) - [Use functions to calculate values](https://sqldbaschool.com/lessons/use-functions-to-calculate-values-4/) - [Create a SELECT statement](https://sqldbaschool.com/lessons/create-a-select-statement-4/) - [Join tables together with keys](https://sqldbaschool.com/lessons/join-tables-together-with-keys-4/) - [Create a data table](https://sqldbaschool.com/lessons/create-a-data-table-4/) - [Understand SQL data types](https://sqldbaschool.com/lessons/understand-sql-data-types-4/) - [Create a new database on the server](https://sqldbaschool.com/lessons/create-a-new-database-on-the-server-4/) - [Install a sample database](https://sqldbaschool.com/lessons/install-a-sample-database-5/) - [Tour the SSMS interface](https://sqldbaschool.com/lessons/tour-the-ssms-interface-4/) - [Locate SQL Server documentation](https://sqldbaschool.com/lessons/locate-sql-server-documentation-4/) - [Log in to the server](https://sqldbaschool.com/lessons/log-in-to-the-server-3/) - [Configure and start the server](https://sqldbaschool.com/lessons/configure-and-start-the-server-4/) - [Installing SQL Server](https://sqldbaschool.com/lessons/installing-sql-server-2/) - [Understand the editions of SQL Server](https://sqldbaschool.com/lessons/understand-the-editions-of-sql-server-3/) - [What is SQL Server?](https://sqldbaschool.com/lessons/what-is-sql-server-4/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know-7/) - [Welcome](https://sqldbaschool.com/lessons/welcome-9/) - [Summing up and Next Steps](https://sqldbaschool.com/lessons/summing-up-and-next-steps-4/) - [Restoring a database](https://sqldbaschool.com/lessons/restoring-a-database/) - [Scheduling a backup](https://sqldbaschool.com/lessons/scheduling-a-backup/) - [Backing up a database](https://sqldbaschool.com/lessons/backing-up-a-database/) - [Designing a backup-and-restore strategy](https://sqldbaschool.com/lessons/designing-a-backup-and-restore-strategy/) - [Understanding SQL Server backup and restore options](https://sqldbaschool.com/lessons/understanding-sql-server-backup-and-restore-options/) - [Securing the database](https://sqldbaschool.com/lessons/securing-the-database/) - [Connecting to a database](https://sqldbaschool.com/lessons/connecting-to-a-database/) - [Creating a database using Transact-SQL](https://sqldbaschool.com/lessons/creating-a-database-using-transact-sql/) - [Creating a database using Management Studio](https://sqldbaschool.com/lessons/creating-a-database-using-management-studio/) - [Understanding SQL Server database files](https://sqldbaschool.com/lessons/understanding-sql-server-database-files/) - [Configure client and network connections](https://sqldbaschool.com/lessons/configure-client-and-network-connections/) - [Configure SQL Server services](https://sqldbaschool.com/lessons/configure-sql-server-services/) - [SQL Server properties: Security, Connections, and Advanced sections](https://sqldbaschool.com/lessons/sql-server-properties-security-connections-and-advanced-sections/) - [SQL Server properties: Machine resources](https://sqldbaschool.com/lessons/sql-server-properties-machine-resources/) - [Testing the installation and connectivity](https://sqldbaschool.com/lessons/testing-the-installation-and-connectivity/) - [Adding or removing features](https://sqldbaschool.com/lessons/adding-or-removing-features/) - [Install SQL Server from the command prompt](https://sqldbaschool.com/lessons/install-sql-server-from-the-command-prompt/) - [Install SQL Server using the GUI: Engine and installation](https://sqldbaschool.com/lessons/install-sql-server-using-the-gui-engine-and-installation/) - [Install SQL Server using the GUI: Instance and server](https://sqldbaschool.com/lessons/install-sql-server-using-the-gui-instance-and-server/) - [Install SQL Server using the GUI: Role and features](https://sqldbaschool.com/lessons/install-sql-server-using-the-gui-role-and-features/) - [Install SQL Server using the GUI: Getting started](https://sqldbaschool.com/lessons/install-sql-server-using-the-gui-getting-started/) - [Installation options](https://sqldbaschool.com/lessons/installation-options/) - [SQL Server components](https://sqldbaschool.com/lessons/sql-server-components/) - [Hardware requirements](https://sqldbaschool.com/lessons/hardware-requirements/) - [SQL Server versions and supported operating systems](https://sqldbaschool.com/lessons/sql-server-versions-and-supported-operating-systems/) - [Welcome](https://sqldbaschool.com/lessons/welcome-8/) - [Summing up and Next Steps](https://sqldbaschool.com/lessons/summing-up-and-next-steps-3/) - [Performing an SQL backup with PowerShell](https://sqldbaschool.com/lessons/performing-an-sql-backup-with-powershell/) - [Using Windows PowerShell to run SQL commands](https://sqldbaschool.com/lessons/using-windows-powershell-to-run-sql-commands/) - [Introduction to Windows PowerShell](https://sqldbaschool.com/lessons/introduction-to-windows-powershell/) - [Exploring health data](https://sqldbaschool.com/lessons/exploring-health-data/) - [Populating the data warehouse](https://sqldbaschool.com/lessons/populating-the-data-warehouse/) - [Introduction to server health monitoring](https://sqldbaschool.com/lessons/introduction-to-server-health-monitoring/) - [Using policy-based management to prevent problems](https://sqldbaschool.com/lessons/using-policy-based-management-to-prevent-problems/) - [Extending policy-based management to repair problems](https://sqldbaschool.com/lessons/extending-policy-based-management-to-repair-problems/) - [Implementing policy-based management](https://sqldbaschool.com/lessons/implementing-policy-based-management/) - [Introduction to policy-based management](https://sqldbaschool.com/lessons/introduction-to-policy-based-management/) - [Indexing tips](https://sqldbaschool.com/lessons/indexing-tips/) - [Working with columnstore indexes](https://sqldbaschool.com/lessons/working-with-columnstore-indexes/) - [Working with query plans](https://sqldbaschool.com/lessons/working-with-query-plans/) - [Using indexes](https://sqldbaschool.com/lessons/using-indexes/) - [Understanding indexes](https://sqldbaschool.com/lessons/understanding-indexes/) - [Using FileStream data](https://sqldbaschool.com/lessons/using-filestream-data/) - [Enabling FileStream access](https://sqldbaschool.com/lessons/enabling-filestream-access/) - [Restoring filegroups separately](https://sqldbaschool.com/lessons/restoring-filegroups-separately/) - [Planning compression](https://sqldbaschool.com/lessons/planning-compression/) - [Planning for partitioning](https://sqldbaschool.com/lessons/planning-for-partitioning/) - [Using multiple files](https://sqldbaschool.com/lessons/using-multiple-files/) - [Understanding files and filegroups](https://sqldbaschool.com/lessons/understanding-files-and-filegroups/) - [Designing data warehouses](https://sqldbaschool.com/lessons/designing-data-warehouses/) - [Using third normal form](https://sqldbaschool.com/lessons/using-third-normal-form/) - [Using second normal form](https://sqldbaschool.com/lessons/using-second-normal-form/) - [Using first normal form](https://sqldbaschool.com/lessons/using-first-normal-form/) - [Designing OLTP databases](https://sqldbaschool.com/lessons/designing-oltp-databases/) - [Managing server resources in a consolidated database infrastructure](https://sqldbaschool.com/lessons/managing-server-resources-in-a-consolidated-database-infrastructure/) - [Considerations for database server consolidation](https://sqldbaschool.com/lessons/v-2/) - [Planning a database server infrastructure](https://sqldbaschool.com/lessons/planning-a-database-server-infrastructure/) - [Setting up for the course](https://sqldbaschool.com/lessons/setting-up-for-the-course/) - [What you should know before watching this course](https://sqldbaschool.com/lessons/what-you-should-know-before-watching-this-course-2/) - [Welcome](https://sqldbaschool.com/lessons/welcome-7/) - [Summing up and Next steps](https://sqldbaschool.com/lessons/summing-up-and-next-steps-2/) - [Find ranks](https://sqldbaschool.com/lessons/find-ranks/) - [Year over year calculations](https://sqldbaschool.com/lessons/year-over-year-calculations/) - [Common table expressions](https://sqldbaschool.com/lessons/common-table-expressions/) - [Date time functions](https://sqldbaschool.com/lessons/date-time-functions/) - [Analyze employee data](https://sqldbaschool.com/lessons/analyze-employee-data/) - [Rolling calculations](https://sqldbaschool.com/lessons/rolling-calculations/) - [Subqueries](https://sqldbaschool.com/lessons/subqueries/) - [Window functions](https://sqldbaschool.com/lessons/window-functions/) - [Aggregate data](https://sqldbaschool.com/lessons/aggregate-data/) - [Filer data](https://sqldbaschool.com/lessons/filer-data/) - [Joins tables](https://sqldbaschool.com/lessons/joins-tables/) - [Retrieve data using SQL](https://sqldbaschool.com/lessons/retrieve-data-using-sql/) - [Using the exercise files](https://sqldbaschool.com/lessons/using-the-exercise-files-4/) - [Using the exercise files](https://sqldbaschool.com/lessons/using-the-exercise-files-3/) - [What you should know before watching this course](https://sqldbaschool.com/lessons/what-you-should-know-before-watching-this-course/) - [Welcome](https://sqldbaschool.com/lessons/welcome-6/) - [Summing up and Next steps](https://sqldbaschool.com/lessons/summing-up-and-next-steps/) - [Exploring execution plans](https://sqldbaschool.com/lessons/exploring-execution-plans/) - [Creating an index](https://sqldbaschool.com/lessons/creating-an-index/) - [Basics of indexes](https://sqldbaschool.com/lessons/basics-of-indexes-2/) - [Importing and exporting Unicode data](https://sqldbaschool.com/lessons/importing-and-exporting-unicode-data/) - [Importing data](https://sqldbaschool.com/lessons/importing-data/) - [Exporting data](https://sqldbaschool.com/lessons/exporting-data/) - [Encrypting data](https://sqldbaschool.com/lessons/encrypting-data/) - [Database-level users](https://sqldbaschool.com/lessons/database-level-users-2/) - [Instance-level logins](https://sqldbaschool.com/lessons/instance-level-logins-2/) - [Overview of authentication in SQL Server](https://sqldbaschool.com/lessons/overview-of-authentication-in-sql-server-2/) - [Using DBCC](https://sqldbaschool.com/lessons/using-dbcc/) - [Understanding dynamic management views](https://sqldbaschool.com/lessons/v/) - [Using Performance Monitor](https://sqldbaschool.com/lessons/using-performance-monitor/) - [Auditing logins](https://sqldbaschool.com/lessons/auditing-logins/) - [Review logs in SQL Server 2014](https://sqldbaschool.com/lessons/review-logs-in-sql-server-2014/) - [Adding a cleanup task to a maintenance plan](https://sqldbaschool.com/lessons/adding-a-cleanup-task-to-a-maintenance-plan/) - [Creating maintenance plans to automate backups](https://sqldbaschool.com/lessons/creating-maintenance-plans-to-automate-backups/) - [Differential backup and restore](https://sqldbaschool.com/lessons/differential-backup-and-restore/) - [Basic restore](https://sqldbaschool.com/lessons/basic-restore-2/) - [Basic backups](https://sqldbaschool.com/lessons/basic-backups-2/) - [Overview of backups in SQL Server](https://sqldbaschool.com/lessons/overview-of-backups-in-sql-server/) - [Storing XML](https://sqldbaschool.com/lessons/storing-xml-2/) - [Working with XML schemas](https://sqldbaschool.com/lessons/working-with-xml-schemas-2/) - [Shredding XML](https://sqldbaschool.com/lessons/shredding-xml/) - [Writing queries to return XML](https://sqldbaschool.com/lessons/writing-queries-to-return-xml/) - [Intro to XML](https://sqldbaschool.com/lessons/intro-to-xml/) - [Scalar functions](https://sqldbaschool.com/lessons/scalar-functions-2/) - [Built-in functions](https://sqldbaschool.com/lessons/built-in-functions-2/) - [Parameterized stored procedures](https://sqldbaschool.com/lessons/parameterized-stored-procedures-3/) - [Stored procedures](https://sqldbaschool.com/lessons/stored-procedures-2/) - [Understanding advanced options of views](https://sqldbaschool.com/lessons/understanding-advanced-options-of-views/) - [Creating a view](https://sqldbaschool.com/lessons/creating-a-view/) - [DELETE statements](https://sqldbaschool.com/lessons/delete-statements/) - [UPDATE statements](https://sqldbaschool.com/lessons/update-statements/) - [INSERT statements](https://sqldbaschool.com/lessons/insert-statements/) - [Sorting results with ORDER BY](https://sqldbaschool.com/lessons/sorting-results-with-order-by/) - [Using wildcards in a WHERE clause](https://sqldbaschool.com/lessons/using-wildcards-in-a-where-clause/) - [Filtering results with a WHERE clause](https://sqldbaschool.com/lessons/filtering-results-with-a-where-clause/) - [Basic SELECT statement](https://sqldbaschool.com/lessons/basic-select-statement/) - [What is SQL?](https://sqldbaschool.com/lessons/what-is-sql/) - [In memory tables](https://sqldbaschool.com/lessons/in-memory-tables-2/) - [Creating relationships between tables](https://sqldbaschool.com/lessons/creating-relationships-between-tables/) - [Creating a table using T-SQL](https://sqldbaschool.com/lessons/creating-a-table-using-t-sql/) - [Understanding data column options](https://sqldbaschool.com/lessons/understanding-data-column-options-2/) - [Creating a table using Managment Studio](https://sqldbaschool.com/lessons/creating-a-table-using-managment-studio/) - [Installing sample database](https://sqldbaschool.com/lessons/installing-sample-database/) - [Advanced options of database configuration](https://sqldbaschool.com/lessons/advanced-options-of-database-configuration/) - [Creating a database](https://sqldbaschool.com/lessons/creating-a-database/) - [More about SQL Server Management Studio](https://sqldbaschool.com/lessons/more-about-sql-server-management-studio-2/) - [Basics of SQL Server Management Studio](https://sqldbaschool.com/lessons/basics-of-sql-server-management-studio/) - [Using SQL Server Configuration Manager](https://sqldbaschool.com/lessons/using-sql-server-configuration-manager-2/) - [Advanced installation options](https://sqldbaschool.com/lessons/advanced-installation-options-2/) - [Basic installation](https://sqldbaschool.com/lessons/basic-installation-2/) - [Installation prerequisites](https://sqldbaschool.com/lessons/installation-prerequisites/) - [SQL Server additional editions](https://sqldbaschool.com/lessons/sql-server-additional-editions/) - [SQL Server principal editions](https://sqldbaschool.com/lessons/sql-server-principal-editions/) - [Understanding the core concepts of SQL Server 2014](https://sqldbaschool.com/lessons/understanding-the-core-concepts-of-sql-server-2014/) - [Using the exercise files](https://sqldbaschool.com/lessons/using-the-exercise-files-2/) - [What you should know before starting](https://sqldbaschool.com/lessons/what-you-should-know-before-starting-2/) - [Welcome](https://sqldbaschool.com/lessons/welcome-5/) - [Conclusion and sum up](https://sqldbaschool.com/lessons/conclusion-and-sum-up/) - [Create a view of the data](https://sqldbaschool.com/lessons/create-a-view-of-the-data-4/) - [Add data with an INSERT statement](https://sqldbaschool.com/lessons/add-data-with-an-insert-statement-2/) - [Write an UPDATE statement](https://sqldbaschool.com/lessons/write-an-update-statement-3/) - [Use functions to calculate values](https://sqldbaschool.com/lessons/use-functions-to-calculate-values-3/) - [Create a SELECT statement](https://sqldbaschool.com/lessons/create-a-select-statement-3/) - [Join tables together with keys](https://sqldbaschool.com/lessons/join-tables-together-with-keys-3/) - [Create a data table](https://sqldbaschool.com/lessons/create-a-data-table-3/) - [Understand SQL data types](https://sqldbaschool.com/lessons/understand-sql-data-types-3/) - [Create a new database on the server](https://sqldbaschool.com/lessons/create-a-new-database-on-the-server-3/) - [Install a sample database](https://sqldbaschool.com/lessons/tour-the-ssms-interface-3/) - [Tour the SSMS interface](https://sqldbaschool.com/lessons/tour-the-ssms-interface-2/) - [Locate SQL Server documentation](https://sqldbaschool.com/lessons/locate-sql-server-documentation-3/) - [Log in to the server](https://sqldbaschool.com/lessons/log-in-to-the-server-2/) - [Configure and start the server](https://sqldbaschool.com/lessons/configure-and-start-the-server-3/) - [Install SQL Server](https://sqldbaschool.com/lessons/install-sql-server-2/) - [Understand the editions of SQL Server](https://sqldbaschool.com/lessons/understand-the-editions-of-sql-server-2/) - [What is SQL Server](https://sqldbaschool.com/lessons/what-is-sql-server-3/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know-6/) - [Welcome](https://sqldbaschool.com/lessons/welcome-4/) - [Sumup and Next steps](https://sqldbaschool.com/lessons/sumup-and-next-steps/) - [Monitor Stretch Database](https://sqldbaschool.com/lessons/monitor-stretch-database/) - [Set up Stretch Database](https://sqldbaschool.com/lessons/set-up-stretch-database/) - [Back up to Azure](https://sqldbaschool.com/lessons/back-up-to-azure/) - [Overview of Query Store](https://sqldbaschool.com/lessons/overview-of-query-store/) - [Explore execution plans](https://sqldbaschool.com/lessons/explore-execution-plans/) - [Columnstore index](https://sqldbaschool.com/lessons/columnstore-index/) - [Create an index](https://sqldbaschool.com/lessons/create-an-index/) - [Basics of indexes](https://sqldbaschool.com/lessons/basics-of-indexes/) - [Dynamic masking](https://sqldbaschool.com/lessons/dynamic-masking/) - [Encrypt data](https://sqldbaschool.com/lessons/encrypt-data/) - [Database-level users](https://sqldbaschool.com/lessons/database-level-users/) - [Instance-level logins](https://sqldbaschool.com/lessons/instance-level-logins/) - [Overview of authentication in SQL Server](https://sqldbaschool.com/lessons/overview-of-authentication-in-sql-server/) - [Overview of high availability in SQL Server 2016](https://sqldbaschool.com/lessons/overview-of-high-availability-in-sql-server-2016/) - [Using database console commands (DBCC)](https://sqldbaschool.com/lessons/using-database-console-commands-dbcc/) - [Understanding dynamic management views](https://sqldbaschool.com/lessons/understanding-dynamic-management-views/) - [Audit logins](https://sqldbaschool.com/lessons/audit-logins/) - [Review logs in SQL Server 2016](https://sqldbaschool.com/lessons/review-logs-in-sql-server-2016/) - [Add a cleanup task to a maintenance plan](https://sqldbaschool.com/lessons/add-a-cleanup-task-to-a-maintenance-plan/) - [Create maintenance plans to automate backups](https://sqldbaschool.com/lessons/create-maintenance-plans-to-automate-backups/) - [Basic restore](https://sqldbaschool.com/lessons/basic-restore/) - [Basic backups](https://sqldbaschool.com/lessons/basic-backups/) - [Overview of backup and restore in SQL Server](https://sqldbaschool.com/lessons/overview-of-backup-and-restore-in-sql-server/) - [Storing JSON](https://sqldbaschool.com/lessons/storing-json/) - [Converting JSON to tabular data](https://sqldbaschool.com/lessons/converting-json-to-tabular-data/) - [Working with JSON](https://sqldbaschool.com/lessons/working-with-json/) - [Storing XML](https://sqldbaschool.com/lessons/storing-xml/) - [Working with XML schemas](https://sqldbaschool.com/lessons/working-with-xml-schemas/) - [Shred XML](https://sqldbaschool.com/lessons/shred-xml/) - [Write queries to return XML](https://sqldbaschool.com/lessons/write-queries-to-return-xml/) - [Introduction to XML](https://sqldbaschool.com/lessons/introduction-to-xml/) - [Scalar functions](https://sqldbaschool.com/lessons/scalar-functions/) - [Built-in functions](https://sqldbaschool.com/lessons/built-in-functions/) - [Parameterized stored procedures](https://sqldbaschool.com/lessons/parameterized-stored-procedures-2/) - [Stored procedures](https://sqldbaschool.com/lessons/stored-procedures/) - [Understanding the advanced options of views](https://sqldbaschool.com/lessons/understanding-the-advanced-options-of-views/) - [Create a view](https://sqldbaschool.com/lessons/create-a-view/) - [Temporal tables](https://sqldbaschool.com/lessons/temporal-tables/) - [In-memory tables](https://sqldbaschool.com/lessons/in-memory-tables/) - [Create relationships between tables](https://sqldbaschool.com/lessons/create-relationships-between-tables-2/) - [Create a table using T-SQL](https://sqldbaschool.com/lessons/create-a-table-using-t-sql/) - [Understanding data column options](https://sqldbaschool.com/lessons/understanding-data-column-options/) - [Create a table using Management Studio](https://sqldbaschool.com/lessons/create-a-table-using-management-studio/) - [Install a sample database](https://sqldbaschool.com/lessons/install-a-sample-database-4/) - [Advanced database configuration options](https://sqldbaschool.com/lessons/advanced-database-configuration-options/) - [Create a database](https://sqldbaschool.com/lessons/create-a-database/) - [SQL Server Profiler](https://sqldbaschool.com/lessons/sql-server-profiler/) - [Activity Monitor](https://sqldbaschool.com/lessons/activity-monitor/) - [More about SQL Server Management Studio](https://sqldbaschool.com/lessons/more-about-sql-server-management-studio/) - [Basics SQL Server Management Studio](https://sqldbaschool.com/lessons/basics-sql-server-management-studio/) - [Using SQL Server Configuration Manager](https://sqldbaschool.com/lessons/using-sql-server-configuration-manager/) - [Install SQL Management Studio](https://sqldbaschool.com/lessons/install-sql-management-studio/) - [Advanced installation options](https://sqldbaschool.com/lessons/advanced-installation-options/) - [Basic installation](https://sqldbaschool.com/lessons/basic-installation/) - [SQL Server editions](https://sqldbaschool.com/lessons/sql-server-editions/) - [Understanding core concepts of SQL Server 2016](https://sqldbaschool.com/lessons/understanding-core-concepts-of-sql-server-2016/) - [Using the exercise files](https://sqldbaschool.com/lessons/using-the-exercise-files/) - [What you should know before starting](https://sqldbaschool.com/lessons/what-you-should-know-before-starting/) - [Welcome](https://sqldbaschool.com/lessons/welcome-3/) - [Next steps](https://sqldbaschool.com/lessons/next-steps-3/) - [New dynamic management views](https://sqldbaschool.com/lessons/new-dynamic-management-views/) - [Automatic query performance tuning](https://sqldbaschool.com/lessons/automatic-query-performance-tuning/) - [Resuming online index rebuilds](https://sqldbaschool.com/lessons/resuming-online-index-rebuilds/) - [Querying graph data](https://sqldbaschool.com/lessons/querying-graph-data/) - [Defining nodes and edges](https://sqldbaschool.com/lessons/defining-nodes-and-edges/) - [What is a graph database?](https://sqldbaschool.com/lessons/what-is-a-graph-database/) - [Manipulating data with Python](https://sqldbaschool.com/lessons/manipulating-data-with-python/) - [Installing Python](https://sqldbaschool.com/lessons/installing-python/) - [Machine Learning Services](https://sqldbaschool.com/lessons/machine-learning-services/) - [Running SQL Server in a Docker container](https://sqldbaschool.com/lessons/running-sql-server-in-a-docker-container/) - [Differences in SQL Server on Linux](https://sqldbaschool.com/lessons/differences-in-sql-server-on-linux/) - [Installing SQL Server on Linux](https://sqldbaschool.com/lessons/installing-sql-server-on-linux/) - [Connecting to a VM with PuTTY](https://sqldbaschool.com/lessons/connecting-to-a-vm-with-putty/) - [Creating a SQL Server 2017 virtual machine](https://sqldbaschool.com/lessons/creating-a-sql-server-2017-virtual-machine/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know-5/) - [Welcome](https://sqldbaschool.com/lessons/welcome-2/) - [Sump up](https://sqldbaschool.com/lessons/sump-up/) - [Create a view of the data](https://sqldbaschool.com/lessons/create-a-view-of-the-data-3/) - [Add data with an INSERT statement](https://sqldbaschool.com/lessons/add-data-with-an-insert-statement/) - [Write an UPDATE statement](https://sqldbaschool.com/lessons/write-an-update-statement-2/) - [Use functions to calculate values](https://sqldbaschool.com/lessons/use-functions-to-calculate-values-2/) - [Create a SELECT statement](https://sqldbaschool.com/lessons/create-a-select-statement-2/) - [Join tables together with keys](https://sqldbaschool.com/lessons/join-tables-together-with-keys-2/) - [Create a data table](https://sqldbaschool.com/lessons/create-a-data-table-2/) - [Understand SQL data types](https://sqldbaschool.com/lessons/understand-sql-data-types-2/) - [Create a new database on the server](https://sqldbaschool.com/lessons/create-a-new-database-on-the-server-2/) - [Install a sample database](https://sqldbaschool.com/lessons/install-a-sample-database-3/) - [Tour the SSMS interface](https://sqldbaschool.com/lessons/tour-the-ssms-interface/) - [Locate SQL Server documentation](https://sqldbaschool.com/lessons/locate-sql-server-documentation-2/) - [Log into the server](https://sqldbaschool.com/lessons/log-into-the-server/) - [Configure and start the server](https://sqldbaschool.com/lessons/configure-and-start-the-server-2/) - [Install SQL Server](https://sqldbaschool.com/lessons/install-sql-server/) - [Understand the editions of SQL Server](https://sqldbaschool.com/lessons/understand-the-editions-of-sql-server/) - [What is SQL Server?](https://sqldbaschool.com/lessons/what-is-sql-server-2/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know-4/) - [Transform your powerful data with SQL Server 2019](https://sqldbaschool.com/lessons/transform-your-powerful-data-with-sql-server-2019/) - [Next steps](https://sqldbaschool.com/lessons/next-steps-2/) - [Miscellaneous tips](https://sqldbaschool.com/lessons/miscellaneous-tips/) - [Parallel query execution](https://sqldbaschool.com/lessons/parallel-query-execution/) - [Hints to the query optimizer](https://sqldbaschool.com/lessons/hints-to-the-query-optimizer/) - [Collect statistics about data in tables](https://sqldbaschool.com/lessons/collect-statistics-about-data-in-tables/) - [Refreshing materialized views](https://sqldbaschool.com/lessons/refreshing-materialized-views/) - [Creating materialized views](https://sqldbaschool.com/lessons/creating-materialized-views/) - [Materialized views](https://sqldbaschool.com/lessons/materialized-views/) - [Partition by hash example](https://sqldbaschool.com/lessons/partition-by-hash-example/) - [Partition by hash](https://sqldbaschool.com/lessons/partition-by-hash/) - [Partition by list example](https://sqldbaschool.com/lessons/partition-by-list-example/) - [Partition by list](https://sqldbaschool.com/lessons/partition-by-list/) - [Partition by range example](https://sqldbaschool.com/lessons/partition-by-range-example/) - [Partition by range](https://sqldbaschool.com/lessons/partition-by-range/) - [Horizontal vs. vertical partitioning](https://sqldbaschool.com/lessons/horizontal-vs-vertical-partitioning/) - [Subqueries vs. joins](https://sqldbaschool.com/lessons/subqueries-vs-joins/) - [Merge join example](https://sqldbaschool.com/lessons/merge-join-example/) - [Merge joins](https://sqldbaschool.com/lessons/merge-joins/) - [Hash join example plan](https://sqldbaschool.com/lessons/hash-join-example-plan/) - [Hash joins](https://sqldbaschool.com/lessons/hash-joins/) - [Nested loop example plan](https://sqldbaschool.com/lessons/nested-loop-example-plan/) - [Nested loops](https://sqldbaschool.com/lessons/nested-loops/) - [What affects joins performance?](https://sqldbaschool.com/lessons/what-affects-joins-performance/) - [PostgreSQL-specific indexes](https://sqldbaschool.com/lessons/postgresql-specific-indexes/) - [Hash index example plan](https://sqldbaschool.com/lessons/hash-index-example-plan/) - [Hash indexes](https://sqldbaschool.com/lessons/hash-indexes/) - [Bitmap index example plan](https://sqldbaschool.com/lessons/bitmap-index-example-plan/) - [Bitmap indexes](https://sqldbaschool.com/lessons/bitmap-indexes/) - [B-tree index example plan](https://sqldbaschool.com/lessons/b-tree-index-example-plan/) - [B-tree indexes](https://sqldbaschool.com/lessons/b-tree-indexes/) - [Indexing](https://sqldbaschool.com/lessons/indexing/) - [Indexes](https://sqldbaschool.com/lessons/indexes/) - [Example plan: Selecting with a WHERE clause](https://sqldbaschool.com/lessons/example-plan-selecting-with-a-where-clause/) - [Explain and analyze](https://sqldbaschool.com/lessons/explain-and-analyze/) - [Overview of pgAdmin](https://sqldbaschool.com/lessons/overview-of-pgadmin/) - [Installing PostgreSQL](https://sqldbaschool.com/lessons/installing-postgresql/) - [Partitioning data](https://sqldbaschool.com/lessons/partitioning-data/) - [Joining tables](https://sqldbaschool.com/lessons/joining-tables/) - [Scanning tables and indexes](https://sqldbaschool.com/lessons/scanning-tables-and-indexes/) - [From declarative SQL to a procedural execution plan](https://sqldbaschool.com/lessons/from-declarative-sql-to-a-procedural-execution-plan/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know-3/) - [Reduce query response time with query tuning](https://sqldbaschool.com/lessons/reduce-query-response-time-with-query-tuning/) - [Thank you](https://sqldbaschool.com/lessons/thank-you/) - [MEMORY](https://sqldbaschool.com/lessons/memory/) - [MyISAM](https://sqldbaschool.com/lessons/myisam/) - [InnooDB](https://sqldbaschool.com/lessons/innoodb/) - [The CREATE TABLE statement](https://sqldbaschool.com/lessons/the-create-table-statement/) - [MYSQL storage engines overview](https://sqldbaschool.com/lessons/mysql-storage-engines-overview/) - [Password expiration](https://sqldbaschool.com/lessons/password-expiration/) - [Access roles](https://sqldbaschool.com/lessons/access-roles/) - [Database access privileges](https://sqldbaschool.com/lessons/database-access-privileges/) - [Hostnames and wildcards](https://sqldbaschool.com/lessons/hostnames-and-wildcards/) - [Creating user accounts](https://sqldbaschool.com/lessons/creating-user-accounts/) - [Installing some example databases](https://sqldbaschool.com/lessons/installing-some-example-databases/) - [Install MYSQL Workbench on Ubuntu](https://sqldbaschool.com/lessons/install-mysql-workbench-on-ubuntu/) - [Installing MYSQL on Ubuntu Linux](https://sqldbaschool.com/lessons/installing-mysql-on-ubuntu-linux/) - [Running MYSQL Workbench on Windows](https://sqldbaschool.com/lessons/running-mysql-workbench-on-windows/) - [Installing MYSQL on Windows](https://sqldbaschool.com/lessons/installing-mysql-on-windows/) - [Installing MYSQL Workbench on a Mac](https://sqldbaschool.com/lessons/installing-mysql-workbench-on-a-mac/) - [Installing MYSQL on a Mac](https://sqldbaschool.com/lessons/installing-mysql-on-a-mac/) - [A brief history of MYSQL](https://sqldbaschool.com/lessons/a-brief-history-of-mysql/) - [Demystifying the server](https://sqldbaschool.com/lessons/demystifying-the-server/) - [Next steps](https://sqldbaschool.com/lessons/next-steps/) - [Databases Console Commands (DBCC)](https://sqldbaschool.com/lessons/databases-console-commands-dbcc/) - [Dynamic management views](https://sqldbaschool.com/lessons/dynamic-management-views/) - [Review the SQL Server error log](https://sqldbaschool.com/lessons/review-the-sql-server-error-log/) - [Explore the role of system databases](https://sqldbaschool.com/lessons/explore-the-role-of-system-databases-2/) - [Explore the role of system databases](https://sqldbaschool.com/lessons/explore-the-role-of-system-databases/) - [Always On data encryption](https://sqldbaschool.com/lessons/always-on-data-encryption/) - [Dynamic data masking](https://sqldbaschool.com/lessons/dynamic-data-masking/) - [Database schemas](https://sqldbaschool.com/lessons/database-schemas/) - [User roles and permissions](https://sqldbaschool.com/lessons/user-roles-and-permissions/) - [Business continuity solutions](https://sqldbaschool.com/lessons/business-continuity-solutions/) - [Automate backups](https://sqldbaschool.com/lessons/automate-backups/) - [Restore a backup](https://sqldbaschool.com/lessons/restore-a-backup/) - [Create a full backup of the database](https://sqldbaschool.com/lessons/create-a-full-backup-of-the-database/) - [Create a differential backup](https://sqldbaschool.com/lessons/create-a-differential-backup/) - [Parameterized stored procedures](https://sqldbaschool.com/lessons/parameterized-stored-procedures/) - [Create stored procedures](https://sqldbaschool.com/lessons/create-stored-procedures/) - [Introduction to stored procedures](https://sqldbaschool.com/lessons/introduction-to-stored-procedures/) - [Leverage user-defined scalar functions](https://sqldbaschool.com/lessons/leverage-user-defined-scalar-functions/) - [Use build-in functions](https://sqldbaschool.com/lessons/use-build-in-functions/) - [Addreate functions](https://sqldbaschool.com/lessons/addreate-functions/) - [Rebuild indexes](https://sqldbaschool.com/lessons/rebuild-indexes/) - [SQL Server’s Query Store](https://sqldbaschool.com/lessons/sql-servers-query-store/) - [View execution plans](https://sqldbaschool.com/lessons/view-execution-plans/) - [columnstore indexes](https://sqldbaschool.com/lessons/columnstore-indexes/) - [Create additional indexes on a table](https://sqldbaschool.com/lessons/create-additional-indexes-on-a-table/) - [Data table indexes](https://sqldbaschool.com/lessons/data-table-indexes/) - [Create a view of the data](https://sqldbaschool.com/lessons/create-a-view-of-the-data-2/) - [Remove a table from the database](https://sqldbaschool.com/lessons/remove-a-table-from-the-database/) - [LEFT JOIN and RIGHT JOIN](https://sqldbaschool.com/lessons/left-join-and-right-join/) - [Join related tables](https://sqldbaschool.com/lessons/join-related-tables/) - [Update records in a table](https://sqldbaschool.com/lessons/update-records-in-a-table/) - [Delete records from a table](https://sqldbaschool.com/lessons/delete-records-from-a-table/) - [Sort records](https://sqldbaschool.com/lessons/sort-records/) - [Filter returned results with WHERE](https://sqldbaschool.com/lessons/filter-returned-results-with-where/) - [Retrieve records with SELECT](https://sqldbaschool.com/lessons/retrieve-records-with-select/) - [Add data to a table](https://sqldbaschool.com/lessons/add-data-to-a-table/) - [Create a table with T-SQL](https://sqldbaschool.com/lessons/create-a-table-with-t-sql/) - [Use T-SQL editor](https://sqldbaschool.com/lessons/use-t-sql-editor/) - [Understand the role of T-SQL](https://sqldbaschool.com/lessons/understand-the-role-of-t-sql/) - [Create relationships between tables](https://sqldbaschool.com/lessons/create-relationships-between-tables/) - [Create a foreign key column](https://sqldbaschool.com/lessons/create-a-foreign-key-column/) - [Foreign keys](https://sqldbaschool.com/lessons/foreign-keys/) - [Unique constraints](https://sqldbaschool.com/lessons/unique-constraints/) - [Check constraints](https://sqldbaschool.com/lessons/check-constraints/) - [Establish a default value](https://sqldbaschool.com/lessons/establish-a-default-value/) - [Primary key fields](https://sqldbaschool.com/lessons/primary-key-fields/) - [Table column properties](https://sqldbaschool.com/lessons/table-column-properties/) - [Understand data types](https://sqldbaschool.com/lessons/understand-data-types/) - [Create tables from flat files](https://sqldbaschool.com/lessons/create-tables-from-flat-files/) - [Install a sample database](https://sqldbaschool.com/lessons/install-a-sample-database-2/) - [Import data from CSV files](https://sqldbaschool.com/lessons/import-data-from-csv-files/) - [Enter data into a table using GUI](https://sqldbaschool.com/lessons/enter-data-into-a-table-using-gui/) - [Edit a table’s structure](https://sqldbaschool.com/lessons/edit-a-tables-structure/) - [Create a simple table](https://sqldbaschool.com/lessons/create-a-simple-table/) - [Table structures](https://sqldbaschool.com/lessons/table-structures/) - [Database configuration options](https://sqldbaschool.com/lessons/database-configuration-options/) - [Create the first database](https://sqldbaschool.com/lessons/create-the-first-database/) - [Create a new user account](https://sqldbaschool.com/lessons/create-a-new-user-account/) - [Authentication and user permissions](https://sqldbaschool.com/lessons/authentication-and-user-permissions/) - [Management Studio first steps](https://sqldbaschool.com/lessons/management-studio-first-steps/) - [Enable features with Configuration Manager](https://sqldbaschool.com/lessons/enable-features-with-configuration-manager/) - [Install Management Studio](https://sqldbaschool.com/lessons/install-management-studio/) - [Install SQL Server Developer Edition](https://sqldbaschool.com/lessons/install-sql-server-developer-edition/) - [SQL Server 2019 Editions](https://sqldbaschool.com/lessons/sql-server-2019-editions/) - [Core Concepts](https://sqldbaschool.com/lessons/core-concepts/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know-2/) - [Harness the modern and innovative tools in SQL Server 2019](https://sqldbaschool.com/lessons/harness-the-modern-and-innovative-tools-in-sql-server-2019/) - [Create a view of the data](https://sqldbaschool.com/lessons/create-a-view-of-the-data/) - [Add data with a INSERT statement](https://sqldbaschool.com/lessons/add-data-with-a-insert-statement/) - [Write an UPDATE statement](https://sqldbaschool.com/lessons/write-an-update-statement/) - [Use functions to calculate values](https://sqldbaschool.com/lessons/use-functions-to-calculate-values/) - [Create a SELECT statement](https://sqldbaschool.com/lessons/create-a-select-statement/) - [Join tables together with keys](https://sqldbaschool.com/lessons/join-tables-together-with-keys/) - [Create a data table](https://sqldbaschool.com/lessons/create-a-data-table/) - [Understand SQL data types](https://sqldbaschool.com/lessons/understand-sql-data-types/) - [Create a new database on the server]](https://sqldbaschool.com/lessons/create-a-new-database-on-the-server/) - [Install a sample database](https://sqldbaschool.com/lessons/install-a-sample-database/) - [Tour the SSMA interface](https://sqldbaschool.com/lessons/tour-the-ssma-interface/) - [Locate SQL Server documentation](https://sqldbaschool.com/lessons/locate-sql-server-documentation/) - [Log in to the server](https://sqldbaschool.com/lessons/log-in-to-the-server/) - [Configure and Start the server](https://sqldbaschool.com/lessons/configure-and-start-the-server/) - [Installing SQL Server](https://sqldbaschool.com/lessons/installing-sql-server/) - [Understand the editions of SQL](https://sqldbaschool.com/lessons/understand-the-editions-of-sql/) - [What is SQL Server?](https://sqldbaschool.com/lessons/what-is-sql-server/) - [What you should know](https://sqldbaschool.com/lessons/what-you-should-know/) - [Welcome](https://sqldbaschool.com/lessons/welcome/) - [Content Drip add-on](https://sqldbaschool.com/lessons/content-drip-add-on/) - [Co-instructors add-on](https://sqldbaschool.com/lessons/co-instructors-add-on/) - [WooCommerce payments add-on](https://sqldbaschool.com/lessons/woocommerce-payments-add-on/) - [Certificate add-on](https://sqldbaschool.com/lessons/certificate-add-on/) - [How to use LearnPress](https://sqldbaschool.com/lessons/how-to-use-learnpress/) - [What is LearnPress](https://sqldbaschool.com/lessons/what-is-learnpress/) ## Quizzes - [SECTION 1 — Checkpoint Quiz (Self-Check)](https://sqldbaschool.com/quizzes/section-1-checkpoint-quiz-self-check/) - [What is Database](https://sqldbaschool.com/quizzes/what-is-database/) - [Simple test](https://sqldbaschool.com/quizzes/simple-test/) ## Question Bank - [Answer these in your notebook. Do not rush. What is the difference between a symptom and a root cause? List the 6 steps of the evidence-first workflow. Name 3 daily DBA checks. Why is rollback planning mandatory? What does “validate” mean after a change? Why is changing 10 settings at once risky? What should a professional incident update include? Give one example of objective evidence (not an opinion). What is a safe first action during a performance incident? Why should you keep scripts and notes in an organized workspace? Answer Key (for self-grading) Symptom = what users experience; root cause = why it’s happening. Define, Measure, Isolate, Change safely, Validate, Document. Backups/jobs status, error log review, disk space check, blocking/deadlocks check, performance anomalies. To reduce risk and recover quickly if a change causes problems. Proving with metrics/evidence that the issue improved and nothing else broke. You can’t isolate what helped or harmed; increases outage risk. Symptom, impact, evidence, action, status, next steps. Blocking chain, wait stats, Query Store regression, error log entries, job failure log. Capture evidence and identify whether it’s CPU/I/O/blocking/memory/plan regression before changing anything. Faster incident response, better learning, and real-world DBA professionalism.](https://sqldbaschool.com/questions/answer-these-in-your-notebook-do-not-rush-what-is-the-difference-between-a-symptom-and-a-root-cause-list-the-6-steps-of-the-evidence-first-workflow-name-3-daily-dba-checks-why-is-rollback-pla-2/) - [Answer these in your notebook. Do not rush. What is the difference between a symptom and a root cause? List the 6 steps of the evidence-first workflow. Name 3 daily DBA checks. Why is rollback planning mandatory? What does “validate” mean after a change? Why is changing 10 settings at once risky? What should a professional incident update include? Give one example of objective evidence (not an opinion). What is a safe first action during a performance incident? Why should you keep scripts and notes in an organized workspace? Answer Key (for self-grading) Symptom = what users experience; root cause = why it’s happening. Define, Measure, Isolate, Change safely, Validate, Document. Backups/jobs status, error log review, disk space check, blocking/deadlocks check, performance anomalies. To reduce risk and recover quickly if a change causes problems. Proving with metrics/evidence that the issue improved and nothing else broke. You can’t isolate what helped or harmed; increases outage risk. Symptom, impact, evidence, action, status, next steps. Blocking chain, wait stats, Query Store regression, error log entries, job failure log. Capture evidence and identify whether it’s CPU/I/O/blocking/memory/plan regression before changing anything. Faster incident response, better learning, and real-world DBA professionalism.](https://sqldbaschool.com/questions/answer-these-in-your-notebook-do-not-rush-what-is-the-difference-between-a-symptom-and-a-root-cause-list-the-6-steps-of-the-evidence-first-workflow-name-3-daily-dba-checks-why-is-rollback-pla/) - [Which metric best represents “response time” for a single request? A) Throughput B) Latency C) Concurrency D) Availability](https://sqldbaschool.com/questions/1-which-metric-best-represents-response-time-for-a-single-request-a-throughput-b-latency-✅-c-concurrency-d-availability/) - [Report slows gradually over months; very high logical reads; storage latency normal. Most likely cause: A) Missing/inefficient indexing + data growth causing scans B) License expired C) Always a deadlock D) Too many backups](https://sqldbaschool.com/questions/report-slows-gradually-over-months-very-high-logical-reads-storage-latency-normal-most-likely-cause-a-missing-inefficient-indexing-data-growth-causing-scans-✅-b-license-expired-c-alwa/) - [System “freezes” but CPU normal; many sessions show LCK_ waits. Most likely cause:* A) CPU saturation B) Blocking chain from a long transaction C) Network outage only D) Too many indexes](https://sqldbaschool.com/questions/system-freezes-but-cpu-normal-many-sessions-show-lck_-waits-most-likely-cause-a-cpu-saturation-b-blocking-chain-from-a-long-transaction-✅-c-network-outage-only-d-too/) - [Best validation step after tuning: A) “It feels faster” B) Compare before/after metrics, check side effects, test under concurrency C) Apply more changes immediately D) Turn off monitoring](https://sqldbaschool.com/questions/best-validation-step-after-tuning-a-it-feels-faster-b-compare-before-after-metrics-check-side-effects-test-under-concurrency-✅-c-apply-more-changes-immediately-d-turn/) - [Good reason to use Query Store plan forcing: A) Hints are always best B) Stabilize performance quickly after a known regression (with validation) C) Disable statistics D) Increase fragmentation](https://sqldbaschool.com/questions/good-reason-to-use-query-store-plan-forcing-a-hints-are-always-best-b-stabilize-performance-quickly-after-a-known-regression-with-validation-✅-c-disable-statistics-d-increase-fragmentat/) - [RPO and RTO mean: A) Index names B) Acceptable data loss (RPO) and acceptable recovery time (RTO) C) Query hints D) CPU scheduling settings](https://sqldbaschool.com/questions/rpo-and-rto-mean-a-index-names-b-acceptable-data-loss-rpo-and-acceptable-recovery-time-rto-✅-c-query-hints-d-cpu-scheduling-settings/) - [Correct HA/DR statement: A) HA/DR has no performance impact B) HA/DR design can affect performance and must be planned C) HA/DR replaces tuning D) HA/DR is only for reporting DBs](https://sqldbaschool.com/questions/correct-ha-dr-statement-a-ha-dr-has-no-performance-impact-b-ha-dr-design-can-affect-performance-and-must-be-planned-✅-c-ha-dr-replaces-tuning-d-ha-dr-is-only-for-reporting-dbs/) - [Profiler/Trace in production is risky mainly because: A) It changes data types B) It can add overhead if capturing too much C) It disables indexes D) It forces FULL recovery model](https://sqldbaschool.com/questions/profiler-trace-in-production-is-risky-mainly-because-a-it-changes-data-types-b-it-can-add-overhead-if-capturing-too-much-✅-c-it-disables-indexes-d-it-forces-full-recovery-model/) - [DTA should be used: A) As the only truth for indexing B) Carefully; reviewed to avoid over-indexing C) Only when server is down D) To delete indexes automatically](https://sqldbaschool.com/questions/dta-should-be-used-a-as-the-only-truth-for-indexing-b-carefully-reviewed-to-avoid-over-indexing-✅-c-only-when-server-is-down-d-to-delete-indexes-automatically/) - [Bad cardinality estimates often lead to: A) Better indexes automatically B) Poor join choices and bad memory grants/spills C) Smaller tables D) Less blocking](https://sqldbaschool.com/questions/bad-cardinality-estimates-often-lead-to-a-better-indexes-automatically-b-poor-join-choices-and-bad-memory-grants-spills-✅-c-smaller-tables-d-less-blocking/) - [Statistics are primarily used to: A) Store encrypted passwords B) Estimate row counts and choose efficient plans C) Schedule backups D) Manage log shipping](https://sqldbaschool.com/questions/statistics-are-primarily-used-to-a-store-encrypted-passwords-b-estimate-row-counts-and-choose-efficient-plans-✅-c-schedule-backups-d-manage-log-shipping/) - [Best feature for tracking regressions over time: A) Query Store B) Renaming tables C) Dropping statistics D) Disabling DMVs](https://sqldbaschool.com/questions/best-feature-for-tracking-regressions-over-time-a-query-store-✅-b-renaming-tables-c-dropping-statistics-d-disabling-dmvs/) - [Why is killing sessions without analysis risky? A) Never risky B) Can rollback large transactions and worsen performance C) Deletes indexes D) Disables Query Store](https://sqldbaschool.com/questions/why-is-killing-sessions-without-analysis-risky-a-never-risky-b-can-rollback-large-transactions-and-worsen-performance-✅-c-deletes-indexes-d-disables-query-store/) - [If many sessions are blocked, most effective fix is usually: A) Tune every blocked query first B) Identify and address the root blocker/long transaction C) Ignore it D) Increase TempDB only](https://sqldbaschool.com/questions/if-many-sessions-are-blocked-most-effective-fix-is-usually-a-tune-every-blocked-query-first-b-identify-and-address-the-root-blocker-long-transaction-✅-c-ignore-it-d-increase-tempdb-only/) - [Best “first 5 minutes” action during timeouts: A) Add indexes everywhere B) Identify top requests, blockers, bottleneck category using safe scripts C) Disable constraints D) Reinstall SQL Server](https://sqldbaschool.com/questions/best-first-5-minutes-action-during-timeouts-a-add-indexes-everywhere-b-identify-top-requests-blockers-bottleneck-category-using-safe-scripts-✅-c-disable-constraints-d/) - [Best interpretation of wait stats: A) Final verdict without context B) Clues that require workload/timeframe context C) Irrelevant D) Only for developers](https://sqldbaschool.com/questions/best-interpretation-of-wait-stats-a-final-verdict-without-context-b-clues-that-require-workload-timeframe-context-✅-c-irrelevant-d-only-for-developers/) - [blocking_session_id indicates: A) Estimated cost B) The session id blocking this request C) The database file id D) Index id used](https://sqldbaschool.com/questions/blocking_session_id-indicates-a-estimated-cost-b-the-session-id-blocking-this-request-✅-c-the-database-file-id-d-index-id-used/) - [PAGEIOLATCH_ waits often suggest:* A) Locking only B) Waiting on data pages to be read from disk / heavy reads C) Network packet loss D) Compilation waits](https://sqldbaschool.com/questions/pageiolatch_-waits-often-suggest-a-locking-only-b-waiting-on-data-pages-to-be-read-from-disk-heavy-reads-✅-c-network-packet-loss-d-compilation-waits/) - [RESOURCE_SEMAPHORE most commonly indicates: A) I/O latency B) Memory grant pressure (queries waiting for memory) C) Deadlocks only D) Backups](https://sqldbaschool.com/questions/resource_semaphore-most-commonly-indicates-a-i-o-latency-b-memory-grant-pressure-queries-waiting-for-memory-✅-c-deadlocks-only-d-backups/) - [LCK_ waits most commonly indicate:* A) Memory pressure B) Blocking/lock contention C) Disk failure D) Network latency](https://sqldbaschool.com/questions/lck_-waits-most-commonly-indicate-a-memory-pressure-b-blocking-lock-contention-✅-c-disk-failure-d-network-latency/) - [In an incident, what should you do before applying fixes? A) Change MAXDOP B) Restart SQL Server C) Capture evidence (current metrics, blockers, top requests) D) Drop indexes](https://sqldbaschool.com/questions/in-an-incident-what-should-you-do-before-applying-fixes-a-change-maxdop-b-restart-sql-server-c-capture-evidence-current-metrics-blockers-top-requests-✅-d-drop-indexes/) - [Fast mitigation for a known plan regression (when appropriate): A) Force the known good plan using Query Store B) Drop the database C) Disable logging D) Clear all cache without analysis](https://sqldbaschool.com/questions/fast-mitigation-for-a-known-plan-regression-when-appropriate-a-force-the-known-good-plan-using-query-store-✅-b-drop-the-database-c-disable-logging-d-clear-all-cache-without-analysis/) - [TempDB spills often occur because: A) Too many indexes B) Sort/hash needs more memory than granted (often bad estimates) C) Missing primary key D) FULL recovery model](https://sqldbaschool.com/questions/tempdb-spills-often-occur-because-a-too-many-indexes-b-sort-hash-needs-more-memory-than-granted-often-bad-estimates-✅-c-missing-primary-key-d-full-recovery-model/) - [“Fast alone but slow under load” most often indicates: A) Too many backups B) Concurrency issues: blocking or resource queueing C) SELECT * D) A clustered index exists](https://sqldbaschool.com/questions/fast-alone-but-slow-under-load-most-often-indicates-a-too-many-backups-b-concurrency-issues-blocking-or-resource-queueing-✅-c-select-d-a-clustered-index-exists/) - [High logical reads with low CPU often suggests: A) I/O-heavy work (reading many pages), likely scans/poor selectivity B) Always blocking C) Always network latency D) Always encryption overhead](https://sqldbaschool.com/questions/high-logical-reads-with-low-cpu-often-suggests-a-i-o-heavy-work-reading-many-pages-likely-scans-poor-selectivity-✅-b-always-blocking-c-always-network-latency-d-always-encryption-overhe/) - [Which is a safe approach to improve a slow query? A) Add multiple hints immediately B) Identify bottleneck, change one thing, validate, and measure side effects C) Disable all indexes D) Change all server settings at once](https://sqldbaschool.com/questions/which-is-a-safe-approach-to-improve-a-slow-query-a-add-multiple-hints-immediately-b-identify-bottleneck-change-one-thing-validate-and-measure-side-effects-✅-c-disable-all-indexes-d-cha/) - [A plan regression is best described as: A) A query becomes faster after a deployment B) SQL Server chooses a worse plan than before, degrading performance C) Statistics update always improves performance D) Index rebuild reduces fragmentation](https://sqldbaschool.com/questions/a-plan-regression-is-best-described-as-a-a-query-becomes-faster-after-a-deployment-b-sql-server-chooses-a-worse-plan-than-before-degrading-performance-✅-c-statistics-update-always-improve/) - [Parameter sniffing refers to: A) Reading from TempDB B) Compiling a plan using initial parameter values and reusing it later C) Encrypting parameters D) A replication feature](https://sqldbaschool.com/questions/parameter-sniffing-refers-to-a-reading-from-tempdb-b-compiling-a-plan-using-initial-parameter-values-and-reusing-it-later-✅-c-encrypting-parameters-d-a-replication-feature/) - [Execution plans are primarily used to: A) Encrypt data at rest B) Understand how SQL Server executes a query (operators, joins, scans/seeks) C) Create backups automatically D) Disable indexes](https://sqldbaschool.com/questions/execution-plans-are-primarily-used-to-a-encrypt-data-at-rest-b-understand-how-sql-server-executes-a-query-operators-joins-scans-seeks-✅-c-create-backups-automatically-d-disable-indexe/) - [What is a non-SARGable predicate most likely to cause? A) Always an index seek B) Reduced reads C) Scans and higher CPU/I/O D) Smaller transaction log](https://sqldbaschool.com/questions/what-is-a-non-sargable-predicate-most-likely-to-cause-a-always-an-index-seek-b-reduced-reads-c-scans-and-higher-cpu-i-o-✅-d-smaller-transaction-log/) - [Which change most directly reduces logical reads? A) Returning more columns B) Making predicates SARGable and using a supporting index C) Adding ORDER BY to everything D) Disabling Query Store](https://sqldbaschool.com/questions/which-change-most-directly-reduces-logical-reads-a-returning-more-columns-b-making-predicates-sargable-and-using-a-supporting-index-✅-c-adding-order-by-to-everything-d-disabling-query-sto/) - [Best indexing strategy for a heavy-write table with a few critical read patterns: A) Create many wide indexes for every query B) Use a small set of targeted indexes supporting the most important patterns C) Avoid all indexes D) Rebuild all indexes daily](https://sqldbaschool.com/questions/best-indexing-strategy-for-a-heavy-write-table-with-a-few-critical-read-patterns-a-create-many-wide-indexes-for-every-query-b-use-a-small-set-of-targeted-indexes-supporting-the-most-important-patte/) - [A key lookup typically happens when: A) The query is fully covered by the index B) SQL Server must fetch missing columns from the base table after using an NCI C) TempDB is full D) The query is blocked](https://sqldbaschool.com/questions/a-key-lookup-typically-happens-when-a-the-query-is-fully-covered-by-the-index-b-sql-server-must-fetch-missing-columns-from-the-base-table-after-using-an-nci-✅-c-tempdb-is-full-d-the-query/) - [Which operation is most likely to become slower as you add more indexes? A) Simple SELECT B) INSERT/UPDATE/DELETE C) RESTORE DATABASE D) DBCC CHECKDB](https://sqldbaschool.com/questions/which-operation-is-most-likely-to-become-slower-as-you-add-more-indexes-a-simple-select-b-insert-update-delete-✅-c-restore-database-d-dbcc-checkdb/) - [What is the main goal of indexing for performance? A) Increase reads B) Reduce the amount of data SQL Server must read/process for common queries C) Increase transaction log size D) Force all queries to use nested loops](https://sqldbaschool.com/questions/what-is-the-main-goal-of-indexing-for-performance-a-increase-reads-b-reduce-the-amount-of-data-sql-server-must-read-process-for-common-queries-✅-c-increase-transaction-log-size-d-force-al/) - [Which best describes index fragmentation? A) Always the #1 performance problem B) Sometimes important; evaluate with evidence and workload context C) The same as blocking D) Fixed only by rebuilding TempDB](https://sqldbaschool.com/questions/which-best-describes-index-fragmentation-a-always-the-1-performance-problem-b-sometimes-important-evaluate-with-evidence-and-workload-context-✅-c-the-same-as-blocking-d-fixed-only-by-re/) - [Included columns in a nonclustered index are mainly used to: A) Change join types B) Cover a query without expanding the key length C) Reduce CPU to zero D) Force parallelism](https://sqldbaschool.com/questions/included-columns-in-a-nonclustered-index-are-mainly-used-to-a-change-join-types-b-cover-a-query-without-expanding-the-key-length-✅-c-reduce-cpu-to-zero-d-force-parallelism/) - [If an index seek is possible but SQL Server still scans, a common reason is: A) The table is empty B) Non-SARGable predicate or estimates/stats suggest scan is cheaper C) SQL Server does not support seeks D) MAXDOP is too high](https://sqldbaschool.com/questions/if-an-index-seek-is-possible-but-sql-server-still-scans-a-common-reason-is-a-the-table-is-empty-b-non-sargable-predicate-or-estimates-stats-suggest-scan-is-cheaper-✅-c-sql-server-does-not/) - [Which is a common risk of creating too many indexes? A) Faster INSERT/UPDATE/DELETE B) Reduced storage usage C) Slower writes and higher maintenance overhead D) Automatic query rewriting](https://sqldbaschool.com/questions/which-is-a-common-risk-of-creating-too-many-indexes-a-faster-insert-update-delete-b-reduced-storage-usage-c-slower-writes-and-higher-maintenance-overhead-✅-d-automatic-query-rewriting/) - [What does a “covering index” usually mean? A) An index that prevents deadlocks B) An index that contains all columns needed by a query, avoiding lookups C) An index used only on weekends D) An index that forces a hash join](https://sqldbaschool.com/questions/what-does-a-covering-index-usually-mean-a-an-index-that-prevents-deadlocks-b-an-index-that-contains-all-columns-needed-by-a-query-avoiding-lookups-✅-c-an-index-used-only/) - [A nonclustered index is best described as: A) The data table itself B) A separate structure that helps find rows faster and can require lookups C) A database backup file D) A TempDB object](https://sqldbaschool.com/questions/a-nonclustered-index-is-best-described-as-a-the-data-table-itself-b-a-separate-structure-that-helps-find-rows-faster-and-can-require-lookups-✅-c-a-database-backup-file-d-a-tempdb-object/) - [A clustered index primarily determines: A) The logical order of rows in the table structure B) The number of CPUs used by a query C) The database recovery model D) The size of the transaction log](https://sqldbaschool.com/questions/a-clustered-index-primarily-determines-a-the-logical-order-of-rows-in-the-table-structure-✅-b-the-number-of-cpus-used-by-a-query-c-the-database-recovery-model-d-the-size-of-the-transactio/) - [SQL Server stores table data primarily in: A) XML nodes B) Pages (8 KB) organized into extents C) JSON documents D) Flat files only](https://sqldbaschool.com/questions/sql-server-stores-table-data-primarily-in-a-xml-nodes-b-pages-8-kb-organized-into-extents-✅-c-json-documents-d-flat-files-only/) - [“One change at a time” is important because: A) It reduces licensing costs B) It ensures you know which change produced the result and limits risk C) It guarantees zero downtime D) It automatically updates statistics](https://sqldbaschool.com/questions/one-change-at-a-time-is-important-because-a-it-reduces-licensing-costs-b-it-ensures-you-know-which-change-produced-the-result-and-limits-risk-✅-c-it-guarantees-zero-downt/) - [Which is the best first response when someone says “the database is slow”? A) Add an index B) Restart SQL Server C) Ask what is slow, when it is slow, and what changed; then capture evidence D) Set cost threshold to 5](https://sqldbaschool.com/questions/which-is-the-best-first-response-when-someone-says-the-database-is-slow-a-add-an-index-b-restart-sql-server-c-ask-what-is-slow-when-it-is-slow-and-what-changed-then-capture-ev/) - [In performance tuning, the “three layers” usually refer to: A) CPU, memory, disk B) Server-level, database-level, query-level C) Dev, test, prod D) Clustered, nonclustered, columnstore](https://sqldbaschool.com/questions/in-performance-tuning-the-three-layers-usually-refer-to-a-cpu-memory-disk-b-server-level-database-level-query-level-✅-c-dev-test-prod-d-clustered-nonclustered-c/) - [Throughput is best described as: A) How long one query takes B) How many transactions/requests complete per time unit C) How much memory SQL Server can use D) How many indexes a table has](https://sqldbaschool.com/questions/throughput-is-best-described-as-a-how-long-one-query-takes-b-how-many-transactions-requests-complete-per-time-unit-✅-c-how-much-memory-sql-server-can-use-d-how-many-indexes-a-table-has/) - [Which is the correct high-level tuning workflow? A) Guess → tweak → deploy B) Restart SQL Server → test C) Baseline → identify bottleneck → apply one change → validate → prevent regression D) Add MAXDOP = 1 → done](https://sqldbaschool.com/questions/which-is-the-correct-high-level-tuning-workflow-a-guess-→-tweak-→-deploy-b-restart-sql-server-→-test-c-baseline-→-identify-bottleneck-→-apply-one-change/) - [Why is a baseline important? A) It makes the server run faster B) It provides “normal” measurements to compare against and prove improvement C) It replaces monitoring tools D) It automatically fixes slow queries](https://sqldbaschool.com/questions/why-is-a-baseline-important-a-it-makes-the-server-run-faster-b-it-provides-normal-measurements-to-compare-against-and-prove-improvement-✅-c-it-replaces-monitoring-tools-d/) - [Which statement is the best definition of performance tuning? A) Add indexes until queries are fast B) Change server settings to recommended defaults C) A repeatable process: measure, diagnose bottleneck, apply targeted fix, validate D) Rewrite all queries in stored procedures](https://sqldbaschool.com/questions/which-statement-is-the-best-definition-of-performance-tuning-a-add-indexes-until-queries-are-fast-b-change-server-settings-to-recommended-defaults-c-a-repeatable-process-measure-diagnose-bottlen/) - [How much does Education WordPress Theme cost?](https://sqldbaschool.com/questions/how-much-does-education-wordpress-theme-cost/) - [Single choice question: Which word means "unpleasant to ​look at, not ​attractive"?](https://sqldbaschool.com/questions/single-choice-question-which-word-means-unpleasant-to-​look-at-not-​attractive/) - [Multiple choise question: Which things different with other?](https://sqldbaschool.com/questions/multiple-choise-question-which-things-different-with-other/) - [True or false question: a rose is red?](https://sqldbaschool.com/questions/true-or-false-question-a-rose-is-red/) ## Jeg Kit - Footer - [Footer Template](https://sqldbaschool.com/jkit-footer/footer-template/) ## Projects - [Soft skills](https://sqldbaschool.com/portfolio/about-soft-skills/) - [Up your skill](https://sqldbaschool.com/portfolio/up-your-skill/) - [Startup Team](https://sqldbaschool.com/portfolio/startup-team/) - [Home Work](https://sqldbaschool.com/portfolio/home-work/) - [Keeping smile](https://sqldbaschool.com/portfolio/keeping-smile/) - [Opened book](https://sqldbaschool.com/portfolio/opened-book/) - [Library](https://sqldbaschool.com/portfolio/library/) - [Reading glasses](https://sqldbaschool.com/portfolio/reading-glasses/) - [Design cover](https://sqldbaschool.com/portfolio/design-cover/) - [Fighting](https://sqldbaschool.com/portfolio/fighting/) - [Reading book](https://sqldbaschool.com/portfolio/reading-book/) - [Electronic book](https://sqldbaschool.com/portfolio/electronic-book/) ## Elementor Header & Footer Builder - [Header](https://sqldbaschool.com/elementor-hf/header/) ## Categories - [Uncategorized](https://sqldbaschool.com/category/uncategorized/) - [Blog](https://sqldbaschool.com/category/blog/) - [Business](https://sqldbaschool.com/category/business/) - [SQL](https://sqldbaschool.com/category/sql/) - [SSMS](https://sqldbaschool.com/category/ssms/) - [SQL Queries](https://sqldbaschool.com/category/sql-queries/) - [IT](https://sqldbaschool.com/category/it/) - [Online Course](https://sqldbaschool.com/category/online-course/) - [Microsoft certification](https://sqldbaschool.com/category/microsoft-certification/) - [career Advice](https://sqldbaschool.com/category/career-advice/) - [Microsoft](https://sqldbaschool.com/category/microsoft/) - [Jobs](https://sqldbaschool.com/category/jobs/) - [SQL Server DBA](https://sqldbaschool.com/category/sql-server-dba/) ## Tags - [microsoft sql server](https://sqldbaschool.com/tag/microsoft-sql-server/) - [Microsoft sql server Certifications](https://sqldbaschool.com/tag/microsoft-sql-server-certifications/) - [sql dba jobs](https://sqldbaschool.com/tag/sql-dba-jobs/) - [remote sql dba](https://sqldbaschool.com/tag/remote-sql-dba/) - [junior sql dba](https://sqldbaschool.com/tag/junior-sql-dba/) - [azure sql dba](https://sqldbaschool.com/tag/azure-sql-dba/) - [aws rds dba](https://sqldbaschool.com/tag/aws-rds-dba/) - [query store tuning](https://sqldbaschool.com/tag/query-store-tuning/) - [backups and restore](https://sqldbaschool.com/tag/backups-and-restore/) - [ha dr sql server](https://sqldbaschool.com/tag/ha-dr-sql-server/) - [apply once get matched](https://sqldbaschool.com/tag/apply-once-get-matched/) - [sql server dba](https://sqldbaschool.com/tag/sql-server-dba/) - [ha/dr](https://sqldbaschool.com/tag/ha-dr/) - [point-in-time restore (pitr)](https://sqldbaschool.com/tag/point-in-time-restore-pitr/) - [azure sql managed instance](https://sqldbaschool.com/tag/azure-sql-managed-instance/) - [azure sql database](https://sqldbaschool.com/tag/azure-sql-database/) - [aws rds aurora](https://sqldbaschool.com/tag/aws-rds-aurora/) - [performance insights](https://sqldbaschool.com/tag/performance-insights/) - [t-sql indexing](https://sqldbaschool.com/tag/t-sql-indexing/) - [database reliability](https://sqldbaschool.com/tag/database-reliability/) - [runbooks and checklists](https://sqldbaschool.com/tag/runbooks-and-checklists/) - [cloud dba jobs](https://sqldbaschool.com/tag/cloud-dba-jobs/) - [interview prep](https://sqldbaschool.com/tag/interview-prep/) - [database security tde](https://sqldbaschool.com/tag/database-security-tde/) - [cost optimization cloud](https://sqldbaschool.com/tag/cost-optimization-cloud/) - [careers at sql dba school](https://sqldbaschool.com/tag/careers-at-sql-dba-school/) - [sql jobs](https://sqldbaschool.com/tag/sql-jobs/) - [sql server jobs](https://sqldbaschool.com/tag/sql-server-jobs/) - [remote sql jobs](https://sqldbaschool.com/tag/remote-sql-jobs/) - [sql resume](https://sqldbaschool.com/tag/sql-resume/) - [sql interview](https://sqldbaschool.com/tag/sql-interview/) - [sql career 2026](https://sqldbaschool.com/tag/sql-career-2026/) - [database jobs](https://sqldbaschool.com/tag/database-jobs/) - [SQL training free](https://sqldbaschool.com/tag/sql-training-free/) - [free sql course](https://sqldbaschool.com/tag/free-sql-course/) - [learn sql free](https://sqldbaschool.com/tag/learn-sql-free/) - [sql training 2026](https://sqldbaschool.com/tag/sql-training-2026/) - [sql dba training](https://sqldbaschool.com/tag/sql-dba-training/) - [SQL Server DBA training](https://sqldbaschool.com/tag/sql-server-dba-training/) - [SQL DBA certification](https://sqldbaschool.com/tag/sql-dba-certification/) - [DP-300](https://sqldbaschool.com/tag/dp-300/) - [Azure Database Administrator](https://sqldbaschool.com/tag/azure-database-administrator/) - [SQL Server DBA roadmap](https://sqldbaschool.com/tag/sql-server-dba-roadmap/) - [T-SQL training](https://sqldbaschool.com/tag/t-sql-training/) - [SQL Server administration](https://sqldbaschool.com/tag/sql-server-administration/) - [database career](https://sqldbaschool.com/tag/database-career/) - [sql server health check](https://sqldbaschool.com/tag/sql-server-health-check/) - [dba checklist](https://sqldbaschool.com/tag/dba-checklist/) - [sql server monitoring](https://sqldbaschool.com/tag/sql-server-monitoring/) - [query store](https://sqldbaschool.com/tag/query-store/) - [dbcc checkdb](https://sqldbaschool.com/tag/dbcc-checkdb/) - [wait stats](https://sqldbaschool.com/tag/wait-stats/) - [backup verification](https://sqldbaschool.com/tag/backup-verification/) - [sql agent jobs](https://sqldbaschool.com/tag/sql-agent-jobs/) - [sql server timeouts](https://sqldbaschool.com/tag/sql-server-timeouts/) - [sql server blocking](https://sqldbaschool.com/tag/sql-server-blocking/) - [dba incident runbook](https://sqldbaschool.com/tag/dba-incident-runbook/) - [sql server triage](https://sqldbaschool.com/tag/sql-server-triage/) - [sql server performance troubleshooting](https://sqldbaschool.com/tag/sql-server-performance-troubleshooting/) - [sql agent monitoring](https://sqldbaschool.com/tag/sql-agent-monitoring/) - [sql server wait stats](https://sqldbaschool.com/tag/sql-server-wait-stats/) - [sys.dm_os_wait_stats](https://sqldbaschool.com/tag/sys-dm_os_wait_stats/) - [pageiolatch](https://sqldbaschool.com/tag/pageiolatch/) - [sos_scheduler_yield](https://sqldbaschool.com/tag/sos_scheduler_yield/) - [cxpacket](https://sqldbaschool.com/tag/cxpacket/) - [blocking waits](https://sqldbaschool.com/tag/blocking-waits/) - [sql server performance](https://sqldbaschool.com/tag/sql-server-performance/) - [dba troubleshooting](https://sqldbaschool.com/tag/dba-troubleshooting/) - [sql dba jobs apply online](https://sqldbaschool.com/tag/sql-dba-jobs-apply-online/) - [sql server dba jobs](https://sqldbaschool.com/tag/sql-server-dba-jobs/) - [remote sql dba jobs](https://sqldbaschool.com/tag/remote-sql-dba-jobs/) - [sql dba resume](https://sqldbaschool.com/tag/sql-dba-resume/) - [sql dba career](https://sqldbaschool.com/tag/sql-dba-career/) - [sql dba school](https://sqldbaschool.com/tag/sql-dba-school/) - [sql training courses online](https://sqldbaschool.com/tag/sql-training-courses-online/) - [learn sql online](https://sqldbaschool.com/tag/learn-sql-online/) - [sql server training](https://sqldbaschool.com/tag/sql-server-training/) - [t-sql course](https://sqldbaschool.com/tag/t-sql-course/) - [ssms training](https://sqldbaschool.com/tag/ssms-training/) - [dp-900](https://sqldbaschool.com/tag/dp-900/) - [microsoft sql training](https://sqldbaschool.com/tag/microsoft-sql-training/) - [microsoft sql certification](https://sqldbaschool.com/tag/microsoft-sql-certification/) - [sql server certification](https://sqldbaschool.com/tag/sql-server-certification/) - [learn microsoft sql server](https://sqldbaschool.com/tag/learn-microsoft-sql-server/) - [azure sql training](https://sqldbaschool.com/tag/azure-sql-training/) - [sql interview prep](https://sqldbaschool.com/tag/sql-interview-prep/) - [sql server labs](https://sqldbaschool.com/tag/sql-server-labs/) - [database administrator certification](https://sqldbaschool.com/tag/database-administrator-certification/) ## Project Types - [Books](https://sqldbaschool.com/portfolio-category/books/) - [Courses](https://sqldbaschool.com/portfolio-category/courses/) - [Presentations](https://sqldbaschool.com/portfolio-category/presentations/) ## Course Categories - [CSS](https://sqldbaschool.com/course-category/css/) - [Frontend](https://sqldbaschool.com/course-category/frontend/) - [General](https://sqldbaschool.com/course-category/general/) - [IT & Software](https://sqldbaschool.com/course-category/it-software/) - [Photography](https://sqldbaschool.com/course-category/photography/) - [Programming Language](https://sqldbaschool.com/course-category/programming-language/) - [Technology](https://sqldbaschool.com/course-category/technology/) - [Entry Level](https://sqldbaschool.com/course-category/entry-to-advanced-level/entry-level/) - [Intermediate Level](https://sqldbaschool.com/course-category/entry-to-advanced-level/intermediate-level/) - [Advanced Level](https://sqldbaschool.com/course-category/entry-to-advanced-level/advanced-level/) - [Skill Level Advanced](https://sqldbaschool.com/course-category/entry-to-advanced-level/skill-level-advanced/) - [Entry to Advanced Level](https://sqldbaschool.com/course-category/entry-to-advanced-level/) ## Course Tags - [css](https://sqldbaschool.com/course-tag/css/) - [foundation](https://sqldbaschool.com/course-tag/foundation/) - [less](https://sqldbaschool.com/course-tag/less/) - [node](https://sqldbaschool.com/course-tag/node/) - [python](https://sqldbaschool.com/course-tag/python/) - [tutorial](https://sqldbaschool.com/course-tag/tutorial/) - [SQL](https://sqldbaschool.com/course-tag/sql/) - [SQL Server](https://sqldbaschool.com/course-tag/sql-server/) - [Microsoft SQL Server](https://sqldbaschool.com/course-tag/microsoft-sql-server/) - [SQL Server tutorial for free](https://sqldbaschool.com/course-tag/sql-server-tutorial-for-free/) - [sql classes online](https://sqldbaschool.com/course-tag/sql-classes-online/) - [sql server installation](https://sqldbaschool.com/course-tag/sql-server-installation/)