By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.TechCourses
(
CourseName varchar(50) NOT NULL,
CourseCode varchar(20) NOT NULL,
StartDate datetime NOT NULL,
FirstName varchar(50) NOT NULL,
LastName varchar(50) NOT NULL,
StudentID int NOT NULL,
Membership varchar(20) NOT NULL)
ALTER TABLE TechCourses
ADD CONSTRAINT TechCourses_PK PRIMARY KEY (StudentID, CourseName);
DECLARE @xml xml = '<?xml version="1.0" encoding="utf-8"?>
<Root>
<Applicants>
<Applicant>
<CourseName>Data Analytics 101 - Beginner"</CourseName>
<CourseCode>DA101</CourseCode>
<StartDate>2022-08-01 08:00:00</StartDate>
<FirstName>Joe</FirstName>
<LastName>Stewart</LastName>
<StudentID>301</StudentID>
<Membership>Gold</Membership>
</Applicant>
<Applicant>
<CourseName>Data Analytics 101 - Beginner"</CourseName>
<CourseCode>DA101</CourseCode>
<StartDate>2022-08-01 08:00:00</StartDate>
<FirstName>Sandy</FirstName>
<LastName>Gomez</LastName>
<StudentID>302</StudentID>
<Membership>Bronze</Membership>
</Applicant>
<Applicant>
<CourseName>Data Analytics 101 - Beginner"</CourseName>
<CourseCode>DA101</CourseCode>
<StartDate>2022-08-01 08:00:00</StartDate>
<FirstName>Cindy</FirstName>
<LastName>Yarnov</LastName>
<StudentID>303</StudentID>
<Membership>Silver</Membership>
</Applicant>
<Applicant>
<CourseName>Data Analytics 101 - Beginner"</CourseName>
<CourseCode>DA101</CourseCode>
<StartDate>2022-08-01 08:00:00</StartDate>
<FirstName>Olek</FirstName>
<LastName>Kovalenko</LastName>
5 rows affected
select * from TechCourses
| CourseName | CourseCode | StartDate | FirstName | LastName | StudentID | Membership |
|---|---|---|---|---|---|---|
| Data Analytics 101 - Beginner" | DA101 | 2022-08-01 08:00:00.000 | Joe | Stewart | 301 | Gold |
| Data Analytics 101 - Beginner" | DA101 | 2022-08-01 08:00:00.000 | Sandy | Gomez | 302 | Bronze |
| Data Analytics 101 - Beginner" | DA101 | 2022-08-01 08:00:00.000 | Cindy | Yarnov | 303 | Silver |
| Data Analytics 101 - Beginner" | DA101 | 2022-08-01 08:00:00.000 | Olek | Kovalenko | 304 | Gold |
| Data Analytics 101 - Beginner" | DA101 | 2022-08-01 08:00:00.000 | Sergio | Lopez | 305 | Gold |