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

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

Other
Size
2.1 GB
Seeders
20
Leechers
3
Files
96
Category
Other
Added
07/08/20 at 5:26pm GMT+1
Infohash
dcb15f687f2277b1c9058d7dea6aecb134d4c5d8

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.




File list
  • [FreeCoursesOnline.Me] Code With Mosh - Complete SQL Mastery
  • 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

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
2.3 GB12/10/22466
3.2 GB12/12/22443
1.8 GB12/19/22434
136 MB03/15/23401
6.9 GB01/07/23396
1.3 GB12/06/22374
6.7 GB11/12/18354
3.5 GB12/08/22359
784 MB12/24/22342
839 MB07/13/23332
1.7 GB01/27/24335
1.8 GB12/29/22325
442 MB02/25/24321
26.9 GB12/25/223013
939 MB12/21/22292