Query Data with SQL - A Level Computer Science 9618

preview_player
Показать описание
Discover how to write SQL scripts to query database tables using essential Data Manipulation Language (DML) commands like SELECT FROM, WHERE, ORDER BY, GROUP BY, SUM, COUNT, and AVG. This video tutorial also demonstrates how to use advanced commands like AND and LIKE in your WHERE clause for more precise data retrieval.

Whether you're a student preparing for the Cambridge International AS & A Level Computer Science 9618 Paper 1 exam on Chapter 8: Databases or a professional seeking to broaden your knowledge, this video is ideal for you.

🔥 EXAM RESOURCES
-----------------------------------------------

📹 SUBSCRIBE
------------------------------------------------

⏳ TIMESTAMPS
------------------------------------------------
00:00 Intro
00:04 What You Will Learn
00:11 DML Query Commands
01:03 How to Write a DML Query
01:31 WHERE
02:43 ORDER BY, COUNT, GROUP BY
04:54 AND
05:36 LIKE, SUM
06:47 AVG
07:25 Past Year Question

🎥 PAPER 1️⃣ PLAYLIST
------------------------------------------------

🎥 PAPER 2️⃣ PLAYLIST
------------------------------------------------

🌎 IMPORTANT LINKS
------------------------------------------------

#alevelcomputerscience
#SQLqueries
#DataManipulationLanguage
#DatabaseQuerying
#9618Paper1
  1. Haguin School
  2. dml in sql
  3. data manipulation language tutorial
  4. dml query example
  5. query data with sql
  6. computer science lecture
Рекомендации по теме
5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Query a SQL 0:05:04

Query a SQL database

Writing your first 0:04:13

Writing your first SQL queries in SQL Server

How I use 0:15:30

How I use SQL as a Data Analyst

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Learn SQL for 0:58:22

Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)

Hierarchical SQL Queries: 0:09:38

Hierarchical SQL Queries: Databases for Developers #16

Excelytics B00635 SQL 1:25:59

Excelytics B00635 SQL & Power BI Day 1 25-11-2024

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

Advanced SQL Tutorial 0:08:37

Advanced SQL Tutorial | Subqueries

How I use 0:00:38

How I use SQL as a data analyst

Learn how to 0:49:56

Learn how to write SQL Queries(Practice Complex SQL Queries)

Approach to Complex 0:08:33

Approach to Complex SQL Queries

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

SQL WITH Clause 0:24:48

SQL WITH Clause | How to write SQL Queries using WITH Clause | SQL CTE (Common Table Expression)

Querying 100 Billion 0:09:07

Querying 100 Billion Rows using SQL, 7 TB in a single table

How is data 0:07:04

How is data stored in sql database

Data Analyst SQL 0:00:36

Data Analyst SQL Question for Beginner

BEST Websites to 0:00:43

BEST Websites to Learn SQL FAST 🏃🏽‍♂️💨

Google Big Query 0:00:56

Google Big Query SQL Tips, Query Walkthrough with Union and Rank

SQL Databases with 0:16:59

SQL Databases with Pandas and Python - A Complete Guide

SQL Explained in 0:02:23

SQL Explained in 100 Seconds

Run SQL queries 0:07:13

Run SQL queries in EXCEL (just like a normal Excel formula 🤯)

Комментарии
Автор

For the last question:

SELECT Avg (Mark)
FROM STUDENT_TEST
WHERE TestID='A7';

nnwld
Автор

can you list all the keys with definations
eg: composite key
candidate keys
difference btw them?

MuhammadAhmed-ef
Автор

Hi! There was a question i got in a past paper in which it required some data to be added, correlating to a certain field into a database. May i receive some help with how i can go about it?

nnwld