/
/
/
/

Database Design with Microsoft SQL Server

(4.7)3 reviews
Recent reviews of this course provider

LAIT Python Immersive review

I would definitely London Academy of IT's Python intensive program. I wanted to ...more

See all reviews
Add to shortlistShortlisted by 44 people

https://www.hotcourses.com/courses-by-subject/Database-Design-with-Microsoft-SQL-Server-courses/54374500/

Course description

Database Design with Microsoft SQL Server:

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), 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.

Course Outline

  • 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

Please click VISIT WEBSITE button at the top of this page to view full course outline and for enrolment.

Additional entry 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.

Course reference: 1003 (use this when contacting provider)

Course info
273 views
START DATES
NOVEMBER 2018
Sun Mon Tue Wed Thu Fri Sat
DECEMBER 2018
Sun Mon Tue Wed Thu Fri Sat

Location:

London, E15 1NT

Time:

10:00am - 1:45pm, 10:00am - 3:00pm, 1:15pm - 5:00pm + 3 more

Duration:

15 hours

Attendance:

Part-time

Qualification:

Certificate of Attendance

Level:

BeginnerIntermediateAdvanced

From: £280

Concessions:

Customised dependent on number of delegates/location

more

Other Microsoft Sql Server training courses

SQL Server Reporting Services (SSRS)

London Academy of IT

Duration: 10 hours

Intermediate

Certificate of Attendance

SQL Server Integration Services (SSIS) Training Course

London Academy of IT

Duration: 10 hours

Beginner

Certificate of Attendance

View 4 courses

Summary of all course reviews for London Academy of IT

3 reviews

(67%)
(33%)

Average student ranking

Reviews of other courses at London Academy of IT

london-academy-of-it

LAIT Python Immersive review
5 5
Hotcourses
by O - July 2018

I would definitely London Academy of IT's Python intensive program. I wanted to learn python as I have around 2.5 years experience programming in another language (Java) and I hoped to learn another language whilst following the correct programming practices for the language (which may not be taught online properly). Priyanka and Jayan definitely taught correct programming practices and gave a lot of exercises. They corrected me immediately when they saw me using programming practices specific to Java, in python. The class sizes were small, so these errors were picked up very quickly when they went around the class. This early correction prevented problems later on. The course went at a fast pace, so even though I had programming experience, I learnt a lot from the beginners course and I learnt even more when I enrolled onto the Intermediate course as part of the immersive package. If you are new to programming, this course may be a bit hard for you, but if you go over the activities in your own time and are determined, then this would not be a problem for you. The lecturers are very knowledgeable and solve bugs immediately. I would give LAIT 5*'s 🙂

Was this review helpful? Yes No
1 Hotcourses user(s) found the following review helpful.

Please note reviews of Python Development Immersive Package are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Database Design with Microsoft SQL Server by London Academy of IT on Hotcourses

Ask a question

Get course info