EXERCISE TOPIC▼
SQL EXERCISES▼
SQL EXERCISES▼
- Simple Queries (4)
- Setting criteria using WHERE (5)
- Calculations (7)
- Calculations using dates (4)
- Basic joins (8)
- More exotic joins (2)
- Aggregation and grouping (8)
- Views (5)
- Subqueries (5)
- Stored procedures (5)
- Variables (8)
- Parameters and return values (11)
- Testing conditions (1)
- Looping (3)
- Scalar functions (6)
- Transactions (5)
- Creating tables (5)
- Temporary tables and table variables (9)
- Table-valued functions (6)
- Derived tables and CTEs (13)
- Dynamic SQL (4)
- Pivots (2)
- Triggers (2)
- Archived (70)
SQL exercises on CREATING TABLES
This page lists the 5 exercises about Creating tables in SQL on our website: p >
Software: | SQL |
Version: | Any version of SQL Server |
Topic: | Creating tables |
Level: | Average difficulty |
Courses: | Fast-track SQLAdvanced SQL |
Exercise: | Write a SQL query to create a table of companies, and add two rows to it. |
Software: | SQL |
Version: | Any version of SQL Server |
Topic: | Creating tables |
Level: | Average difficulty |
Courses: | Fast-track SQLAdvanced SQL |
Exercise: | Create a table of genres for books using CREATE TABLE, then insert a few rows using INSERT INTO. |
Software: | SQL |
Version: | Any version of SQL Server |
Topic: | Creating tables |
Level: | Average difficulty |
Courses: | Fast-track SQLAdvanced SQL |
Exercise: | Has mistake must fix spelling of millenium!!!!. |
Software: | SQL |
Version: | Any version of SQL Server |
Topic: | Creating tables |
Level: | Average difficulty |
Courses: | Fast-track SQLAdvanced SQL |
Exercise: | Store useful information about continents in a new permanent table. |
Software: | SQL |
Version: | Any version of SQL Server |
Topic: | Creating tables |
Level: | Harder than average |
Courses: | Fast-track SQLAdvanced SQL |
Exercise: | Create a table of genres for books, and create a foreign key constraint linking this to a table of authors. |
You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?
This page has 0 threads
Add post