| 1. Comparison Operators.mp4 | 62.1 MB | ||
| 1. Filtering Data.mp4 | 45.2 MB | ||
| 1. Introduction.mp4 | 9.1 MB | ||
| 1. ORDER BY Clause.mp4 | 2.5 MB | ||
| 1. PostgreSQL Table Joins.mp4 | 4.2 MB | ||
| 1. What are Aggregate Functions.mp4 | 7.5 MB | ||
| 1. What is PostgreSQL.mp4 | 12.7 MB | ||
| 1. What is SQL.mp4 | 15.2 MB | ||
| 10. Backing up database.mp4 | 18.9 MB | ||
| 10. Database Concepts.mp4 | 18.9 MB | ||
| 10. IN Operator.mp4 | 57.3 MB | ||
| 11. Deleting records.mp4 | 23.9 MB | ||
| 11. Union Operator.mp4 | 24.1 MB | ||
| 12. Truncating tables.mp4 | 13.6 MB | ||
| 12. Union All Operator.mp4 | 16.1 MB | ||
| 13. Dropping tables.mp4 | 12.6 MB | ||
| 13. INTERSECT Operator.mp4 | 36.9 MB | ||
| 14. Dropping database.mp4 | 11.1 MB | ||
| 14. EXCEPT Operator.mp4 | 47.3 MB | ||
| 15. Restoring database.mp4 | 14.1 MB | ||
| 2. AVG Function.mp4 | 61.6 MB | ||
| 2. Between Operators.mp4 | 49.4 MB | ||
| 2. Filtering data with equality filters.mp4 | 129.8 MB | ||
| 2. Getting all data from a table.mp4 | 34.8 MB | ||
| 2. INNER Join.mp4 | 54.5 MB | ||
| 2. Installing PostgreSQL on Windows.mp4 | 45.3 MB | ||
| 2. Sorting by ascending order.mp4 | 38.7 MB | ||
| 2. What is Microsoft SQL (T-SQL).mp4 | 7.4 MB | ||
| 2. What is SQL Server.mp4 | 11.2 MB | ||
| 3. COUNT Function.mp4 | 56.8 MB | ||
| 3. Creating databases.mp4 | 18.2 MB | ||
| 3. Filtering data with comparisons.mp4 | 55.8 MB | ||
| 3. Getting data from specific table.mp4 | 31.7 MB | ||
| 3. Installing PostgreSQL on Macs.mp4 | 16.8 MB | ||
| 3. LEFT Join.mp4 | 53.7 MB | ||
| 3. Not Between Operators.mp4 | 28.5 MB | ||
| 3. SQL Server Editions.mp4 | 28.5 MB | ||
| 3. Sorting by descending.mp4 | 42.1 MB | ||
| 4. Creating tables.mp4 | 42.8 MB | ||
| 4. FULL Outer Join.mp4 | 49.4 MB | ||
| 4. Filtering data with logical comparisons.mp4 | 153.7 MB | ||
| 4. Hardware and Software Installation Requirements.mp4 | 21.5 MB | ||
| 4. Installing PostgreSQL on Linux.mp4 | 40.9 MB | ||
| 4. Like Operators.mp4 | 58.9 MB | ||
| 4. MAX Function.mp4 | 57.3 MB | ||
| 4. Removing duplicate data.mp4 | 22.3 MB | ||
| 4. Sorting by multiple columns.mp4 | 47.7 MB | ||
| 5. CROSS Join.mp4 | 35.1 MB | ||
| 5. Download SQL Server.mp4 | 23.2 MB | ||
| 5. Filtering data with string comparisons.mp4 | 113.3 MB | ||
| 5. Inserting data into database.mp4 | 30.5 MB | ||
| 5. Installing PgAdmin on Macs.mp4 | 33.3 MB | ||
| 5. MIN Function.mp4 | 46.6 MB | ||
| 5. NOT Operator.mp4 | 31 MB | ||
| 5. Sorting data.mp4 | 40.4 MB | ||
| 6. Filtering data with NULL Comparisons.mp4 | 42.6 MB | ||
| 6. Grouping data.mp4 | 55.5 MB | ||
| 6. Install SQL Server.mp4 | 62.5 MB | ||
| 6. Installing PgAdmin on Linux.mp4 | 45.9 MB | ||
| 6. NATURAL Join.mp4 | 64.8 MB | ||
| 6. OR Operator.mp4 | 34.9 MB | ||
| 6. Retrieving data from database.mp4 | 43 MB | ||
| 6. SUM Function.mp4 | 32.2 MB | ||
| 7. AND Operator.mp4 | 38.7 MB | ||
| 7. Connect PgAdmin to PostgreSQL.mp4 | 20.7 MB | ||
| 7. Creating Views.mp4 | 26.8 MB | ||
| 7. Filtering Groups.mp4 | 45.2 MB | ||
| 7. Install SSMS.mp4 | 36.8 MB | ||
| 8. Combining AND OR Operator.mp4 | 51.8 MB | ||
| 8. Connect SSMS to SQL Server.mp4 | 36.8 MB | ||
| 8. Creating stored proedures.mp4 | 40.2 MB | ||
| 8. Install Sample database.mp4 | 46.9 MB | ||
| 8. Sub Queries.mp4 | 42.5 MB | ||
| 9. Install Sample Database.mp4 | 32.6 MB | ||
| 9. Limit Operator.mp4 | 46.1 MB | ||
| 9. Updating Records.mp4 | 31.3 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 79 total files | |||
SQL for beginners with: Microsoft SQL Server | PostgreSQL
https://CoursePig.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 77 lectures (8h 22m) | Size: 2.34 GB
Query and interact with databases using SQL
What you'll learn:
Backup a database
Restore a database
Create stored procedures
Write SQL queries with confidence
Select data from specific table column
Select data from all table columns
Join data from multiple tables
Insert records into the database
Extract data from database using subqueries
Delete records
Query databases with multiple operators
Group data
Aggregate data
Filter Data from database
Sort data from database
Requirements
No SQL experience required.
Description
SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences.
Millions of data points are being generated every minute and raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 4 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 1 month | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments