Administering a MS SQL Server Database Infrastructure
- Intermediate
- 18 and older
- $2,394
- Earn 23,940 reward points
- Price Lock Guarantee
- Live, Interactive Online Classroom
- 40 hours over 5 sessions
May 14th
6–9pm EDT
Meets 2 Times
Discover Classes. Earn 10% Rewards.
Administering a MS SQL Server Database Infrastructure is unfortunately unavailable
Thankfully we have 10 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.
SQL Level I
NYC Career Centers - Virtually Online
Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.
$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 Server Bootcamp
Noble Desktop - Virtually Online
Gain actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Take your data analysis skills to the next level at Noble Desktop.
May 14th
6–9pm EDT
Meets 6 Times
$975
20 Seats Left
May 28th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
Jun 24th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 14th, 6–9pm EDT
(18 hours over 6 sessions)
Other dates (7)
SQL Level II
NYC Career Centers - Virtually Online
Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.
May 21st
6–9pm EDT
Meets 2 Times
$350
20 Seats Left
May 29th
10am–5pm EDT
$350
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 21st, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
SQL Level III
NYC Career Centers - Virtually Online
Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.
May 28th
6–9pm EDT
Meets 2 Times
$425
20 Seats Left
May 30th
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)
SQL Bootcamp
NYC Career Centers - Virtually Online
Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.
Apr 30th
10am–5pm EDT
Meets 3 Times
$975
19 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)
Sold Out
Start Dates (0)
- $2,394
- 40 hours over 5 sessions
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this sql server training:
Full Course Name
Administering a Microsoft SQL Server Database Infrastructure
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. This course will help you with the certification of Exam 70-764 Administering a SQL Database Infrastructure.
The average salary of Database Administrator (DBA) with Microsoft SQL Server skills is $74,885 per year.
Course Objectives:
After completing this course, students will be able to:
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:
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Administering a Microsoft SQL Server Database Infrastructure
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. This course will help you with the certification of Exam 70-764 Administering a SQL Database Infrastructure.
The average salary of Database Administrator (DBA) with Microsoft SQL Server skills is $74,885 per year.
Course Objectives:
After completing this course, students will be able to:
- 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
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:
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- 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.
- Module 1: SQL Server Security
- Module 2: Assigning Server and Database Roles
- Module 3: Authorizing Users to Access Resources
- Module 4: Protecting Data with Encryption and Auditing
- Module 5: Recovery Models and Backup Strategies
- Module 6: Backing Up SQL Server Databases
- Module 7: Restoring SQL Server 2016 Databases
- Module 8: Automating SQL Server Management
- Module 9: Configuring Security for SQL Server Agent
- Module 10: Monitoring SQL Server with Alerts and Notifications
- Module 11: Introduction to Managing SQL Server by using PowerShell
- Module 12: Tracing Access to SQL Server with Extended events
- Module 13: Monitoring SQL Server
- Module 14: Troubleshooting SQL Server
- Module 15: Importing and Exporting Data
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
We are saving your seat! In order to provide you with the highest quality training at the best price, we ask that you abide by our cancellation policy. You may cancel a class without a cancellation charge up to 10 business days prior to the class start date. If you cancel less than 10 business days prior to the class start date, then QuickStart will charge you the full amount of the class. You will have the option to reschedule the class at no additional fee - on a space available basis only. If you are unable to reschedule the class because of personal reasons or QuickStart no longer offers the class, no refund will be provided. QuickStart asks that you notify us as soon as possible if you need to reschedule a class.
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 23940 points. Earn 10% back in reward points!
QuickStart
QuickStart exists to create world-class technologists by personalizing and individualizing training to address the massive skills gap in the IT industry. Through 20 years of research and data analysis, we’ve learned that a modern learner prefers to learn through multiple modalities such as self-paced...
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 Microsoft Servers
Made in NYC
© CourseHorse, Inc. 2024 Loading...