Free online courseSQL Database Programming

Conteúdo do Curso

• Video class: Introduction | SQL | Tutorial 1

  0h02m

• Exercise: What is a primary purpose of a relational database management system (RDBMS)?

• Video class: What is a Database? | Let's Learn

  0h20m

• Exercise: What is a database management system (DBMS) and what is its primary purpose?

• Video class: Tables

  0h20m

• Exercise: In a relational database, which type of key is used to uniquely identify a row within a table and has no direct mapping to real-world data?

• Video class: SQL Basics | SQL | Tutorial 3

  0h09m

• Exercise: What is one of the primary roles of SQL in a relational database management system?

• Video class: MySQL Windows Installation | SQL | Tutorial 4

  0h09m

• Exercise: What is the main purpose of a MySQL database server?

• Video class: MySQL Mac Installation | SQL | Tutorial 5

  0h14m

• Exercise: What is MySQL primarily used for?

• Video class: Creating Tables - SQL - Tutorial 6

  0h15m

• Exercise: In SQL, which command is used to remove a table from the database?

• Video class: Inserting Data - SQL - Tutorial 7

  0h07m

• Exercise: What is the SQL command used to add a new row of data into an existing table called?

• Video class: Constraints - SQL - Tutorial 8

  0h10m

• Exercise: In SQL, which of the following constraints ensures that a column must have a value and that the value must be unique across all rows in the table?

• Video class: Update

  0h08m

• Exercise: What SQL statement would you use to remove specific rows from a database table based on a condition?

• Video class: Basic Queries | SQL | Tutorial 10

  0h12m

• Exercise: What would be the result of executing the following SQL command: SELECT name FROM student WHERE major = 'Computer Science' ORDER BY name DESC LIMIT 3?

• Video class: Company Database Intro | SQL | Tutorial 11

  0h08m

• Exercise: In a given company database schema, an employee table contains an 'employee ID', which is also a primary key. This table also contains two foreign keys: 'super ID' and 'branch ID'. What is the purpose of the 'super ID' foreign key in this schema?

• Video class: Creating Company Database | SQL | Tutorial 12

  0h13m

• Exercise: Which of the following is true about creating a complex database schema with foreign key relationships?

• Video class: More Basic Queries | SQL | Tutorial 13

  0h06m

• Exercise: Which SQL statement would retrieve the distinct department names from a table named 'department'?

• Video class: Functions | SQL | Tutorial 14

  0h09m

• Exercise: Which SQL function would you use to calculate the total expenditure on payroll for all employees in a company?

• Video class: WIldcards | SQL | Tutorial 15

  0h08m

• Exercise: What would be the appropriate SQL LIKE pattern to find all suppliers whose names contain the word 'Supplies'?

• Video class: Union | SQL | Tutorial 16

  0h08m

• Exercise: In SQL, which operator can be used to combine the results of multiple SELECT statements into a single result set?

• Video class: Joins | SQL | Tutorial 17

  0h10m

• Exercise: Which type of SQL join includes all rows from the left table and the matched rows from the right table, filling in with NULL where there is no match?

• Video class: Nested Queries | SQL | Tutorial 18

  0h10m

• Exercise: What is the primary purpose of using nested queries in SQL?

• Video class: On Delete | SQL | Tutorial 19

  0h08m

• Exercise: What is a potential consequence of using 'ON DELETE CASCADE' in a foreign key relationship?