| 0. (1Hack.Us) Premium Tutorials-Guides-Articles _ Community based Forum.url | 409 B | ||
| 1- Aggregate Functions.mp4 | 28.9 MB | ||
| 1- Column Attributes.mp4 | 11.7 MB | ||
| 1- Creating Views.mp4 | 16.7 MB | ||
| 1- Inner Joins.mp4 | 28 MB | ||
| 1- Introduction.mp4 | 3.9 MB | ||
| 1- Numeric Functions.mp4 | 6.9 MB | ||
| 1- The SELECT Statement.mp4 | 19.2 MB | ||
| 1- Transactions.mp4 | 6.9 MB | ||
| 1- Triggers.mp4 | 21 MB | ||
| 1- What are Stored Procedures.mp4 | 12.7 MB | ||
| 1. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url | 307 B | ||
| 10- 1NF- First Normal Form.mp4 | 9.3 MB | ||
| 10- Deadlocks.mp4 | 29.1 MB | ||
| 10- Functions.mp4 | 18.2 MB | ||
| 10- Restoring the Databases.mp4 | 3.3 MB | ||
| 10- Subqueries in the FROM Clause.mp4 | 10.6 MB | ||
| 10- The ORDER BY Clause.mp4 | 24.5 MB | ||
| 10- The USING Clause.mp4 | 15.1 MB | ||
| 10- Using Indexes for Sorting.mp4 | 18.6 MB | ||
| 11- Covering Indexese.mp4 | 5.4 MB | ||
| 11- Link Tables.mp4 | 15.9 MB | ||
| 11- Natural Joins.mp4 | 2.7 MB | ||
| 11- Other Conventions.mp4 | 3.2 MB | ||
| 11- The LIMIT Clause.mp4 | 13.3 MB | ||
| 12- 2NF- Second Normal Form.mp4 | 22.3 MB | ||
| 12- Cross Joins.mp4 | 8.6 MB | ||
| 12- Index Maintenance.mp4 | 2.7 MB | ||
| 13- 3NF- Third Normal Form.mp4 | 4.6 MB | ||
| 13- Performance Best Practices.pdf | 2.4 MB | ||
| 13- Unions.mp4 | 24.3 MB | ||
| 14- My Pragmatic Advice.mp4 | 14 MB | ||
| 15- Don't Model the Universe.mp4 | 51.2 MB | ||
| 16- Forward Engineering a Model.mp4 | 10.2 MB | ||
| 17- Synchronizing a Model with a Database.mp4 | 17.9 MB | ||
| 18- Reverse Engineering a Database.mp4 | 10.9 MB | ||
| 19- Project- Flight Booking System.mp4 | 2.2 MB | ||
| 2- Altering or Dropping Views.mp4 | 9.9 MB | ||
| 2- Creating Transactions.mp4 | 15.4 MB | ||
| 2- Creating a Stored Procedure.mp4 | 15.1 MB | ||
| 2- Creating a User.mp4 | 7.6 MB | ||
| 2- Data Modelling.mp4 | 17.3 MB | ||
| 2- Indexes.mp4 | 11.8 MB | ||
| 2- Inserting a Row.mp4 | 17.9 MB | ||
| 2- Joining Across Databases.mp4 | 7.7 MB | ||
| 2- String Functions.mp4 | 13.3 MB | ||
| 2- String Types.mp4 | 4.6 MB | ||
| 2- Subqueries.mp4 | 7.7 MB | ||
| 2- The GROUP BY Clause.mp4 | 22.1 MB | ||
| 2- The SELECT Clause.mp4 | 26.1 MB | ||
| 2- Viewing Triggers.mp4 | 3.6 MB | ||
| 2- What is SQL.mp4 | 7.3 MB | ||
| 20- Solution- Conceptual Model.mp4 | 27.6 MB | ||
| 21- Solution- Logical Model.mp4 | 33.1 MB | ||
| 22- Project - Video Rental Application.mp4 | 8.8 MB | ||
| 23- Solution- Conceptual Model.mp4 | 29.5 MB | ||
| 24- Solution- Logical Model.mp4 | 38.6 MB | ||
| 25- Creating and Dropping Databases.mp4 | 4.1 MB | ||
| 26- Creating Tables.mp4 | 11.5 MB | ||
| 27- Altering Tables.mp4 | 8.6 MB | ||
| 28- Creating Relationships.mp4 | 18.7 MB | ||
| 29- Altering Primary and Foreign Key Constraints.mp4 | 7.3 MB | ||
| 3- Conceptual Models.mp4 | 17.8 MB | ||
| 3- Concurrency and Locking.mp4 | 17.6 MB | ||
| 3- Creating Indexes.mp4 | 13 MB | ||
| 3- Creating Procedures Using MySQLWorkbench.mp4 | 4.3 MB | ||
| 3- Date Functions in MySQL.mp4 | 9 MB | ||
| 3- Dropping Triggers.mp4 | 2 MB | ||
| 3- Inserting Multiple Rows.mp4 | 9.2 MB | ||
| 3- Installing MySQL on Mac.mp4 | 25.3 MB | ||
| 3- Integer Types.mp4 | 5.7 MB | ||
| 3- Self Joins.mp4 | 16.8 MB | ||
| 3- The HAVING Clause.mp4 | 27 MB | ||
| 3- The IN Operator.mp4 | 11.2 MB | ||
| 3- The WHERE Clause.mp4 | 16.1 MB | ||
| 3- Updatable Views.mp4 | 18 MB | ||
| 3- Viewing Users.mp4 | 4.1 MB | ||
| 3. (FTUApps.com) Download Cracked Developers Applications For Free.url | 204 B | ||
| 30- Character Sets and Collations.mp4 | 20.9 MB | ||
| 31- Storage Engines.mp4 | 8.2 MB | ||
| 4- Concurrency Problems.mp4 | 17.4 MB | ||
| 4- Dropping Stored Procedures.mp4 | 6.3 MB | ||
| 4- Dropping Users.mp4 | 1.6 MB | ||
| 4- Fixed-point and Floating-point Types.mp4 | 3.1 MB | ||
| 4- Formatting Dates and Times.mp4 | 10.6 MB | ||
| 4- Inserting Hierarchical Rows.mp4 | 17.9 MB | ||
| 4- Installing MySQL on Windows.mp4 | 25.9 MB | ||
| 4- Joining Multiple Tables.mp4 | 20.9 MB | ||
| 4- Logical Models.mp4 | 29.1 MB | ||
| 4- Subqueries vs Joins.mp4 | 15.6 MB | ||
| 4- THE WITH OPTION CHECK Clause.mp4 | 8.2 MB | ||
| 4- The AND, OR and NOT Operators.mp4 | 24.2 MB | ||
| 4- The ROLLUP Operator.mp4 | 14.1 MB | ||
| 4- Using Triggers for Auditing.mp4 | 15.9 MB | ||
| 4- Viewing Indexes.mp4 | 9.1 MB | ||
| 5- Boolean Types.mp4 | 1.4 MB | ||
| 5- Calculating Dates and Times.mp4 | 6.6 MB | ||
| 5- Changing Passwords.mp4 | 3 MB | ||
| 5- Compound Join Conditions.mp4 | 11.8 MB | ||
| 5- Creating a Copy of a Table.mp4 | 31.4 MB | ||
| 5- Creating the Databases.mp4 | 30.9 MB | ||
| 5- Events.mp4 | 16.5 MB | ||
| 5- Other Benefits of Views.mp4 | 6.7 MB | ||
| 5- Parameters.mp4 | 16.4 MB | ||
| 5- Physical Models.mp4 | 21.7 MB | ||
| 5- Prefix Indexes.mp4 | 8.5 MB | ||
| 5- The ALL Keyword.mp4 | 14.3 MB | ||
| 5- The IN Operator.mp4 | 10.5 MB | ||
| 5- Transaction Isolation Levels.mp4 | 13.3 MB | ||
| 6- Enum and Set Types.mp4 | 12.7 MB | ||
| 6- Full-text Indexes.mp4 | 22.5 MB | ||
| 6- Granting Privileges.mp4 | 16.9 MB | ||
| 6- Implicit Join Syntax.mp4 | 8 MB | ||
| 6- Parameters with Default Value.mp4 | 23 MB | ||
| 6- Primary Keys.mp4 | 12.2 MB | ||
| 6- READ UNCOMMITTED Isolation Level.mp4 | 10.2 MB | ||
| 6- The ANY Keyword.mp4 | 7.5 MB | ||
| 6- The BETWEEN Operator.mp4 | 7.3 MB | ||
| 6- The IFNULL and COALESCE Functions.mp4 | 9.2 MB | ||
| 6- Updating a Single Row.mp4 | 12.5 MB | ||
| 6- Viewing, Dropping and Altering Events.mp4 | 5.7 MB | ||
| 6- What You'll Learn.mp4 | 5.5 MB | ||
| 7- Composite Indexes.mp4 | 15.1 MB | ||
| 7- Correlated Subqueries.mp4 | 18.7 MB | ||
| 7- Date and Time Types.mp4 | 1.3 MB | ||
| 7- Foreign Keys.mp4 | 22 MB | ||
| 7- Outer Joins.mp4 | 17.3 MB | ||
| 7- Parameter Validation.mp4 | 22.6 MB | ||
| 7- READ COMMITTED Isolation Level.mp4 | 10 MB | ||
| 7- The IF Function.mp4 | 12.9 MB | ||
| 7- The LIKE Operator.mp4 | 19.4 MB | ||
| 7- Updating Multiple Rows.mp4 | 9.7 MB | ||
| 7- Viewing Privileges.mp4 | 5 MB | ||
| 8- Blob Types.mp4 | 2.4 MB | ||
| 8- Foreign Key Constraints.mp4 | 17.1 MB | ||
| 8- Order of Columns in Composite Indexes.mp4 | 24.7 MB | ||
| 8- Outer Join Between Multiple Tables.mp4 | 19.3 MB | ||
| 8- Output Parameters.mp4 | 12.7 MB | ||
| 8- REPEATABLE READ Isolation Level.mp4 | 12.3 MB | ||
| 8- Revoking Privileges.mp4 | 2.1 MB | ||
| 8- The CASE Operator.mp4 | 15.2 MB | ||
| 8- The EXISTS Operator.mp4 | 14 MB | ||
| 8- The REGEXP Operator.mp4 | 32.4 MB | ||
| 8- Using Subqueries in Updates.mp4 | 17.5 MB | ||
| 9- Deleting Rows.mp4 | 3.2 MB | ||
| 9- JSON Type.mp4 | 29.5 MB | ||
| 9- Normalization.mp4 | 3.5 MB | ||
| 9- SERIALIZABLE Isolation Level.mp4 | 8.5 MB | ||
| 9- Self Outer Joins.mp4 | 7.1 MB | ||
| 9- Subqueries in the SELECT Clause.mp4 | 14.6 MB | ||
| 9- The IS NULL Operator.mp4 | 8.7 MB | ||
| 9- Variables.mp4 | 13.5 MB | ||
| 9- When Indexes are Ignored.mp4 | 13.9 MB | ||
| 9- Wrap Up.mp4 | 1.8 MB | ||
| How you can help our Group!.txt | 204 B | ||
| ▲ 160 total files | |||
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.

| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 858.6 MB | freecoursewb | 5 days | 0 | 0 | |
| 1.9 GB | freecoursewb | 3 weeks | 28 | 14 | |
| 1.9 GB | freecoursewb | 2 months | 31 | 4 | |
| 2.2 GB | freecoursewb | 2 months | 52 | 5 | |
| 1.8 GB | freecoursewb | 2 months | 7 | 3 |
All Comments