FreeCoursesOnline Me Code With Mosh Complete SQL Mastery | DCB15F687F2277B1C9058D7DEA6AECB134D4C5D8

FreeCoursesOnline Me Code With Mosh Complete SQL Mastery

Name	[FreeCoursesOnline.Me] Code With Mosh - Complete SQL Mastery	DOWNLOAD Copy Link
Total Size	2.2 GB
Total Files	160
Last Seen	2024-11-15 23:37
Hash	DCB15F687F2277B1C9058D7DEA6AECB134D4C5D8

/0. Websites you may like/
0. (1Hack.Us) Premium Tutorials-Guides-Articles _ Community based Forum.url	0.4 KB
1. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url	0.3 KB
3. (FTUApps.com) Download Cracked Developers Applications For Free.url	0.2 KB
How you can help our Group!.txt	0.2 KB
/1. Getting Started/
1- Introduction.mp4	2.4 MB
2- What is SQL.mp4	7.7 MB
3- Installing MySQL on Mac.mp4	26.5 MB
4- Installing MySQL on Windows.mp4	27.2 MB
5- Creating the Databases.mp4	32.4 MB
6- What You'll Learn.mp4	5.8 MB
/10. Triggers and Events/
1- Triggers.mp4	22.0 MB
2- Viewing Triggers.mp4	3.8 MB
3- Dropping Triggers.mp4	2.1 MB
4- Using Triggers for Auditing.mp4	16.7 MB
5- Events.mp4	17.3 MB
6- Viewing, Dropping and Altering Events.mp4	5.9 MB
/11. Transactions and Concurrency/
1- Transactions.mp4	7.2 MB
10- Deadlocks.mp4	30.6 MB
2- Creating Transactions.mp4	16.1 MB
3- Concurrency and Locking.mp4	18.5 MB
4- Concurrency Problems.mp4	18.3 MB
5- Transaction Isolation Levels.mp4	14.0 MB
6- READ UNCOMMITTED Isolation Level.mp4	10.7 MB
7- READ COMMITTED Isolation Level.mp4	10.5 MB
8- REPEATABLE READ Isolation Level.mp4	12.9 MB
9- SERIALIZABLE Isolation Level.mp4	8.9 MB
/12. Data Types/
1- Introduction.mp4	2.1 MB
2- String Types.mp4	4.9 MB
3- Integer Types.mp4	6.0 MB
4- Fixed-point and Floating-point Types.mp4	3.3 MB
5- Boolean Types.mp4	1.5 MB
6- Enum and Set Types.mp4	13.3 MB
7- Date and Time Types.mp4	1.4 MB
8- Blob Types.mp4	2.5 MB
9- JSON Type.mp4	30.9 MB
/13. Designing Databases/
1- Introduction.mp4	17.9 MB
10- 1NF- First Normal Form.mp4	9.7 MB
11- Link Tables.mp4	16.7 MB
12- 2NF- Second Normal Form.mp4	23.4 MB
13- 3NF- Third Normal Form.mp4	4.9 MB
14- My Pragmatic Advice.mp4	14.7 MB
15- Don't Model the Universe.mp4	53.7 MB
16- Forward Engineering a Model.mp4	10.7 MB
17- Synchronizing a Model with a Database.mp4	18.7 MB
18- Reverse Engineering a Database.mp4	11.4 MB
19- Project- Flight Booking System.mp4	2.3 MB
2- Data Modelling.mp4	18.2 MB
20- Solution- Conceptual Model.mp4	28.9 MB
21- Solution- Logical Model.mp4	34.7 MB
22- Project - Video Rental Application.mp4	9.3 MB
23- Solution- Conceptual Model.mp4	31.0 MB
24- Solution- Logical Model.mp4	40.5 MB
25- Creating and Dropping Databases.mp4	4.3 MB
26- Creating Tables.mp4	12.1 MB
27- Altering Tables.mp4	9.0 MB
28- Creating Relationships.mp4	19.6 MB
29- Altering Primary and Foreign Key Constraints.mp4	7.7 MB
3- Conceptual Models.mp4	18.7 MB
30- Character Sets and Collations.mp4	21.9 MB
31- Storage Engines.mp4	8.6 MB
4- Logical Models.mp4	30.5 MB
5- Physical Models.mp4	22.7 MB
6- Primary Keys.mp4	12.7 MB
7- Foreign Keys.mp4	23.0 MB
8- Foreign Key Constraints.mp4	17.9 MB
9- Normalization.mp4	3.7 MB
/14. Indexing for High Performance/
1- Introduction.mp4	5.7 MB
10- Using Indexes for Sorting.mp4	19.5 MB
11- Covering Indexese.mp4	5.7 MB
12- Index Maintenance.mp4	2.8 MB
13- Performance Best Practices.pdf	2.5 MB
2- Indexes.mp4	12.3 MB
3- Creating Indexes.mp4	13.6 MB
4- Viewing Indexes.mp4	9.6 MB
5- Prefix Indexes.mp4	8.9 MB
6- Full-text Indexes.mp4	23.6 MB
7- Composite Indexes.mp4	15.8 MB
8- Order of Columns in Composite Indexes.mp4	25.9 MB
9- When Indexes are Ignored.mp4	14.5 MB
/15. Securing Databases/
1- Introduction.mp4	7.5 MB
2- Creating a User.mp4	8.0 MB
3- Viewing Users.mp4	4.3 MB
4- Dropping Users.mp4	1.6 MB
5- Changing Passwords.mp4	3.2 MB
6- Granting Privileges.mp4	17.7 MB
7- Viewing Privileges.mp4	5.3 MB
8- Revoking Privileges.mp4	2.2 MB
9- Wrap Up.mp4	1.9 MB
/2. Retrieving Data From a Single Table/
1- The SELECT Statement.mp4	20.1 MB
10- The ORDER BY Clause.mp4	25.7 MB
11- The LIMIT Clause.mp4	14.0 MB
2- The SELECT Clause.mp4	27.4 MB
3- The WHERE Clause.mp4	16.9 MB
4- The AND, OR and NOT Operators.mp4	25.4 MB
5- The IN Operator.mp4	11.0 MB
6- The BETWEEN Operator.mp4	7.6 MB
7- The LIKE Operator.mp4	20.4 MB
8- The REGEXP Operator.mp4	34.0 MB
9- The IS NULL Operator.mp4	9.2 MB
/3. Retrieving Data From Multiple Tables/
1- Inner Joins.mp4	29.4 MB
10- The USING Clause.mp4	15.8 MB
11- Natural Joins.mp4	2.8 MB
12- Cross Joins.mp4	9.0 MB
13- Unions.mp4	25.5 MB
2- Joining Across Databases.mp4	8.1 MB
3- Self Joins.mp4	17.6 MB
4- Joining Multiple Tables.mp4	21.9 MB
5- Compound Join Conditions.mp4	12.4 MB
6- Implicit Join Syntax.mp4	8.4 MB
7- Outer Joins.mp4	18.2 MB
8- Outer Join Between Multiple Tables.mp4	20.3 MB
9- Self Outer Joins.mp4	7.4 MB
/4. Inserting, Updating, and Deleting Data/
1- Column Attributes.mp4	12.3 MB
10- Restoring the Databases.mp4	3.5 MB
2- Inserting a Row.mp4	18.8 MB
3- Inserting Multiple Rows.mp4	9.6 MB
4- Inserting Hierarchical Rows.mp4	18.8 MB
5- Creating a Copy of a Table.mp4	32.9 MB
6- Updating a Single Row.mp4	13.1 MB
7- Updating Multiple Rows.mp4	10.2 MB
8- Using Subqueries in Updates.mp4	18.3 MB
9- Deleting Rows.mp4	3.4 MB
/5. Summarizing Data/
1- Aggregate Functions.mp4	30.3 MB
2- The GROUP BY Clause.mp4	23.2 MB
3- The HAVING Clause.mp4	28.3 MB
4- The ROLLUP Operator.mp4	14.8 MB
/6. Writing Complex Query/
1- Introduction.mp4	4.1 MB
10- Subqueries in the FROM Clause.mp4	11.1 MB
2- Subqueries.mp4	8.1 MB
3- The IN Operator.mp4	11.8 MB
4- Subqueries vs Joins.mp4	16.4 MB
5- The ALL Keyword.mp4	15.0 MB
6- The ANY Keyword.mp4	7.9 MB
7- Correlated Subqueries.mp4	19.6 MB
8- The EXISTS Operator.mp4	14.7 MB
9- Subqueries in the SELECT Clause.mp4	15.3 MB
/7. Essential MySQL Functions/
1- Numeric Functions.mp4	7.3 MB
2- String Functions.mp4	13.9 MB
3- Date Functions in MySQL.mp4	9.4 MB
4- Formatting Dates and Times.mp4	11.1 MB
5- Calculating Dates and Times.mp4	6.9 MB
6- The IFNULL and COALESCE Functions.mp4	9.6 MB
7- The IF Function.mp4	13.5 MB
8- The CASE Operator.mp4	15.9 MB
/8. Views/
1- Creating Views.mp4	17.5 MB
2- Altering or Dropping Views.mp4	10.4 MB
3- Updatable Views.mp4	18.9 MB
4- THE WITH OPTION CHECK Clause.mp4	8.6 MB
5- Other Benefits of Views.mp4	7.1 MB
/9. Stored Procedures/
1- What are Stored Procedures.mp4	13.3 MB
10- Functions.mp4	19.1 MB
11- Other Conventions.mp4	3.4 MB
2- Creating a Stored Procedure.mp4	15.8 MB
3- Creating Procedures Using MySQLWorkbench.mp4	4.5 MB
4- Dropping Stored Procedures.mp4	6.6 MB
5- Parameters.mp4	17.2 MB
6- Parameters with Default Value.mp4	24.1 MB
7- Parameter Validation.mp4	23.7 MB
8- Output Parameters.mp4	13.3 MB
9- Variables.mp4	14.2 MB
Total files 160