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
