TGx:Code With Mosh | Complete SQL Mastery [FCO]

Hot Picks

New TV

First Cam

New Movies

1080p x265

Misc

Torrent details for "Code With Mosh | Complete SQL Mastery [FCO]" Log in to bookmark

Quicknav > Description Read comments 2 Post guest comment

Torrent details

Name:

Code With Mosh | Complete SQL Mastery [FCO]

Controls:

Report Torrent

Torrent verified by Prom3th3uS

Category:

Other > Training

Language:

English

Total Size:

2.08 GB

Info Hash:

dcb15f687f2277b1c9058d7dea6aecb134d4c5d8

Added By:

Prom3th3uS :_verified_uploader:

Added:

08-07-2020 15:57

Views:

2,485

Update stats Post guest comment 2

Health:

Seeds:

Leechers:

Completed:

2,782

File	Size
0. Websites you may like/0. (1Hack.Us) Premium Tutorials-Guides-Articles _ Community based Forum.url	377.00 B
0. Websites you may like/1. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url	286.00 B
0. Websites you may like/3. (FTUApps.com) Download Cracked Developers Applications For Free.url	239.00 B
0. Websites you may like/How you can help our Group!.txt	208.00 B
1. Getting Started/1- Introduction.mp4	2.30 MB
1. Getting Started/2- What is SQL.mp4	7.33 MB
1. Getting Started/3- Installing MySQL on Mac.mp4	25.26 MB
1. Getting Started/4- Installing MySQL on Windows.mp4	25.95 MB
1. Getting Started/5- Creating the Databases.mp4	30.92 MB
1. Getting Started/6- What You'll Learn.mp4	5.49 MB
10. Triggers and Events/1- Triggers.mp4	21.02 MB
10. Triggers and Events/2- Viewing Triggers.mp4	3.63 MB
10. Triggers and Events/3- Dropping Triggers.mp4	1.98 MB
10. Triggers and Events/4- Using Triggers for Auditing.mp4	15.95 MB
10. Triggers and Events/5- Events.mp4	16.47 MB
10. Triggers and Events/6- Viewing, Dropping and Altering Events.mp4	5.66 MB
11. Transactions and Concurrency/1- Transactions.mp4	6.86 MB
11. Transactions and Concurrency/10- Deadlocks.mp4	29.14 MB
11. Transactions and Concurrency/2- Creating Transactions.mp4	15.38 MB
11. Transactions and Concurrency/3- Concurrency and Locking.mp4	17.63 MB
11. Transactions and Concurrency/4- Concurrency Problems.mp4	17.43 MB
11. Transactions and Concurrency/5- Transaction Isolation Levels.mp4	13.32 MB
11. Transactions and Concurrency/6- READ UNCOMMITTED Isolation Level.mp4	10.19 MB
11. Transactions and Concurrency/7- READ COMMITTED Isolation Level.mp4	10.01 MB
11. Transactions and Concurrency/8- REPEATABLE READ Isolation Level.mp4	12.28 MB
11. Transactions and Concurrency/9- SERIALIZABLE Isolation Level.mp4	8.45 MB
12. Data Types/1- Introduction.mp4	2.04 MB
12. Data Types/2- String Types.mp4	4.63 MB
12. Data Types/3- Integer Types.mp4	5.75 MB
12. Data Types/4- Fixed-point and Floating-point Types.mp4	3.11 MB
12. Data Types/5- Boolean Types.mp4	1.39 MB
12. Data Types/6- Enum and Set Types.mp4	12.68 MB
12. Data Types/7- Date and Time Types.mp4	1.30 MB
12. Data Types/8- Blob Types.mp4	2.39 MB
12. Data Types/9- JSON Type.mp4	29.46 MB
13. Designing Databases/1- Introduction.mp4	17.05 MB
13. Designing Databases/10- 1NF- First Normal Form.mp4	9.25 MB
13. Designing Databases/11- Link Tables.mp4	15.91 MB
13. Designing Databases/12- 2NF- Second Normal Form.mp4	22.32 MB
13. Designing Databases/13- 3NF- Third Normal Form.mp4	4.65 MB
13. Designing Databases/14- My Pragmatic Advice.mp4	14.01 MB
13. Designing Databases/15- Don't Model the Universe.mp4	51.19 MB
13. Designing Databases/16- Forward Engineering a Model.mp4	10.23 MB
13. Designing Databases/17- Synchronizing a Model with a Database.mp4	17.85 MB
13. Designing Databases/18- Reverse Engineering a Database.mp4	10.89 MB
13. Designing Databases/19- Project- Flight Booking System.mp4	2.16 MB
13. Designing Databases/2- Data Modelling.mp4	17.35 MB
13. Designing Databases/20- Solution- Conceptual Model.mp4	27.56 MB
13. Designing Databases/21- Solution- Logical Model.mp4	33.09 MB
13. Designing Databases/22- Project - Video Rental Application.mp4	8.85 MB
13. Designing Databases/23- Solution- Conceptual Model.mp4	29.53 MB
13. Designing Databases/24- Solution- Logical Model.mp4	38.58 MB
13. Designing Databases/25- Creating and Dropping Databases.mp4	4.13 MB
13. Designing Databases/26- Creating Tables.mp4	11.54 MB
13. Designing Databases/27- Altering Tables.mp4	8.59 MB
13. Designing Databases/28- Creating Relationships.mp4	18.68 MB
13. Designing Databases/29- Altering Primary and Foreign Key Constraints.mp4	7.32 MB
13. Designing Databases/3- Conceptual Models.mp4	17.85 MB
13. Designing Databases/30- Character Sets and Collations.mp4	20.93 MB
13. Designing Databases/31- Storage Engines.mp4	8.22 MB
13. Designing Databases/4- Logical Models.mp4	29.07 MB
13. Designing Databases/5- Physical Models.mp4	21.68 MB
13. Designing Databases/6- Primary Keys.mp4	12.16 MB
13. Designing Databases/7- Foreign Keys.mp4	21.98 MB
13. Designing Databases/8- Foreign Key Constraints.mp4	17.12 MB
13. Designing Databases/9- Normalization.mp4	3.50 MB
14. Indexing for High Performance/1- Introduction.mp4	5.41 MB
14. Indexing for High Performance/10- Using Indexes for Sorting.mp4	18.61 MB
14. Indexing for High Performance/11- Covering Indexese.mp4	5.44 MB
14. Indexing for High Performance/12- Index Maintenance.mp4	2.71 MB
14. Indexing for High Performance/13- Performance Best Practices.pdf	2.38 MB
14. Indexing for High Performance/2- Indexes.mp4	11.77 MB
14. Indexing for High Performance/3- Creating Indexes.mp4	12.96 MB
14. Indexing for High Performance/4- Viewing Indexes.mp4	9.14 MB
14. Indexing for High Performance/5- Prefix Indexes.mp4	8.51 MB
14. Indexing for High Performance/6- Full-text Indexes.mp4	22.53 MB
14. Indexing for High Performance/7- Composite Indexes.mp4	15.06 MB
14. Indexing for High Performance/8- Order of Columns in Composite Indexes.mp4	24.71 MB
14. Indexing for High Performance/9- When Indexes are Ignored.mp4	13.86 MB
15. Securing Databases/1- Introduction.mp4	7.14 MB
15. Securing Databases/2- Creating a User.mp4	7.64 MB
15. Securing Databases/3- Viewing Users.mp4	4.11 MB
15. Securing Databases/4- Dropping Users.mp4	1.57 MB
15. Securing Databases/5- Changing Passwords.mp4	3.01 MB
15. Securing Databases/6- Granting Privileges.mp4	16.87 MB
15. Securing Databases/7- Viewing Privileges.mp4	5.02 MB
15. Securing Databases/8- Revoking Privileges.mp4	2.09 MB
15. Securing Databases/9- Wrap Up.mp4	1.79 MB
2. Retrieving Data From a Single Table/1- The SELECT Statement.mp4	19.17 MB
2. Retrieving Data From a Single Table/10- The ORDER BY Clause.mp4	24.51 MB
2. Retrieving Data From a Single Table/11- The LIMIT Clause.mp4	13.35 MB
2. Retrieving Data From a Single Table/2- The SELECT Clause.mp4	26.10 MB
2. Retrieving Data From a Single Table/3- The WHERE Clause.mp4	16.14 MB
2. Retrieving Data From a Single Table/4- The AND, OR and NOT Operators.mp4	24.20 MB
2. Retrieving Data From a Single Table/5- The IN Operator.mp4	10.52 MB
2. Retrieving Data From a Single Table/6- The BETWEEN Operator.mp4	7.27 MB
2. Retrieving Data From a Single Table/7- The LIKE Operator.mp4	19.44 MB
2. Retrieving Data From a Single Table/8- The REGEXP Operator.mp4	32.41 MB
2. Retrieving Data From a Single Table/9- The IS NULL Operator.mp4	8.73 MB
3. Retrieving Data From Multiple Tables/1- Inner Joins.mp4	28.03 MB
3. Retrieving Data From Multiple Tables/10- The USING Clause.mp4	15.07 MB
3. Retrieving Data From Multiple Tables/11- Natural Joins.mp4	2.70 MB
3. Retrieving Data From Multiple Tables/12- Cross Joins.mp4	8.57 MB
3. Retrieving Data From Multiple Tables/13- Unions.mp4	24.28 MB
3. Retrieving Data From Multiple Tables/2- Joining Across Databases.mp4	7.75 MB
3. Retrieving Data From Multiple Tables/3- Self Joins.mp4	16.77 MB
3. Retrieving Data From Multiple Tables/4- Joining Multiple Tables.mp4	20.88 MB
3. Retrieving Data From Multiple Tables/5- Compound Join Conditions.mp4	11.82 MB
3. Retrieving Data From Multiple Tables/6- Implicit Join Syntax.mp4	8.01 MB
3. Retrieving Data From Multiple Tables/7- Outer Joins.mp4	17.34 MB
3. Retrieving Data From Multiple Tables/8- Outer Join Between Multiple Tables.mp4	19.34 MB
3. Retrieving Data From Multiple Tables/9- Self Outer Joins.mp4	7.06 MB
4. Inserting, Updating, and Deleting Data/1- Column Attributes.mp4	11.69 MB
4. Inserting, Updating, and Deleting Data/10- Restoring the Databases.mp4	3.33 MB
4. Inserting, Updating, and Deleting Data/2- Inserting a Row.mp4	17.91 MB
4. Inserting, Updating, and Deleting Data/3- Inserting Multiple Rows.mp4	9.16 MB
4. Inserting, Updating, and Deleting Data/4- Inserting Hierarchical Rows.mp4	17.93 MB
4. Inserting, Updating, and Deleting Data/5- Creating a Copy of a Table.mp4	31.37 MB
4. Inserting, Updating, and Deleting Data/6- Updating a Single Row.mp4	12.52 MB
4. Inserting, Updating, and Deleting Data/7- Updating Multiple Rows.mp4	9.69 MB
4. Inserting, Updating, and Deleting Data/8- Using Subqueries in Updates.mp4	17.48 MB
4. Inserting, Updating, and Deleting Data/9- Deleting Rows.mp4	3.24 MB
5. Summarizing Data/1- Aggregate Functions.mp4	28.85 MB
5. Summarizing Data/2- The GROUP BY Clause.mp4	22.14 MB
5. Summarizing Data/3- The HAVING Clause.mp4	26.97 MB
5. Summarizing Data/4- The ROLLUP Operator.mp4	14.10 MB
6. Writing Complex Query/1- Introduction.mp4	3.86 MB
6. Writing Complex Query/10- Subqueries in the FROM Clause.mp4	10.62 MB
6. Writing Complex Query/2- Subqueries.mp4	7.75 MB
6. Writing Complex Query/3- The IN Operator.mp4	11.24 MB
6. Writing Complex Query/4- Subqueries vs Joins.mp4	15.61 MB
6. Writing Complex Query/5- The ALL Keyword.mp4	14.27 MB
6. Writing Complex Query/6- The ANY Keyword.mp4	7.50 MB
6. Writing Complex Query/7- Correlated Subqueries.mp4	18.68 MB
6. Writing Complex Query/8- The EXISTS Operator.mp4	14.03 MB
6. Writing Complex Query/9- Subqueries in the SELECT Clause.mp4	14.61 MB
7. Essential MySQL Functions/1- Numeric Functions.mp4	6.93 MB
7. Essential MySQL Functions/2- String Functions.mp4	13.29 MB
7. Essential MySQL Functions/3- Date Functions in MySQL.mp4	8.99 MB
7. Essential MySQL Functions/4- Formatting Dates and Times.mp4	10.58 MB
7. Essential MySQL Functions/5- Calculating Dates and Times.mp4	6.60 MB
7. Essential MySQL Functions/6- The IFNULL and COALESCE Functions.mp4	9.19 MB
7. Essential MySQL Functions/7- The IF Function.mp4	12.92 MB
7. Essential MySQL Functions/8- The CASE Operator.mp4	15.19 MB
8. Views/1- Creating Views.mp4	16.70 MB
8. Views/2- Altering or Dropping Views.mp4	9.89 MB
8. Views/3- Updatable Views.mp4	18.02 MB
8. Views/4- THE WITH OPTION CHECK Clause.mp4	8.19 MB
8. Views/5- Other Benefits of Views.mp4	6.73 MB
9. Stored Procedures/1- What are Stored Procedures.mp4	12.68 MB
9. Stored Procedures/10- Functions.mp4	18.21 MB
9. Stored Procedures/11- Other Conventions.mp4	3.24 MB
9. Stored Procedures/2- Creating a Stored Procedure.mp4	15.07 MB
9. Stored Procedures/3- Creating Procedures Using MySQLWorkbench.mp4	4.32 MB
9. Stored Procedures/4- Dropping Stored Procedures.mp4	6.26 MB
9. Stored Procedures/5- Parameters.mp4	16.41 MB
9. Stored Procedures/6- Parameters with Default Value.mp4	23.03 MB
9. Stored Procedures/7- Parameter Validation.mp4	22.61 MB
9. Stored Procedures/8- Output Parameters.mp4	12.69 MB
9. Stored Procedures/9- Variables.mp4	13.54 MB

