Administering a SQL Database Infrastructure is unfortunately unavailable

Thankfully we have 10 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

Administering a SQL Database Infrastructure

at NetCom Learning - Hell's Kitchen

(19)
Course Details
Price:
$2,995
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Hell's Kitchen, Manhattan
519 8th Ave
Btwn W 35th & W 36th Streets
New York, New York 10018
(Map)
Share:
Purchase Options
Description
Class Level: All levels
Age Requirements: 16 and older
Average Class Size: 6

What you'll learn in this sql class:

Administering a SQL Database Infrastructure (SQL Server 2017) 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 is based on the objectives of the course version 20764C. 

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

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.

Still have questions? Ask the community.

Map

Google Map

NetCom Learning

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

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 29950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at NetCom Learning (16)

School: NetCom Learning

NetCom Learning

NetCom Learning delivers top-quality training and certification solutions to businesses, individuals and government agencies.

Experience
Since its inception in 1998, NetCom has trained over 95 percent of the Fortune 500, serviced over 23,000 business customers, and advanced the skills and careers of over...

Read more about NetCom Learning

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

10 Top Choices

Introduction to SQL and Data Analysis

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. Also, this workshop will teach you advanced concepts of databases as well as how to write...

Wednesday Nov 6th, 6pm - 9pm

  (3 sessions)
$399

3 sessions

SQL Bootcamp: Learning the Language

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways Understand...

Saturday Oct 19th, 10am - 5pm

SQL Bootcamp Series

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence and begin to unleash...

Thursday Oct 24th, 10am - 5pm

  (2 sessions)
$479

2 sessions

Developing SQL Data Models

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS. Audience Profile The primary audience for this...

Monday Oct 21st, 10am - 6pm

  (3 sessions)
$1,785

3 sessions

Provisioning SQL Databases

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. Audience Profile The primary audience for this course is individuals...

Monday Oct 21st, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

Administering a SQL Database Infrastructure

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

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. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases. Audience Profile The primary audience for this...

Monday Nov 11th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

Intermediate SQL Bootcamp

at General Assembly - Financial District 1 Liberty St 3rd Fl, New York, New York 10006

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis. Takeaways We will be going over the following: JOIN and UNION with Aliasing Primary and Foreign Keys Aggregation and Functions Complex JOINs with multiple tables NULL values and related SQL functions...

Saturday Oct 26th, 10am - 4pm

SQL Querying: Basic

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses. This course is taught using Microsoft SQL Server, but...

Thursday Nov 14th, 10am - 5pm

  (2 sessions)
$990

2 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

SQL Querying: Advanced

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle...

Thursday Dec 12th, 10am - 5pm