What is MSSQL and how it works
Hello Friends today i have start with Database concept this will help you to work in Companies like HCL,TCS ,CTS ,INFOSYS etc , Generally people are struggling with concepts so this video will give you full idea about database and there work .
this video cover basic understanding with RDBMS along with MSSQL server versions editions ,Licensing and installation instructions.
please comments and confirm if you have any doubt on this and also give feedback in case you want me to create Video on specific topic .
Email me [email protected]
To know about patching of SQL server using installer ,Configuration manager settings and know about CU,SP and KB in details .
How to avoid restart using RegEdit .
Part 1 :- • What is MSSQL and how it works
Part 2 :- • MSSQL Server versions and updates
Db configuration :- • How to create database Rename databas...
1. SQL Server Create Database with GUI and TSQL
2.How to Rename a Database in MSSQL Server using GUI and TSQL?
3. How to Attach and Detach Databases in MSSQL server and detach database without log file.
4.How to Shrink Database log files And Database Files using TSQL and GUI .
5.How to Take Database Offline and Bring it Online using TSQL and GUI .
6.How to Script out an Entire Database in MS SQL Server Using GUI .
7. How to change Compatibility level of a database Using GUI
8.How to Take Database Single User Mode and Multi User Mode in MSSQL Server Using GUI?
9.How do I change the ownership of a database and how find the database owner in mssql ?
10.Auto growth setting and initial size setting Database in SQL Server?
Author :- Gaurav Jain
Software used :- MSQL server 2019,2017 and sql server 2014
Notepad ,Zoom.