Description

Lynda and other Courses >>> https://www.freecoursesonline.me/
For Developer Tools & Apps >>> https://ftuapps.com/
Forum for discussion >>> https://1hack.us/

By: Mosh Hamedani
Publisher: CodeWithMosh
Runtime: 11 Hours
Updated: June 2020
Course Source: https://codewithmosh.com/p/complete-sql-mastery

Master the SQL statements that every software developer or data analyst needs for designing, developing and maintaining databases

Description

Accelerate from Beginner to Advanced in Just 11 Hours

Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases - to name just a few.

So, to be a successful developer or data scientist you need to know SQL inside-out.

SQL isn’t complicated - or at least it doesn’t need to be, so long as you learn it the right way.

Problem is - too many other courses out there jump around, skipping important concepts or simply teaching things badly.

That’s why this course goes further than most. You’ll get in-depth knowledge and skills that are built-up sequentially to make sure you don’t have any gaps.

It takes you from whatever level you’re at to advanced skills, without delay - using real-life examples and applicable concepts to get you ready for any SQL job or project

Clear and concise, packed with plenty of exercises, solutions and free of "fluff".

By the end of this course…

You’ll be able to:

• Write SQL queries with confidence
• Design and optimize relational databases
• Secure your databases

What You'll Learn

I’ve put a lot of thought and time into making this course the most complete SQL course available on the market at the moment.

Every module contains information and activities that are relevant to real-life jobs or the kind of tasks you may get on interview.

• Write complex SQL queries
• Joins (inner, outer, natural, cross)
• Views
• Stored procedures
• Functions
• Events
• Triggers
• Transactions
• Concurrency
• Use indexing for performance
• Design relational databases
• Secure databases
• And much, much more!

Who is this course for?

• Anyone who wants to learn to design and query relational databases
• Computer science students who want to better understand SQL
• Anyone pursuing a job in back-end development, database administration or data science
• SQL developers who want to brush up on their SQL skills

No Prior Knowledge Needed

The course covers everything you need to know in detail, so don’t worry if you’re a complete novice. You don’t even need to know what a database is!

For those with some development and database experience, you can jump in at the relevant module that fits your current level, as the course is designed sequentially.

Your Instructor

Mosh Hamedani

Hi! My name is Mosh Hamedani. I'm a software engineer with almost two decades of experience. I've taught over nine million people how to code and how to become professional software engineers through my online courses and YouTube channel.

I believe coding should be fun and accessible to everyone.