Step by Step Database Tutorial for Beginners |
1. Installing MS SQL Server Database
In this tutorial, you'll learn to install MS SQL Server in your PC. Any version of MS SQL Server is Okay.MS SQL Server is a paid software but for now you can download and install MS SQL Server Express from the link below which is FREE.
Download MS SQL Server Express: https://www.microsoft.com/en-us/download/details.aspx?id=55994
2. Learn to Create new Database, Alter/Update Existing Database and Drop/Delete Database
After the MS SQL Server is installed successfully, first step is to learn to create database. And here you'll learna. To Create a n
ew Database
b. To Alter (Update) Existing Database
c. Drop (Delete) Existing Database
3. Learn to Create new Table, Alter/Update Table and Drop/Delete Table in MS SQL Server Database
After the database is created, we need to create tables to store data for different modules.Thus, In this tutorial you'll learn to
a. Create New Table
b. Alter (Update) Existing Table
c. Drop (Delete) Existing Table
4. Learn to Add new columns, Modify and Delete Existing Columns in Database Tables
Once the tables are created, you'll learn to do following things in this tutoriala. Add new columns in a Table
b. Modify Columns in a Table
c. Delete Columns in a Table
5. Learn to Insert Data in Database Table using SQL Query
After learning the Data Definition Language (DDL) of database i.e. Creating, Updating and Deleting Databases and Tables, You'll learn to Insert data in database tables in this tutorial.6. Learn to Update Data in Database Table using SQL Query
Now, in this tutorial you'll learn to Update Existing Data in a database.7. Learn to Delete Data in Database Table using SQL Query
And Here you'll learn to Delete Existing Data in Database.8. Learn to Update and Backup Database in MS SQL Server
One of the most important thing in database is to know how to backup and restore database for security.Thus, you'll learn to BACKUP and RESTORE database in MS SQL Server.
9. How to use WHERE keyword in Database?
In this tutorial, you'll learn to use WHERE keyword with SELECT statement and different operators like equals to =, greater than, not equals to, etc. to filter and select specific data from the relational database.10. How to use DISTINCT and TOP keywords in Database?
In this episode, you'll learn to use DISTINCT keyword in Relational Databases (MS SQL Server/MySQL/Oracle, etc.) to display unique data without repetition.And use TOP keyword to display limited data from the database.
11. How to use ORDER BY and LIKE keywords in Database?
This is the 11th episode of our "Database for Beginner" Tutorial Series.In this episode, you'll learn to use ORDER BY keywords with ASC and DESC in SELECT statement to sort data in database.
12. How to use AND OR keywords for Complex Queries in Database?
This is the 12th episode of our "Database for Beginner" Tutorial Series.You'll learn to use AND/OR keywords with SELECT statement to make complex queries in database.
13. How to use Aggregate Functions like Count, Max, Min, Sum, Avg, etc. in Database?
In this tutorial, you'll learn to use Aggregate Functions like Count, Max, Min, Sum and Avg in Database to know the general statistics easily and quickly.If you like this tutorial series and think it can help others as well then don't forget to share it on social media.And if you have any suggestions or want to learn anything else related to Programming or Database, then please leave a comment below.
Comments