Udemy - The Complete Sql And Mysql Course - From Beginner To Expert

Torrent Details

Udemy - The Complete Sql And Mysql Course - From Beginner To ExpertUdemy - The Complete Sql And Mysql Course - From Beginner To Expert

NAME
Udemy - The Complete Sql And Mysql Course - From Beginner To Expert.torrent
CATEGORY
Other
INFOHASH
0cbeb24a1a467bef079ded0feb46692ca73dc360
SIZE
1.6 GB in 98 files
ADDED
Uploaded on 09-08-2022 by our crawler pet called "Spidey".
SWARM
0 seeders & 2 peers
RATING
No votes yet.

Please login to vote for this torrent.


Description

[ DevCourseWeb.com ] The Complete Sql And Mysql Course - From Beginner To Expert



If You Need More Stuff, kindly Visit and Support Us -->> 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



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...



Image error



Image error

Discussion

Comments 0

Post Your Comment

Files in this torrent

FILENAMESIZE
~Get Your Files Here !/1 - Introduction/1 - Introduction English.vtt3.9 KB
~Get Your Files Here !/1 - Introduction/1 - Introduction.mp412.4 MB
~Get Your Files Here !/10 - Advanced SQL Transactions/100 - Transaction example English.vtt6 KB
~Get Your Files Here !/10 - Advanced SQL Transactions/100 - Transaction example SAVEPOINT.mp411.3 MB
~Get Your Files Here !/10 - Advanced SQL Transactions/101 - CODE savepoint.html325 B
~Get Your Files Here !/10 - Advanced SQL Transactions/102 - Chapter summary & source code.html76 B
~Get Your Files Here !/10 - Advanced SQL Transactions/102 - transactions.pdf328.6 KB
~Get Your Files Here !/10 - Advanced SQL Transactions/8 - Transactions Quiz.html0 B
~Get Your Files Here !/10 - Advanced SQL Transactions/93 - Transactions introduction English.vtt12.7 KB
~Get Your Files Here !/10 - Advanced SQL Transactions/93 - Transactions introduction locking.mp445.5 MB
~Get Your Files Here !/10 - Advanced SQL Transactions/94 - Transactions introduction English.vtt5.3 KB
~Get Your Files Here !/10 - Advanced SQL Transactions/94 - Transactions introduction transactions.mp418.8 MB
~Get Your Files Here !/10 - Advanced SQL Transactions/95 - What are the ACID principles English.vtt4.5 KB
~Get Your Files Here !/10 - Advanced SQL Transactions/95 - What are the ACID principles.mp414.6 MB
~Get Your Files Here !/10 - Advanced SQL Transactions/96 - Transaction example COMMIT.mp48.8 MB
~Get Your Files Here !/10 - Advanced SQL Transactions/96 - Transaction example English.vtt5 KB
~Get Your Files Here !/10 - Advanced SQL Transactions/97 - CODE commit.html177 B
~Get Your Files Here !/10 - Advanced SQL Transactions/98 - Transaction example English.vtt2.9 KB
~Get Your Files Here !/10 - Advanced SQL Transactions/98 - Transaction example ROLLBACK.mp45.3 MB
~Get Your Files Here !/10 - Advanced SQL Transactions/99 - CODE rollback.html188 B
~Get Your Files Here !/11 - Advanced SQL Views/103 - What are views English.vtt5.7 KB
~Get Your Files Here !/11 - Advanced SQL Views/103 - What are views.mp417.5 MB
~Get Your Files Here !/11 - Advanced SQL Views/104 - Views example English.vtt1.8 KB
~Get Your Files Here !/11 - Advanced SQL Views/104 - Views example initialize database.mp43 MB
~Get Your Files Here !/11 - Advanced SQL Views/105 - Views example create views.mp47.7 MB
~Get Your Files Here !/11 - Advanced SQL Views/105 - Views example English.vtt3.7 KB
~Get Your Files Here !/11 - Advanced SQL Views/106 - CODE creating views.html122 B
~Get Your Files Here !/11 - Advanced SQL Views/107 - Views example English.vtt3.1 KB
~Get Your Files Here !/11 - Advanced SQL Views/107 - Views example update views.mp45.9 MB
~Get Your Files Here !/11 - Advanced SQL Views/108 - Views example dropping views.mp41.8 MB
~Get Your Files Here !/11 - Advanced SQL Views/108 - Views example English.vtt1.1 KB
~Get Your Files Here !/11 - Advanced SQL Views/109 - CODE update and drop views.html292 B
~Get Your Files Here !/11 - Advanced SQL Views/110 - Exercise.html446 B
~Get Your Files Here !/11 - Advanced SQL Views/111 - Solution.html201 B
~Get Your Files Here !/11 - Advanced SQL Views/112 - Chapter summary & source code.html76 B
~Get Your Files Here !/11 - Advanced SQL Views/112 - views.pdf324.8 KB
~Get Your Files Here !/11 - Advanced SQL Views/9 - Views Quiz.html0 B
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/10 - Indexes Quiz.html0 B
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/113 - What are indexes English.vtt15.1 KB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/113 - What are indexes.mp449.1 MB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/114 - Indexes example English.vtt5.1 KB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/114 - Indexes example.mp49.3 MB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/115 - Constraints introduction English.vtt2.9 KB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/115 - Constraints introduction.mp46.7 MB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/116 - Primary keys English.vtt3.3 KB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/116 - Primary keys.mp45.9 MB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/117 - Unique constraints English.vtt3 KB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/117 - Unique constraints.mp45.6 MB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/118 - Check constraints English.vtt7.3 KB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/118 - Check constraints.mp428 MB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/119 - What is bitmap indexing English.vtt13.8 KB
~Get Your Files Here !/12 - Advanced SQL Indexes And Constraints/119 - What is bitmap indexing.mp437.1 MB
~Get Your Files Here !/13 - Data Structures Behind Databases/11 - Database Data Structures Quiz.html0 B
~Get Your Files Here !/13 - Data Structures Behind Databases/120 - External memory and paging English.vtt9.4 KB
~Get Your Files Here !/13 - Data Structures Behind Databases/120 - External memory and paging.mp435 MB
~Get Your Files Here !/13 - Data Structures Behind Databases/121 - B tree data structures English.vtt9.9 KB
~Get Your Files Here !/13 - Data Structures Behind Databases/121 - B tree data structures.mp427.9 MB
~Get Your Files Here !/13 - Data Structures Behind Databases/122 - Using B trees English.vtt7.2 KB
~Get Your Files Here !/13 - Data Structures Behind Databases/122 - Using B trees.mp418.2 MB
~Get Your Files Here !/14 - Stored Procedures/12 - Stored Procedures Quiz.html0 B
~Get Your Files Here !/14 - Stored Procedures/123 - What are stored procedures English.vtt6.9 KB
~Get Your Files Here !/14 - Stored Procedures/123 - What are stored procedures.mp426 MB
~Get Your Files Here !/14 - Stored Procedures/124 - Creating our first stored procedure English.vtt6.3 KB
~Get Your Files Here !/14 - Stored Procedures/124 - Creating our first stored procedure.mp428.2 MB
~Get Your Files Here !/14 - Stored Procedures/125 - CODE first stored procedure.html153 B
~Get Your Files Here !/14 - Stored Procedures/126 - Listing and removing stored procedures English.vtt3.6 KB
~Get Your Files Here !/14 - Stored Procedures/126 - Listing and removing stored procedures.mp421.3 MB
~Get Your Files Here !/14 - Stored Procedures/127 - CODE listing and removing stored procedures.html220 B
~Get Your Files Here !/14 - Stored Procedures/128 - Variables English.vtt5.4 KB
~Get Your Files Here !/14 - Stored Procedures/128 - Variables.mp418 MB
~Get Your Files Here !/14 - Stored Procedures/129 - Exercise.html312 B
~Get Your Files Here !/14 - Stored Procedures/130 - Solution.html341 B
~Get Your Files Here !/14 - Stored Procedures/131 - Session variables English.vtt3.5 KB
~Get Your Files Here !/14 - Stored Procedures/131 - Session variables.mp411.4 MB
~Get Your Files Here !/14 - Stored Procedures/132 - Parameters English.vtt8 KB
~Get Your Files Here !/14 - Stored Procedures/132 - Parameters.mp431 MB
~Get Your Files Here !/14 - Stored Procedures/133 - CODE parameters.html257 B
~Get Your Files Here !/14 - Stored Procedures/134 - Exercise.html436 B
~Get Your Files Here !/14 - Stored Procedures/135 - Solution.html318 B
~Get Your Files Here !/14 - Stored Procedures/136 - Conditional statements English.vtt8.7 KB
~Get Your Files Here !/14 - Stored Procedures/136 - Conditional statements.mp446.4 MB
~Get Your Files Here !/14 - Stored Procedures/137 - CODE conditional statements.html356 B
~Get Your Files Here !/14 - Stored Procedures/138 - Loops English.vtt9.3 KB
~Get Your Files Here !/14 - Stored Procedures/138 - Loops.mp435.9 MB
~Get Your Files Here !/14 - Stored Procedures/139 - ITERATE English.vtt2.8 KB
~Get Your Files Here !/14 - Stored Procedures/139 - ITERATE.mp411.6 MB
~Get Your Files Here !/14 - Stored Procedures/140 - WHILE English.vtt4.7 KB
~Get Your Files Here !/14 - Stored Procedures/140 - WHILE.mp417.4 MB
~Get Your Files Here !/14 - Stored Procedures/141 - CODE loops.html343 B
~Get Your Files Here !/14 - Stored Procedures/142 - Returning multiple values English.vtt4.4 KB
~Get Your Files Here !/14 - Stored Procedures/142 - Returning multiple values.mp421.6 MB
~Get Your Files Here !/14 - Stored Procedures/143 - CODE returning multiple values.html386 B
~Get Your Files Here !/15 - Course Materials DOWNLOADS/144 - Course materials.html54 B
~Get Your Files Here !/15 - Course Materials DOWNLOADS/sql/country_city.txt638.4 KB
~Get Your Files Here !/15 - Course Materials DOWNLOADS/sql/students_university.txt1.6 KB
~Get Your Files Here !/15 - Course Materials DOWNLOADS/sql_database.pptx695.9 KB
~Get Your Files Here !/2 - Environment/2 - Installing SQL and MySQL on Windows.html1.1 KB
~Get Your Files Here !/2 - Environment/3 - Installing SQL and MySQL on Mac.html1.1 KB

Alternative Torrents for 'Udemy Complete Sql And Mysql Course From Beginner To Expert'.

There are no alternative torrents found.