Udemy - SQL for beginners with - Microsoft SQL Server PostgreSQL

seeders: 4
leechers: 2
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ CoursePig.com ] Udemy - SQL for beginners with - Microsoft SQL Server PostgreSQL
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. SQL Server Setup
    • 1. Introduction.mp4 (1.5 MB)
    • 10. Database Concepts.mp4 (18.9 MB)
    • 2. What is SQL Server.mp4 (11.2 MB)
    • 3. SQL Server Editions.mp4 (28.5 MB)
    • 4. Hardware and Software Installation Requirements.mp4 (21.5 MB)
    • 5. Download SQL Server.mp4 (23.2 MB)
    • 6. Install SQL Server.mp4 (62.5 MB)
    • 7. Install SSMS.mp4 (36.8 MB)
    • 8. Connect SSMS to SQL Server.mp4 (36.8 MB)
    • 9. Install Sample Database.mp4 (32.6 MB)
    2. SQL Microsoft SQL (T-SQL ) Fundamentals
    • 1. What is SQL.mp4 (15.2 MB)
    • 10. Backing up database.mp4 (18.9 MB)
    • 11. Deleting records.mp4 (23.9 MB)
    • 12. Truncating tables.mp4 (13.6 MB)
    • 13. Dropping tables.mp4 (12.6 MB)
    • 14. Dropping database.mp4 (11.1 MB)
    • 15. Restoring database.mp4 (14.1 MB)
    • 2. What is Microsoft SQL (T-SQL).mp4 (7.4 MB)
    • 3. Creating databases.mp4 (18.2 MB)
    • 4. Creating tables.mp4 (42.8 MB)
    • 5. Inserting data into database.mp4 (30.5 MB)
    • 6. Retrieving data from database.mp4 (43.0 MB)
    • 7. Creating Views.mp4 (26.8 MB)
    • 8. Creating stored proedures.mp4 (40.2 MB)
    • 9. Updating Records.mp4 (31.3 MB)
    3. Filtering data from SQL Server
    • 1. Introduction.mp4 (9.1 MB)
    • 2. Filtering data with equality filters.mp4 (129.8 MB)
    • 3. Filtering data with comparisons.mp4 (55.8 MB)
    • 4. Filtering data with logical comparisons.mp4 (153.7 MB)
    • 5. Filtering data with string comparisons.mp4 (113.3 MB)
    • 6. Filtering data with NULL Comparisons.mp4 (42.6 MB)
    4. Sorting data from SQL Server Database
    • 1. ORDER BY Clause.mp4 (2.5 MB)
    • 2. Sorting by ascending order.mp4 (38.7 MB)
    • 3. Sorting by descending.mp4 (42.1 MB)
    • 4. Sorting by multiple columns.mp4 (47.7 MB)
    5. PostgreSQL Setup
    • 1. What is PostgreSQL.mp4 (12.7 MB)
    • 2. Installing PostgreSQL on Windows.mp4 (45.3 MB)
    • 3. Installing PostgreSQL on Macs.mp4 (16.8 MB)
    • 4. Installing PostgreSQL on Linux.mp4 (40.9 MB)
    • 5. Installing PgAdmin on Macs.mp4 (33.3 MB)
    • 6. Installing PgAdmin on Linux.mp4 (45.9 MB)
    • 7. Connect PgAdmin to PostgreSQL.mp4 (20.7 MB)
    • 8. Install Sample database.mp4 (46.9 MB)
    6. SQL Fundamentals with PostgreSQL Database
    • 1. Filtering Data.mp4 (45.2 MB)
    • 2. Getting all data from a table.mp4 (34.8 MB)
    • 3. Getting data from specific table.mp4 (31.7 MB)
    • 4. Removing duplicate data.mp4 (22.3 MB)
    • 5. Sorting data.mp4 (40.4 MB)
    • 6. Grouping data.mp4 (55.5 MB)
    • 7. Filtering Groups.mp4 (45.2 MB)
    • 8. Sub Queries.mp4 (42.5 MB)
    7. SQL Query data in PostgreSQL using Operators
    • 1. Comparison Operators.mp4 (62.1 MB)
    • 10. IN Operator.mp4 (57.3 MB)
    • 11. Union Operator.mp4 (24.1 MB)
    • 12. Union All Operator.mp4 (16.1 MB)
    • 13. INTERSECT Operator.mp4 (36.9 MB)
    • 14. EXCEPT Operator.mp4 (47.3 MB)
    • 2. Between Operators.mp4 (49.4 MB)
    • 3. Not Between Operators.mp4 (28.5 MB)
    • 4. Like Operators.mp4 (58.9 MB)
    • 5. NOT Operator.mp4 (31.0 MB)
    • 6. OR Operator.mp4 (34.9 MB)
    • 7. AND Operator.mp4 (38.7 MB)
    • 8. Combining AND OR Operator.mp4 (51.8 MB)
    • 9. Limit Operator.mp4 (46.1 MB)
    8. SQL Data Aggregation with PostgreSQL
    • 1. What are Aggregate Functions.mp4 (7.5 MB)
    • 2. AVG Function.mp4 (61.6 MB)
    • 3. COUNT Function.mp4 (56.8 MB)
    • 4. MAX Function.mp4 (57.3 MB)
    • 5. MIN Function.mp4 (46.6 MB)
    • 6. SUM Function.mp4 (32.2 MB)
    9. Joining Data from multiple tables in PostgreSQL
    • 1. PostgreSQL Table Joins.mp4 (4.2 MB)
    • 2. INNER Join.mp4 (54.5 MB)
    • 3. LEFT Join.mp4 (53.7 MB)
    • 4. FULL Outer Join.mp4 (49.4 MB)
    • 5. CROSS Join.mp4 (35.1 MB)
    • 6. NATURAL Join.mp4 (64.8 MB)
    • Bonus Resources.txt (0.3 KB)

Description

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.



Download torrent
2.9 GB
seeders:4
leechers:2
Udemy - SQL for beginners with - Microsoft SQL Server PostgreSQL
Loading...