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), SQL Programming, database backup and restoring.
This course will prepare you for the Microsoft Technology Associate (MTA) certification exam. It also leads to our SSIS, SSRS and SSAS courses.
- 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
20% DISCOUNT OFFER!
The regular price of this course is £390 including VAT. You’ll get 20% OFF on the regular price for a limited time by using the promo code: HOTC195
With the promo code you’ll pay £312 including VAT.
How to find course details & Enrol?
Please click VISIT WEBSITE button at the top of this page to view full course outline, dates, time and for enrolment.
Outcome / Qualification etc.
Get Inspired! Watch the Video
Your London Academy of IT experience begins on the way there - check out the shortest route from the Underground to the classroom.
Study at London Academy of IT - Open courses in Programming, Web design, CMS
London Academy of IT provide professional IT training courses focused on programming, web design and content management systems at all levels. Their open courses are highly practical, including guided applications and tailored details to suit everyone's IT background and level...
Find out more about this Database Design with Microsoft SQL Server course - simply fill out your details:
There are no reviews available yet.
Are you curious about the L&D strategies of some of the U.K.'s top companies?
Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!