SQL 2: DML and DDL (February start)

Apply For SQL 2: DML and DDL (February start) ...

Course information

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

Qualifications

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

This course leads to...

Work in IT Industry

Entry Requirements

None


Apply Now »

Further Information...

Need more information or can’t find the course you’re looking for? We can book you in to speak with our dedicated Advice & Guidance team about your options at The City of Liverpool College. With hundreds of courses and flexible learning, we’re sure to have something to meet your needs.


You can contact us online via applications@liv-coll.ac.uk or call us at any point on 0151 252 3000 with any queries you may have – we’re here to help.
.


Overview

Course ID: 156526

Course Year: 18/19

Course Duration: 6 Weeks



Fees

This course is only available to learners aged 19 and over. Fees are payable by all students unless sponsored by an employer.


Apply Now »