SQL for Newcomers - The Full Mastery...

Description

“Wow! I really regret learning SQL”

– No one ever

Hi!

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

Files (374)

[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/1. SQL Data Types Revised.mp4102.89 MiB
TutsNode.net.txt63 B
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/9.1 emp_dept.sql76.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/1. Introduction/1. Introduction.srt1.67 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/9. Primary Keys.srt15.5 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/1. Introduction/2. Tools Used in This Course.srt1.32 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/3. Character Functions - LPAD & RPAD.srt15.06 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/1. Download PostgreSQL.srt1.97 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/7.1 emp_dept.sql66.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/2. Install PostgreSQL.srt2.37 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/4.1 emp_dept.sql66.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/3. Download SQLectron.srt1.55 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/9.1 emp_dept.sql66.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/4. Install SQLectron.srt432 B
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/8. Solution Extract Employee's Email Address.srt15.02 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/5. Connect to PostgreSQL - Credentials.srt1.62 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/1. SQL Data Types Revised.srt13.92 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/6. Connect to PostgreSQL Using SQLectron.srt1.64 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/7. Number Functions - MOD & ROUND.srt13 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/7. Import Course Data Using SQLectron.srt2.39 KiB
[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.srt12.85 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/8. FOR WINDOWS 32-BIT USERS SQL Alternative - DBeaver.html835 B
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/3. Cast Number to Character.srt12.35 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/6. Cast Character to Date & Timestamp.srt11.63 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/1. Auto Data Conversion in SQL.srt11.43 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/2. Character Functions - CONCAT & LENGTH.srt11.42 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/3. Cartesian Join.srt11.42 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/2. Cast Date to Character.srt11.34 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/2. So.. What is a Database.srt1.51 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/2. OR Operator.srt11.09 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/3. SQL Data Types.srt2.2 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/2. Insert Without Specifying Column Names.srt10.82 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/4. Finally Some Fun! Extracting Data Based on Requirements.srt1.08 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/2. Entity Relationship Diagram (ERD).srt10.57 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/5. Character Functions - REPLACE.srt10.56 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/5. Your Knowledge So Far Under A Great Test.srt10.5 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/6. Filter Data by Range Using BETWEEN.srt2.74 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/8. Outer Join - Right, Left & Full.srt10.21 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/4. Build More Sophisticated Queries with CASE Statements.srt10.08 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/13. More Filtering by Strings 2.srt10.04 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/5. Cast Character to Number.srt9.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/3. Create Your First Table!.srt9.63 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/6. Character Functions - SUBSTR.srt9.62 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/9. Now For Some Tough Workout.srt9.46 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/10. Another Query Filtering by Date.srt1.01 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/1. AND Operator.srt9.39 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/1. INSERT a New Record to a Table.srt9.25 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/5. Why I Don't Recommend Cartesian Joins.srt9.1 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/5. Filtering Data using WHERE Keyword.srt9.01 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/10. Filter By Aggregate Functions with HAVING Clause.srt8.92 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/3. NOT Operator.srt8.92 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/13. Foreign Keys.srt8.81 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/14. More Filtering by Strings 3.srt1.4 KiB
[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.srt8.79 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/8. Number Functions - TRUNC.srt8.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/4. Cast Timestamp to Character.srt8.34 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/3. UPDATE a Record's Field Values.srt8.33 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/4. Insert Data to Your New Table.srt8.29 KiB
[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.srt8.29 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/1. Character Functions - UPPER, LOWER & INITCAP.srt8.25 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/4. Table Aliases with Joins.srt8.23 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/14. Use Foreign Keys with Joins - Books & Publishers.srt7.95 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/15. Foreign Keys - Properties.srt7.91 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/5. Change Column Data Type.srt7.48 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/11. Nested Queries/1. Selectception A Select Query Inside Another Select Query!.srt7.46 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/4. COUNT Function.srt7.26 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/2. A Report for Payroll.srt7.25 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/20. Insert New Records Using Select Statement.srt6.95 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/10. Insert Records with Nested Select Queries.srt6.93 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/6. Inner Join.srt6.86 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/4. Filter Data with Math Equations.srt2.53 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/9. DELETE a Table's Record.srt6.85 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/3. It's Payday! Calculate The Net Salary for Employees.srt6.74 KiB
[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.srt6.53 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/6. String Concatenation/2. Concatenate Strings with Numbers.srt1.86 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/2. Using DISTINCT Keyword with Multiple Columns.srt6.33 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/3. Order Records by Column.srt6.1 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/6. String Concatenation/1. Concatenate Strings with '' Operator.srt6.09 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/1. Check Imported Data.srt6.03 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/7. GROUP BY Clause Use Functions with Dimensions.srt5.83 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/8. Filter Data by Date.srt5.8 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/3. What is a NULL Value Anyway.srt5.65 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/6. User Groups.srt5.54 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/1. Basic Math Operations.srt5.34 KiB
[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.srt2.02 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/12. More Filtering by Strings.srt5.25 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/10. NOT NULL Constraint.srt5.07 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/5. Update a Record Using Single-Row Functions.srt5.05 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/1. Fetch A Field's Unique Values Using DISTINCT.srt2.5 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/4. CAUTION! How an UPDATE Query Can Go Wrong.srt5.02 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/8. GROUP BY More Than One Dimension.srt4.92 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/18. Create a New Table with Select Statement.srt4.88 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/23. Create & Use Schemas.srt4.85 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/11. UNIQUE Constraint.srt4.62 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/12. DEFAULT Constraint.srt4.58 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/7. Add a New Column to Table.srt4.55 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/2. SUM Function.srt4.45 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/1. Let Me Introduce You to Functions.srt4.45 KiB
[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.srt4.34 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/2. Bookstore Data Set Let's Move It to Database.srt4.32 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/4. Character Functions - TRIM.srt4.2 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/3. AVG (Average) Function.srt4.1 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/11. Filter Data by Strings (Names, Addresses, ...).srt4.08 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/2. Modulo Operator.srt4.03 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/15. How to Ignore Caps when Filtering by String.srt3.99 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/2. Create User.srt3.93 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/6. Rename Column.srt3.86 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/1. UNION.srt3.82 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/7. Filter Data by Set of Values Using IN.srt3.79 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/6. How To Count Your Field's Unique Values.srt3.74 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/5. MIN & MAX Functions.srt3.57 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/21. Views.srt3.52 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/4. Grant Insert & Update to User.srt3.43 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/7. In-Depth Look into Join Types in SQL.srt3.35 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/19. A Trick to Create an Empty Table with Select Statement.srt3.34 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/1. Employees & Departments Tables Revised.srt3.3 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/9. More Filtering by Date.srt3.25 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/3. Grant SELECT to User.srt2.83 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/2. UNION ALL.srt2.24 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/3. Important Note about Combining Queries.srt2.17 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/5. Revoke Privilege from User.srt2.08 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/6. A Good Exercise Extract Employee's Email Address.srt1.89 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/5. EXCEPT.srt1.57 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/22. Schemas.srt1.55 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/1. Introduction to Access Control.srt1.45 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/8. Constraints in SQL.srt1.27 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/4. INTERSECT.srt1.26 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/7. Hints on How to Extract Employee's Email Address.html1.21 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/17. DROP Table.srt1.19 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/16. Drop Column.srt704 B
[TGx]Downloaded from torrentgalaxy.to .txt585 B
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/8.1 employees_fl.sql108 B
.pad/0124.93 KiB
[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.mp4102.22 MiB
.pad/1799.38 KiB
[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.mp487.15 MiB
.pad/2874.44 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/9. Primary Keys.mp474.73 MiB
.pad/3275.29 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/8. Solution Extract Employee's Email Address.mp465.5 MiB
.pad/4509.28 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/2. OR Operator.mp465.09 MiB
.pad/5933.54 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/5. Filtering Data using WHERE Keyword.mp464.2 MiB
.pad/6821.29 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/5. Your Knowledge So Far Under A Great Test.mp463.68 MiB
.pad/7331.21 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/3. Character Functions - LPAD & RPAD.mp462.67 MiB
.pad/8338.53 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/1. AND Operator.mp458.87 MiB
.pad/9132.56 KiB
[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.mp456.26 MiB
.pad/10758.61 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/8. Outer Join - Right, Left & Full.mp455.68 MiB
.pad/11330.5 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/3. Order Records by Column.mp455.27 MiB
.pad/12748.65 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/13. More Filtering by Strings 2.mp451.8 MiB
.pad/13203.83 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/10. Filter By Aggregate Functions with HAVING Clause.mp451.36 MiB
.pad/14657.53 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/9. Now For Some Tough Workout.mp447.99 MiB
.pad/1511.24 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/1. Auto Data Conversion in SQL.mp446.41 MiB
.pad/16605.86 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/4. Build More Sophisticated Queries with CASE Statements.mp446.22 MiB
.pad/17794.21 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/7. Tidy Up Your Results Sorting, Alias Names, Limit Records/2. A Report for Payroll.mp444.92 MiB
.pad/1887.02 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/3. Cartesian Join.mp444.49 MiB
.pad/19519.51 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/2. Character Functions - CONCAT & LENGTH.mp443.23 MiB
.pad/20792.73 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/4. Filter Data with AND, OR, NOT Operators/3. NOT Operator.mp441.44 MiB
.pad/21576.37 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/8. Filter Data by Date.mp441.14 MiB
.pad/22881.5 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/5. Why I Don't Recommend Cartesian Joins.mp440.59 MiB
.pad/23419.41 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/5. Character Functions - REPLACE.mp439.24 MiB
.pad/24781.18 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/13. Foreign Keys.mp438.32 MiB
.pad/25700.23 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/2. Insert Without Specifying Column Names.mp438.06 MiB
.pad/26965.33 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/4. Insert Data to Your New Table.mp436.94 MiB
.pad/2760.14 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/2. Cast Date to Character.mp436.78 MiB
.pad/28226.7 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/4. Table Aliases with Joins.mp435.4 MiB
.pad/29616.94 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/1. Check Imported Data.mp434.69 MiB
.pad/30313.03 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/1. INSERT a New Record to a Table.mp434.24 MiB
.pad/31774.56 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/6. Inner Join.mp434.18 MiB
.pad/32836.1 KiB
[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.mp434.1 MiB
.pad/33917.75 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/2. Using DISTINCT Keyword with Multiple Columns.mp432.58 MiB
.pad/34426.32 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/3. UPDATE a Record's Field Values.mp431.45 MiB
.pad/35567.66 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/4. CAUTION! How an UPDATE Query Can Go Wrong.mp431.43 MiB
.pad/36586.23 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/14. Use Foreign Keys with Joins - Books & Publishers.mp429.53 MiB
.pad/37482.43 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/12. More Filtering by Strings.mp429.3 MiB
.pad/38720.52 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/3. Cast Number to Character.mp429.15 MiB
.pad/39869.96 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/11. Filter Data by Strings (Names, Addresses, ...).mp429.15 MiB
.pad/40873.98 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/15. Foreign Keys - Properties.mp429.11 MiB
.pad/41908.85 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/8. GROUP BY More Than One Dimension.mp428.47 MiB
.pad/42538.79 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/3. It's Payday! Calculate The Net Salary for Employees.mp428.21 MiB
.pad/43805.64 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/9. More Filtering by Date.mp428.2 MiB
.pad/44815.49 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/3. Create Your First Table!.mp427.62 MiB
.pad/45384.43 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/1. Character Functions - UPPER, LOWER & INITCAP.mp427.46 MiB
.pad/46557.68 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/7. Number Functions - MOD & ROUND.mp427.39 MiB
.pad/47621.03 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/6. User Groups.mp427.36 MiB
.pad/48658.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/2. Install PostgreSQL.mp426.63 MiB
.pad/49374.55 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/3. What is a NULL Value Anyway.mp425.76 MiB
.pad/50245.54 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/5. Change Column Data Type.mp425.31 MiB
.pad/51705.5 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/20. Insert New Records Using Select Statement.mp425.18 MiB
.pad/52837.85 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/18. Create a New Table with Select Statement.mp424.94 MiB
.pad/5364 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/10. Insert Records with Nested Select Queries.mp424.68 MiB
.pad/54322.98 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/11. Nested Queries/1. Selectception A Select Query Inside Another Select Query!.mp424.51 MiB
.pad/55505.96 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/6. Cast Character to Date & Timestamp.mp423.99 MiB
.pad/569.77 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/5. Cast Character to Number.mp423.83 MiB
.pad/57173.35 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/7. Import Course Data Using SQLectron.mp423.68 MiB
.pad/58326.03 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/9. DELETE a Table's Record.mp423.41 MiB
.pad/59599.63 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/4. Grant Insert & Update to User.mp423.04 MiB
.pad/60985.5 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/12. DEFAULT Constraint.mp423.01 MiB
.pad/611012.17 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/12. Casting & Data Conversion/4. Cast Timestamp to Character.mp422.56 MiB
.pad/62447.75 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/2. Bookstore Data Set Let's Move It to Database.mp422.34 MiB
.pad/63675.87 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/2. Entity Relationship Diagram (ERD).mp422.25 MiB
.pad/64765.13 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/4. COUNT Function.mp422.15 MiB
.pad/65875.47 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/7. Add a New Column to Table.mp421.89 MiB
.pad/66110.41 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/6. Character Functions - SUBSTR.mp421.88 MiB
.pad/67124.37 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/10. NOT NULL Constraint.mp421.71 MiB
.pad/68293.65 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/11. UNIQUE Constraint.mp421.69 MiB
.pad/69313.46 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/7. GROUP BY Clause Use Functions with Dimensions.mp421.36 MiB
.pad/70652.09 KiB
[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.mp421.24 MiB
.pad/71783.23 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/8. Number Functions - TRUNC.mp420.51 MiB
.pad/72502.26 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/23. Create & Use Schemas.mp420.19 MiB
.pad/73827.76 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/1. Download PostgreSQL.mp419.8 MiB
.pad/74202.67 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/7. Filter Data by Set of Values Using IN.mp419.29 MiB
.pad/75723.86 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/1. Employees & Departments Tables Revised.mp418.86 MiB
.pad/76141.15 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/6. String Concatenation/1. Concatenate Strings with '' Operator.mp418.85 MiB
.pad/77158.36 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/1. UNION.mp418.53 MiB
.pad/78481.33 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/15. How to Ignore Caps when Filtering by String.mp417.86 MiB
.pad/79141.08 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/6. Filter Data by Range Using BETWEEN.mp417 MiB
.pad/804.32 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/2. SUM Function.mp416.83 MiB
.pad/81178.67 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/3. Grant SELECT to User.mp416.27 MiB
.pad/82744.61 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/6. Rename Column.mp416.16 MiB
.pad/83855.76 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/5. Update a Record Using Single-Row Functions.mp415.41 MiB
.pad/84604.21 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/21. Views.mp415.09 MiB
.pad/85932.03 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/4. Filter Data with Math Equations.mp414.2 MiB
.pad/86819.87 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/1. Basic Math Operations.mp413.53 MiB
.pad/87477.89 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/5. EXCEPT.mp413.09 MiB
.pad/88928.46 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/2. Create User.mp412.71 MiB
.pad/89293.95 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/2. UNION ALL.mp412.66 MiB
.pad/90343.4 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/8. NULL, DISTINCT & CASE Statements/1. Fetch A Field's Unique Values Using DISTINCT.mp412.59 MiB
.pad/91420.74 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/22. Schemas.mp412.49 MiB
.pad/92520.78 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/5. Revoke Privilege from User.mp412.48 MiB
.pad/93528.57 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/5. Math Operations/2. Modulo Operator.mp412.12 MiB
.pad/94904.88 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/10. Functions in SQL Single-Row Functions/4. Character Functions - TRIM.mp411.95 MiB
.pad/9554.33 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/3. AVG (Average) Function.mp411.43 MiB
.pad/96587.23 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/3. Important Note about Combining Queries.mp411.18 MiB
.pad/97844.64 KiB
[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.mp411.17 MiB
.pad/98846.45 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/14. Joins in SQL/7. In-Depth Look into Join Types in SQL.mp411.09 MiB
.pad/99936.11 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/6. Connect to PostgreSQL Using SQLectron.mp410.91 MiB
.pad/10095.08 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/6. How To Count Your Field's Unique Values.mp410.83 MiB
.pad/101178.51 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/5. MIN & MAX Functions.mp410.78 MiB
.pad/102226.99 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/3. Download SQLectron.mp410.6 MiB
.pad/103407.18 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/9. Functions in SQL Multiple-Row Functions/1. Let Me Introduce You to Functions.mp410.29 MiB
.pad/104725.78 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/19. A Trick to Create an Empty Table with Select Statement.mp49.44 MiB
.pad/105576.36 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/1. Introduction/1. Introduction.mp48.79 MiB
.pad/106217 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/15. Data Manipulation (DML)/6. A Good Exercise Extract Employee's Email Address.mp47.81 MiB
.pad/107191.52 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/14. More Filtering by Strings 3.mp47.57 MiB
.pad/108436.22 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/10. Another Query Filtering by Date.mp47.54 MiB
.pad/109475.35 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/2. So.. What is a Database.mp47.47 MiB
.pad/110540.89 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/8. Constraints in SQL.mp47.23 MiB
.pad/111784.64 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/5. Connect to PostgreSQL - Credentials.mp46.43 MiB
.pad/112588.4 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/6. String Concatenation/2. Concatenate Strings with Numbers.mp46.02 MiB
.pad/1131002.51 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/2. Setting Up Course Tools/4. Install SQLectron.mp45.75 MiB
.pad/114251.37 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/13. Combination Relationships/4. INTERSECT.mp45.22 MiB
.pad/115796.24 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/17. DROP Table.mp44.93 MiB
.pad/11673.61 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/4. Finally Some Fun! Extracting Data Based on Requirements.mp44.6 MiB
.pad/117412.92 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/3. Browsing & Filtering Data/3. SQL Data Types.mp44.44 MiB
.pad/118574.91 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/1. Introduction/2. Tools Used in This Course.mp43.92 MiB
.pad/11986.94 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/16. SQL Data Definition Language (DDL)/16. Drop Column.mp43.91 MiB
.pad/12087.53 KiB
[TutsNode.net] - SQL for Newcomers - The Full Mastery Course/17. Access Control/1. Introduction to Access Control.mp43.81 MiB

SQL for Newcomers - The Full Mastery Course

Continue browsing

Description

Files (374)