Other
[FreeCoursesOnline Me] Code With Mosh - Complete SQL Mastery
Torrent info
Torrent Files List
0. Websites you may like (Size: 2.08 GB) (Files: 160)
0. Websites you may like
0. (1Hack.Us) Premium Tutorials-Guides-Articles _ Community based Forum.url
1. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url
3. (FTUApps.com) Download Cracked Developers Applications For Free.url
How you can help our Group!.txt
1. Getting Started
1- Introduction.mp4
2- What is SQL.mp4
3- Installing MySQL on Mac.mp4
4- Installing MySQL on Windows.mp4
5- Creating the Databases.mp4
6- What You'll Learn.mp4
10. Triggers and Events
1- Triggers.mp4
2- Viewing Triggers.mp4
3- Dropping Triggers.mp4
4- Using Triggers for Auditing.mp4
5- Events.mp4
6- Viewing, Dropping and Altering Events.mp4
11. Transactions and Concurrency
1- Transactions.mp4
10- Deadlocks.mp4
2- Creating Transactions.mp4
3- Concurrency and Locking.mp4
4- Concurrency Problems.mp4
5- Transaction Isolation Levels.mp4
6- READ UNCOMMITTED Isolation Level.mp4
7- READ COMMITTED Isolation Level.mp4
8- REPEATABLE READ Isolation Level.mp4
9- SERIALIZABLE Isolation Level.mp4
12. Data Types
1- Introduction.mp4
2- String Types.mp4
3- Integer Types.mp4
4- Fixed-point and Floating-point Types.mp4
5- Boolean Types.mp4
6- Enum and Set Types.mp4
7- Date and Time Types.mp4
8- Blob Types.mp4
9- JSON Type.mp4
13. Designing Databases
1- Introduction.mp4
10- 1NF- First Normal Form.mp4
11- Link Tables.mp4
12- 2NF- Second Normal Form.mp4
13- 3NF- Third Normal Form.mp4
14- My Pragmatic Advice.mp4
15- Don't Model the Universe.mp4
16- Forward Engineering a Model.mp4
17- Synchronizing a Model with a Database.mp4
18- Reverse Engineering a Database.mp4
19- Project- Flight Booking System.mp4
2- Data Modelling.mp4
20- Solution- Conceptual Model.mp4
21- Solution- Logical Model.mp4
22- Project - Video Rental Application.mp4
23- Solution- Conceptual Model.mp4
24- Solution- Logical Model.mp4
25- Creating and Dropping Databases.mp4
26- Creating Tables.mp4
27- Altering Tables.mp4
28- Creating Relationships.mp4
29- Altering Primary and Foreign Key Constraints.mp4
3- Conceptual Models.mp4
30- Character Sets and Collations.mp4
31- Storage Engines.mp4
4- Logical Models.mp4
5- Physical Models.mp4
6- Primary Keys.mp4
7- Foreign Keys.mp4
8- Foreign Key Constraints.mp4
9- Normalization.mp4
14. Indexing for High Performance
1- Introduction.mp4
10- Using Indexes for Sorting.mp4
11- Covering Indexese.mp4
12- Index Maintenance.mp4
13- Performance Best Practices.pdf
2- Indexes.mp4
3- Creating Indexes.mp4
4- Viewing Indexes.mp4
5- Prefix Indexes.mp4
6- Full-text Indexes.mp4
7- Composite Indexes.mp4
8- Order of Columns in Composite Indexes.mp4
9- When Indexes are Ignored.mp4
15. Securing Databases
1- Introduction.mp4
2- Creating a User.mp4
3- Viewing Users.mp4
4- Dropping Users.mp4
5- Changing Passwords.mp4
6- Granting Privileges.mp4
7- Viewing Privileges.mp4
8- Revoking Privileges.mp4
9- Wrap Up.mp4
2. Retrieving Data From a Single Table
1- The SELECT Statement.mp4
10- The ORDER BY Clause.mp4
11- The LIMIT Clause.mp4
2- The SELECT Clause.mp4
3- The WHERE Clause.mp4
4- The AND, OR and NOT Operators.mp4
5- The IN Operator.mp4
6- The BETWEEN Operator.mp4
7- The LIKE Operator.mp4
8- The REGEXP Operator.mp4
9- The IS NULL Operator.mp4
3. Retrieving Data From Multiple Tables
1- Inner Joins.mp4
10- The USING Clause.mp4
11- Natural Joins.mp4
12- Cross Joins.mp4
13- Unions.mp4
2- Joining Across Databases.mp4
3- Self Joins.mp4
4- Joining Multiple Tables.mp4
5- Compound Join Conditions.mp4
6- Implicit Join Syntax.mp4
7- Outer Joins.mp4
8- Outer Join Between Multiple Tables.mp4
9- Self Outer Joins.mp4
4. Inserting, Updating, and Deleting Data
1- Column Attributes.mp4
10- Restoring the Databases.mp4
2- Inserting a Row.mp4
3- Inserting Multiple Rows.mp4
4- Inserting Hierarchical Rows.mp4
5- Creating a Copy of a Table.mp4
6- Updating a Single Row.mp4
7- Updating Multiple Rows.mp4
8- Using Subqueries in Updates.mp4
9- Deleting Rows.mp4
5. Summarizing Data
1- Aggregate Functions.mp4
2- The GROUP BY Clause.mp4
3- The HAVING Clause.mp4
4- The ROLLUP Operator.mp4
6. Writing Complex Query
1- Introduction.mp4
10- Subqueries in the FROM Clause.mp4
2- Subqueries.mp4
3- The IN Operator.mp4
4- Subqueries vs Joins.mp4
5- The ALL Keyword.mp4
6- The ANY Keyword.mp4
7- Correlated Subqueries.mp4
8- The EXISTS Operator.mp4
9- Subqueries in the SELECT Clause.mp4
7. Essential MySQL Functions
1- Numeric Functions.mp4
2- String Functions.mp4
3- Date Functions in MySQL.mp4
4- Formatting Dates and Times.mp4
5- Calculating Dates and Times.mp4
6- The IFNULL and COALESCE Functions.mp4
7- The IF Function.mp4
8- The CASE Operator.mp4
8. Views
1- Creating Views.mp4
2- Altering or Dropping Views.mp4
3- Updatable Views.mp4
4- THE WITH OPTION CHECK Clause.mp4
5- Other Benefits of Views.mp4
9. Stored Procedures
1- What are Stored Procedures.mp4
10- Functions.mp4
11- Other Conventions.mp4
2- Creating a Stored Procedure.mp4
3- Creating Procedures Using MySQLWorkbench.mp4
4- Dropping Stored Procedures.mp4
5- Parameters.mp4
6- Parameters with Default Value.mp4
7- Parameter Validation.mp4
8- Output Parameters.mp4
9- Variables.mp4
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [FreeCoursesOnline Me] Code With Mosh - Complete SQL Mastery Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
