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

[FreeCoursesOnline.Me] Code With Mosh - Complete SQL Mastery

TORRENT SUMMARY

	Status:	All the torrents in this section have been verified by our verification system
Category:	Other
Infohash	dcb15f687f2277b1c9058d7dea6aecb134d4c5d8
Size:	2.1 GB in 96 files
Release Date(s):	Torrent Release: 08-07-2020 by user
Swarm:	0 Seeds & 0 Peers
Vote:	No votes yet.

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.

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	0. Websites you may like/How you can help our Group!.txt	208 B
	1. Getting Started/1- Introduction.mp4	2.3 MB
	1. Getting Started/2- What is SQL.mp4	7.3 MB
	1. Getting Started/3- Installing MySQL on Mac.mp4	25.3 MB
	1. Getting Started/4- Installing MySQL on Windows.mp4	25.9 MB
	1. Getting Started/5- Creating the Databases.mp4	30.9 MB
	1. Getting Started/6- What You'll Learn.mp4	5.5 MB
	10. Triggers and Events/1- Triggers.mp4	21 MB
	10. Triggers and Events/2- Viewing Triggers.mp4	3.6 MB
	10. Triggers and Events/3- Dropping Triggers.mp4	2 MB
	10. Triggers and Events/4- Using Triggers for Auditing.mp4	15.9 MB
	10. Triggers and Events/5- Events.mp4	16.5 MB
	10. Triggers and Events/6- Viewing, Dropping and Altering Events.mp4	5.7 MB
	11. Transactions and Concurrency/1- Transactions.mp4	6.9 MB
	11. Transactions and Concurrency/10- Deadlocks.mp4	29.1 MB
	11. Transactions and Concurrency/2- Creating Transactions.mp4	15.4 MB
	11. Transactions and Concurrency/3- Concurrency and Locking.mp4	17.6 MB
	11. Transactions and Concurrency/4- Concurrency Problems.mp4	17.4 MB
	11. Transactions and Concurrency/5- Transaction Isolation Levels.mp4	13.3 MB
	11. Transactions and Concurrency/6- READ UNCOMMITTED Isolation Level.mp4	10.2 MB
	11. Transactions and Concurrency/7- READ COMMITTED Isolation Level.mp4	10 MB
	11. Transactions and Concurrency/8- REPEATABLE READ Isolation Level.mp4	12.3 MB
	11. Transactions and Concurrency/9- SERIALIZABLE Isolation Level.mp4	8.5 MB
	12. Data Types/1- Introduction.mp4	2 MB
	12. Data Types/2- String Types.mp4	4.6 MB
	12. Data Types/3- Integer Types.mp4	5.7 MB
	12. Data Types/4- Fixed-point and Floating-point Types.mp4	3.1 MB
	12. Data Types/5- Boolean Types.mp4	1.4 MB
	12. Data Types/6- Enum and Set Types.mp4	12.7 MB
	12. Data Types/7- Date and Time Types.mp4	1.3 MB
	12. Data Types/8- Blob Types.mp4	2.4 MB
	12. Data Types/9- JSON Type.mp4	29.5 MB
	13. Designing Databases/1- Introduction.mp4	17 MB
	13. Designing Databases/10- 1NF- First Normal Form.mp4	9.3 MB
	13. Designing Databases/11- Link Tables.mp4	15.9 MB
	13. Designing Databases/12- 2NF- Second Normal Form.mp4	22.3 MB
	13. Designing Databases/13- 3NF- Third Normal Form.mp4	4.6 MB
	13. Designing Databases/14- My Pragmatic Advice.mp4	14 MB
	13. Designing Databases/15- Don't Model the Universe.mp4	51.2 MB
	13. Designing Databases/16- Forward Engineering a Model.mp4	10.2 MB
	13. Designing Databases/17- Synchronizing a Model with a Database.mp4	17.9 MB
	13. Designing Databases/18- Reverse Engineering a Database.mp4	10.9 MB
	13. Designing Databases/19- Project- Flight Booking System.mp4	2.2 MB
	13. Designing Databases/2- Data Modelling.mp4	17.3 MB
	13. Designing Databases/20- Solution- Conceptual Model.mp4	27.6 MB
	13. Designing Databases/21- Solution- Logical Model.mp4	33.1 MB
	13. Designing Databases/22- Project - Video Rental Application.mp4	8.8 MB
	13. Designing Databases/23- Solution- Conceptual Model.mp4	29.5 MB
	13. Designing Databases/24- Solution- Logical Model.mp4	38.6 MB
	13. Designing Databases/25- Creating and Dropping Databases.mp4	4.1 MB
	13. Designing Databases/26- Creating Tables.mp4	11.5 MB
	13. Designing Databases/27- Altering Tables.mp4	8.6 MB
	13. Designing Databases/28- Creating Relationships.mp4	18.7 MB
	13. Designing Databases/29- Altering Primary and Foreign Key Constraints.mp4	7.3 MB
	13. Designing Databases/3- Conceptual Models.mp4	17.8 MB
	13. Designing Databases/30- Character Sets and Collations.mp4	20.9 MB
	13. Designing Databases/31- Storage Engines.mp4	8.2 MB
	13. Designing Databases/4- Logical Models.mp4	29.1 MB
	13. Designing Databases/5- Physical Models.mp4	21.7 MB
	13. Designing Databases/6- Primary Keys.mp4	12.2 MB
	13. Designing Databases/7- Foreign Keys.mp4	22 MB
	13. Designing Databases/8- Foreign Key Constraints.mp4	17.1 MB
	13. Designing Databases/9- Normalization.mp4	3.5 MB
	14. Indexing for High Performance/1- Introduction.mp4	5.4 MB
	14. Indexing for High Performance/10- Using Indexes for Sorting.mp4	18.6 MB
	14. Indexing for High Performance/11- Covering Indexese.mp4	5.4 MB
	14. Indexing for High Performance/12- Index Maintenance.mp4	2.7 MB
	14. Indexing for High Performance/13- Performance Best Practices.pdf	2.4 MB
	14. Indexing for High Performance/2- Indexes.mp4	11.8 MB
	14. Indexing for High Performance/3- Creating Indexes.mp4	13 MB
	14. Indexing for High Performance/4- Viewing Indexes.mp4	9.1 MB
	14. Indexing for High Performance/5- Prefix Indexes.mp4	8.5 MB
	14. Indexing for High Performance/6- Full-text Indexes.mp4	22.5 MB
	14. Indexing for High Performance/7- Composite Indexes.mp4	15.1 MB
	14. Indexing for High Performance/8- Order of Columns in Composite Indexes.mp4	24.7 MB
	14. Indexing for High Performance/9- When Indexes are Ignored.mp4	13.9 MB
	15. Securing Databases/1- Introduction.mp4	7.1 MB
	15. Securing Databases/2- Creating a User.mp4	7.6 MB
	15. Securing Databases/3- Viewing Users.mp4	4.1 MB
	15. Securing Databases/4- Dropping Users.mp4	1.6 MB
	15. Securing Databases/5- Changing Passwords.mp4	3 MB
	15. Securing Databases/6- Granting Privileges.mp4	16.9 MB
	15. Securing Databases/7- Viewing Privileges.mp4	5 MB
	15. Securing Databases/8- Revoking Privileges.mp4	2.1 MB
	15. Securing Databases/9- Wrap Up.mp4	1.8 MB
	2. Retrieving Data From a Single Table/1- The SELECT Statement.mp4	19.2 MB
	2. Retrieving Data From a Single Table/10- The ORDER BY Clause.mp4	24.5 MB
	2. Retrieving Data From a Single Table/11- The LIMIT Clause.mp4	13.3 MB
	2. Retrieving Data From a Single Table/2- The SELECT Clause.mp4	26.1 MB
	2. Retrieving Data From a Single Table/3- The WHERE Clause.mp4	16.1 MB
	2. Retrieving Data From a Single Table/4- The AND, OR and NOT Operators.mp4	24.2 MB
	2. Retrieving Data From a Single Table/5- The IN Operator.mp4	10.5 MB
	2. Retrieving Data From a Single Table/6- The BETWEEN Operator.mp4	7.3 MB
	2. Retrieving Data From a Single Table/7- The LIKE Operator.mp4	19.4 MB
	2. Retrieving Data From a Single Table/8- The REGEXP Operator.mp4	32.4 MB
	2. Retrieving Data From a Single Table/9- The IS NULL Operator.mp4	8.7 MB

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health