Cursusomgeving Data-Docent
Home
Effectieve Business Intelligence
Data Gedreven Werken
Databases
SQL
Selecteer opdracht/Select an assignment
Opdracht/Assignment
S1.01 - Example - Creating a table with a create table statement
S1.02 - Example - Creating a view with a create view statement
S1.03 - Example - Delete the newly created table
S1.04 - Example - Delete the newly created view
S1.05 - Example - Creating a SCHEMA
S1.06 - Assignment - ASSIGNMENT Create your own SCHEMA
S1.07 - Assignment - ADDITIONAL ASSIGNMENT Adjust the table definition and enter the data type and null/not null at XXX
S2.01 - Example - Example basic select query with all columns
S2.02 - Example - Example basic select query with specific columns
S2.03 - Example - Example select query with order by for the order
S2.04 - Example - Example select query with a restriction on the rows and columns
S2.05 - Assignment - EXTRA ASSIGNMENT Create a select statement for the Suppliers in the country France and Germany. We want to see the company and contactname
S3.01 - Example - A query with a calculated column in the select part
S3.02 - Example - A query with filter on NULL and search for words in an alphanumeric column
S3.03 - Example - A DISTINCT query to deduplicate the result
S3.04 - Example - A select statement limiting the number of results with TOP in combination with ORDER BY
S3.05 - Assignment - ASSIGNMENT Create a list of products with a price between 10 and 30 and order it by name
S3.06 - Assignment - EXTRA ASSIGNMENT Create a list of products with a price between 10 and 30 and order it by name And with a name that starts with a B or a P
S3.07 - Example - Example of an inner join based on two tables
S3.08 - Example - Example of a left join based on two tables
S3.09 - Example - Example of a right join based on two tables
S3.10 - Example - Example of a full join based on two tables
S3.11 - Example - Example of a lazy join based on two tables
S3.12 - Example - Example of a self join in the Employees table
S3.13 - Example - Example of a UNION to combine two tables based on the rows
S3.14 - Assignment - ASSIGNMENT an overview of products in the category of beverages or dairy products
S4.01 - Example - Query with numerical data where you will work with mathematical operators
S4.02 - Example - A query with filter on Between
S4.03 - Example - Query with columns of calendar dates. Here you will filter and you must display the date in text values
S4.04 - Example - Use the IN() statement to easily specify a list of values
S4.04 - Example - Combination of Boolean filters based on AND, OR and NOT including working with brackets
S4.05 - Example - Select statement with a case when part to create your own classification
S4.06 - Example - Make use of a subquery with IN in the where part.
S4.07 - Example - Make use of a subquery with a subquery in the SELECT part.
S4.08 - Assignment - ASSIGNMENT an overview of products in the category of beverages or dairy products and give the name of the supplier of the product
S4.09 - Assignment - ASSIGNMENT Make a list of employees and customers Xname and suppliers Xname who live in the same city. Use a union
S4.10 - Assignment - EXTRA ASSIGNMENT Make a select statement of the products where you only show the products from the suppliers in the UK country. Use a IN() subquery
S5.01 - Example - Various aggregate functions on a result set in a select statement
S5.02 - Example - Various aggregate functions on a result set in a select statement extended with group by for subtotals
S5.04 - Example - Various SQL Server functions for alphanumeric columns. To provide transformation of text
S5.04 - Example - Convert date column contents to year or month to more easily retrieve data for a year or month
S5.05 - Example - Calculate calendar date values by adding or subtracting a period
S5.06 - Example - Calculate with calendar date by calculating the difference between two calendar dates to a specific calendar unit
S5.07 - Assignment - ASSIGNMENT: Northwind would like a sales overview divided by product category and the month of sale
S5.08 - Assignment - EXTRA ASSIGNMENT Total turnover calculation divided into weekday or weekend and into the month of sale
S5.09 - Assignment - EXTRA ASSIGNMENT Use advanced functions from the SQL Server database
S6.01 - Example - Create a table related to the Northwind database but we create this in our own namespace
S6.02 - Example - Create a key column in the training table
S6.03 - Example - Create a primary key for a table
S6.04 - Example - Create a reference key to a primary key in another table
S6.05 - Example - Check constraints
S6.06 - Assignment - ASSIGNMENT Create the congratulations table in your own schema and add a column for the primary key column
S6.07 - Assignment - ASSIGNMENT add a primary key constraint to your table.
S7.01 - Example - Example of an Insert statement to add a row to a table
S7.02 - Example - Example of an update statement for changing one or more rows
S7.03 - Example - Example of a delete statement for removing one or more rows from a table
S7.04 - Assignment - ASSIGNMENT Add some rows to your own created table with insert, and update and delete a number of rows
S8.01 - Example - Creating an example of a view
S8.02 - Example - Create a select statement with an inner join in which you combine Order and TrainingExtra tables
S8.03 - Example - Discarding the view from your own schema
S8.04 - Assignment - ASSIGNMENT Create a query based on Score table
SQL Query
Query *
Query is required
Email *