Mastering SQL Programming

Janets

Course

Online

£ 319 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

The Mastering SQL Programming aims teach you how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases.

This course describes the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statement. Learn how to use the Structured Query Language (SQL) to create, manipulate, and create reports from database tables. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Mastering SQL Programming is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

Upon successful completion of the course you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of 9.99 and PDF Certificate at 4.99.

Earn a free e-certificate upon successful completion.
Accessible, informative modules taught by expert instructors
Study in your own time, at your own pace, through your computer tablet or mobile device
Benefit from instant feedback through mock exams and multiple-choice assessments
Get 24/7 help or advice from our email and live chat teams
Full Tutor Support on Weekdays

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • XML training
  • XML
  • Server
  • Database
  • SQL
  • Database training
  • Programming
  • Creating
  • Indexed
  • Columns

Course programme

COURSE CURRICULUM

Beginner

Module: 01
  • Introduction
  • Tools for Creating Views
  • Examples
  • Updating Data Using a View
  • Columns and Indexed Views
Module: 02
  • Introduction Stored Procedures
  • Creating Stored Procedures
  • Returning Data
Module: 03
  • Testing and Debugging
  • Execute with Result Sets
  • Creating Triggers
Module: 04
  • Overview and Scalar Functions
  • Inline Table Valued Functions
  • Multi Statement
  • Views and Stored Procedures
Module: 05
  • Transaction Concepts
  • Applications and Transactions
  • Creating Explicit Transactions
  • Structured Error Handling
Module: 06
  • Introduction to SQL CLR
  • Writing SQL CLR Code
  • Using SQL CLR Code
  • SQL CLR Code
  • SQL CLR Security
Intermediate

Module: 01
  • Topic A Aggregates
  • Topic B User Defined Types
  • Topic C Table and Functions
  • Topic D Managing Code Modules
Module: 02
  • Topic A Introduction Data Tools
  • Topic B Connected Database Development
  • Topic C Updating a Connected Database
Module: 03
  • Topic A Creating New Objects with TSQL
  • Topic B Comparing Database Schemas
  • Topic C Offline Database Development
  • Topic D Database Project Settings
Module: 04
  • Topic A Using APPLY
  • Topic B MERGE Statement
  • Topic C Creating Recursive Queries
  • Topic D Grouping Sets
Module: 05
  • Topic A ROLLUP and CUBE Operators
  • Topic B Creating Pivot Queries
  • Topic C Executing Dynamic SQL
Module: 06
  • Topic A Complex Query Execution
  • Topic B Using Execution Plans
  • Topic C Execution Plan Operators
  • Topic D Common Join Operators
Module: 07
  • Topic A Hierarchy ID Data Type
  • Topic B Exploring a Hierarchy
  • Topic C Sparse Columns
  • Topic D Column Sets
Module: 08
  • Topic A Filtered Indexes
  • Topic B FILESTREAM Storage
  • Topic C Adding Sequences to Queries
Module: 09
  • Topic A Introduction to Spatial Data
  • Topic B Spatial Data in SQL Server
  • Topic C Manipulating Spatial Shapes
  • Topic D Interactions Between Objects
Advanced

Module: 01
  • Topic A Partitioning
  • Topic B Creating Partition Tables
  • Topic C Querying Partitions
  • Topic D Managing Partitions
Module: 02
  • Topic A Complex Querying
  • Topic B Rankings
  • Topic C SubQueries
  • Topic D Common Table Expressions
Module: 03
  • Topic A Complex Data and Structures
  • Topic B Efficient Queries
  • Topic C Complex Queries
Module: 04
  • Topic A XML Data Type
  • Topic B XML Schemas
  • Topic C Querying XML
  • Topic D Best Practices
Mock Exam
  • Mock Exam – Mastering SQL Programming
Final Exam
  • Final Exam – Mastering SQL Programming

See related categories

Mastering SQL Programming

£ 319 VAT inc.

The best SQL Server courses

See all

See all