SQL Server Database Administration

SAM Career Center
SAM Career Center

Detailed information

This course will introduce SQL Server Administration and Development. You will get knowledge and practical skills in T-SQL coding and debugging, system installation, management, and maintenance.
SQL Server DBA, SQL Server Database Administrator, SQL Server Database Developer, SQL Developer
Method:In a classroom
Duration:4 Months
Total hours of lesson:120
Accreditation:Licensed New York State Private Career School
Requirements:Database Development with MS SQL Server
Internship:This Hands-on course do not required any Internship
Students per class:10

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

Upon completing this course students will have skills in:
- Microsoft SQL Server installation / Cluster Installation / Microsoft SQL Server Analysis.
- How to use SQL Help/SQL Help Online; how to find an answer for problematic issue
Managing database files:
- Data structure
- Creating and Managing databases
- Performance considerations
Managing Security
Performing Administrative tasks
Backup/restore and recovery
Monitoring SQL for performance
Transferring Data (DTS)
Replication; Disaster recovery; Log Shipping
Data warehousing; SQL Analysis Server

The Following topics will be covered:
SQL Server Overview
SQL Server Installation and Configuration
Overview of Database Concepts
Managing Security
Performing Administrative tasks
Monitoring Performance
Transferring data
SQL Server Analysis
SQL Server – ADO technology
SQL Programming Across Multiple Servers
XML Integration
Strategies to Maintaining High Availability
Maintaining transactions and locks

Course location

SAM Career Center

SAM Consulting Services, Inc. (d/b/a SAM Career Center) was founded in 1993 by a team of experienced Information Technology and Human Resources professionals. Over this period of time our firm has grown into one of the Tri-State area most respected job skills training and job readiness training organizations. Currently SAM Consulting Services is a registered in NY State Business School specializing in advanced Computer, Finance and Business training.

Among our most significant achievements are:
- Licensed as a New York State Business School
- Approved as a Vocational Type of Institution (Visa M-1) for Foreign students
- Approved by NYS Department of State as Real Estate Training Provider
- Approved as a Work Force Training Provider by State of New York and New Jersey
- Approved as a Training Institution of New York State Division of Veterans Affairs
- Approved as a Microsoft IT Academy in 2011
- Developed about 50 various IT and Business related programs

Our programs are selected on the basis of industry trends and ongoing market demands and continuously receive a high rate of employers satisfaction.

SAM Career Center offers various free classes and seminars, such as ESL courses and City Jobs preparation seminars.

In 1999 SAM Consulting Services, Inc. was merged with PowerSelf Corp, a placement and consulting services company to offer a full range of IT related services for its clients including Consulting, Development, Placement and Training.

Our contact information:

SAM Career Center
1723 East 12 Street, 3rd Floor,
Brooklyn, NY 11229
P: 718-648-3997 (Training), 718-769-1440 (Consulting)
F: 718-648-3888

Search similar to SQL Server

Courses similar to SQL Server

Sponsored links