• 9891108002

  • Hire From Us
  • Alumni
SmartBrains - Piping | Process | Electrical | Instrumentation | Civil & Structural Design Engineering Training & Certification Courses| Solar Power Plant | Piping Stress Analysis | Health Safety & Environment Engineering | Robotics Engineering | HVAC | Wind Turbine Technology | Solar Water Hearing Engineering | Chemical & Petroleum Engineering | Civil Engineering | Electrical Engineering | Mechanical Engineering Course | Oil & Gas Training | Renewable Energy Program | AR/VR Technology | Process Safety Engineering | Embedded System Design | Industrial Automation System Design | Internet of Things (IOT) | Heat Exchanger | Hazop Engineering | Waste Water Treatment System Design | Steel BIM Design | Steel Column Design | Hydroelectric Power Plant Design | Highway & Road Design Engineering | Roofing System Design | Cathodic Protection | Mechatronics Engineering | CNC Machining Engineering | Website Development Training | IT Courses | Mobile App Development Training | Game Design & Development | Data Science Training Program | Business Management  Course | Project Management Certification Program | Accounting & Finance Certification Program  | Noida | PuneSmartBrains - Piping | Process | Electrical | Instrumentation | Civil & Structural Design Engineering Training & Certification Courses| Solar Power Plant | Piping Stress Analysis | Health Safety & Environment Engineering | Robotics Engineering | HVAC | Wind Turbine Technology | Solar Water Hearing Engineering | Chemical & Petroleum Engineering | Civil Engineering | Electrical Engineering | Mechanical Engineering Course | Oil & Gas Training | Renewable Energy Program | AR/VR Technology | Process Safety Engineering | Embedded System Design | Industrial Automation System Design | Internet of Things (IOT) | Heat Exchanger | Hazop Engineering | Waste Water Treatment System Design | Steel BIM Design | Steel Column Design | Hydroelectric Power Plant Design | Highway & Road Design Engineering | Roofing System Design | Cathodic Protection | Mechatronics Engineering | CNC Machining Engineering | Website Development Training | IT Courses | Mobile App Development Training | Game Design & Development | Data Science Training Program | Business Management  Course | Project Management Certification Program | Accounting & Finance Certification Program  | Noida | Pune
  • About Us
    • About Company
    • Affiliation & Accreditation
    • Business Portfolio
    • Our Partners
    • Achievements
  • Courses
    • Group 1
      • Oil & Energy
      • Engineering & Technology
      • Project Management
      • Health, Safety & Environment
      • AR/VR/XR Technology
      • Robotics/IoT
    • Group 4
      • I.T / Software
      • Website Development
      • Mobile App. Development
      • Game Design & Development
      • Data Science & Analytics
      • Business Management
    • Group 3
      • Fastrack Program
      • PG/Diploma Program
      • Summer/Winter Training Program
      • Technician Training Program
      • Campus Training Program
      • Special Workshops
  • Resources
    • News & Events
    • Testimonials
    • Training Calender
    • Global Certification
    • Skill Loan
    • Career
  • Join Us
    • Frenchise Partners
    • Summer/Winter Internship
  • Contact Us
  • Student Training
    • 6 Months Industrial Training
    • Summer Training
    • Winter Training
    • Campus Training

Website Development

  • Home
  • All courses
  • Website Development
  • MS SQL Server DBA Training

MS SQL Server DBA Training

×

Fill This Form For Brochure

×

SmartBrains Oil,Gas & Energy Training program is conducted in both Online & Classroom mode using the latest state of the art software tools and via the Design Engineering Software and remote sharing facility. The training program is delivered by well-experienced mentors from the relevant domain of expertise as per the specific need of the participants. The Training program is provided with required reference material, hands-on exercises and Lab sessions for practical exposure. The students are monitored and instant assisted for any clarifications and doubts by the faculty & support-team.

Delivery Mode -
  • Classroom
  • Live Instructor-Led Training - Online
