IGCSE Computer Science 2023-25 ​​- Topic 9 DATABASES: Video 3 - SQL Structured Query Language

In this video we look at the uses of the different SQL Query Statements to extract information from a Flat File Database
#IGCSE #sql #databases #cambridge #computerscience
My channel primarily looks at the Computer Science across the Key Stages of the British and International Curriculum. I have also included a series of videos which cover each topic from the Syllabus for the 2023-2025 Cambridge IGCSE. There are also examples of how to best answers exam questions from both papers 1 and 2 of the iGCSE.
🤩 Thank you so much for your support... it means a lot! 😍
☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕
If you wish help out in keeping the caffeine flowing so that the channel keeps growing visit: buymeacoffee.c...
☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕ ☕
IGCSE Computer Science 2023-25 ​​- Topic 9 DATABASES: Video 3 - SQL Structured Query Language - • IGCSE Computer Science...
VIDEO to support Computer Science Syllabus
Cambridge IGCSE™ (9-1 0984) (A*-C 0478)
For exams in 2023, 2024 and 2025.
Cambridge IGCSE Computer Science helps learners develop an interest in computational thinking and an understanding of the principles of problem-solving using computers. They apply this understanding to create computer-based solutions to problems using algorithms and a high-level programming language. Learners also develop a range of technical skills, and the ability to effectively test and evaluate computing solutions.

[@justsbYT]

Rlly good video. SQL has been a pain for me for a year now and this video with examples is JUST what I needed
Super useful stuff ty mate!

[@Ziggerastika]

Thank you very much! Will we have to write any SQL from scratch, like with pseudocode?

[@mrbulmerslearningzone]

just the basics, very little about finding specific entries in a table.

[@Ziggerastika]

Thank you!@@mrbulmerslearningzone

[@germanos7204]

you have done a great job educating me please continue to do so with other future generations
💝

[@mrbulmerslearningzone]

Thank you for your kind words… 🤩

[@hddssd-s7m]

Very nicely taught ❤❤

[@aryansalman74]

hats off to you sir!🙏🏻

[@mrbulmerslearningzone]

Thank you for your kindness

[@khadijaimran1810]

Thanks sir it helped a lot

[@hiraali833]

Hello sir ur videos are amazing plz also make videos on exam style questions at the end of every chapter in computer science igcse book kindly

[@mrbulmerslearningzone]

Thank you for your kind words :-)

[@riyanroy2870]

thanks
!!

[@bhaikills2632]

This guy is great

[@schoolsteachers]

Dear sir , your videos are realy helpful. can u give me some Wave side address for practice

[@Kenziior]

Can you please do a video solving questions on it

[@NewSummers]

8:04 I just want to bring up that I believe you got the rows and fields mixed up. According to the IGCSE & O level book, you seem to have done the opposite regarding the fields and records..
Please do make sure of such information. I could be mistaken myself but after checking the confusion had passed

[@mrbulmerslearningzone]

CODE is a field (column)… the rows are Records. I don’t follow what you are saying

[@Assasin89FT]

hi! do u have any suggestions for which website we could use for topical past papers (for this chapter)?

[@mrbulmerslearningzone]

Search papacambridge…this is a great place for past papers

[@radinmoradi9903]

thanks

[@namanjangid-e4p]

Ty sir❤

[@CloudOnIOS]

Just a quick question, does the primary key count as a field or is it not counted? Like if I’m asked a question to fill a table with 7 fields and I do, but add a primary key at the start after it, would it count as 8 fields or 7?

[@likelystrategy9895]

Ay ay ay are you from my school I got a computer science exam tmrw as well bro

[@CloudOnIOS]

@@likelystrategy9895 Oooooo, you might be onto something, let’s start with our country, mine is Pakistan. Also, good luck for the exam.

[@Yu__h]

I'm from Pakistan too! :)

[@amnasuleman3047]

Same

[@Maseha-m2w]

Yes ofc the field counts you just highlight the field as the primary key and field does count.

[@idekanymore698]

Would you mind doing some questions on this (SQL)?

[@mrbulmerslearningzone]

Hi Harisi, just waiting for clarification from the exam board as to the exact requirements not that the syllabus has changed

[@idekanymore698]

@@mrbulmerslearningzone I have been watchin your channel to help me prepare for my CIES and they've been extremely helpful. Looking forward for another video!

[@mahnoorsufian1092]

sir are these lectures also regarding the 2210 syllabus of computer science??

[@mrbulmerslearningzone]

They are very similar yes 2021 and 2023

[@mahnoorsufian1092]

@@mrbulmerslearningzone ok thanks

[@mahnoorsufian1092]

I mean the o levels syllabus

[@mrbulmerslearningzone]

Yes they are

[@mahnoorsufian1092]

@@mrbulmerslearningzone ok thanks alot