Skip to main content
СУ
You are currently using guest access (
Log in
)
Topic: Applications in SQL
Home
Courses
Стопански факултет
Active class Project
Databases in Finance
Topic: Applications in SQL
Section outline
◄
Topic: Theoretical concepts in Databases
►
Topic: Applications in MS Access
This topic presents practical applications of a SQL database management system
Select activity Video curriculum
Video curriculum
Page
Select activity Materials - Introduction into SQL
Materials - Introduction into SQL
File
PDF
662.6 KB
Select activity Materials - SQL Fundamentals
Materials - SQL Fundamentals
File
PDF
253.7 KB
Select activity Materials - SQL Intermidiate
Materials - SQL Intermidiate
File
PDF
274.1 KB
Select activity Materials - SQL Advanced
Materials - SQL Advanced
File
PDF
634.3 KB
Select activity Brokerage.DB
Brokerage.DB
File
356.0 KB
Select activity SQLite online IDE
SQLite online IDE
URL
Select activity SQLite tutorial
SQLite tutorial
URL
Select activity Creating DB schema diagrams
Creating DB schema diagrams
Page
Select activity Visual JOIN web-page
Visual JOIN web-page
URL
Select activity Assignment 1: SELECT statement
Assignment 1: SELECT statement
Page
Select activity Demo 1
Demo 1
File
SQL
125 bytes
Select activity Solution 1
Solution 1
File
SQL
150 bytes
Select activity Assignment 2: ORDER BY and LIMIT clauses
Assignment 2: ORDER BY and LIMIT clauses
Page
Select activity Demo2
Demo2
File
SQL
189 bytes
Select activity Solution 2
Solution 2
File
SQL
239 bytes
Select activity Assignment 3: WHERE and Logical Operators
Assignment 3: WHERE and Logical Operators
Page
Select activity Demo 3: WHERE clause
Demo 3: WHERE clause
File
SQL
559 bytes
Select activity Solution 3
Solution 3
File
SQL
629 bytes
Select activity Assignment 4: DISTINCT , CASE
Assignment 4: DISTINCT , CASE
Page
Select activity Demo 4 DISTINCT
Demo 4 DISTINCT
File
SQL
67 bytes
Select activity Demo 4.2 CASE
Demo 4.2 CASE
File
SQL
247 bytes
Select activity Demo 4.1 CASE
Demo 4.1 CASE
File
SQL
189 bytes
Select activity Solution 4
Solution 4
File
SQL
644 bytes
Select activity Assignment 5: GROUP BY
Assignment 5: GROUP BY
Page
Select activity Demo 5 GROUP BY
Demo 5 GROUP BY
File
SQL
681 bytes
Select activity Solution 5
Solution 5
File
SQL
341 bytes
Select activity Assignment 6: DATES
Assignment 6: DATES
Page
Select activity Demo6
Demo6
File
SQL
585 bytes
Select activity Solution 6
Solution 6
File
SQL
786 bytes
Select activity SQL Intermediate solutions
SQL Intermediate solutions
Page
Select activity Assignment 7: HAVING and Subquery WITH
Assignment 7: HAVING and Subquery WITH
Page
Select activity demo7 HAVING
demo7 HAVING
File
SQL
381 bytes
Select activity Demo 7 Chained Query
Demo 7 Chained Query
File
SQL
640 bytes
Select activity Demo 7: DROP CREATE TABLE
Demo 7: DROP CREATE TABLE
File
SQL
325 bytes
Select activity Solution 7
Solution 7
File
SQL
340 bytes
Select activity Exercise: Joins
Exercise: Joins
File
PDF
511.6 KB
Select activity Assignment 8: JOIN syntax
Assignment 8: JOIN syntax
Page
Select activity Demo JOIN syntax
Demo JOIN syntax
File
SQL
262 bytes
Select activity Solution 8
Solution 8
File
SQL
140 bytes
Select activity Assignment 9: LEFT JOIN + GROUP BY
Assignment 9: LEFT JOIN + GROUP BY
Page
Select activity DEMO LEFT JOIN + Group BY
DEMO LEFT JOIN + Group BY
File
SQL
256 bytes
Select activity Demo LEFT JOIN
Demo LEFT JOIN
File
SQL
296 bytes
Select activity Solution 9
Solution 9
File
SQL
223 bytes
Select activity Assignment 10 Multiple JOINS
Assignment 10 Multiple JOINS
Page
Select activity Demo 10 Multiple Joins
Demo 10 Multiple Joins
File
SQL
902 bytes
Select activity Demo 10 Multiple Join 2
Demo 10 Multiple Join 2
File
SQL
402 bytes
Select activity Solution 10
Solution 10
File
SQL
1000 bytes
Select activity Assignment 11 FULL JOIN
Assignment 11 FULL JOIN
Page
Select activity Demo FULL OUTER JOIN
Demo FULL OUTER JOIN
File
SQL
360 bytes
Select activity Assignment 12: General SQL Recap
Assignment 12: General SQL Recap
Page
Select activity Assignment 13: General SQL Recap
Assignment 13: General SQL Recap
Page
Select activity SQL Game
SQL Game
Page
Select activity sql-murder-mystery-no-sol.db
sql-murder-mystery-no-sol.db
File
2.9 MB
Select activity Q&A session
Q&A session
URL
◄
Topic: Theoretical concepts in Databases
Jump to...
Main course page
General
Topic: Data science
Topic: Theoretical concepts in Databases
Topic: Applications in SQL
Topic: Applications in MS Access
►
Topic: Applications in MS Access