Steps to get into Demo -
  • Fill the Demo request form.
  • Select the mode of Demo.
  • Select the program/Course.
  • Book your slot as per your convenience
  • Join the pre-scheduled demo by SmartBrains

Request For Demo

×
Classroom Training

Classroom Training schedule is a custom-made training program to suit the aspirants from different educational backgrounds, the training programs are conducted by well-trained faculties in the corresponding specializations in a real-time environment. The classroom training is conducted exclusively on the campus of SmartBrains with well equipped and configured architecture to give students exactly an environment of industrial exposure.

Key Features :
  • Optimum Training Class Size.
  • Well equipped Labs
  • Group interaction enhances learning.
  • One to one individual monitoring & attention
  • Learning from peers
  • Instant and quick solution of doubts
  • Customized schedule for fast learning

Get In Touch With Us

(0 review)
Free
SmartBrains-MS-SQL-Server-DBA-Training-Database-Website-Development-Summer-Winter-Internship-Program-Certification-Noida-Delhi-Mumbai-Chennai-Dehradun-Pune
  • Overview

About the Program

This is a detailed MS SQL Server DBA training course from Intellipaat that will help you understand all about database administration and become a Database Administrator. You will get a clear understanding about installation, functioning and authentication types in SQL Servers. This course also covers managing, maintaining and securing of databases and automation of SQL Server. Further, you will also receive official course material issued by Microsoft for Administering Microsoft® SQL Server® 2014 Databases.

 

Learning objective

By the end of the course, you’ll be able to:

  • Roles and responsibilities of SQL Server DBA
  • Various SQL Server tools available
  • Query Design and Query Performance Tuning
  • Disaster Recovery and High-availability solutions
  • DBA creation, modification and file addition
  • SQL Server security authentication measures
  • Importance of backups and restorations
  • Job monitoring and SQL Server Agent Clustering
  • Creation of users and logins

Program Highlights

 

About The Course

Mode / Duration

  • Online
  • Weekend

Learning-Based Outcomes

Get hands-on experience in applying design tools & techniques to real engineering problems and understand Design, Engineering, Construction, O & M, etc. Thus, become a Technology Driven Engineering Professional.

Trainer

Delivered by Senior Industry Professionals having extensive experience in Design & Engineering in diverse domains & industries. These practitioners are also Empanelled as subject matter experts with SmartBrains Engineers & Technologist Pvt. Ltd.

Content

Get 24 x 7 access to SmartBrains LMS platform (Online/Offline) with Abundant Content on Process Engineering including Courseware (PPT / PDF), data, case studies, articles, books, videos, examples, presentations, resource library & related more.

Job Oriented Outcomes

Fill the Void of Talent Shortage in Design Engineering by becoming eligible for thousands of High Paying Jobs in India & Abroad with an upgraded profile through this skill & certification. Additionally, Get Promoted from your current position with the added skill set.

 

Course Modules

  • Starting with SQL Server
    • Responsibilities of Database Administrator, Types of DBAs, History of SQL Server, Editions of SQL Server, Tools of SQL Server, Differences between Standard and Enterprise editions, Instances types in SQL Server, Default Instance, Named Instance, SQL Server Services, Instance aware services, Instance unaware services
  • Installing SQL Server
    • Pre-requisites, Installation of Server, Post Installation configuration and verification
    • Hands-on Exercise – Install SQL Server on Linux, Install SQL Server on Windows, Configure the Server and verify that it is up and running
  • Functioning of Databases
    • Describe Database, Types of Database and Brief explanation, System Databases, User Database, Sql Server Database Architecture, Pages, Extents, File groups, Transaction Architecture, Creating Database, Modifying Database, Adding Files, Moving and renaming of Database files, Database modes, Real time Scenario
    • Hands-on Exercise – Create a database schema in SQL Server, Create a table to store details of a student personal information, Add dummy data to the table, Move a database file to another location, Rename database file
  • Importing and Exporting Data
    • What is Import and Export of table data, Copy or Move a database, Tools, and Techniques for data transfer
    • Hands-on Exercise – Import a table from a saved database file in the workspace, Export data from workspace to save in a database file
  • Security
    • Authentication Types in SQL Server, Types of Login, Windows Login, SQL Login, Creating Users and Logins, Server roles, Password policy, Understanding Database and Server Roles, Permissions, Working on access level issues, Orphan users Finding and Fixing
    • Hands-on Exercise – Use SQL Server Management Studio, Create a login, Create database users, Assign different roles (owner, reader, accessadmin, securityadmin, denydatawriter, denydatareader), Provide permission level and access level, Create an orphan user, Find the orphan user
  • Database Backups
    • Database Backups, Why we need backups, Types of Backup, Full Backup, Differential Backup, Transaction Log Backup, Copy-only, Mirrored, Split and Tail log Backups, Differences between backups, Backup Strategy, Understanding how the data moving from Log to Data File,CHECKPOINT, Monitoring the space usage of Log File and fixing, Checking the backup files VALID or CORRUPTED, Backup storage tables
    • Hands-on Exercise – Perform database backup, Check transaction log backup, Monitor space usage of Log files, Use backup storage table
  • Recovery and Restoration of Database
    • Types of Recovery Models, Full, Bulk Logged, Simple, Differences between Recovery Models, Setting Recovery Models according to the Scenarios with examples, Performing Restorations, Types of Restoration, Attach and Detach, Shrinking files, Point-in-Time Recovery
    • Hands-on Exercise – Set a recovery model, Perform point-in-time recovery, Perform restoration from the last saved state
  • Monitoring SQL Server 2014
    • What is monitoring sql server, Dynamic Management Views (DMV), Dynamic Management Functions (DMF), Performance Monitor, Activity Monitor, Configure database mails, alerts and notification
    • Hands-on Exercise – Create a DMV, Write Functions to monitor sql server activity dynamically, Configure mails, alerts and notification, Generate alerts and notification, Send email
  • Tracing SQL Server Activity
    • SQL Server Profiler, SQL Trace stored procedures, Using Traces, Optimize SQL Server workloads
    • Hands-on Exercise – Use SQL server profiler, Create trace stored procedures and run them Optimize workloads of server
  • Auditing Data Access and Encrypting Data
    • SQL server audit feature, Implement audit, Audit data access, Implement encryption
    • Hands-on Exercise – Implement audit, Audit data access, Implement encryption
  • Database Maintenance
    • Common database maintenance tasks, Ensuring database integrity, Maintaining Indexes, Automating common tasks
    • Hands-on Exercise – Create index on table column, Update index after inserting new records
  • Automating SQL Server 2014 Management
    • Implementing and Managing SQL Server Agent Jobs, Managing job on multiple servers
    • Hands-on Exercise – Implement Server Agent Jobs Manage Jobs on same server
  • MS SQL Server DBA Project
    • Project : SQL Server Audit
    • Industry : General
    • Topics : This project is involved with implementing an SQL Server audit that includes creating of the TestDB database, triggering audit events from tables, altering audit, checking, filtering, etc. You will learn to audit an SQL Server instance by tracking and logging the events on the system. You will work with SQL Server Management; learn about database level and Server level auditing.

Course Certificates

SmartBrains is associated with The National Skill Development Corporation (NSDC) as the Training and Certification partner for various job oriented training programs across various sectors including Oil & Gas, Power, Renewable Energy, Hydrocarbon, IT & ITs, Electronics, Telecom, Agriculture, Life science etc. offering assessment based Training & certifications for a gamut of job profile.

Who should join?

  • Working professionals in Domains: Software Development, Database, Admin, Web developers, Software Tester & Analyst.
  • Students (Computer Science Engineering & Diploma in Computer Science Engineering) who want to develop their career in Software development, database, Web Developer, Software Tester & Analyst.

 

