Turn what you know into an opportunity and reach millions around the world.

Your cart is empty.

Microsoft SQL Server 2014 Database Administration

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

Created byTarang B. Patel

Last updated 4/2019

English

What you'll learn

microsoft sql server 2014 database administration skill and begaining guide
General knowledge of what a Database is.
How to install SQL Server Express 2014
Create a database in SQL Server
Create tables in SQL Server
Add data into tables in SQL Server
Update data in tables in SQL Server
Delete data from tables in SQL Server
Backup and Restore SQL Server Database

Course content

6 sections • 7 lectures • 46m total length

Introduction8:22
In this lecture you will learn how to Install Microsoft SQL Server in Your Desktop/Laptop after that Step by step installation guideline and know basic configuration of Microsoft SQL Server easy and fast ways.

Create, Alter and Drop Microsoft SQL Database5:55
In this lecture you will get knowledge about step by step
1. how to Create new MS SQL Database using query mode and GUI mode both ways.
2. After that we will See how to Alter (Edit/Update) Database structure using query and GUI (both) Mode.
3. At last we see how we can Drop (Delete) database using query and GUI Mode.
All Step are easy , clean and described explanation.

How to Add, Remove and Modify Columns in an Existing Table in MS SQL Server9:57
We already know how to create empty table, now we learn how to create columns (Table Structure).
1. In this lecture we will learn how to create table structure (Column Structure) and column data type using Query and GUI mode.
2. How to modify SQL Table's columns and column datatype using query and GUI mode.
3. And How to remove Column from SQL Table.
This SQL Table Structure is designed or changed time to time base on requirement so this function is useful everytime.

How to Insert Data in Table Using Query in MS SQL SERVER6:18
In This Lecture you will learn how to insert new data using "Insert" Query and using GUI Mode.
1. Where do you find Table content in SQL Server Manager
2. How to understand what column has which kind of data type
3. construct insert query using query syntax and data type format
4. write data and how to run query
5. insert data using UI mode

How to Update Data in Table Using Query in MS SQL SERVER4:44
In this lecture you will learn how to update data from SQL Table in MY SQL Server 2014
1. Connect Database and Table
2. Construct "Update" query for updating existing table data.
3. Execute query and update data
Updating data is major use in database, normally in database, Data retrieve information operation is usefull tool in Database administration, Project management, Data analysis and Data mining.
How to Delete Data From Table Using Query in MS SQL SERVER3:00
In this lecture you will learn how to delete data using "Delete" Query in SQL Server

Requirements

basic knowladge of Database
able to operating computer
basic knowledge of database query

Description

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

General knowledge of what a Database is.
Different versions of SQL Server 2014
How to install SQL Server Express 2014
Create a database in SQL Server
Create tables in SQL Server
Add data into tables in SQL Server
Set foreign key relationships between tables
Delete data from tables
Update data in tables.
backup and restore database

Who this course is for:

database administrator
beginner in software development
IT Student and Begainner Programmer
web developer begainner