Welcome

Labore et dolore magna aliqua. Ut enim ad minim veniam

Select Your Favourite
Category And Start Learning.

( 0 Review )

Featured

Database Design with Microsoft SQL Server

Free

( 0 Review )

Course Level

Beginner

Total Hour

08h

Video Tutorials

10

Free
Placeholder

Course content

10 Lessons08h

Database Concepts and Introduction of MS SQL Server

Database and DBMS
Editions of MS SQL Server
Downloading and Installing Microsoft SQL Server

Planning and Creating Databases

Constraints and Data Integrity

Description

Course Overview:

This course is designed for beginners who wish to design and implement database with Microsoft SQL Server. It is a classroom based course that covers relational database fundamentals, database design, Structured Query Language (SQL) and database administration.

Following topics are included in this course:

  • Database Concepts and Introduction of MS SQL Server
  • Planning and Creating Databases
  • Constraints and Data Integrity
  • Structured Query Language (SQL) and T-SQL
  • Retrieving Data with SQL and T-SQL
  • Creating Views, Stored Procedures and UDF
  • T-SQL Programming
  • Migrating, Importing and Exporting
  • Backing Up and Restoring

What to learn?

This course will prepare you for the Microsoft Technology Associate (MTA) certification exam. It also leads to our Querying Data with SQL and T-SQL, SSIS and SSRS courses.

Requirements

  • No existing knowledge on Microsoft SQL Server is required. You should have basic computing knowledge. Familiarity with relational database concepts is helpful but not required.

Instructor

0 /5

2 Courses

Younus has over 15 years of experiences in working and teaching IT in both public and private organisations. His specialities include Web design, development, software development and project management. He graduated from London Metropolitan University in Computing and Information Systems. He
Free

Share

Select your currency
EUREuro