Complete Microsoft SQL Server Database Administration Course

Course Name : Complete Microsoft SQL Server Database Administration Course
Students : 54,676
Duration : 33 hrs
Avg Rating : 4.4
Original Price : $119.99
Discount Price : $9
Instructor / Provider : Imran Afzal, Udemy
Course Type : Self Paced Online Course. Lifetime Access
Coupon : Click on ENROLL NOW to apply discount code

You’ll Learn How to

• Become a Professional SQL Database Administrator: Master the skills needed to apply for SQL DBA jobs with confidence.
• SQL Administration on Windows: Learn to manage SQL servers in a corporate environment.
• Write 150+ SQL Queries: Develop proficiency in writing basic to advanced SQL queries.
• Troubleshoot SQL Issues: Resolve everyday SQL database and server-related challenges effectively.
• Answer Business Questions: Use SQL aggregate functions to generate insights and run reports for management.
• Corporate-Ready Skills: Gain hands-on experience with installation, configuration, backups, security, and high availability.
• Reporting and Decision-Making: Generate critical reports to support financial and operational decisions.

Frequently Bought Together

Course Outline

Section 1: Introduction

• Overview of Databases and RDBMS.
• What is SQL and why it’s important?
• Introduction to MS SQL Server and its editions.

Section 2: Installing and Configuring Windows for SQL Server

• Virtualization basics: VMware and VirtualBox setup.
• Create and manage virtual machines.
• Install and configure Windows Server for SQL environments.

Section 3: Installing and Configuring MS SQL Server

• Prerequisites and installation of MS SQL Server.
• Setting up SQL Server Management Studio (SSMS).
• Downloading and working with the AdventureWorks sample database.

Section 4: Database Fundamentals and Design

• Understanding data storage, tables, columns, and rows.
• Keys: primary, foreign, and unique keys.
• ACID properties and database transactions.
• Database normalization and its different forms.
• Create your first database, table, and populate it with data.

Section 5: Introduction to SQL Commands

• Overview of SQL statements: DML, DDL, DCL, and TCL.
• Examples of key SQL statements for querying and data management.

Section 6: Querying and Data Manipulation

• Create and use tables, temporary tables, and views.
• Master SELECT, WHERE, GROUP BY, HAVING, and ORDER BY clauses.
• Learn about joins (inner, outer, left, right) and subqueries.
• Understand triggers, functions, and stored procedures.
• Design and optimize indexes (clustered and non-clustered).

Section 7: SQL Database Administration Essentials

• Explore SQL Server Management Studio and Configuration Manager.
• Overview of system databases: master, tempdb, msdb, and best practices.

Section 8: Deep Dive into SQL Server Architecture

• Pages, extents, and page architecture in SQL Server.
• Detailed study of SQL Server and database architecture.
• Configure user databases with best practices.

Section 9: Backup and Restore

• Importance of database backups and recovery models.
• Full, differential, and transaction log backups.
• Restore databases, including point-in-time recovery.
• Use DBCC CHECKDB for database integrity checks.
• Implement maintenance plans for backups and re-indexing.

Section 10: User Management and Security

• SQL Server authentication modes and server roles.
• Manage database users and roles.
• Permissions: GRANT, DENY, and REVOKE.

Section 11: SQL Server Agent Management

• Introduction to SQL Server Agent for automation.
• Create jobs, schedules, alerts, and operators.
• Use database mail and monitor server activity.

Section 12: Advanced SQL Server Administration

• High availability options: replication, transactional replication setup, and log shipping.
• Encryption techniques, including Transparent Data Encryption (TDE).

Section 13: Course Recap

• Review of SQL commands and concepts covered throughout the course.

FAQs on Udemy Coupon