| 0 | 906 KB | ||
| 1. Basic Select Statements.mp4 | 125.5 MB | ||
| 1. Create Database Command.mp4 | 28.1 MB | ||
| 1. Data Types - Integers.mp4 | 163.4 MB | ||
| 1. Installing MySQL Server and Workbench.mp4 | 214.2 MB | ||
| 1. Introduction.mp4 | 111.5 MB | ||
| 1. SubQueries Introduction.mp4 | 97.7 MB | ||
| 1. Table Join Example.mp4 | 124.3 MB | ||
| 1. [BONUS LECTURE] - Other Courses.html | 1.1 KB | ||
| 1 | 756.6 KB | ||
| 1.1 Course Materials.html | 102.4 B | ||
| 1.1 Installing MySQL on a Mac.html | 102.4 B | ||
| 1.2 DareData Website.html | 102.4 B | ||
| 1.2 Installing MySQL on Ubuntu.html | 204.8 B | ||
| 1.3 LinkedIn.html | 102.4 B | ||
| 1.3 MySQL Community Download.html | 102.4 B | ||
| 2 | 865.1 KB | ||
| 3 | 650.3 KB | ||
| 4 | 250 KB | ||
| 5 | 446.5 KB | ||
| 6 | 183 KB | ||
| 7 | 677.2 KB | ||
| 8 | 926.1 KB | ||
| 9 | 547.7 KB | ||
| 10. Query Clauses - Having.mp4 | 66.6 MB | ||
| 10. [Case Study] - Code Along Solutions.mp4 | 146.6 MB | ||
| 11. Query Clauses - Order By.mp4 | 97.6 MB | ||
| 12. Quiz - Basic Querying.html | 204.8 B | ||
| 13. [Case Study] - Basic Querying.mp4 | 40.9 MB | ||
| 14. [Case Study] - Code Along Solutions.mp4 | 248.3 MB | ||
| 15. [Coding Exercise 1] - Basic Querying.html | 204.8 B | ||
| 16. [Coding Exercise 2] - Basic Querying.html | 204.8 B | ||
| 17. [Coding Exercise 3] - Basic Querying.html | 204.8 B | ||
| 18. [Coding Exercise 4] - Basic Querying.html | 204.8 B | ||
| 19. [Coding Exercise 5] - Basic Querying.html | 204.8 B | ||
| 2. Column and Table Aliases.mp4 | 58.1 MB | ||
| 2. Course Materials.html | 204.8 B | ||
| 2. Creating Tables.mp4 | 122.4 MB | ||
| 2. Data Types - DecimalsFloats.mp4 | 95 MB | ||
| 2. Inner Join Explanation.mp4 | 95.9 MB | ||
| 2. More on SubQueries.mp4 | 120.3 MB | ||
| 2. Setting up the Sakila Database.mp4 | 71.6 MB | ||
| 3. Combining Insert Into and Select Statements.mp4 | 82.1 MB | ||
| 3. Data Types - Text and Characters.mp4 | 100.1 MB | ||
| 3. Inserting Data into a Table.mp4 | 79.6 MB | ||
| 3. Left and Right Join Explanation.mp4 | 135.1 MB | ||
| 3. Table Filtering - Simple Filters.mp4 | 70.4 MB | ||
| 4. Data Types - Dates.mp4 | 66.4 MB | ||
| 4. Insert Into and Select with Multiple Columns.mp4 | 59.1 MB | ||
| 4. Inserting Multiple Rows and Inserting Into Specific Columns.mp4 | 89.2 MB | ||
| 4. Multiple Key Joins - Composite Key Definition.mp4 | 57.1 MB | ||
| 4. Table Filtering - Multiple Filters, AND and OR.mp4 | 52.6 MB | ||
| 5. Common Pitfalls when Inserting Data.mp4 | 75.7 MB | ||
| 5. Data Types - Implicit Conversions.mp4 | 66.3 MB | ||
| 5. Multiple Key Joins - Explanation and Syntax.mp4 | 140.3 MB | ||
| 5. Table Filtering - Other Concepts.mp4 | 90.8 MB | ||
| 6. Creating New Columns - Same Value for all Rows.mp4 | 34.1 MB | ||
| 6. Data Types - Explicit Conversions.mp4 | 86.2 MB | ||
| 6. Deleting Data and Tables.mp4 | 79.1 MB | ||
| 6. Union and Union All.mp4 | 124.2 MB | ||
| 7. Alter Table - Changing and Modifying Tables.mp4 | 145.8 MB | ||
| 7. Creating New Columns - Using Functions and Existing Columns.mp4 | 100.9 MB | ||
| 7. Quiz - Combining Tables.html | 204.8 B | ||
| 7. Quiz - Data Types.html | 204.8 B | ||
| 8. Creating New Columns - Mathematical Expressions.mp4 | 66.7 MB | ||
| 8. Quiz - Creating and Modifying Tables.html | 204.8 B | ||
| 8. [Case Study] - Combining Tables.mp4 | 58.1 MB | ||
| 8. [Case Study] - Data Types.mp4 | 41.7 MB | ||
| 9. Query Clauses - Group By.mp4 | 155.8 MB | ||
| 9. [Case Study] - Code Along Solutions.mp4 | 83.8 MB | ||
| 9. [Case Study] - Creating and Modifying Tables.mp4 | 42.8 MB | ||
| TutsNode.com.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| 10 | 727.1 KB | ||
| 11 | 816.1 KB | ||
| 12 | 577.1 KB | ||
| 13 | 745.2 KB | ||
| 14 | 515.8 KB | ||
| 15 | 56 KB | ||
| 16 | 932.8 KB | ||
| 17 | 325.5 KB | ||
| 18 | 418.5 KB | ||
| 19 | 145.6 KB | ||
| 20 | 45.8 KB | ||
| 21 | 190.2 KB | ||
| 22 | 859.4 KB | ||
| 23 | 828.5 KB | ||
| 24 | 240.7 KB | ||
| 25 | 956.1 KB | ||
| 26 | 423.8 KB | ||
| 27 | 956.6 KB | ||
| 28 | 272.8 KB | ||
| 29 | 405.3 KB | ||
| 30 | 577.7 KB | ||
| 31 | 281.5 KB | ||
| 32 | 387.7 KB | ||
| 33 | 587.9 KB | ||
| 34 | 697.1 KB | ||
| 35 | 949 KB | ||
| 36 | 943.2 KB | ||
| 37 | 960 KB | ||
| 38 | 879.2 KB | ||
| 39 | 446.1 KB | ||
| 40 | 238.8 KB | ||
| 41 | 351.3 KB | ||
| 42 | 128.7 KB | ||
| 43 | 878.4 KB | ||
| ▲ 108 total files | |||
Description
So, you’ve decided that you want to learn SQL or you want to get familiar with it, but don’t know where to start? Or are you a data/business analyst or data scientist that wants to power up your data skills by performing queries with Structured Query Language?
Then, this course was designed just for you!
This course was designed to be your first step into the SQL programming world! We will delve deeper into the concepts of SQL queries, understand the MySQL user interface and play around with several datasets. This course contains lectures around the following groups:
Code along lectures where we will go step-by-step in each instruction, compounding our SQL knowledge.
Test your knowledge with questions and practical exercises with different levels of difficulty!
Analyze real datasets and understand the thought process from question to SQL code solution!
This course was designed to be focused on the practical side of coding in SQL – instead of teaching you every possible function out there, we’ll learn all the fundamentals slowly and build our knowledge from scratch. We’ll use a case study to cement every concept we will learn, so that you can have a hands-on learning process, making it easier to apply the concepts in your projects.
At the end of the course you should be able to use SQL to build and manipulate tables. Along the way we will also learn the most important SQL statements such as GROUP BY, INSERT INTO or CREATE TABLE.
Here are some examples of things you will be able to do after finishing the course:
Join different tables using SQL;
Create your own tables with the appropriate structure.
Use different data types according to their characteristics.
Create columns using data available from your existing tables.
Use subqueries, building complex instructions.
Join thousands of professionals and students in this SQL journey and discover the amazing power of this querying language.
This course will be constantly updated based on students feedback.
Who this course is for:
Data Analysts
Data Scientists
Data Engineers
Full Beginners that want to learn how to work with SQL
Marketing, Finance and Supply Chain Professionals
IT Professionals
Requirements
Computer with at least 4 GB of RAM
Access to the Internet
Last Updated 3/2022
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.4 GB | freecoursewb | 3 hours | 0 | 0 | |
| 274.1 MB | freecoursewb | 2 weeks | 16 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 1 month | 10 | 7 |
| 1.3 GB | freecoursewb | 1 month | 32 | 2 | |
| 258.8 MB | freecoursewb | 1 month | 0 | 0 |
All Comments