Skip to content
  1. Online
  2. IT
  3. Database
SQL Programming with Microsoft SQL Server cover image
Play overlay
Preview this course

SQL Programming with Microsoft SQL Server
Uplatz

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate

Summary

Price
£100 inc VAT
Or £33.33/mo. for 3 months...
Study method
Online, On Demand 
Duration
55 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
  • Uplatz Certificate of Completion - Free

Overview

Uplatz offers complete course on SQL Programming with Microsoft SQL Server. This is video-based online course (self-paced training). You will be awarded Course Completion Certificate at the end of the course.

SQL Programming with Microsoft SQL Server involves working with the Microsoft SQL Server database management system using the SQL language. Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft, and it is widely used for managing and querying relational databases.

Here's a description of SQL Programming with Microsoft SQL Server:

  1. Database Management

    • SQL Server enables users to create, modify, and manage relational databases. It provides tools for creating and maintaining database structures, including tables, indexes, views, and stored procedures.

  2. Transact-SQL (T-SQL)

    • Microsoft SQL Server uses Transact-SQL (T-SQL), an extension of SQL, as its programming language. T-SQL includes additional features such as procedural programming constructs, local variables, and error handling, making it a powerful language for database programming.

  3. Stored Procedures and Functions

    • SQL Server supports the creation of stored procedures and user-defined functions. These database objects allow developers to encapsulate SQL logic on the server, improving code reusability, security, and performance.

  4. Triggers

    • Triggers in SQL Server are special types of stored procedures that automatically execute in response to certain events, such as data modifications. Triggers are useful for enforcing business rules and maintaining data integrity.

  5. Views

    • Views provide a way to present a subset of data from one or more tables in a structured manner. They can simplify complex queries and restrict access to sensitive information.

  6. Indexing and Query Optimization

    • SQL Server includes features for optimizing query performance, such as the ability to create indexes on tables. Proper indexing can significantly enhance the speed of data retrieval.

  7. Security Features [this topic is not in scope of this course]

    • SQL Server provides robust security features, including user authentication, role-based access control, and encryption. Database administrators can define permissions at various levels to control access to data and database objects.

  8. Integration Services (SSIS) [this topic is not in scope of this course]

    • SQL Server Integration Services (SSIS) is a part of the SQL Server suite that enables the creation of data integration and workflow solutions. It is used for tasks such as ETL (Extract, Transform, Load) processes.

  9. Reporting and Analysis Services (SSRS and SSAS) [this topic is not in scope of this course]

    • SQL Server Reporting Services (SSRS) allows the creation, management, and delivery of reports, while SQL Server Analysis Services (SSAS) provides online analytical processing (OLAP) and data mining functionality.

  10. Database Maintenance and Monitoring [this topic is not in scope of this course]

    • SQL Server offers tools for database administrators to perform routine maintenance tasks, monitor performance, and troubleshoot issues. This includes features like SQL Server Management Studio (SSMS) and dynamic management views.

SQL Programming with Microsoft SQL Server involves leveraging these features and tools to design, implement, and maintain database solutions that meet the needs of applications and businesses. It is an essential skill for developers, database administrators, and other professionals working with SQL Server databases.

Certificates

Curriculum

1
section
63
lectures
55h 3m
total

    • 1: Part 1 - Introduction to MS SQL Server 1:10:58
    • 2: Part 2 - Introduction to MS SQL Server 18:18
    • 3: Part 3 - Introduction to MS SQL Server 52:34
    • 4: Part 1 - Select and Where 56:53
    • 5: Part 2 - Select and Where 04:45
    • 6: Part 3 - Select and Where 1:04:46
    • 7: Part 1 - SQL Sub Languages - Order By Clauses 1:05:10
    • 8: Part 2 - SQL Sub Languages - Order By Clauses 1:00:17
    • 9: Part 1 - Any - All - Select Into - Insert Into - Case 1:02:19
    • 10: Part 2 - Any - All - Select Into - Insert Into - Case 1:02:33
    • 11: Part 1 - Delete - Top - Aggregate Functions - Wild Cards 53:32
    • 12: Part 2 - Delete - Top - Aggregate Functions - Wild Cards Preview 1:02:23
    • 13: Part 1 - Insert - Update - Is Null Commands 1:08:20
    • 14: Part 2 - Insert - Update - Is Null Commands 29:10
    • 15: Part 3 - Insert - Update - Is Null Commands 42:03
    • 16: Part 1 - In - Between - Table Alias 45:02
    • 17: Part 2 - In - Between - Table Alias 45:47
    • 18: Part 1 - SQL Comments - SQL Operators 34:34
    • 19: Part 2 - SQL Comments - SQL Operators 51:22
    • 20: Part 1 - Joins Preview 1:04:02
    • 21: Part 2 - Joins Preview 1:03:10
    • 22: Part 1 - Union All - Union - Group By - Having - Exists - Not Exists 1:02:02
    • 23: Part 2 - Union All - Union - Group By - Having - Exists - Not Exists 1:08:16
    • 24: Part 1 - Null Functions - Transact SQL 1:02:03
    • 25: Part 2 - Null Functions - Transact SQL 1:08:15
    • 26: Part 1 - Examples - If - Conditional Statements 1:02:26
    • 27: Part 2 - Examples - If - Conditional Statements 1:08:05
    • 28: Part 1 - Goto Statement - Looping Construct 1:06:06
    • 29: Part 2 - Goto Statement - Looping Construct 1:02:01
    • 30: Part 1 - Sub Programs - Stored Procedures 1:07:59
    • 31: Part 2 - Sub Programs - Stored Procedures 56:16
    • 32: Part 1 - Stored Procedure Examples 1:01:16
    • 33: Part 2 - Stored Procedure Examples 1:08:02
    • 34: Part 1 - Modifying and Dropping a Stored Procedure 58:48
    • 35: Part 2 - Modifying and Dropping a Stored Procedure 1:01:42
    • 36: Part 1 - Dynamic Queries - Procedure Returning Values - Functions 51:21
    • 37: Part 2 - Dynamic Queries - Procedure Returning Values - Functions 1:16:36
    • 38: Part 1 - Break - Continue - Exception Handling 56:58
    • 39: Part 2 - Break - Continue - Exception Handling 1:06:52
    • 40: Part 1 - Structured Exception Handling 48:48
    • 41: Part 2 - Structured Exception Handling 1:01:48
    • 42: Part 1 - Multiple and Nested Try Catch Blocks 52:56
    • 43: Part 2 - Multiple and Nested Try Catch Blocks 1:05:03
    • 44: Part 1 - Using Anonymous Block - Table Valued Functions 1:05:10
    • 45: Part 2 - Using Anonymous Block - Table Valued Functions 1:01:07
    • 46: Part 1 - Backup DB - Differential Example - DDL Statements 46:28
    • 47: Part 2 - Backup DB - Differential Example - DDL Statements 1:03:37
    • 48: Part 1 - User Defined DB - Creating DB with GUI - Query - Commands 48:29
    • 49: Part 2 - User Defined DB - Creating DB with GUI - Query - Commands 1:11:56
    • 50: Part 1 - Database Constraints and Domain Integrity Constraints 35:28
    • 51: Part 2 - Database Constraints and Domain Integrity Constraints 41:09
    • 52: Part 1 - Primary Key and Composite Key 47:01
    • 53: Part 2 - Primary Key and Composite Key 37:48
    • 54: Part 1 - Creating 1-to-1 Relationship - Indexes 31:56
    • 55: Part 2 - Creating 1-to-1 Relationship - Indexes 50:09
    • 56: Part 1 - Views and Types of Views 1:09:05
    • 57: Part 2 - Views and Types of Views 1:22:05
    • 58: Part 1 - Auto Increment - SQL Date Operations 26:34
    • 59: Part 2 - Auto Increment - SQL Date Operations 29:15
    • 60: 29 - Hosting 25:17
    • 61: Microsoft SQL Server Booklet 07:00
    • 62: Glossary of Microsoft SQL Server Terms 06:00
    • 63: Microsoft SQL Server Interview Questions 05:00

Course media

Description

SQL Programming with Microsoft SQL Server - Course Syllabus

  1. Introduction to Microsoft SQL Server
  2. Select and Where
  3. SQL Sub Languages - Order By Clauses
  4. Any - All - Select Into - Insert Into - Case
  5. Delete - Top - Aggregate Functions - Wild Cards
  6. Insert - Update - Is Null Commands
  7. In - Between - Table Alias
  8. SQL Comments - SQL Operators
  9. Joins
  10. Union All - Union - Group By - Having - Exists - Not Exists
  11. Null Functions - Transact SQL
  12. Examples - If - Conditional Statements
  13. Goto Statement - Looping Construct
  14. Sub Programs - Stored Procedures
  15. Stored Procedure Examples
  16. Modifying and Dropping a Stored Procedure
  17. Dynamic Queries - Procedure Returning Values - Functions
  18. Break - Continue - Exception Handling
  19. Structured Exception Handling
  20. Multiple and Nested Try Catch Blocks
  21. Using Anonymous Block - Table Valued Functions
  22. Backup DB - Differential Example - DDL Statements
  23. User Defined DB - Creating DB with GUI - Query - Commands
  24. Database Constraints and Domain Integrity Constraints
  25. Primary Key and Composite Key
  26. Creating 1-to-1 Relationship - Indexes
  27. Views and Types of Views
  28. Auto Increment - SQL Date Operations
  29. Hosting

Who is this course for?

Anyone who wants to make a mark in this world!

Requirements

Passion and determination to achieve your goals!

Career path

  • SQL Server Developer
  • SQL Programmer
  • Database Engineer
  • Data Engineer
  • Data Analyst
  • Data Scientist
  • Machine Learning Engineer
  • SQL BI Developer
  • Reporting Analyst
  • Software Developer
  • Application Developer
  • Database Administrator
  • Data Architect
  • SQL Engineer
  • SQL Application Support Analyst
  • BI Specialist
  • SQL Analyst
  • Data Transformation Analyst
  • Data Modeler
  • Quantitative Engineer
  • Data Consultant
  • MS SQL DBA

Questions and answers

Reviews

1.8
Course rating
33%
Service
53%
Content
26%
Value

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Database, Coding, SQL, IT
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.