Add to basket

Course:

Short Course - SQL 2: Database Definition Language

Category:

Computer Science and Digital

Duration:

6 WEEKS

Start Date:

7th Feb 2018

Location:

Learning Exchange

Tuition Fee:

£150.00

Exam Fee:

£0.00

Total Fees:

£150.00

Course Day:

Wednesday

Hours/week:

2

Weeks/yr:

6

Student Ratings

There are currently no reviews for this course, be the first!

Related Courses

Fashion - Pattern Cutting Fashion - Bra Making Short Course - SQL 5: Advanced Queries Short Course - SQL 4: Query Optimisation Junior Coding with Minecraft Short Course - SQL 3: Programmable Objects Junior Games Design - Unreal Engine 4 Fashion - Millinery Fashion - Pattern Cutting Intermediate Art & Design - Pottery

Short Course - SQL 2:

Database Definition Language

Description

This short course covers database creation using Data Definition Language (DDL) statements using Microsoft T-SQL 2012.

 

  • DML Statements : INSERT UPDATE DELETE

  • Understanding Datatypes

  • Creating and Maintaining Tables with DDL

  • Primary Key and Foreign Key Constraints

  • NULL and Unique Constraints

  • Views

  • Triggers

  • Importing and Exporting Data

  • Understanding INFORMATION_SCHEMA

 This course also constitutes part 2 of 5 of the preparation for the Microsoft Certification - Querying Microsoft SQL Server 2012 (Exam 70-461).

 

 

...More

Course Images

Course Location

Student Reviews

Add Review

There are currently no reviews for this course, be the first!

Add a Review

Rating:

Add Review

Courses Selected

Course Bundle Lookup

Course bundles are designed for 16 - 18 year olds only.

Career Coach is designed to help you find a good career by providing the most current local data on wages, employment, job postings, and associated education and training.