17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
SQL For Newcomers - The Full Mastery Course
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
I’m Sameh Sharaf. I am a data engineer. I have worked on data since 2010 so I guess I can say I’m experienced enough.
This course will teach you how to use SQL (Structured Query Language), a language so prominent for relational databases, databases such as MySQL, PostgreSQL, SQLlite and more.
SQL now is a great skill to have if you want to work as a data analyst, data scientist, BI developer, data engineer, database administrator or even a software developer/engineer, since all these jobs need to use databases and data in a daily basis.
I’m a beginner, is this course for me?
Sure! This course was done for beginners. Even students with experience in SQL may find it useful too to memorize some keywords and functions, as well as learning more about the bits they may miss.
Is there any prerequisites to attend this course?
The only thing you need is a PC or laptop with average performance and any operating system installed on. We’ll be using Windows 10 for this course but the OS does not matter since the tech we’ll be using is cross-platform and can work on Linux and Mac.
Who this course is for:
Students aspiring to become data analysts, scientists or engineers
Junior data analysts and scientists.
Junior developers who need to work on relational databases.
Undergraduate students who study relational databases in their curriculum.
Anyone who’s interested to learn SQL and add it to their resume.
Requirements
Have a PC or laptop to work on. Your old clunky notebook will do.
Can work on any operating system (Windows, Linux & MacOS).
Last Updated 4/2019
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
TutsNode.net.txt
63 B
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/1. Introduction/1. Introduction.srt
1.7 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/1. Introduction/2. Tools Used in This Course.srt
1.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/1. Character Functions - UPPER, LOWER & INITCAP.srt
8.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/2. Character Functions - CONCAT & LENGTH.srt
11.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/3. Character Functions - LPAD & RPAD.srt
15.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/5. Character Functions - REPLACE.srt
10.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/6. Character Functions - SUBSTR.srt
9.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/7. Number Functions - MOD & ROUND.srt
13 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/8. Number Functions - TRUNC.srt
8.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/11. Nested Queries/1. Selectception A Select Query Inside Another Select Query!.srt
7.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/1. Auto Data Conversion in SQL.srt
11.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/2. Cast Date to Character.srt
11.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/3. Cast Number to Character.srt
12.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/4. Cast Timestamp to Character.srt
8.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/5. Cast Character to Number.srt
9.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/6. Cast Character to Date & Timestamp.srt
11.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/2. Entity Relationship Diagram (ERD).srt
10.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/3. Cartesian Join.srt
11.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/4. Table Aliases with Joins.srt
8.2 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/5. Why I Don't Recommend Cartesian Joins.srt
9.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/6. Inner Join.srt
6.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/8. Outer Join - Right, Left & Full.srt
10.2 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/1. INSERT a New Record to a Table.srt
9.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/10. Insert Records with Nested Select Queries.srt
6.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/2. Insert Without Specifying Column Names.srt
10.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/3. UPDATE a Record's Field Values.srt
8.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/4. CAUTION! How an UPDATE Query Can Go Wrong.srt
5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/4.1 emp_dept.sql
66.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/5. Update a Record Using Single-Row Functions.srt
5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/8. Solution Extract Employee's Email Address.srt
15 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/9. DELETE a Table's Record.srt
6.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/9.1 emp_dept.sql
66.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/1. SQL Data Types Revised.mp4
102.9 MB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/1. SQL Data Types Revised.srt
13.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/10. NOT NULL Constraint.srt
5.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/11. UNIQUE Constraint.srt
4.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/12. DEFAULT Constraint.srt
4.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/13. Foreign Keys.srt
8.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/14. Use Foreign Keys with Joins - Books & Publishers.srt
8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/15. Foreign Keys - Properties.srt
7.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/18. Create a New Table with Select Statement.srt
4.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/20. Insert New Records Using Select Statement.srt
6.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/23. Create & Use Schemas.srt
4.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/3. Create Your First Table!.srt
9.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/4. Insert Data to Your New Table.srt
8.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/5. Change Column Data Type.srt
7.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/7. Add a New Column to Table.srt
4.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/9. Primary Keys.srt
15.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/6. User Groups.srt
5.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/1. Download PostgreSQL.srt
2 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/2. Install PostgreSQL.srt
2.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/3. Download SQLectron.srt
1.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/4. Install SQLectron.srt
432 B
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/5. Connect to PostgreSQL - Credentials.srt
1.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/6. Connect to PostgreSQL Using SQLectron.srt
1.6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/7. Import Course Data Using SQLectron.srt
2.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/7.1 emp_dept.sql
66.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/8. FOR WINDOWS 32-BIT USERS SQL Alternative - DBeaver.html
835 B
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/9. FOR WINDOWS 32-BIT USERS Download, Install, Configure & Import Data.srt
8.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/9.1 emp_dept.sql
76.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/1. Check Imported Data.srt
6 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/10. Another Query Filtering by Date.srt
1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/12. More Filtering by Strings.srt
5.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/13. More Filtering by Strings 2.srt
10 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/14. More Filtering by Strings 3.srt
1.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/2. So.. What is a Database.srt
1.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/3. SQL Data Types.srt
2.2 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/4. Finally Some Fun! Extracting Data Based on Requirements.srt
1.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/5. Filtering Data using WHERE Keyword.srt
9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/6. Filter Data by Range Using BETWEEN.srt
2.7 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/8. Filter Data by Date.srt
5.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/1. AND Operator.srt
9.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/2. OR Operator.srt
11.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/3. NOT Operator.srt
8.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/4. AND, OR & NOT Operators Which Has The Highest Priority.srt
6.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/1. Basic Math Operations.srt
5.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/3. It's Payday! Calculate The Net Salary for Employees.srt
6.7 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/4. Filter Data with Math Equations.srt
2.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/6. String Concatenation/1. Concatenate Strings with '' Operator.srt
6.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/6. String Concatenation/2. Concatenate Strings with Numbers.srt
1.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/1. Give Your Report Fields A Cool Name.srt
4.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/2. A Report for Payroll.srt
7.2 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/3. Order Records by Column.srt
6.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/4. Order Records by Multiple Columns.srt
12.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/5. How Alias Names Cannot Be Used with WHERE.srt
2 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/6. LIMIT Record Count Fetched by Your Query.srt
8.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/1. Fetch A Field's Unique Values Using DISTINCT.srt
2.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/2. Using DISTINCT Keyword with Multiple Columns.srt
6.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/3. What is a NULL Value Anyway.srt
5.7 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/4. Build More Sophisticated Queries with CASE Statements.srt
10.1 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/5. Your Knowledge So Far Under A Great Test.srt
10.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/1. Let Me Introduce You to Functions.srt
4.4 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/10. Filter By Aggregate Functions with HAVING Clause.srt
8.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/2. SUM Function.srt
4.5 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/4. COUNT Function.srt
7.3 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/7. GROUP BY Clause Use Functions with Dimensions.srt
5.8 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/8. GROUP BY More Than One Dimension.srt
4.9 KB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/9. Now For Some Tough Workout.srt
