Database Design with Microsoft SQL Server Training Course in Newham

London Academy of IT 

Posting for 5+ years

Newham

Ad ID: 35577527

Ended

Description:

Course Price: £325 excl. VAT (£390 incl. VAT)
Discounted Price with promo code: £260 excl. VAT (£312 incl. VAT)
Total Duration: 15 Hours
Course level: Beginner
Delivery Method: Instructor Led Classroom Training
Certification: Certificate of Completion will be provided after completing the course

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.

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.

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
- Database Normalisation
- Understanding Indexes
- Migrating, Importing and Exporting
- Database security
- Backing Up and Restoring


Skills Required:
--------------------
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.

If you do not have basic computer and Internet skills then we highly recommend you to attend our Computer Basics for Absolute Beginners course before attending this course.

Training Venue:
--------------------

Getting to London Academy of IT is easy. We are situated at Stratford which is a transport hub and has excellent rail, Tube and bus links.


Address of the Training Venue:
----------------------------------------
London Academy of IT
Boardman House
64 Broadway
Stratford
London E15 1NT


Further Information:
---------------------------
Please give us a call on 0208 432 6218, apply to this ad or visit our website at www.londonacademyofit.co.uk for more information.