Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Becoming a Production SQL Server DBA
Rating: 4.6 out of 5(216 ratings)
6,546 students

Becoming a Production SQL Server DBA

Learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance and more
Created byPaul Obalonye
Last updated 2/2020
English

What you'll learn

  • How to efficiently administer SQL Server instances and databases in many aspects
  • How to perform essential SQL Server maintenance tasks
  • How to perform essential SQL Server performance tasks
  • How to handle common errors you might get in SQL Server
  • Get deeper understanding about key SQL Server topics and concepts
  • How to perform different SQL Server integration tasks

Course content

1 section • 16 lectures • 1h 35m total length

  • Introduction1:35

    Explore how to become a production sql server dba through hands-on exercises and demonstrations, guiding you from zero to hero and towards landing a job.

  • Installing SQL server in a domain production Enviroment1:27

    Install and configure SQL Server in a domain production environment by setting up a secure virtualized server, deploying, testing, and exploring database administrator responsibilities and rewards.

  • Software Download and VMware Installation6:48

    Download and install VMware Workstation and Windows Server 2012 ISO using trial downloads, then install the domain controller while learning virtualization basics and hypervisor concepts.

  • Domain controller installation8:15
  • Promote Server to a Domain Controller7:28

    Promote a windows server 2012 to a domain controller by installing active directory domain services, adding the net framework 3.5, and configuring a new forest.

  • Create Service Accounts5:15

    Create a service account within a domain controller using Active Directory Users and Computers, organize it under an organizational unit, and configure password policies for a production SQL Server environment.

  • Setup a Static IP Address4:22

    Set a static IP address for the domain controller in the virtual machine by configuring the IPv4 properties of the network adapter. Verify connectivity by running ipconfig and pinging google.com.

  • Create another Virtual Machine6:21

    Create another virtual machine by installing Windows Server 2012 as a standard server, customize hardware and network, install VMware tools, and restart.

  • Create Additional Virtual Drives4:33

    Create multiple virtual drives using server manager and computer management, initialize disks, and create new simple volumes with assigned drive letters, such as G and M.

  • Join Server to a Domain7:59

    Configure a static ip address on node 1, set the dns to the domain controller, and join node 1 to the domain; restart to apply changes and verify domain membership.

  • SQL Server installation14:29

    Install SQL Server 2012 in a virtual machine, selecting core engine features and configuring data, log, and temp directories. Enable Windows authentication or mixed mode.

  • How to create a database for a complete begineer1:54

    Learn how to create a database in SQL Server by right-clicking databases, selecting new database, naming the database, setting the owner, and clicking OK to create.

  • How to Backup a database for a complete beginner6:32
  • How to Restore a database for a complete beginner5:00
  • How to take a Database offline and bring it back online4:20

    Learn to take a database offline and bring it back online using both the GUI and sql scripts, including handling active connections and immediate rollback for running transactions.

  • How to create a database SnapShot for a complete beginner9:31

    Learn how to create a database snapshot and restore it after deployments. See how snapshots protect the main database for developers and business intelligence teams.

Requirements

  • Basic SQL Training

Description

In this course, you will learn many SQL Server administration hands-on tips, that will help you efficiently administer SQL Server within the context of SQL Server maintenance, performance, security, integration and error handling.

SQL Server is one of the world's leading Data Platforms. It is full of features that enable you to store, organize, retrieve and transform your data into useful business insights and knowledge. Like in all Database Management Systems, in order for your SQL Server instances to operate to the best possible level in terms of stability and performance, you need to properly administer and maintain them.

I have carefully designed this course, in order to help you with your SQL Server journey. With many live demonstrations and step by step guides, via my course, I will help you learn how to perform many SQL Server administration tasks, as well as, get a deeper understanding about critical SQL Server topics that all modern SQL Server Administrators, Engineers and Architects needs to know.

In my course, you will learn how to patch standalone and failover cluster SQL Server instances, how to enable Transparent Data Encryption (TDE) for data at rest and encrypt database backups, how to enable SSL encryption for data in motion, how to tune SQL Server instances via indexes, CPU, RAM and storage monitoring, how to protect your data with Dynamic Data Masking and Row Level Security, how to use Unicode, how to troubleshoot common error messages in SQL Server and much more.


AFTER THE COURSE:

  • You will know how to efficiently perform different SQL Server administration tasks on the below SQL Server knowledge areas:

    • Maintenance

    • Performance

    • Security

    • Integration

    • Error Handling

  • You will have a deeper understanding on many SQL Server administration topics that fall under the above knowledge areas

  • You will be able to download a rich set of downloadable resources, mainly T-SQL scripts, that will help you better understand all tips provided via the course.


I WILL KEEP UPDATING THIS COURSE!!!



PREREQUISITES:

  • At least basic knowledge of SQL Server is required.

  • It would be helpful to know some basic database-related concepts (i.e. what is a database, a table, etc.) but is not a prerequisite, since we will talk about it as well.

  • Willingness and excitement to learn!


THIS COURSE CONTAINS/OFFERS:

  • 2 hours of high-quality video

  • Live demonstrations and hands-on guides that will help you perform many essential SQL Server administration tasks

  • Useful quizzes for testing your knowledge on each section

  • Many downloadable resources such as T-SQL scripts and links

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion

Who this course is for:

  • SQL Server Developers who want to learn more about SQL Server Administration
  • SQL Server Administrators (DBAs)
  • Those with little work experience

Report abuse