Administering a SQL Database Infrastructure
- All levels
- 18 and older
- $2,975
- Earn 29,750 reward points
- Price Lock Guarantee
- Live, Interactive Online Classroom
- 40 hours over 5 sessions
Apr 30th
10am–5pm EDT
Meets 3 Times
Discover Classes. Earn 10% Rewards.
Administering a SQL Database Infrastructure is unfortunately unavailable
Thankfully we have 18 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.
SQL Bootcamp
Noble Desktop - Virtually Online
Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.
$975
20 Seats Left
May 20th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
Jun 10th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, Apr 30th, 10am–5pm EDT
(21 hours over 3 sessions)
Other dates (7)
SQL Private Training
Noble Desktop - Virtually Online
Unlock the power of databases with personalized SQL training. Master the art of querying, filtering, and aggregating data using PostgreSQL, gaining essential skills applicable across various database platforms. Transform
Wed, May 29th, 10am–1pm EDT
(3 hours)
Data Analytics Technologies Bootcamp
Noble Desktop - Virtually Online
In this course, students will master Excel, SQL, and Tableau, some of the top data analytics tools. Here, students will gain the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.
May 13th
10am–5pm EDT
Meets 8 Times
$1,949
20 Seats Left
May 14th
6–9pm EDT
Meets 16 Times
$1,949
20 Seats Left
Jun 21st
10am–5pm EDT
Meets 8 Times
$1,949
20 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, May 13th, 10am–5pm EDT
(56 hours over 8 sessions)
Other dates (3)
SQL Level 1
Noble Desktop - Virtually Online
Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.
May 14th
6–9pm EDT
Meets 2 Times
$350
20 Seats Left
May 28th
10am–5pm EDT
$350
20 Seats Left
Jun 24th
10am–5pm EDT
$350
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 14th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
SQL Level 3
Noble Desktop - Virtually Online
Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.
May 28th
6–9pm EDT
Meets 2 Times
$425
20 Seats Left
May 30th
10am–5pm EDT
$425
20 Seats Left
Jun 26th
10am–5pm EDT
$425
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 28th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
Sold Out
Start Dates (0)
- $2,975
- 40 hours over 5 sessions
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this sql class:
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Who should attend
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
Course Objectives
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Protect data with encryption and auditing
- Describe recovery models and backup strategies
- Backup SQL Server databases
- Restore SQL Server databases
- Automate database management
- Configure security for the SQL Server agent
- Manage alerts and notifications
- Managing SQL Server using PowerShell
- Trace access to SQL Server
- Monitor a SQL Server infrastructure
- Troubleshoot a SQL Server infrastructure
- Import and export data
Outline: Administering a SQL Database Infrastructure (20764)
1 - SQL Server Security
- Authenticating Connections to SQL Server
- Authorizing Logins to Connect to databases
- Authorization Across Servers
- Partially Contained Databases
2 - Assigning Server and Database Roles
- Working with server roles
- Working with Fixed Database Roles
- Assigning User-Defined Database Roles
3 - Authorizing Users to Access Resources
- Describe and use server roles to manage server-level security.
- Describe and use fixed database roles.
- Use custom database roles and application roles to manage database-level security.
4 - Protecting Data with Encryption and Auditing
- Options for auditing data access in SQL Server
- Implementing SQL Server Audit
- Managing SQL Server Audit
- Protecting Data with Encryption
5 - Recovery Models and Backup Strategies
- Understanding Backup Strategies
- SQL Server Transaction Logs
- Planning Backup Strategies
6 - Backing Up SQL Server Databases
- Backing Up Databases and Transaction Logs
- Managing Database Backups
- Advanced Database Options
7 - Restoring SQL Server Databases
- Understanding the Restore Process
- Restoring Databases
- Advanced Restore Scenarios
- Point-in-Time Recovery
8 - Automating SQL Server Management
- Automating SQL Server management
- Working with SQL Server Agent
- Managing SQL Server Agent Jobs
- Multi-server Management
9 - Configuring Security for SQL Server Agent
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
10 - Monitoring SQL Server with Alerts and Notifications
- Monitoring SQL Server Errors
- Configuring Database Mail
- Operators, Alerts, and Notifications
- Alerts in Azure SQL Database
11 - Introduction to Managing SQL Server by using PowerShell
- Getting Started with Windows PowerShell
- Configure SQL Server using PowerShell
- Administer and Maintain SQL Server with PowerShell
- Managing Azure SQL Databases using PowerShell
12 - Tracing Access to SQL Server with Extended events
- Extended Events Core Concepts
- Working with Extended Events
13 - Monitoring SQL Server
- Monitoring activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
- SQL Server Utility
14 - Troubleshooting SQL Server
- A Trouble Shooting Methodology for SQL Server
- Resolving Service Related Issues
- Resolving Connectivity and Log-in issues
15 - Importing and Exporting Data
- Transferring Data to and from SQL Server
- Importing and Exporting Table Data
- Using bcp and BULK INSERT to Import Data
- Deploying and Upgrading Data-Tier Application
Remote Learning
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Refund Policy
Cancellation Policy:
Public Classes
All requests to cancel a registration must be in writing via e-mail to [email protected]
- You may cancel 11 or more business days from the start of the class for a refund less 5% cancellation fee.
- If you cancel less than 11 business days from the start of the class, you are responsible for 100% of the course fee.
Cisco Data Center or Cisco Cloud Courses
All requests to cancel a Cisco Data Center or Cisco Cloud class reservation must be made via e-mail.
- You may cancel or reschedule more than 19 business days from the start of the class for a refund less 5% cancellation fee.
- If a Learner chooses to reschedule, the payment already received will be applied to the new class.
- If a cancellation request is made within 19 business days of the class start date, no refund will be provided, regardless of payment method.
Partner-Delivered Classes
For Partner-delivered courses, if a reservation is canceled or rescheduled fewer than 16 business days before the class start date, the entire original course fee will be forfeited. An additional course fee will be required for the new reservation.
*The school, or one of its Partners, reserves the right to cancel a course for any reason and without penalty more than ten (10) business days before the start of the class.
Rescheduling:
All requests to reschedule a registration must be in writing via e-mail to [email protected]
Public Classes
- Students may reschedule a registration up to 11 business days before the scheduled start date without penalty.
- Rescheduling will be defined as transferring the registration to the same course on a different date or transferring to another course of equal or lesser value up to 6 months from the original course start date.
Partner Delivered Classes
- For Partner delivered courses, if a student reschedules less than 16 business days before the class, the entire original course fee may be forfeited. An additional course fee may be required for the new registration.
* You are allowed two (2) reschedules. After a second reschedule, the entire original course fee will be forfeited, and an additional course fee will be required for a new registration.
No Shows:
Failure to attend without prior written notice to the start date of the course will be considered a "no show" and will result in forfeiture of the full course price including NetApp courses paid for with NetApp Training Units. Under these conditions, the school, at its own discretion may allow you to re-sit another session of the same or lower priced course.
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.
Similar Classes
People who viewed this class also viewed the following classes
CourseHorse Gift Card
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 29750 points. Earn 10% back in reward points!
Fast Lane - New York
Fast Lane, a leading provider of advanced IT training courses, offers complete authorized training solutions for Cisco, NetApp, VMware and more. We are a proud developer of new advanced technology courses to ensure your access to the most updated training for your career.
Fast Lane’s instructor-led...
Read more about Fast Lane - New York
This school has been carefully vetted by CourseHorse and is a verified Online educator.
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 Database
Made in NYC
© CourseHorse, Inc. 2024 Loading...