Skedmia

Microsoft SQL for Beginners

30

Exam questions

70%

Pass mark

QR-verifiable Certificate of Training

Self-paced online, start today

About this course

Introduction: 

The Microsoft SQL for Beginners course is an introductory-level course designed to teach the basics of SQL and relational databases using Microsoft SQL Server. The course covers essential topics such as database design and normalization, SQL syntax and commands, querying and manipulating data, joins and relationships, and data analysis and reporting.

Through a combination of lectures, hands-on exercises, and quizzes, learners will gain a solid understanding of SQL fundamentals and the ability to create and manage databases using Microsoft SQL Server. The course is ideal for individuals who are new to SQL and relational databases or want to enhance their skills in working with SQL Server.

By the end of the course, learners will have the knowledge and skills needed to write basic SQL queries, create and manage databases, and perform data analysis and reporting using Microsoft SQL Server.

 

Objectives: 

  1. Understanding basic database concepts: The course may cover basic concepts such as what a database is, how data is organized in tables, what SQL is, and how it  is  used   to interact with a database.
  2. Learning SQL syntax and commands: The course may teach the syntax and commands used to create, retrieve, update, and delete data from a database using SQL.
  3. Understanding database design and normalization: The course may cover the principles of database design and normalization, which are essential for creating efficient,   scalable, and maintainable databases.
  4. Learning to use Microsoft SQL Server: The course may provide an introduction to Microsoft SQL Server, which is a popular relational database management system  (RDBMS) used in many organizations. Learners may learn to install, configure, and use SQL Server for creating and managing databases.
  5. Querying and manipulating data: The course may teach learners how to write SQL queries to extract, filter, sort, and aggregate data from a database. Learners may also learn to use SQL to insert, update, and delete data from a database.
  6. Understanding joins and relationships: The course may cover the concepts of joins and relationships, which are used to link tables in a database and retrieve data from multiple tables simultaneously.
  7. Analyzing and reporting data: The course may teach learners how to use SQL to perform data analysis and generate reports from a database. Learners may also learn to use tools such as SQL Server Management Studio to visualize data and create reports.

 

Course Outlines:

  1. How to Download and Install SQL Server Express
  2. How to install Adventure Works database on SQL Azure
  3. Introduction to T-SQL and Database Concepts
  4. Literal SELECT Statements - Part 1
  5. Literal SELECT Statements - Part 2
  6. Basic SELECT Statements - Part 1
  7. Basic SELECT Statements - Part 2
  8. Basic SELECT Statements - Part 3
  9. Using the WHERE Clause - Part 1
  10. Using the WHERE Clause - Part 2
  11. Using the WHERE Clause - Part 3
  12. Using the WHERE Clause - Part 4
  13. Sorting with the ORDER BY Clause - Part 1
  14. Sorting with the ORDER BY Clause - Part
  15. Using the INNER JOIN - Part 1
  16. Using the INNER JOIN - Part 2
  17. Using the LEFT OUTER JOIN - Part 1
  18. Using the LEFT OUTER JOIN - Part 2
  19. Using the LEFT OUTER JOIN - Part 3
  20. Aggregate Functions - Part 1
  21. Aggregate Functions - Part 2
  22. Grouping with the GROUP BY Clause - Part 1
  23. Grouping with the GROUP BY Clause - Part 2
  24. Filtering Groups with the HAVING Clause - Part 1
  25. Filtering Groups with the HAVING Clause - Part 2

 

Who should attend?

 

  1. Anyone who is interested in learning the basics of SQL and relational databases
  2. Individuals who are looking to start a career in data analytics, business intelligence, or database development
  3. Professionals who work with data and want to enhance their skills in working with databases
  4. IT professionals who are responsible for managing and maintaining databases using Microsoft SQL Server
  5. Individuals who want to learn SQL for personal or academic purposes
  6. Students who are pursuing a degree in computer science or a related field and want to learn SQL as part of their curriculum.

 

Learning Outcomes:

 

  1. Understanding basic database concepts: The course may cover basic concepts such as what a database is, how data is organized in tables, what SQL is, and how it is used to interact with a database.
  2. Learning SQL syntax and commands: The course may teach the syntax and commands used to create, retrieve, update, and delete data from a database using SQL.
  3. Understanding database design and normalization: The course may cover the principles of database design and normalization, which are essential for creating efficient, scalable, and maintainable databases.
  4. Learning to use Microsoft SQL Server: The course may provide an introduction to Microsoft SQL Server, which is a popular relational database management system (RDBMS) used in many organizations. Learners may learn to install, configure, and use SQL Server for creating and managing databases.
  5. Querying and manipulating data: The course may teach learners how to write SQL queries to extract, filter, sort, and aggregate data from a database. Learners may also learn to use SQL to insert, update, and delete data from a database.
  6. Understanding joins and relationships: The course may cover the concepts of joins and relationships, which are used to link tables in a database and retrieve data from multiple tables simultaneously.
  7. Analyzing and reporting data: The course may teach learners how to use SQL to perform data analysis and generate reports from a database. Learners may also learn to use tools such as SQL Server Management Studio to visualize data and create reports.

 

End of Course

After completion of the course students must undertake the exam. Once the exam is passed, it is considered as end of the course.

 

Format
Self-paced online — the lessons open as soon as you enrol
Assessment
Final Exam: 30 questions, 70% pass mark, 45 minutes
Exam attempts
5
Certificate
Skedmia Certificate of Training, valid for 1 year and verifiable at skedmia.com/verify
Access
Lifetime access with a one-time payment

Course content

Final Exam30 questions · pass mark 70% · 45 min
CertificateOF TRAINING

What you earn

A certificate anyone can verify in seconds

Score 70% or better on the final exam and Skedmia issues your Certificate of Training with a unique certificate number. Every certificate carries a QR code that resolves to our public register, so an employer or auditor can confirm it is genuine without contacting anyone. Certificates state a validity of 1 year from issue and can be renewed.

Verified at skedmia.com/verify

Certified byExemplar Global

Before you enrol

How is the course delivered?

Entirely online and self-paced. Once you enrol, the lessons open immediately in your Skedmia account on any device, and you can stop and resume whenever you like.

How do I earn the certificate?

Complete the lessons, then sit the 30-question final exam. Score 70% or more and your Certificate of Training is issued straight away with a unique certificate number and QR code. The PDF downloads from your account.

What happens if I don't pass?

You have 5 attempts at the exam. Review the lessons between attempts; each one is marked immediately.

How does an employer verify my certificate?

Every certificate carries a QR code and a certificate number. Scanning the code, or entering the number on our verification page, returns the holder’s name, the course and the issue date. No account is needed.

How can I pay?

By card through our secure Stripe checkout, with access opening instantly. Or by bank transfer: we show our account details and an order reference, you send the receipt, and the course opens once the payment is verified.

Can I enrol a team?

Yes. Organisations enrol staff as a cohort, follow progress on a manager dashboard and receive completion reports formatted for an audit file. See corporate training or send an enquiry.

For organisations

Training a whole team on this course?

Enrol staff as a cohort, follow progress from one dashboard and receive completion reports ready for your audit file.