| 001 About SQL Strings.mp4 | 5.6 MB | ||
| 001 About SQL Strings_en.vtt | 2 KB | ||
| 001 About SQL.mp4 | 9.9 MB | ||
| 001 About SQL_en.vtt | 4.5 KB | ||
| 001 Automating Data With Triggers.mp4 | 38.6 MB | ||
| 001 Automating Data With Triggers_en.vtt | 5 KB | ||
| 001 B-tree indexes.mp4 | 13 MB | ||
| 001 B-tree indexes_en.vtt | 5 KB | ||
| 001 Creating A Table.mp4 | 19.1 MB | ||
| 001 Creating A Table_en.vtt | 3.3 KB | ||
| 001 Creating a Subselect.mp4 | 28 MB | ||
| 001 Creating a Subselect_en.vtt | 3.3 KB | ||
| 001 Date and Times.mp4 | 6 MB | ||
| 001 Date and Times_en.vtt | 2.5 KB | ||
| 001 EXPLAIN and ANALYZE commands.mp4 | 36.8 MB | ||
| 001 EXPLAIN and ANALYZE commands_en.vtt | 10.4 KB | ||
| 001 Embedding SQL.mp4 | 42.4 MB | ||
| 001 Embedding SQL_en.vtt | 6.3 KB | ||
| 001 Extending SQL with user-defined functions.mp4 | 13 MB | ||
| 001 Extending SQL with user-defined functions_en.vtt | 4.3 KB | ||
| 001 Federated Queries.mp4 | 14.7 MB | ||
| 001 Federated Queries_en.vtt | 5.1 KB | ||
| 001 Installing on Windows.mp4 | 49.2 MB | ||
| 001 Installing on Windows_en.vtt | 7.4 KB | ||
| 001 Introduction.mp4 | 9.1 MB | ||
| 001 Introduction_en.vtt | 819.2 B | ||
| 001 Make your queries faster.mp4 | 19.7 MB | ||
| 001 Make your queries faster_en.vtt | 2.1 KB | ||
| 001 Numeric Types.mp4 | 8.2 MB | ||
| 001 Numeric Types_en.vtt | 3.7 KB | ||
| 001 Overview.mp4 | 10.5 MB | ||
| 001 Overview_en.vtt | 1.1 KB | ||
| 001 Retrieve data with SELECT.mp4 | 55.8 MB | ||
| 001 Retrieve data with SELECT_en.vtt | 6.2 KB | ||
| 001 Rules of normalization.mp4 | 26.8 MB | ||
| 001 Rules of normalization_en.vtt | 8 KB | ||
| 001 Understanding JOIN.mp4 | 9 MB | ||
| 001 Understanding JOIN_en.vtt | 2.8 KB | ||
| 001 What are Aggregates.mp4 | 34.6 MB | ||
| 001 What are Aggregates_en.vtt | 5.4 KB | ||
| 001 What are Transactions.mp4 | 6.6 MB | ||
| 001 What are Transactions_en.vtt | 2.4 KB | ||
| 002 Accessing Related Tables.mp4 | 49.8 MB | ||
| 002 Accessing Related Tables_en.vtt | 7.3 KB | ||
| 002 Bitmap indexes.mp4 | 15.1 MB | ||
| 002 Bitmap indexes_en.vtt | 3.6 KB | ||
| 002 Bloom filters.mp4 | 18.1 MB | ||
| 002 Bloom filters_en.vtt | 5.6 KB | ||
| 002 Data Integrity.mp4 | 34.6 MB | ||
| 002 Data Integrity_en.vtt | 4.5 KB | ||
| 002 Database Organisation.mp4 | 15.2 MB | ||
| 002 Database Organisation_en.vtt | 3.3 KB | ||
| 002 Date and Time Related Functions.mp4 | 15.6 MB | ||
| 002 Date and Time Related Functions_en.vtt | 2.5 KB | ||
| 002 Deleting A Table.mp4 | 16.8 MB | ||
| 002 Deleting A Table_en.vtt | 2.5 KB | ||
| 002 Denormalization.mp4 | 28.6 MB | ||
| 002 Denormalization_en.vtt | 9.2 KB | ||
| 002 Filter results with WHERE clause.mp4 | 51.3 MB | ||
| 002 Filter results with WHERE clause_en.vtt | 5.8 KB | ||
| 002 Finding The Length Of A String.mp4 | 13.2 MB | ||
| 002 Finding The Length Of A String_en.vtt | 2.1 KB | ||
| 002 Generating data with generate_sequence.mp4 | 35.6 MB | ||
| 002 Generating data with generate_sequence_en.vtt | 5 KB | ||
| 002 Get familiar with phpMyAdmin.mp4 | 41.7 MB | ||
| 002 Get familiar with phpMyAdmin_en.vtt | 4.7 KB | ||
| 002 Installing on Mac.mp4 | 57.7 MB | ||
| 002 Installing on Mac_en.vtt | 9.2 KB | ||
| 002 Merge data across tables with JOINS.mp4 | 47.6 MB | ||
| 002 Merge data across tables with JOINS_en.vtt | 5.6 KB | ||
| 002 Preventing Updates.mp4 | 36 MB | ||
| 002 Preventing Updates_en.vtt | 4.7 KB | ||
| 002 SQL query functions.mp4 | 43.8 MB | ||
| 002 SQL query functions_en.vtt | 10.9 KB | ||
| 002 Searching Within A Result Set.mp4 | 26.2 MB | ||
| 002 Searching Within A Result Set_en.vtt | 3.3 KB | ||
| 002 The SELECT Function.mp4 | 50.4 MB | ||
| 002 The SELECT Function_en.vtt | 7.1 KB | ||
| 002 Understanding SQL.mp4 | 12.6 MB | ||
| 002 Understanding SQL_en.vtt | 1.3 KB | ||
| 002 Using Aggregate Functions.mp4 | 11.5 MB | ||
| 002 Using Aggregate Functions_en.vtt | 1.5 KB | ||
| 002 What Type is That Value.mp4 | 13.5 MB | ||
| 002 What Type is That Value_en.vtt | 2.7 KB | ||
| 002 What you should know before watching this course.mp4 | 2.7 MB | ||
| 002 What you should know before watching this course_en.vtt | 1.5 KB | ||
| 003 Aggregating DISTINCT Values.mp4 | 12.8 MB | ||
| 003 Aggregating DISTINCT Values_en.vtt | 2.1 KB | ||
| 003 Analyzing a query with WHERE clauses and indexes.mp4 | 27.3 MB | ||
| 003 Analyzing a query with WHERE clauses and indexes_en.vtt | 3.3 KB | ||
| 003 Creating a View.mp4 | 20.7 MB | ||
| 003 Creating a View_en.vtt | 2.4 KB | ||
| 003 Example Timestamps.mp4 | 33.2 MB | ||
| 003 Example Timestamps_en.vtt | 3.9 KB | ||
| 003 Function overloading.mp4 | 40 MB | ||
| 003 Function overloading_en.vtt | 6 KB | ||
| 003 Hash indexes.mp4 | 5.5 MB | ||
| 003 Hash indexes_en.vtt | 1.7 KB | ||
| 003 How to use the Exercise files.mp4 | 6.2 MB | ||
| 003 How to use the Exercise files_en.vtt | 1.1 KB | ||
| 003 Hstore for key-value pairs.mp4 | 45.5 MB | ||
| 003 Hstore for key-value pairs_en.vtt | 7.1 KB | ||
| 003 INSERT, UPDATE and DELETE Functions.mp4 | 27.6 MB | ||
| 003 INSERT, UPDATE and DELETE Functions_en.vtt | 4.3 KB | ||
| 003 Inserting Rows.mp4 | 26.6 MB | ||
| 003 Inserting Rows_en.vtt | 3.5 KB | ||
| 003 Integer Division.mp4 | 13.2 MB | ||
| 003 Integer Division_en.vtt | 2.3 KB | ||
| 003 Partitioning data.mp4 | 54.4 MB | ||
| 003 Partitioning data_en.vtt | 9.5 KB | ||
| 003 Performance.mp4 | 25.3 MB | ||
| 003 Performance_en.vtt | 3.2 KB | ||
| 003 Relating Multiple Tables.mp4 | 47 MB | ||
| 003 Relating Multiple Tables_en.vtt | 5.6 KB | ||
| 003 Selecting Part Of A String.mp4 | 23.8 MB | ||
| 003 Selecting Part Of A String_en.vtt | 3.8 KB | ||
| 003 Sort SQL results with ORDER BY.mp4 | 17.9 MB | ||
| 003 Sort SQL results with ORDER BY_en.vtt | 2 KB | ||
| 003 The SELECT Statement.mp4 | 39.9 MB | ||
| 003 The SELECT Statement_en.vtt | 6.4 KB | ||
| 003 Understand the demo database.mp4 | 20.5 MB | ||
| 003 Understand the demo database_en.vtt | 1.8 KB | ||
| 003 Using the exercise files.mp4 | 1.5 MB | ||
| 003 Using the exercise files_en.vtt | 921.6 B | ||
| 004 Analyzing a query with a join.mp4 | 52.5 MB | ||
| 004 Analyzing a query with a join_en.vtt | 6.6 KB | ||
| 004 Change report headings with alias.mp4 | 27.2 MB | ||
| 004 Change report headings with alias_en.vtt | 3 KB | ||
| 004 Creating a Joined View.mp4 | 27.8 MB | ||
| 004 Creating a Joined View_en.vtt | 2.9 KB | ||
| 004 Deleting Rows.mp4 | 16.2 MB | ||
| 004 Deleting Rows_en.vtt | 2.3 KB | ||
| 004 Function volatility.mp4 | 15.5 MB | ||
| 004 Function volatility_en.vtt | 5.1 KB | ||
| 004 GiST and SP-GiST indexes.mp4 | 7.7 MB | ||
| 004 GiST and SP-GiST indexes_en.vtt | 2.4 KB | ||
| 004 JSON for semi-structured data.mp4 | 63.7 MB | ||
| 004 JSON for semi-structured data_en.vtt | 9.2 KB | ||
| 004 Join tables.mp4 | 36.9 MB | ||
| 004 Join tables_en.vtt | 7.8 KB | ||
| 004 Materialized views.mp4 | 48.9 MB | ||
| 004 Materialized views_en.vtt | 9.7 KB | ||
| 004 Removing Spaces.mp4 | 10.3 MB | ||
| 004 Removing Spaces_en.vtt | 1.8 KB | ||
| 004 Rounding Numbers.mp4 | 8.8 MB | ||
| 004 Rounding Numbers_en.vtt | 1.3 KB | ||
| 004 Selecting Rows.mp4 | 23.5 MB | ||
| 004 Selecting Rows_en.vtt | 2.8 KB | ||
| 005 Challenge Design a data model for analytics.mp4 | 6.8 MB | ||
| 005 Challenge Design a data model for analytics_en.vtt | 1.9 KB | ||
| 005 Challenge Optimize a query using an explain plan.mp4 | 4.3 MB | ||
| 005 Challenge Optimize a query using an explain plan_en.vtt | 614.4 B | ||
| 005 Filter data.mp4 | 47.7 MB | ||
| 005 Filter data_en.vtt | 7.6 KB | ||
| 005 Folding Case.mp4 | 16.5 MB | ||
| 005 Folding Case_en.vtt | 2.7 KB | ||
| 005 GIN and BRIN indexes.mp4 | 16.2 MB | ||
| 005 GIN and BRIN indexes_en.vtt | 5.5 KB | ||
| 005 Hierarchical data and ltrees.mp4 | 91.9 MB | ||
| 005 Hierarchical data and ltrees_en.vtt | 13.5 KB | ||
| 005 PLPython functions.mp4 | 14.5 MB | ||
| 005 PLPython functions_en.vtt | 5.2 KB | ||
| 005 Selecting Columns.mp4 | 14.7 MB | ||
| 005 Selecting Columns_en.vtt | 1.6 KB | ||
| 005 The NULL Value.mp4 | 43.1 MB | ||
| 005 The NULL Value_en.vtt | 5.6 KB | ||
| 006 Aggregate data.mp4 | 52 MB | ||
| 006 Aggregate data_en.vtt | 8.6 KB | ||
| 006 Challenge Choosing an optimal indexing strategy.mp4 | 5.5 MB | ||
| 006 Challenge Choosing an optimal indexing strategy_en.vtt | 819.2 B | ||
| 006 Challenge Design a table to support unstructured data.mp4 | 4.1 MB | ||
| 006 Challenge Design a table to support unstructured data_en.vtt | 614.4 B | ||
| 006 Constraining Columns.mp4 | 34.2 MB | ||
| 006 Constraining Columns_en.vtt | 5.1 KB | ||
| 006 Counting Rows.mp4 | 13.8 MB | ||
| 006 Counting Rows_en.vtt | 2.1 KB | ||
| 006 Solution Design a data model for analytics.mp4 | 12 MB | ||
| 006 Solution Design a data model for analytics_en.vtt | 3.2 KB | ||
| 007 Changing A Schema.mp4 | 19.5 MB | ||
| 007 Changing A Schema_en.vtt | 2.8 KB | ||
| 007 Inserting Data.mp4 | 15.6 MB | ||
| 007 Inserting Data_en.vtt | 1.9 KB | ||
| 007 Solution Choosing an optimal indexing strategy.mp4 | 5.8 MB | ||
| 007 Solution Choosing an optimal indexing strategy_en.vtt | 1.8 KB | ||
| 007 Solution Design a table to support unstructured data.mp4 | 14.9 MB | ||
| 007 Solution Design a table to support unstructured data_en.vtt | 2.7 KB | ||
| 007 Window functions.mp4 | 13 MB | ||
| 007 Window functions_en.vtt | 2.7 KB | ||
| 008 ID Columns.mp4 | 24.4 MB | ||
| 008 ID Columns_en.vtt | 3.9 KB | ||
| 008 Subqueries.mp4 | 31.1 MB | ||
| 008 Subqueries_en.vtt | 6.1 KB | ||
| 008 Updating Data.mp4 | 17.8 MB | ||
| 008 Updating Data_en.vtt | 2.3 KB | ||
| 009 Deleting Data.mp4 | 9.4 MB | ||
| 009 Deleting Data_en.vtt | 1.3 KB | ||
| 009 Filtering Data.mp4 | 61.2 MB | ||
| 009 Filtering Data_en.vtt | 7.1 KB | ||
| 009 Rolling calculations.mp4 | 36.2 MB | ||
| 009 Rolling calculations_en.vtt | 6.6 KB | ||
| 010 Analyze employee data.mp4 | 33.7 MB | ||
| 010 Analyze employee data_en.vtt | 6.1 KB | ||
| 010 Removing Duplicates.mp4 | 26.3 MB | ||
| 010 Removing Duplicates_en.vtt | 3.3 KB | ||
| 011 Date and time functions.mp4 | 39.6 MB | ||
| 011 Date and time functions_en.vtt | 7.6 KB | ||
| 011 Ordering Output.mp4 | 29.4 MB | ||
| 011 Ordering Output_en.vtt | 3.8 KB | ||
| 012 Conditional Expressions.mp4 | 19.8 MB | ||
| 012 Conditional Expressions_en.vtt | 2.9 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 216 total files | |||
Master SQL For Data Science | 2022
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.64 GB | Duration: 6h 26m
Become SQL WIZARD for Data Science, Machine Learning, Business Analysis, Data Analysis, etc.
What you'll learn
Master the most essential SQL skills for Data Science
Write complex SQL statements to query the database and gain critical insight on data
Learn how to professionally query large industry database
How databases are organized
Learn how to creating simple to complex tables and databases in SQL
Learn how to build applications using CRUD functions
Automating data with triggers
Using aggregate functions and transactions
Lear SQLite and Postgresql
Requirements
This is a Begginer to Advanced level course and no experience or prerequisite needed
Just a passion to learn is enough to get started !!
Description
This course will make you super confident to query databases without any fear. By the end of this course, you will be able to use SQL to fetch data and draw insights from it like a genius. You will also learn the professional ways of reporting insights with SQL.
The course is taught by 4 experience Data Scientist, Data Analyst, Machine Learning Engineer and a Business Analyst in top MNC like IBM.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.2 GB | freecoursewb | 2 weeks | 14 | 2 | |
| 1.3 GB | freecoursewb | 3 weeks | 14 | 10 | |
|
Udemy - LoadRunner Essentials - Master Performance Testing and Analysis Posted by
freecoursewb in Other
|
942.4 MB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Master AI Prompt Writing - Content, Branding and Productivity Posted by
freecoursewb in Other
|
1.2 GB | freecoursewb | 4 weeks | 23 | 9 |
| 561.9 MB | freecoursewb | 4 weeks | 8 | 6 |
All Comments