For Corporate queries

A-25, Sector-59, Noida (UP),India
Pin Code-201301

Connect with Program Advisor

training@smartbrains.com
+91 8955560560 | +91 9891108700

www.smartbrains.com

Nodal Centers

Noida, Dehradun
Guwahati, Pune

 

 

 

Course Features

  • Lectures 0
  • Training Mode Online|Classroom
  • Duration 50 hours
  • Certification Yes (NSDC)
  • Students 0
  • Assessment Yes (Third Party)

Get In Touch With Us

[contact-form-7 404 "Not Found"]

Click for brochure :

×

Please fill this form to download pdf

  • Overview
  • Online | Classroom
  • ×

    The Online Training program is conducted over the internet using the latest state of the art software tools and via the video and desktop sharing facility. The training program is conducted by well-experienced training faculty who are mentored in conducting such sessions as per the convenience of the participant.
    The Online Training program is provided with required material for reference and on hands exercises and Lab sessions for practical exposure. The students are monitored for any clarifications and doubts by the faculty.

    Key Highlights :
    • • A flexible & hassle free Learning ecosystem

    • • Access anywhere & Anytime.
    • • Modern, Simple Design LMS
    • • Mobile & Laptop compatibility

    • • Learn on the GO.

    • • Live & Interactive session.
    • • Previously Recorded Session

    Get In Touch With Us

    ×
    Classroom Training

    Classroom Training schedule is a custom-made training program to suit the aspirants from different educational backgrounds, the training programs are conducted by well-trained faculties in the corresponding specializations in a real-time environment. The classroom training is conducted exclusively on the campus of SmartBrains with well equipped and configured architecture to give students exactly an environment of industrial exposure.

    Key Features :
    • • Optimum Training Class Size.

    • • Well equipped Labs
    • • Group interaction enhances learning.
    • • One to one individual monitoring & attention
    • • Learning from peers
    • • Instant and quick solution of doubts
    • • Customized schedule for fast learning

    Get In Touch With Us

Free
  • Share:

You May Like

PG Diploma in Solar Power Plant: Design, Engineering and O&M Read More
smartbrains

PG Diploma in Solar Power Plant: Design, Engineering and O&M

0
0
₹ 50,000 ₹ 45,000
Process Design Engineering Read More
smartbrains

Process Design Engineering

0
0
₹ 36,200 ₹ 31,200
Electrical Design Engineering Read More
smartbrains

Electrical Design Engineering

0
0
₹ 36,200 ₹ 31,200
Instrumentation Design Engineering Read More
smartbrains

Instrumentation Design Engineering

0
0
₹ 36,200 ₹ 31,200
Piping Design Engineering Read More
smartbrains

Piping Design Engineering

0
0
₹ 36,200 ₹ 31,200

Register Here !!!









All Courses

  • AR/VR/XR Technology
  • Business Management
  • Engineering & Technology
    • Chemical & Petroleum Engineering (8)
    • Civil Engineering (9)
    • Electrical Engineering (14)
    • Electronics Engineering (12)
    • Instrumentation Engineering (7)
    • Mechanical Engineering (10)
  • featured
  • Health, Safety & Environment
  • I.T / Software
  • Oil & Energy
    • Oil & Gas (7)
    • Renewable Energy (5)
  • PG/Diploma Program
  • Project Management
  • Robotics/IoT
  • Special Workshops
  • Summer/Winter Training Program
  • Website Development

logo-eduma-the-best-lms-wordpress-theme

A-25, Sector-59, NOIDA – 201301

1800-12100-0018

9891108002

info@smartbrains.com

Company

  • About Us
  • Blog
  • Contact Us
  • Become A Teacher

Links

  • Courses
  • Events
  • Gallery
  • FAQ

Support

  • Brochure
  • Enquiry
  • Career
  • Testimonials

smartbrains.com Powered by Smartbrains Engineers & Technologist Pvt. Ltd.