SQL Server Database Administration
- Intermediate
- 18 and older
- $2,990
- Earn 29,900 reward points
- Price Lock Guarantee
- 13650 Dulles Technology Dr, Herndon, VA
- 30 hours over 4 sessions
May 4th
9am–5pm EDT
Discover Classes. Earn 10% Rewards.
SQL Server Database Administration is unfortunately unavailable
Thankfully we have 7 other Tech Classes for you to choose from. Check our top choices below or see all classes for more options.
Photoshop For Photographers
Capital Photography Center @ 8130 Porter Rd, Virginia, DC
Master the art of Photoshop and unlock its full potential for photographers in this hands-on training. Learn the essential techniques, from layers and masks to retouching tools and composites, to confidently enhance your images. Discover tips and tricks that will save you time and simplify your Photoshop workflow.
Sat, May 4th, 9am–5pm EDT
(8 hours)
Portrait Editing - Tools and Techniques
Capital Photography Center @ 218 N Lee St, Washington, DC
Learn the secrets to professional portrait editing in this hands-on course led by professional headshot photographer Laura Hatcher. Discover the powerful editing tools in Lightroom Classic and Photoshop that will take your portrait editing to the next level. Enhance your skills and create stunning portraits with confidence.
Sun, May 19th, 1–4:30pm EDT
(3 hours & 30 minutes)
Certified Optical Network Associate (CONA)
FiberGuide @ 1765 Greensboro Station Place Tower 1, Tysons, VA
Unlock the intricate world of optical networking with our comprehensive training. Dive deep into designing high-capacity transmission links and mastering optical system performance. Elevate your skills with hands-on assignments and industry-recognized certification.
All levels
18 and older
May 13th
9am–5pm EDT
Meets 5 Times
$3,100
8 Seats Left
Jun 17th
9am–5pm EDT
Meets 5 Times
$3,100
8 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, May 13th, 9am–5pm EDT
(40 hours over 5 sessions)
Other dates (1)
Certified Optical Network Engineer (CONE)
FiberGuide @ 1765 Greensboro Station Place Tower 1, Tysons, VA
Unlock the secrets of advanced optical networking in this intensive 5-day training. Dive deep into cutting-edge technology, mastering solutions to meet the demands of tomorrow's networks while optimizing costs and environmental impact. Gain invaluable insights to shape the future of your network infrastructure.
All levels
18 and older
May 20th
9am–5pm EDT
Meets 5 Times
$3,960
8 Seats Left
Jun 24th
9am–5pm EDT
Meets 5 Times
$3,960
8 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, May 20th, 9am–5pm EDT
(40 hours over 5 sessions)
Other dates (1)
Instructional Design Certificate Program
American Management Association @ 2345 Crystal Dr , Arlington, VA
Learn the practical and proven methods of instructional design to create innovative and successful training programs at the American Management Association. This comprehensive program will guide you through the steps of analyzing training needs, creating engaging activities, and evaluating course effectiveness. Enhance your instructional design expertise in just three days.
Jun 10th
9am–4:30pm EDT
Meets 3 Times
$2,695
20 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, Jun 10th, 9am–4:30pm EDT
(22 hours & 30 minutes over 3 sessions)
Sold Out
Start Dates (0)
- $2,990
- 30 hours over 4 sessions
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this sql server training:
Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative tasks with SQL Server Management Studio and Transact-SQL.
SQL Server Database Administration Course Benefits
- Configure and manage SQL Server databases
- Ensure SQL Server security with logins, roles, users, and permissions
- Develop backup strategies and recover from disasters
- Leverage SQL Server Agent to automate administrative tasks
- Isolate and repair fragmentation and database corruption
SQL Server Database Administration Course Outline
Important SQL Server Database Administration Course Information
Prerequisites
- Relational database experience
- Working knowledge of computers and a familiarity with Microsoft Windows
- SQL programming experience is helpful, but not required
Audience Profile
This course is helpful to those who are new to SQL Server administration and who will be responsible for administering SQL Server. A basic understanding of SQL Server or experience at the level of Microsoft SQL Server Training Course is required.
Exam Information
Optional Learning Tree exam is available at the end of class.
SQL Server Database Administration Course Outline
Getting Started with SQL Server
Setting up SQL Server
- Selecting installation options
- Installing a named instance
Leveraging essential tools
- SQL Server Management Studio
- Configuration Manager
- Transact-SQL
- sqlcmd
- PowerShell
Constructing and Managing Databases
Inspecting storage structures
- Relating servers, databases and files
- Creating databases and transaction logs
Designing file groups
Upgrading and moving databases
- Maximizing storage utilization
- Placing tables on file groups
- Choosing between upgrade and migration
- Detaching and attaching databases
Controlling database space
- Permitting automatic database growth
- Adding database files to expand databases
Handling Server and Database Security
Implementing server security
- Comparing authentication modes
- Defining logins
- Creating user-defined server roles
- Enforcing password policy
Granting database access
- Contrasting users and logins
- Adding users
- Defining new roles
- Delegating privileges with predefined roles
- Repairing mis-mapped logins
Granting and Revoking Permissions
Managing database-scoped privileges
- Permitting object creation
- Giving blanket permissions
Defining object-level permissions
- Limiting object access
- Meeting complex permission requirements with roles
Backup and Recovery
Backing up databases
- Selecting a recovery model
- Investigating the transaction log
- Running full, log and differential backups
Restoring databases
- Performing a post-crash log backup
- Rebuilding the master database
- Recovering user and system databases
Streamlining Tasks with Jobs, Alerts and Database Mail
Configuring SQL Server Agent
- Setting agent properties
- Implementing database mail
Defining jobs to handle routine tasks
- Creating alerts and operators
- Initiating multi-step jobs
- Associating alerts with jobs
Database Maintenance and Monitoring
Handling fragmentation and database corruption
- Identifying and curing fragmentation
- Repairing database corruption
Building database maintenance plans
- Scheduling plan execution
- Notifying operators of success or failure
Resolving contention problems
- Identifying blocked processes
- Killing blockers
Refund Policy
If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to 3 weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.
- If a customer transfers to another course prior to 3 weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.
- If a customer needs to cancel an enrollment 3 weeks prior to the start of the class or within seven days of registration, we will refund 95% of any prepaid course tuition for that enrollment.
- If a customer does need to transfer or cancel a course within 3 weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances.
Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.
In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.
Benefits of Booking Through CourseHorse
- Booking is safe. When you book with us your details are protected by a secure connection.
- Lowest price guaranteed. Classes on CourseHorse are never marked up.
- This class will earn you 29900 points. Earn 10% back in reward points!
Learning Tree International
Established in 1974, Learning Tree International is a leading provider of IT training and management training to business and government organizations worldwide. In addition, Learning Tree provides IT Workforce Optimization Solutions – a modern approach that improves the adoption of skills, and accelerates...
Read more about Learning Tree International
This school has been carefully vetted by CourseHorse and is a verified Washington, D.C. educator.
Learning Tree International
Herndon
13650 Dulles Technology Dr Ste #175
At Sunrise Valley Dr
Herndon, Virginia 20171 Herndon
13650 Dulles Technology Dr Ste #175
At Sunrise Valley Dr
Herndon, Virginia 20171
Give This Course as a Gift Card
- Thousands of classes
- No expiration
- Unique and memorable gifts for any occasion
- Personalized
- Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
- Instant delivery
- Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Book this Class as a Group Event
Booking this class for a group? Find great private group events
Or see all Professional Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?
-
Price Lock Guarantee
Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!
-
Earn 10% Reward Points
Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!
-
No Added Fees
Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!
-
Curated Courses
Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Microsoft Servers
Made in NYC
© CourseHorse, Inc. 2024 Loading...