SQL Server Development

What topics are covered by the course?

Section 01 Introduction to SQL Server 2005

Module 01: SQL Server Overview
Module 02: Using Management Studio
Module 03: Designing Relational Databases

Section 02 Selecting Data

Module 01: Working with Single Table Queries
Module 02: Merging Data with Joins & Unions
Module 03: Working with Subqueries
Module 04: Aggregating Data
Module 05: Using Full-Text Search
Module 06: Selecting Data through Views
Module 07: Distributed Queries
Module 08: Modifying Data

Section 03 Developing Solutions

Module 01: T-SQL Stored Procedures
Module 02: Triggers & Audit Trails
Module 03: User-Defined Functions
Module 04: Indexing for Performance
Module 05: Transactions, Locking & Blocking
Module 06: Introducing to Optimization Theory

Who should attend?

These intensive online courses are open to everyone, as long as you have an interest in the topic!

What will I be able to do on completion?

You will acquire skills listed under the curriculum.

How will I be assessed?

You will have one assignment. Pass mark is 65%.
You will only need to pay 19 for assessment.
You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

What are the requirements?
You must be 16 or over
You should have a basic understanding of English, Maths and ICT
You will need a computer or tablet with internet connection (or access to one)

What careers can I get with this qualification?
This excellent SQL Server Development course will qualify you to be a Backend Developer. As a Backend Developer you could work for an existing organisation, or could work on a freelance basis. The average salary of a Backend Developer in the UK is 24,885, and this will go up with experience (payscale.com). With this course you could fulfil any of the following roles:

Database Development
Database Engineering
Database Manager
Backend Developer
Data Analyst
Data Scientist

Guide Price: 19

Delivery: Online
Category: IT & Computer »
Duration: 365
Qualification: Certificate in SQL Server Development

Search for it & computer courses in