Microsoft SQL Server 2014 Database Administration

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.
Rating: 3.8 out of 5 (214 ratings)
7,242 students
Microsoft SQL Server 2014 Database Administration
Rating: 3.8 out of 5 (214 ratings)
7,243 students
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

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
Curriculum
6 sections • 7 lectures • 46m total length
  • Introduction
  • Create, Alter and Drop Microsoft SQL Database
  • Create, Alter and Drop SQL Table
  • How to Add, Remove and Modify Columns in an Existing Table in MS SQL Server
  • How to Insert Data in Table Using Query in MS SQL SERVER
  • How to Update Data in Table Using Query in MS SQL SERVER
  • How to Delete Data From Table Using Query in MS SQL SERVER

Instructor
Web Developer and CEO at ValsadMarket
Tarang B. Patel
  • 3.8 Instructor Rating
  • 332 Reviews
  • 12,836 Students
  • 2 Courses

Hi, I am tarang patel from india, I am entered Programming world in 2010 when I completed Computer Engineering. Since then I am App and Web developer. In 2015 I founded my first IT Company named "BlueOcenIndia". Now Today I have "BlueOceanIndia", "AnyStudy" and "ValsadMarket". Currently I work on Android App Development, Website Design, Graphic Design and Web Development. Soon i started .Net MVC and iOS. I have Total 9 experience as Trainer and Developer.