All pages
Jump to navigation
Jump to search
DataWars: Practice Data Science/Analysis with +100 Real Life Projects
- % MODULO
- % MODULO/de
- +(dates)
- +(dates)/de
- + (string)
- + (string)/de
- + INTERVAL
- + INTERVAL/de
- 2015 UK General Election Normalising Data
- 2015 UK General Election using SQL Server
- 2015 UK General Election using mssql
- 2015 UK General Election using mysql
- ABS
- ABS/de
- ALTER
- ALTER/de
- ALTER TABLE ... ADD COLUMN
- ALTER TABLE ... ADD constraint
- ALTER TABLE ... DROP COLUMN
- AVG
- AVG/de
- AdventureWorks
- AdventureWorks easy questions
- AdventureWorks hard questions
- AdventureWorks medium questions
- AdventureWorks resit questions
- Adventureworks
- Aggregates with DISTINCT
- Aggregates with DISTINCT/ja
- Album
- Ambigous column name
- Apostrophe
- Archived SELECT from WORLD Tutorial
- Assessment Temp
- Autonumber fields
- BBC QUIZ
- BBC QUIZ/ja
- BBC QUIZ/zh
- ByQuarter
- CASE
- CASE/de
- CASE/ja
- CAST
- CAST/de
- CEIL
- CEIL/de
- COALESCE
- COALESCE/de
- CONCAT
- CONCAT/de
- COS
- COS/de
- COUNT
- COUNT/de
- CREATE INDEX
- CREATE TABLE
- CREATE TABLE problems: Foreign key references.
- CREATE TABLE problems: Insufficient privileges.
- CREATE TABLE problems: Invalid column name.
- CREATE TABLE problems: Table already exists.
- CREATE VIEW
- CREATE a VIEW
- CREATE a foreign key
- CREATE a new table
- CREATE and DROP Reference
- CURRENT DATE
- CURRENT DATE/de
- CURRENT TIMESTAMP
- CURRENT TIMESTAMP/de
- Change my own password
- Change the default schema/database.
- Cheat Mode
- Column name
- Column name with spaces
- ComMySQL
- Combinations
- Combine queries
- Combine tables
- Common.css
- Components of date
- Composite primary key
- Concatenate Columns
- Concatenate strings
- Conditional values
- Congestion Charging
- Congestion Easy
- Congestion Easy2
- Congestion Hard
- Congestion Hard2
- Congestion Medium
- Congestion Medium2
- Convert CSV to TXT
- Create a new user
- Create database
- Createworld.txt
- Credit debit
- DATEPART
- DATEPART/de
- DATE and TIME Reference
- DAY
- DAY/de
- DDL Extended Student Records Tutorial
- DDL General Election
- DDL Student Records
- DE:Main Page
- DELETE
- DELETE problems: reference
- DELETE records
- DIV
- DIV/de
- DROP
- DROP TABLE problems: Foreign key references.
- DROP a table
- Data normalization
- Date and time types
- Date arithmetics
- Date functions
- Derived table
- Dressmaker
- Dressmaker easy
- Dressmaker hard
- Dressmaker medium
- EXTRACT
- EXTRACT/de
- Edinburgh Buses.
- Elite Dangerous
- Equi Join
- Explicitly enter a NULL
- Extracting substrings
- FLOOR
- FLOOR/de
- FUNCTIONS
- FUNCTIONS/de
- Find another process and kill it.
- Finding a substring in a string
- Forgotten rows
- Format a date and time
- Format dates
- Formating numbers to two decimal spaces
- Full text search
- Functions Reference
- GRUH
- Generate rows
- Get a date and time right now
- Get the 11th to the 20th rows of the cia table - by population.
- Get the first 10 rows of the gisq.cia table.
- Get to the point
- Get to the point/ja
- Getting the latest record
- Guest House
- Guest House/zh
- Guest House Assessment Easy
- Guest House Assessment Easy/zh
- Guest House Assessment Hard
- Guest House Assessment Medium
- Guest House Assessment Sample Queries
- HOUR
- HOUR/de
- HTL
- HTL/EinfacheAggregatfunktion
- HTL/Gruppierungen
- HTLWienWest
- HTLWienWest/Group By Having 01
- HTLWienWest/SMUE 2022-05-09 2ACIF
- HTLWienWest/SMUE 2022-05-09 5ABIF
- HTLWienWest/Select Basics
- HTLWienWest/deleteme
- Hacks Reference
- Help Desk
- Helpdesk Easy Questions
- Helpdesk Hard Questions
- Helpdesk Medium Questions
- How can you determine the primary key using SQL?
- Hw
- IFNULL
- IFNULL/de
- INF08104
- INSERT: Not all fields need to be specified
- INSERT ... SELECT
- INSERT .. SELECT
- INSERT .. VALUES
- INSERT a date
- INSERT and DELETE Reference
- INSERT new records
- INSERT problems: incompatible formats
- INSERT problems: reference
- INSTR
- INSTR/de
- INTERVAL of time
- Image
- Import data
- Incorrect GROUP BY
- Invalid Group function
- Issue queries
- JOIN
- JOIN Quiz
- JOIN Quiz 2
- Join BabySteps
- LEFT
- LEFT/de
- LEFT JOIN
- LEN
- LEN/de
- LENGTH
- LENGTH/de
- Language Test Page
- Language Test Page/de
- LaurenTest
- Like
- Lire notes a propose de cette table.
- Lower case
- MAX
- MAX/de
- MIN
- MIN/de
- MINUTE
- MINUTE/de
- MOD
- MOD/de
- MONTH
- MONTH/de
- Main Page
- Main Page/de
- Main Page/fr
- Manning
- Match a range of dates
- Maximum
- Meta Data Reference
- MoL Chapter 2
- MoL Chapter 2 Lab
- MoL Chapter 5 Lab
- MoL Chapter 7 Lab
- MoL Chapter 8
- MoL Chapter 8 Lab
- Module Feedback
- More JOIN operations
- More JOIN operations/ja
- More JOIN operations/zh
- More details about the database.
- Multiply sets
- Music Tutorial
- Music Tutorial/ja
- Music Tutorial/zh
- Musicians
- Musicians easy questions
- Musicians hard questions
- Musicians medium questions
- NSS Tutorial
- NULL
- NULLIF
- NULLIF/de
- NVL
- NVL/de
- Neeps
- Neeps easy questions
- Neeps hard questions
- Neeps medium questions
- Neeps resit questions
- Nested SELECT Quiz
- Nested SELECT Quiz/ja
- Nested SELECT Quiz/zh
- No Group By Function
- Nobel Quiz
- Nobel Quiz/ja
- Nobel Quiz/zh
- Old Congestion
- Old JOIN Tutorial
- Outer joins
- PATINDEX
- POSITION
- Practice for create a table tablename=job
- Putty and winscp
- Putty and winscp off campus
- QUARTER
- QUARTER/de
- QUIZ BBC
- RANK
- REPLACE
- RIGHT
- RIGHT/de
- ROUND
- Range
- Read tables from another schema/database
- Read the notes about this table.
- Read the notes about this table./de
- Rename column
- Replace a NULL with specific value
- Return a sequential record count for all records returned
- Rows to columns
- Running Total
- SECOND
- SECOND/de
- SELECT
- SELECT ... WHERE
- SELECT .. GROUP BY
- SELECT .. JOIN
- SELECT .. SELECT
- SELECT .. SELECT/ja
- SELECT .. WHERE
- SELECT Quiz
- SELECT Quiz/ja
- SELECT Quiz/zh
- SELECT Quiz1
- SELECT Reference
- SELECT bases
- SELECT basics
- SELECT basics/de
- SELECT basics/es
- SELECT basics/ja
- SELECT basics/zh
- SELECT from BBC Tutorial
- SELECT from MONDE
- SELECT from Nobel
- SELECT from Nobel Tutorial
- SELECT from Nobel Tutorial/ja
- SELECT from Nobel Tutorial/zh
- SELECT from WORLD Tutorial
- SELECT from WORLD Tutorial/ja
- SELECT from WORLD Tutorial/zh
- SELECT names
- SELECT names/ja
- SELECT names/zh
- SELECT within SELECT Tutorial
- SELECT within SELECT Tutorial/ja
- SELECT within SELECT Tutorial/zh
- SIN
- SQL Error Messages
- SQL Tutorial
- SQL Tutorial/ja
- SQL Tutorial/zh
- SQL Tutorial - SQLZOO
- SQL Zoo
- SQL from Java
- SQL from webpage
- SQL in perl on the Web
- SQL with CS
- SQL with PDO
- SQL with PHP
- SUBSTR
- SUBSTR/de
- SUBSTRING
- SUBSTRING(ansi)
- SUBSTRING(ansi)/de
- SUBSTRING/de
- SUM
DataWars: Practice Data Science/Analysis with +100 Real Life Projects