CPD-accredited courses from £39 · Instant e-certificates · 2,700+ courses
CPD-accredited certificates 020 4618 6402 Team training
Home / Courses / Data Science and Machine Learning / SQL Server: Basic Microsoft SQL Server
CPD course All Levels

SQL Server: Basic Microsoft SQL Server

4 enrolled 3h 52m of learning Updated Nov 2026
CertificateOn completion
3h 52mSelf-paced
36 lessonsOn the UISC learning portal
All LevelsNo prior training needed

Course curriculum

1 modules 36 lessons 3h 52m total
01 SQL Server: Basic Microsoft SQL Server 36 lessons
  1. Course and Instructor Introduction
  2. Pre-requisites & Different Editions of SQL Server
  3. Downloading Express Edition & sample database
  4. Installing the downloads & Configuration
  5. The sa Login
  6. Wrap up – what we went over!
  7. What is RDBMS?
  8. Where does SQL Server fit in?
  9. Basic database objects
  10. Different Files that got installed – MDF & LDF
  11. Getting started with SSMS
  12. Getting around Object Explorer
  13. Query Window
  14. Pre-built DB – system database
  15. Bare Minimum: SELECTING a literal
  16. Retrieving / querying data from a table – using FROM clause
  17. Playing with Column Names
  18. Rearranging columns to your liking
  19. Narrowing down and ordering result set – WHERE and ORDER clause
  20. Narrowing down result set – BETWEEN / NOT BETWEEN
  21. Narrowing down result set – IN and NOT IN operator
  22. Narrowing down result set – Pattern Matching: LIKE and Wildcards
  23. Dealing with nothing: NULL
  24. Working with strings: Concatenation and other string functions
  25. Working with dates: Date Functions
  26. Some System Functions
  27. Joining multiple tables – INNER JOIN
  28. Join types – OUTER JOIN – LEFT / RIGHT / FULL
  29. Join types – CROSS JOIN
  30. Holy UNION!
  31. Subqueries
  32. DISTINCT and ALL Predicates
  33. Aggregate Functions
  34. GROUP BY clause / HAVING clause
  35. WHERE and ORDER BY in aggregate queries
  36. Bonus_Section

About this course

Overview:

Welcome to our comprehensive online course, "SQL Server: Basic Microsoft SQL Server," designed to provide you with a solid foundation in utilizing Microsoft SQL Server for database management and querying. Throughout this course, you'll learn essential SQL Server concepts and techniques, empowering you to effectively interact with databases, write SQL queries, and perform basic database administration tasks. Our interactive modules ensure an engaging learning experience, with practical exercises and real-world examples to reinforce your understanding of SQL Server fundamentals.

  • Interactive video lectures by industry experts
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified first aid professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Main Course Features:

  • Introduction to Microsoft SQL Server and its architecture
  • Understanding SQL Server databases, tables, and relationships
  • Writing SQL queries to retrieve and manipulate data
  • Basic database administration tasks such as backup and restore
  • Hands-on exercises and quizzes for practical application
  • Guidance on best practices for SQL Server development and administration

Who Should Take This Course:

  • Beginners with little to no experience in SQL Server
  • Database administrators seeking to expand their skills to SQL Server
  • IT professionals interested in database management and querying

Learning Outcomes:

  • Understand the architecture and components of Microsoft SQL Server
  • Create and manage databases, tables, and relationships
  • Write SQL queries to retrieve and manipulate data
  • Perform basic database administration tasks such as backup and restore
  • Apply best practices for SQL Server development and administration
  • Troubleshoot common SQL Server issues
  • Interpret and analyze SQL Server query execution plans
  • Develop foundational skills for advanced SQL Server topics

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Your certificate

CPD certificate — download it when you finish

Issued the moment you complete the final module. Every certificate lists the course aims and objectives, anticipated learning outcomes, the quality-assurance process — the elements required for verifiable CPD. Non-registrants can use it as CQC training evidence and for appraisals.

Aims & objectives Learning outcomes Unique certificate number

Common questions

Where do I take the course?

On the UISC learning portal. "Enrol now" takes you to this course there, where you pay securely, get your login and study at your own pace. Your certificate is issued there when you finish.

When can I start?

Immediately. Access opens the moment your order is confirmed and you can learn from any device, in any order, as many times as you like.

How is the course assessed?

A short multiple-choice or scenario-based assessment at the end of the course with instant results. You can retake it as many times as you need at no extra cost.

Can I enrol my whole team?

Yes. Organisations can buy multiple places on one invoice and receive a training record for every learner. Contact us for team pricing.

Keep learning

Related courses

More in Data Science and Machine Learning
Machine Learning Basics
Save 86%
47 lessons
Data Science and Machine Learning 11h 17m

Machine Learning Basics

16 others bought this course in the last 24 hours! Machine Learning Basics teaches you everything on the topic thoroughly from scratch so you can achieve a prof...

4.9 (8) 5 enrolled
£39.00 £279.00
Enrol now
£39.00 3h 52m · All Levels
Enrol now