| 1 - Databases Theory Quiz.html | 0 B | ||
| 1 - Introduction English.vtt | 3.9 KB | ||
| 1 - Introduction.mp4 | 12.4 MB | ||
| 10 - Creating databases English.vtt | 4.2 KB | ||
| 10 - Creating databases.mp4 | 14 MB | ||
| 10 - Indexes Quiz.html | 0 B | ||
| 100 - Transaction example English.vtt | 6 KB | ||
| 100 - Transaction example SAVEPOINT.mp4 | 11.3 MB | ||
| 101 - CODE savepoint.html | 307.2 B | ||
| 102 - Chapter summary & source code.html | 102.4 B | ||
| 102 - transactions.pdf | 328.6 KB | ||
| 103 - What are views English.vtt | 5.7 KB | ||
| 103 - What are views.mp4 | 17.5 MB | ||
| 104 - Views example English.vtt | 1.8 KB | ||
| 104 - Views example initialize database.mp4 | 3 MB | ||
| 105 - Views example English.vtt | 3.7 KB | ||
| 105 - Views example create views.mp4 | 7.7 MB | ||
| 106 - CODE creating views.html | 102.4 B | ||
| 107 - Views example English.vtt | 3.1 KB | ||
| 107 - Views example update views.mp4 | 5.9 MB | ||
| 108 - Views example English.vtt | 1.1 KB | ||
| 108 - Views example dropping views.mp4 | 1.8 MB | ||
| 109 - CODE update and drop views.html | 307.2 B | ||
| 11 - CODE creating databases.html | 512 B | ||
| 11 - Database Data Structures Quiz.html | 0 B | ||
| 110 - Exercise.html | 409.6 B | ||
| 111 - Solution.html | 204.8 B | ||
| 112 - Chapter summary & source code.html | 102.4 B | ||
| 112 - views.pdf | 324.8 KB | ||
| 113 - What are indexes English.vtt | 15.1 KB | ||
| 113 - What are indexes.mp4 | 49.1 MB | ||
| 114 - Indexes example English.vtt | 5.1 KB | ||
| 114 - Indexes example.mp4 | 9.3 MB | ||
| 115 - Constraints introduction English.vtt | 2.9 KB | ||
| 115 - Constraints introduction.mp4 | 6.7 MB | ||
| 116 - Primary keys English.vtt | 3.3 KB | ||
| 116 - Primary keys.mp4 | 5.9 MB | ||
| 117 - Unique constraints English.vtt | 3 KB | ||
| 117 - Unique constraints.mp4 | 5.6 MB | ||
| 118 - Check constraints English.vtt | 7.3 KB | ||
| 118 - Check constraints.mp4 | 28 MB | ||
| 119 - What is bitmap indexing English.vtt | 13.8 KB | ||
| 119 - What is bitmap indexing.mp4 | 37.1 MB | ||
| 12 - Creating a table English.vtt | 5.2 KB | ||
| 12 - Creating a table.mp4 | 19.1 MB | ||
| 12 - Stored Procedures Quiz.html | 0 B | ||
| 120 - External memory and paging English.vtt | 9.4 KB | ||
| 120 - External memory and paging.mp4 | 35 MB | ||
| 121 - B tree data structures English.vtt | 9.9 KB | ||
| 121 - B tree data structures.mp4 | 27.9 MB | ||
| 122 - Using B trees English.vtt | 7.2 KB | ||
| 122 - Using B trees.mp4 | 18.2 MB | ||
| 123 - What are stored procedures English.vtt | 6.9 KB | ||
| 123 - What are stored procedures.mp4 | 26 MB | ||
| 124 - Creating our first stored procedure English.vtt | 6.3 KB | ||
| 124 - Creating our first stored procedure.mp4 | 28.2 MB | ||
| 125 - CODE first stored procedure.html | 102.4 B | ||
| 126 - Listing and removing stored procedures English.vtt | 3.6 KB | ||
| 126 - Listing and removing stored procedures.mp4 | 21.3 MB | ||
| 127 - CODE listing and removing stored procedures.html | 204.8 B | ||
| 128 - Variables English.vtt | 5.4 KB | ||
| 128 - Variables.mp4 | 18 MB | ||
| 129 - Exercise.html | 307.2 B | ||
| 13 - CODE creating database tables.html | 819.2 B | ||
| 130 - Solution.html | 307.2 B | ||
| 131 - Session variables English.vtt | 3.5 KB | ||
| 131 - Session variables.mp4 | 11.4 MB | ||
| 132 - Parameters English.vtt | 8 KB | ||
| 132 - Parameters.mp4 | 31 MB | ||
| 133 - CODE parameters.html | 307.2 B | ||
| 134 - Exercise.html | 409.6 B | ||
| 135 - Solution.html | 307.2 B | ||
| 136 - Conditional statements English.vtt | 8.7 KB | ||
| 136 - Conditional statements.mp4 | 46.4 MB | ||
| 137 - CODE conditional statements.html | 307.2 B | ||
| 138 - Loops English.vtt | 9.3 KB | ||
| 138 - Loops.mp4 | 35.9 MB | ||
| 139 - ITERATE English.vtt | 2.8 KB | ||
| 139 - ITERATE.mp4 | 11.6 MB | ||
| 14 - Inserting into a table English.vtt | 5.7 KB | ||
| 14 - Inserting into a table.mp4 | 23.8 MB | ||
| 140 - WHILE English.vtt | 4.7 KB | ||
| 140 - WHILE.mp4 | 17.4 MB | ||
| 141 - CODE loops.html | 307.2 B | ||
| 142 - Returning multiple values English.vtt | 4.4 KB | ||
| 142 - Returning multiple values.mp4 | 21.6 MB | ||
| 143 - CODE returning multiple values.html | 409.6 B | ||
| 144 - Course materials.html | 102.4 B | ||
| 15 - Inserting multiple items in one statement English.vtt | 1.7 KB | ||
| 15 - Inserting multiple items in one statement.mp4 | 5.9 MB | ||
| 16 - CODE inserting into tables.html | 819.2 B | ||
| 17 - Delete row from a table English.vtt | 5.2 KB | ||
| 17 - Delete row from a table.mp4 | 24.3 MB | ||
| 18 - CODE delete row.html | 204.8 B | ||
| 19 - Updating a row English.vtt | 2.7 KB | ||
| 19 - Updating a row.mp4 | 10.5 MB | ||
| 2 - Installing SQL and MySQL on Windows.html | 1.1 KB | ||
| 2 - Table Manipulation Quiz.html | 0 B | ||
| 20 - CODE updating rows.html | 409.6 B | ||
| 21 - Changing table structure English.vtt | 4.1 KB | ||
| 21 - Changing table structure.mp4 | 18.4 MB | ||
| 22 - CODE change table structure.html | 716.8 B | ||
| 23 - Drop tables English.vtt | 2.3 KB | ||
| 23 - Drop tables.mp4 | 3.7 MB | ||
| 24 - What are primary keys English.vtt | 6.8 KB | ||
| 24 - What are primary keys.mp4 | 26.8 MB | ||
| 25 - The auto increment feature English.vtt | 4.8 KB | ||
| 25 - The auto increment feature.mp4 | 22.4 MB | ||
| 26 - CODE auto incremented primary keys.html | 614.4 B | ||
| 27 - Enums English.vtt | 4.7 KB | ||
| 27 - Enums.mp4 | 24 MB | ||
| 28 - Booleans English.vtt | 6.1 KB | ||
| 28 - Booleans.mp4 | 30.7 MB | ||
| 29 - Floating point numbers with decimals English.vtt | 6.2 KB | ||
| 29 - Floating point numbers with decimals.mp4 | 29.5 MB | ||
| 3 - Basic SQL Quiz.html | 0 B | ||
| 3 - Installing SQL and MySQL on Mac.html | 1.1 KB | ||
| 30 - Dates English.vtt | 4.9 KB | ||
| 30 - Dates.mp4 | 17.4 MB | ||
| 31 - Exercise.html | 1 KB | ||
| 32 - Solution English.vtt | 6.2 KB | ||
| 32 - Solution.mp4 | 32.4 MB | ||
| 33 - Chapter summary & source code.html | 102.4 B | ||
| 33 - tablemanipulation.pdf | 338.3 KB | ||
| 34 - SQL dump English.vtt | 5.8 KB | ||
| 34 - SQL dump the city and country tables.mp4 | 52 MB | ||
| 35 - SELECT English.vtt | 4.4 KB | ||
| 35 - SELECT.mp4 | 29.1 MB | ||
| 36 - WHERE English.vtt | 3.3 KB | ||
| 36 - WHERE.mp4 | 17.3 MB | ||
| 37 - IN English.vtt | 2.8 KB | ||
| 37 - IN.mp4 | 8.7 MB | ||
| 38 - BETWEEN English.vtt | 3.4 KB | ||
| 38 - BETWEEN.mp4 | 7.7 MB | ||
| 39 - NOT English.vtt | 2 KB | ||
| 39 - NOT negation in SQL.mp4 | 4.5 MB | ||
| 4 - Multiple Tables Quiz.html | 0 B | ||
| 4 - What are databases and database management systems DBMS English.vtt | 6.6 KB | ||
| 4 - What are databases and database management systems DBMS.mp4 | 19.9 MB | ||
| 40 - Logical operators English.vtt | 3.7 KB | ||
| 40 - Logical operators.mp4 | 8 MB | ||
| 41 - Wildcards English.vtt | 3.6 KB | ||
| 41 - Wildcards.mp4 | 9.2 MB | ||
| 42 - Functions English.vtt | 6 KB | ||
| 42 - Functions.mp4 | 11.8 MB | ||
| 43 - ORDER BY English.vtt | 4.9 KB | ||
| 43 - ORDER BY.mp4 | 13.7 MB | ||
| 44 - Code order by.html | 204.8 B | ||
| 45 - GROUP BY English.vtt | 3.2 KB | ||
| 45 - GROUP BY.mp4 | 6.2 MB | ||
| 46 - CODE group by.html | 307.2 B | ||
| 47 - Exercise.html | 307.2 B | ||
| 48 - Solution English.vtt | 2.7 KB | ||
| 48 - Solution.mp4 | 5.1 MB | ||
| 49 - HAVING English.vtt | 3 KB | ||
| 49 - HAVING.mp4 | 6.4 MB | ||
| 5 - Database Normalization Quiz.html | 0 B | ||
| 5 - The relational model English.vtt | 5.8 KB | ||
| 5 - The relational model.mp4 | 14.7 MB | ||
| 50 - Chapter summary & source code.html | 102.4 B | ||
| 50 - basicsql.pdf | 345 KB | ||
| 51 - What is a foreign key English.vtt | 3.4 KB | ||
| 51 - What is a foreign key.mp4 | 11.5 MB | ||
| 52 - Foreign key example English.vtt | 6.7 KB | ||
| 52 - Foreign key example.mp4 | 29.4 MB | ||
| 53 - CODE foreign keys.html | 716.8 B | ||
| 54 - How to handle changes when dealing with multiple tables English.vtt | 6.1 KB | ||
| 54 - How to handle changes when dealing with multiple tables.mp4 | 21.1 MB | ||
| 55 - Updating dependent tables example English.vtt | 8.9 KB | ||
| 55 - Updating dependent tables example.mp4 | 42 MB | ||
| 56 - CODE updating tables.html | 716.8 B | ||
| 57 - Exercise.html | 1.4 KB | ||
| 58 - Solution.html | 716.8 B | ||
| 59 - What is database normalization English.vtt | 4.7 KB | ||
| 59 - What is database normalization.mp4 | 12.3 MB | ||
| 6 - Data structures behind database servers English.vtt | 9.6 KB | ||
| 6 - Data structures behind database servers.mp4 | 31.5 MB | ||
| 6 - Joining Tables Quiz.html | 0 B | ||
| 60 - The first normal form English.vtt | 4.4 KB | ||
| 60 - The first normal form.mp4 | 14.6 MB | ||
| 61 - The second normal form English.vtt | 5.6 KB | ||
| 61 - The second normal form.mp4 | 18.8 MB | ||
| 62 - The third normal form English.vtt | 4.1 KB | ||
| 62 - The third normal form.mp4 | 13 MB | ||
| 63 - Configuring the database tables English.vtt | 3 KB | ||
| 63 - Configuring the database tables PERSON and UNIVERSITY.mp4 | 5.6 MB | ||
| 64 - Inner join introduction English.vtt | 6.7 KB | ||
| 64 - Inner join introduction.mp4 | 14.7 MB | ||
| 65 - Inner join example English.vtt | 5.2 KB | ||
| 65 - Inner join example.mp4 | 23.8 MB | ||
| 66 - CODE inner join.html | 512 B | ||
| 67 - Left join introduction English.vtt | 4.2 KB | ||
| 67 - Left join introduction.mp4 | 10.4 MB | ||
| 68 - Left join example English.vtt | 2.6 KB | ||
| 68 - Left join example.mp4 | 12.7 MB | ||
| 69 - CODE left join.html | 204.8 B | ||
| 7 - Procedural and non English.vtt | 4.4 KB | ||
| 7 - Procedural and nonprocedural languages.mp4 | 13.9 MB | ||
| 7 - Subqueries Quiz.html | 0 B | ||
| 70 - Right join introduction English.vtt | 3.1 KB | ||
| 70 - Right join introduction.mp4 | 7.7 MB | ||
| 71 - Right join example English.vtt | 1.5 KB | ||
| 71 - Right join example.mp4 | 2.7 MB | ||
| 72 - CODE right join.html | 204.8 B | ||
| 73 - JOIN example English.vtt | 5.3 KB | ||
| 73 - JOIN example number of cities.mp4 | 11.1 MB | ||
| 74 - CODE joining cities.html | 409.6 B | ||
| 75 - Exercise.html | 204.8 B | ||
| 76 - Solution English.vtt | 3.3 KB | ||
| 76 - Solution.mp4 | 7.2 MB | ||
| 77 - Online SQL console English.vtt | 1.1 KB | ||
| 77 - Online SQL console.mp4 | 2.2 MB | ||
| 78 - JOIN example English.vtt | 3.1 KB | ||
| 78 - JOIN example customers and orders.mp4 | 5.7 MB | ||
| 79 - JOIN example English.vtt | 3.5 KB | ||
| 79 - JOIN example number of orders by customers.mp4 | 6.5 MB | ||
| 8 - Transactions Quiz.html | 0 B | ||
| 8 - Types of DBMS and database languages English.vtt | 5.6 KB | ||
| 8 - Types of DBMS and database languages.mp4 | 21 MB | ||
| 80 - JOIN example English.vtt | 2 KB | ||
| 80 - JOIN example number of orders by country.mp4 | 3.9 MB | ||
| 81 - Chapter summary & source code.html | 102.4 B | ||
| 81 - JOIN.pdf | 334.8 KB | ||
| 82 - What are subqueries English.vtt | 8.5 KB | ||
| 82 - What are subqueries.mp4 | 30.3 MB | ||
| 83 - Non English.vtt | 2.2 KB | ||
| 83 - Noncorrelated scalar subquery.mp4 | 4.5 MB | ||
| 84 - CODE scalar subquery.html | 102.4 B | ||
| 85 - Non English.vtt | 3 KB | ||
| 85 - Noncorrelated multiplerow subquery.mp4 | 5.8 MB | ||
| 86 - CODE multiple row subquery.html | 102.4 B | ||
| 87 - Correlated subquery English.vtt | 2.9 KB | ||
| 87 - Correlated subquery.mp4 | 5.9 MB | ||
| 88 - CODE correlated subquery.html | 204.8 B | ||
| 89 - Subqueries and joins English.vtt | 1.6 KB | ||
| 89 - Subqueries and joins.mp4 | 4.5 MB | ||
| 9 - Data types English.vtt | 11 KB | ||
| 9 - Data types.mp4 | 43.7 MB | ||
| 9 - Views Quiz.html | 0 B | ||
| 90 - Transforming subquery into join English.vtt | 2.9 KB | ||
| 90 - Transforming subquery into join.mp4 | 6.3 MB | ||
| 91 - CODE subquery and join.html | 307.2 B | ||
| 92 - Chapter summary & source code.html | 102.4 B | ||
| 92 - subqueies.pdf | 328 KB | ||
| 93 - Transactions introduction English.vtt | 12.7 KB | ||
| 93 - Transactions introduction locking.mp4 | 45.5 MB | ||
| 94 - Transactions introduction English.vtt | 5.3 KB | ||
| 94 - Transactions introduction transactions.mp4 | 18.8 MB | ||
| 95 - What are the ACID principles English.vtt | 4.5 KB | ||
| 95 - What are the ACID principles.mp4 | 14.6 MB | ||
| 96 - Transaction example COMMIT.mp4 | 8.8 MB | ||
| 96 - Transaction example English.vtt | 5 KB | ||
| 97 - CODE commit.html | 204.8 B | ||
| 98 - Transaction example English.vtt | 2.9 KB | ||
| 98 - Transaction example ROLLBACK.mp4 | 5.3 MB | ||
| 99 - CODE rollback.html | 204.8 B | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| country_city.txt | 638.4 KB | ||
| sql_database.pptx | 695.9 KB | ||
| students_university.txt | 1.6 KB | ||
| ▲ 261 total files | |||
The Complete Sql And Mysql Course - From Beginner To Expert
https://DevCourseWeb.com
Last updated 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.57 GB | Duration: 6h 54m
Learn the Basics of Managing Data with SQL - Basics, Transactions, Views, Pages and Stored Procedures
What you'll learn
understand the basic concepts of databases
get a good grasp of SQL and MySQL queries
understand database management systems (DBMSs) and database languages
understand table manipulation
understand pages
understand views
understand strored procedures
understand the data structures (B trees and B+ trees) behind databases
Requirements
Internet connection
Description
In this course you can learn the fundamental basics of data management with SQL and MySQL. Learn everything that you will need to make queries with the most popular data manipulating programming language - SQL. This course is about SQL commands in the main. You will learn the basics of queries. Let's take a look at what you are going to learn in this course:Section 1 - Setting up The Environment:setting up the environmentinstalling MySQL server on Windows and MacOSSection 2 - Database Theorywhat are databases?what are database management systems (DBMSs)?what are database languages?the data structures (B-trees) behind databasesprocedural and non-procedural programming languagesSection 3 - Creating and Manipulating Tablesbasic data types (integers, floating point numbers and characters)enums and dateshow to create databases?how to insert and remove items?how to update existing items or database tables?Section 4 - Basic SQLbasic SQL and MySQL commandsselect, where and wildcardslogical operatorsORDER BY and GROUP BY commandsSection 5 - Multiple Tablesjoining multiple database tablesinner joinleft and right joinSection 6 - Database Normalizationwhat is database normalisation?first normal form (NF1)second normal form (NF2)third normal form (NF3)Section 7 - Subqueries:advanced SQL and MySQLwhat are subqueries?correlated and non-correlated subqueriesSection 8 - Transactionswhat is database locking?the ACID principles?COMMIT, ROLLBACK and SAVEPOINTSection 9 - Viewswhat are views and why are they crucial?creating viewsupdating viewsdropping viewsSection 10 - Indexes and Constraintswhat are indexes and why to use them?primary keys and foreign keys revisitedwhat are constraints?Section 11 - Data Structures Behind Databaseswhat are pages?the basic concept of paging in operating systemsexternal memory and internal memoryB tree data structureB+ tree data structureSection 12 - Stored Procedureswhat are stored procedures?variablesloopsconditional statementsLearning the fundamentals of SQL and MySQL is a good choice and puts a powerful tool at your fingertips. SQL is easy to learn as well as it has excellent documentations. The most important fact about SQL that it is used in almost every field from software engineering to financial analysis so understanding the concepts and basic language features can prove to be very marketable.Thanks for joining the course, let's get started!
Overview
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 784.3 MB | freecoursewb | 1 week | 18 | 6 | |
| 2.2 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.3 GB | freecoursewb | 1 week | 24 | 16 | |
| 410.6 MB | freecoursewb | 1 week | 21 | 8 |
All Comments