4.2  648 reviews on Udemy

The Complete SQL and MySQL Course - From Beginner to Expert

Learn the Basics of Managing Data with SQL - Basics, Transactions, Views, Pages and Stored Procedures
Course from Udemy
 10375 students enrolled
 en
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

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 environment

  • installing MySQL server on Windows and MacOS

Section 2 - Database Theory

  • what are databases?

  • what are database management systems (DBMSs)?

  • what are database languages?

  • the data structures (B-trees) behind databases

  • procedural and non-procedural programming languages

Section 3 - Creating and Manipulating Tables

  • basic data types (integers, floating point numbers and characters)

  • enums and dates

  • how to create databases?

  • how to insert and remove items?

  • how to update existing items or database tables?

Section 4 - Basic SQL

  • basic SQL and MySQL commands

  • select, where and wildcards

  • logical operators

  • ORDER BY and GROUP BY commands

Section 5 - Multiple Tables

  • joining multiple database tables

  • inner join

  • left and right join

Section 6 - Database Normalization

  • what is database normalisation?

  • first normal form (NF1)

  • second normal form (NF2)

  • third normal form (NF3)

Section 7 - Subqueries:

  • advanced SQL and MySQL

  • what are subqueries?

  • correlated and non-correlated subqueries

Section 8 - Transactions

  • what is database locking?

  • the ACID principles?

  • COMMIT, ROLLBACK and SAVEPOINT

Section 9 - Views

  • what are views and why are they crucial?

  • creating views

  • updating views

  • dropping views

Section 10 - Indexes and Constraints

  • what are indexes and why to use them?

  • primary keys and foreign keys revisited

  • what are constraints?

Section 11 - Data Structures Behind Databases

  • what are pages?

  • the basic concept of paging in operating systems

  • external memory and internal memory

  • B tree data structure

  • B+ tree data structure

Section 12 - Stored Procedures

  • what are stored procedures?

  • variables

  • loops

  • conditional statements

Learning 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!

The Complete SQL and MySQL Course - From Beginner to Expert
$ 19.99
per course
Also check at

FAQs About "The Complete SQL and MySQL Course - From Beginner to Expert"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK