Skip to content
Microsoft SQL Server for Beginners cover image
Play overlay
Preview this course

Microsoft SQL Server for Beginners
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
11.2 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed Courses Certificate of Completion - Free
  • Uplatz Certificate of Completion - Free

Overview

Uplatz offers comprehensive training on Introduction to Microsoft SQL Server for Beginners. This is online video-based training course. You will be awarded Course Completion Certificate at the end of the course.

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. Its primary function is to store and retrieve data as requested by other software applications. It is available in several editions:

  • Enterprise: The most comprehensive edition, designed for large-scale, mission-critical applications.
  • Standard: A good choice for most organizations, including the core database engine and many add-on services.
  • Express: A free, scaled-down edition ideal for small businesses and individual developers.
  • Developer: A free edition for developers to use for development and testing purposes.

SQL Server uses T-SQL (Transact-SQL) as its primary query language, which extends standard SQL with additional features. It also includes various tools and services, such as:

  • SQL Server Management Studio (SSMS): A graphical user interface (GUI) tool used to manage SQL Server instances and databases.
  • SQL Server Integration Services (SSIS): A tool used for extracting, transforming, and loading (ETL) data.
  • SQL Server Analysis Services (SSAS): A tool used to create and manage online analytical processing (OLAP) cubes.
  • SQL Server Reporting Services (SSRS): A tool used to create and manage reports.

Microsoft SQL Server is a powerful and versatile RDBMS suitable for a wide range of applications. It's a popular choice for businesses of all sizes and individual developers.

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Uplatz Certificate of Completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Curriculum

1
section
26
lectures
11h 13m
total

    • 1: Introduction to SQL 20:25
    • 2: Introduction to SQL Server - part 1 21:45
    • 3: Introduction to SQL Server - part 2 24:44
    • 4: SQL Constraints 07:52
    • 5: SQL Server Data Types 25:38
    • 6: DDL and DML Commands in SQL - part 1 02:59
    • 7: DDL and DML Commands in SQL - part 2 11:14
    • 8: Normalization in SQL 05:31
    • 9: Introduction to MSBI 28:15
    • 10: Error Handling in SQL Server 24:47
    • 11: Find Recent Record in SQL - part 1 19:04
    • 12: Find Recent Record in SQL - part 2 12:39
    • 13: Stored Procedures 1:31:22
    • 14: One-to-One Relationships in SQL Server 18:01
    • 15: One-to-Many Relationships in SQL Server 30:51
    • 16: Many-to-Many Relationships in SQL Server 31:56
    • 17: Operators in SQL Server Preview 38:32
    • 18: System Databases 08:27
    • 19: Library Stored Procedure - part 1 56:15
    • 20: Library Stored Procedure - part 2 35:06
    • 21: Stored Procedure Example - part 1 56:46
    • 22: Stored Procedure Example - part 2 55:53
    • 23: Using Aggregate Task 26:43
    • 24: Microsoft SQL Server Booklet 07:00
    • 25: Glossary of Microsoft SQL Server Terms 06:00
    • 26: Microsoft SQL Server Interview Questions 05:00

Course media

Description

Microsoft SQL Server for Beginners - Course Syllabus

  1. Introduction to SQL
  2. Introduction to SQL Server - part 1
  3. Introduction to SQL Server - part 2
  4. SQL Constraints
  5. SQL Server Data Types
  6. DDL and DML Commands in SQL - part 1
  7. DDL and DML Commands in SQL - part 2
  8. Normalization in SQL
  9. Introduction to MSBI
  10. Error Handling in SQL Server
  11. Find Recent Record in SQL - part 1
  12. Find Recent Record in SQL - part 2
  13. Stored Procedures
  14. One-to-One Relationships in SQL Server
  15. One-to-Many Relationships in SQL Server
  16. Many-to-Many Relationships in SQL Server
  17. Operators in SQL Server
  18. System Databases
  19. Library Stored Procedure - part 1
  20. Library Stored Procedure - part 2
  21. Stored Procedure Example - part 1
  22. Stored Procedure Example - part 2
  23. Using Aggregate Task

Who is this course for?

  1. Aspiring Data Professionals: Individuals who want to start a career in data analysis, database administration, or data engineering.

  2. Students: Those studying computer science, information technology, or related fields who want to learn database management.

  3. Beginners with No Prior Experience: People who are new to databases and want to learn SQL Server from scratch.

  4. Professionals Transitioning to Tech Roles: Non-technical professionals (e.g., business analysts, marketers) who need to work with databases as part of their job.

  5. Developers: Programmers who want to expand their skill set to include database management and SQL querying.

  6. Small Business Owners or Entrepreneurs: Those who want to manage their own data and understand how databases work.

  7. IT Support Staff: Individuals who need to troubleshoot or manage databases as part of their role.

  8. Hobbyists or Enthusiasts: Anyone interested in learning about databases for personal projects or curiosity.

Requirements

Passion and determination to make it big!

Career path

  • SQL Developer
  • Database Administrator (DBA)
  • Data Analyst
  • Data Engineer
  • Data Scientist
  • Business Intelligence (BI) Developer
  • Data Warehouse Developer
  • ETL Developer
  • Data Architect
  • Database Developer
  • BI Analyst
  • Systems Analyst
  • Data Visualization Developer
  • Database Consultant
  • Application Developer
  • Reporting Analyst
  • Solutions Architect
  • Data Consultant
  • Marketing Analyst
  • Financial Analyst
  • Software Engineer

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

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, MySQL, SQL, IT, Coding
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.