Read more
Month/20 Hours Price:85,000
80,000
SQL Server Database Administration (Advanced Course)
SQL Server Introduction
This course is designed for professionals who wish to design and implement a database with Microsoft SQL Server. It is an instructor-led course that covers relational database fundamentals, database design, Structured Query Language (SQL) and database administration. (Online classes available)
Module -1(SQL SERVER DBA COURSE CONTENT)
INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS AND DATABASESWhat is a database and a database management system (DBMS)
Introduction to Microsoft SQL Server and its overall SQL Server Data
Module-2 (Platform)
History and Current trends of DBMS and Database Administration
Tasks of a Database Administrator
MICROSOFT SQL SERVER 2016 INSTALLATION
What are the editions of Microsoft SQL Server 2016 Data Platform ?
Learn the hardware and software pre-requisites for a successful SQL
Module-3 (Server 2016 installation)
Understanding SQL Server 2016 components
Perform an successful initial installation of Microsoft SQL Server 2016
Understanding SQL Server version identifiers, installed directories and
Module-4 (conventions)
Add features to an existing SQL Server 2016 installation including Analysis
Module-5 (Services and Reporting Services)
Install Microsoft SQL Server 2016 Management Studio
MICROSOFT SQL SERVER 2016 ARCHITECTURE
Understanding SQL Server system databases and business (non-system)
Module-6 (databases)
Understanding the SQL Server database structure
What are SQL Server filegroups and datafiles
What are SQL Server Transactional logs and database recovery models
What is the difference between a SQL Server instance and database
Client-Server Communication in SQL Server 201
HOW TO CREATE DATABASE OBJECTS USING SQL SERVER 2016
Module-7 (MANAGEMENT STUDIO)
Create two sample databases (“AdventureWorks” databases) for
Module-8 (practice in the training)
How to create tables and indexes using the SQL Server Management
Module-9 (Studio (SSMS))
How to manage indexes using SSMS including rebuilding indexes to
Module-10 (reduce fragmentation)
How to create primary key foreign key relationships between tables using
Module-11 (SSMS)
How to add new file groups in SQL Server using SSMS
MICROSOFT SQL SERVER 2016 SECURITY
What are instance-level principals and database-level principals ?
Understand SQL Server fixed server roles
How to create a new database user and map it with an instance login
What are SQL Server database schemas and learn about their association
Module-12 (with database users)
Under database role memberships and how to grant permissions to
ownership of a SQL Server database instance
How to enable login auditing in SQL Server 2016
MICROSOFT SQL SERVER 2016 DATABASE SESSION ADMINISTRATION
Understand the differences between database connections and sessions
Learn about the details of various dynamic management views (DMVs)
Module-13(for monitoring database activity)
How to kill (terminate) an SQL Server session id using SSMS
How to identify and run built-in reports in SSMS
Learn about the auto-commit, implicit and explicit transactions in SQL
Module-14 (Server)
SQL SERVER 2016 BACKUP AND RECOVERY PART 1
Introduction to Backup and Recovery strategy for databases
How to detach and attach databases in offline mode
How to copy databases using the Copy Database Wizard (CDW)
Full Database backups using the SIMPLE Recovery Model
Full Database and Transactional log backups with FULL Recovery Model
Differential database backups with FULL Recovery Model
How to view and maintain database backup history information
How to create maintenance plans for automating backups in SQL Server
How to create maintenance plans for purging old backups
Learn about the SQL Server Agent for scheduling backups
SQL SERVER 2016 BACKUP AND RECOVERY PART 2
Introduction to SQL Server Database Restore and Recovery
How to perform a full database restore and recovery
How to recover from SQL Server transactional logs
How to recover a database using time based recovery option (STOPAT)
How to use the checksum and compression options in backup operations
APPLYING SERVICE PACKS AND PERFORMING DATABASE UPGRADES
How to apply SQL Server 2012 Service Pack 3 (SP3) to SQL Server 2012 RTM
Module-15 (version)
How to upgrade databases from SQL Server 2012 SP3 to SQL Server 2016
Module-16 (RTM)
SQL SERVER 2016 DATA EXPORT AND IMPORT (DATA MOVEMENT)
Partial Data export and import using the command line tools – BCP
Module-17 (command)
Partial Data export and import using GUI tools – Export and Import Wizard
SQL SERVER 2016 PERFORMANCE TUNING
Understanding database indexes
Checking index fragmentation and maintaining them
Understanding and maintaining SQL Server Database statistics
Understanding SQL Server Profiler
How to create SQL Server traces
How to run server-side traces
SQL SERVER 2016 BACKUP TO URL (MICROSOFT CLOUD)
Create an account in Windows Azure
Create a storage account and containers within the Windows Azure
Module-18 (account)
Create SQL Server credentials for authenticating to the Windows Azure
Module-19 (URL)
Perform a full database backup to URL
Delete the database and restore it from the URL
Final Project
MySQL Database Management Final Project
MySQL CheatSheet Download
MySQL Download
MySQL Free Cloud Services (Trail)
International Student Fees: USD 350$
Job Interview Questions
PHP + MYSQL Job Interview Questions & Answers
Data Sciences Job Interview Questions and Answers
Machine Learning Job Interview Questions
Skills Required
Fresh IT Student /No programming knowledge of SQL or MySQL is required. You should have basic experience of using computers and web browsers. This includes:
able to use keyboard and mouse
know how to create, save, move and rename files
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
Week End Classes For Professionals SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Data Sciences Job Interview Questions and Answers
Machine Learning Job Interview Questions
Skills Required
Fresh IT Student /No programming knowledge of SQL or MySQL is required. You should have basic experience of using computers and web browsers. This includes:
able to use keyboard and mouse
know how to create, save, move and rename files
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
Week End Classes For Professionals SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Python Programming (for Beginner)
Python Data Science Course for Beginners
MySQL Database (for Beginners)
Java Programming for Beginners
PHP Programming (for Beginner)
Computer Networking (for Beginners)
Excel Training Course (for Beginners)
Coding Classes for Kids – Programming HTML CSS
Join FREE – Big Data Workshop
0 Reviews