| 1. Basic Functions - Intro.mp4 | 3.5 MB | ||
| 1. Erasing - Intro.mp4 | 3.5 MB | ||
| 1. Filtering - Intro.mp4 | 3.5 MB | ||
| 1. Getting data - Intro.mp4 | 3.5 MB | ||
| 1. Inserting - Intro.mp4 | 3.5 MB | ||
| 1. Intro.mp4 | 27.5 MB | ||
| 1. Joining - Intro.mp4 | 3.5 MB | ||
| 1. Modifying - Intro.mp4 | 3.5 MB | ||
| 1. Sorting - Intro.mp4 | 3.5 MB | ||
| 10. Continuing aggregate functions.html | 204.8 B | ||
| 10. How to get books published in some years range.html | 204.8 B | ||
| 11. How to get average price of english written books.html | 204.8 B | ||
| 11. Practising of LIKE keyword.html | 204.8 B | ||
| 12. How to get average price for books from last century..html | 204.8 B | ||
| 13. Continuing aggregate functions.html | 204.8 B | ||
| 14. Continuing aggregate functions.html | 204.8 B | ||
| 15. How to get minimal price of dollar books.html | 204.8 B | ||
| 16. How to get the highest price of books sold by USD.html | 204.8 B | ||
| 17. All together..html | 204.8 B | ||
| 18. How can we understand average value.html | 204.8 B | ||
| 2. Aggregate Functions.mp4 | 106.9 MB | ||
| 2. Creating Data.mp4 | 243.3 MB | ||
| 2. Deleting Data.mp4 | 26 MB | ||
| 2. Filtering by Conditions.mp4 | 320.2 MB | ||
| 2. Joining Data From More Tables.mp4 | 67.3 MB | ||
| 2. Reading Data.mp4 | 58.1 MB | ||
| 2. Sorting.mp4 | 112.5 MB | ||
| 2. Updating Data.mp4 | 62.1 MB | ||
| 2.1 F_BasicAggregateFunctions.sql | 1.7 KB | ||
| 2.1 F_ClauseOrderBy.sql | 1.5 KB | ||
| 2.1 F_ConditionAndOperators.sql | 4.5 KB | ||
| 2.1 F_CreateData.sql | 9.5 KB | ||
| 2.1 F_DeletingData.sql | 2.3 KB | ||
| 2.1 F_Joins.sql | 819.2 B | ||
| 2.1 F_SelectingData.sql | 1.8 KB | ||
| 2.1 F_UpdatingData.sql | 1.4 KB | ||
| 3. Aggregate functions.html | 204.8 B | ||
| 3. Data Modification.html | 204.8 B | ||
| 3. Erasing of data.html | 204.8 B | ||
| 3. How to read data from database.html | 204.8 B | ||
| 3. Inserting.html | 204.8 B | ||
| 3. Joining.html | 204.8 B | ||
| 3. Sorting.html | 204.8 B | ||
| 3. What is the reserved command for filtering by conditions.html | 204.8 B | ||
| 4. Deleting exercise.html | 204.8 B | ||
| 4. Friendly Notice.html | 204.8 B | ||
| 4. How to get authors of books.html | 204.8 B | ||
| 4. How to get number of rows.html | 204.8 B | ||
| 4. How to get titles of books written in English.html | 204.8 B | ||
| 4. Inserting Exercise.html | 204.8 B | ||
| 4. One side partial join.html | 204.8 B | ||
| 4. Updating exercise.html | 204.8 B | ||
| 5. How to find count of english written books.html | 204.8 B | ||
| 5. How to get titles of books written in Czech.html | 204.8 B | ||
| 5. How to get titles of books.html | 204.8 B | ||
| 5. How to sort books by name of author from A to Z.html | 204.8 B | ||
| 5. Other join example - with other direction.html | 204.8 B | ||
| 6. Both sides join.html | 204.8 B | ||
| 6. Continuing aggregate functions.html | 204.8 B | ||
| 6. How to get all information of books from database.html | 204.8 B | ||
| 6. How to get book titles of Neil Gaiman from DB.html | 204.8 B | ||
| 6. How to sort books by name of author from Z to A.html | 204.8 B | ||
| 7. How to find out the price of all books sold for dollars.html | 204.8 B | ||
| 7. How to get all information of customers.html | 204.8 B | ||
| 7. How to sort on multiple columns.html | 204.8 B | ||
| 7. Which of our books were written by Neil Gaiman, Paulo Coelho or Nick Cave.html | 204.8 B | ||
| 8. Get all books published last century.html | 204.8 B | ||
| 8. How to find a total price of books sold by Czech Koruna..html | 204.8 B | ||
| 8. How to get all parts of names of customers.html | 204.8 B | ||
| 9. How to get authors, titles and year publishing for each of books.html | 204.8 B | ||
| 9. How to get info of books published in the last century and have been published in English.html | 204.8 B | ||
| 9. How to get total price of books sold by dollars and written in last century.html | 204.8 B | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 74 total files | |||
SQL Practice (2023)
https://DevCourseWeb.com
Published 4/2023
Created by Tomáš Podešva
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 18 Lectures ( 1h 25m ) | Size: 1 GB
Practice the SQL language on quizzes and exercises. Mainly suitable for beginners and intermediates.
What you'll learn
Exercise the Data Manipulation Language (DML)
Exercise the Creating Data operation
Exercise the Reading Data operation
Exercise the Updating Data operation
Exercise the Deleting Data operation
Exercise the Filtering Data in SQL
Exercise the using logical operators
Exercise the Sorting Data in SQL
Exercise the Data Definition Language (DDL)
Check SQL knowledge
Exercise how to get count, sum, minimal, maximal or average value
Understand how to write comments in SQL code
Requirements
Minimal SQL knowledge
Passion to check own knowledge
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.4 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 3.5 GB | freecoursewb | 2 weeks | 0 | 0 | |
|
Udemy - IMRaD-Q1 Paper Writing and Publishing with ChatGPT and AI '26 Posted by
freecoursewb in Other
|
846.5 MB | freecoursewb | 2 weeks | 0 | 0 |
| 3.8 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 1.3 GB | freecoursewb | 2 weeks | 0 | 0 |
All Comments