Students will learn how to install Free Version of SQL SERVER with Management Studio.…
What you’ll learn
By the cease of this course you will be a professional sq. Database administrator and be able to practice for square jobs
Administration of sq. Database through Microsoft home windows
You may study one hundred fifty+ sq. Queries
You will be capable of troubleshoot ordinary sq. Associated issues
You may manipulate sq. Servers in a company environment
You may write simple to develop square queries
Troubleshoot regular sq. Database associated problems
Understand the way to solution particular business questions by way of the use of square’s mixture features
College students will be capable of run reviews for management if you want to make monetary decisions
Fine attitude and desire to research
Passion to emerge as sq. Database administrator
A computer with as a minimum four-8G of RAM
Microsoft sq. Server remains one of the world’s maximum famous and top databases. Database is a heart of IT which is wanted to saved all vital statistics and records.
If you want to come to be square database administrator then that is the route for YOU.
This training publications will offer you all of the essential abilities you want to be a successful database administrator and take you to the subsequent stage. Plus, this path will prep you for the square Server MCSA certification.
Right here is the route outline:
Section 1 – advent
Introduction to Database
Pinnacle 5 RDBMS
Introduction to MS sq. Server
One of a kind editions of MS square
Segment 2 – down load, install and Configure home windows
MS sq. Server prerequisite
Download and installation VMWare pc player
Non-compulsory – download and set up Oracle Virtualbox
Create a digital device
Down load and installation home windows Server
Digital system control
Segment 3 – down load, install and Configure MS sq. Server
Stipulations for MSSQL installation
Down load MSSQL and square Server management Studio
Deploy and Configure MSSQL
Installation sq. Server control Studio
Download and install AdventureWorks Database
Segment 4 – Database fundamentals and layout
What is facts and Database?
How is information saved?
What’s a desk, COLUMN and ROW ?
What’s a key? Number one, foreign, precise keys and so forth.
What is Relational Database and Relational Database control system (RDBMS)?
What’s a Transaction and ACID properties?
Database Normalization AND specific kinds of Database Normalization
Create your first Database, desk and Populate desk with records…
Phase 5 – creation to square commands
Welcome to primary sq. Instructions
What’s a square announcement and varieties of square statements
DML announcement with examples
DDL Statements with examples
DCL declaration with examples
TCL announcement with examples
Section 6 – query and Manipulation of records the use of square
Create table(s) and Temp table(s)
What’s a View?
Select assertion in element
Operators, Expressions and situations
Where Clause, ORDER by using, HAVING via, organization by Clause
Select from tables – JOINS
Distinctive kinds of JOINS
What’s a Sub question?
INSERT, replace, DELETE and Truncate Statements
What is a shop system?
Function, trigger and INDEX
Clustered ,Non-clustered Indexes and Index layout considerations
Index Fragmentation and Lab for Index
Phase 7 – Microsoft sq. Database administration
Review of MSSQL control tools
Exploring square Server management Studio (SSMS)
Exploring sq. Server Configuration manager
MSSQL gadget Databases, DO’s and DONT’s of machine databases
What’s grasp, etmpdb, msdb and other gadget databases?
Section eight – Deep Dive into MSSQL running
What are Pages , Extents, web page architecture and PFS?
MSSQL Database structure
Operation and working of transaction log
Configuring consumer Database
Quality practices even as growing user Database
Phase nine – MSSQL Backup and restore
Backup of a Database, significance for DBA and exceptional Media used for Backups
Restoration models in MSSQL and the way that impact backups an restore
Full and differential backups
Transaction Log Backups, Log Backup Chain and Tail-log Backup
Lab for full, Differential and Transaction Log Backups
Repair and restoration review
Complete, Differential and Transaction Log database restore
Point in time restore of a database
Whole Backup , repair and restore in Time Lab
MS sq. Server DBCC CHECKDB command
Page stage restore / recuperation the use of complete Backups
Growing maintenance Plan Backups/Re-indexing and so on.
Phase 10 – MSSQL user management
MSSQL safety version
MSSQL Server Authentication Modes
Permissions (provide , DENY, and REVOKE)
Section eleven – MSSQL Server Agent management
Square Server Agent advent
Sq. Server Agent Jobs and Schedules
Section 12 – superior square Server administration topics
High Availability and its types
What is Replication and Transactional Replication
Transactional Replication Setup (LAB)
MSSQL facts Encryption and type of encryption
Transparent statistics Encryption (TDE) and configuration
Backup and repair of encrypted Databases
MS square Server Reporting services (SSRS)
MS sq. Server Integration offerings (SSIS)
Segment 13 – direction Re-cap
Commands we’ve got learned
Who this route is for:
All and sundry who wants to begin a career in sq. Database administration
Each person who wants to have complete sq. Database education to get a job in IT
Absolutely everyone who wants to enhance his/her career
Everyone who desires to master the sq. Command line abilties
University college students
Instructors and instructors