The Complete SQL and MySQL Course From Beginner to Expert

The Complete SQL and MySQL Course – From Beginner to Expert, available at $84.99, has an average rating of 4.58, with 161 lectures, 12 quizzes, based on 1368 reviews, and has 13381 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge It is particularly useful for This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge.

Enroll now: The Complete SQL and MySQL Course – From Beginner to Expert

Summary

Title: The Complete SQL and MySQL Course – From Beginner to Expert

Price: $84.99

Average Rating: 4.58

Number of Lectures: 161

Number of Quizzes: 12

Number of Published Lectures: 158

Number of Published Quizzes: 12

Number of Curriculum Items: 173

Number of Published Curriculum Objects: 170

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

Target Audiences

This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

In this course you can learn the fundamental basics of data management with SQLand 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

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

composite keys

what are constraints?

check constraints

unique constraints

default 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

cursors

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Source code and scripts (for city and country tables)

Chapter 2: Environment

Lecture 1: Installing SQL and MySQL

Lecture 2: Installing SQL and MySQL on Mac

Chapter 3: Databases Theory

Lecture 1: What are databases and database management systems (DBMS)?

Lecture 2: The relational model

Lecture 3: Data structures behind database servers

Lecture 4: Procedural and non-procedural languages

Lecture 5: Types of DBMS and database languages

Chapter 4: Table Manipulation

Lecture 1: Data types

Lecture 2: Creating databases

Lecture 3: CODE – creating databases

Lecture 4: Creating a table

Lecture 5: CODE – creating database tables

Lecture 6: Inserting into a table

Lecture 7: Inserting multiple items in one statement

Lecture 8: CODE – inserting into tables

Lecture 9: Delete row from a table

Lecture 10: CODE – delete row

Lecture 11: Updating a row

Lecture 12: CODE – updating rows

Lecture 13: Changing table structure

Lecture 14: CODE – change table structure

Lecture 15: Drop tables

Lecture 16: What are primary keys?

Lecture 17: The auto increment feature

Lecture 18: CODE – auto incremented primary keys

Lecture 19: Enums

Lecture 20: Booleans

Lecture 21: Floating point numbers with decimals

Lecture 22: Dates

Lecture 23: Exercise

Lecture 24: Solution

Lecture 25: Chapter summary & source code

Chapter 5: Basic SQL

Lecture 1: SQL dump – the city and country tables

Lecture 2: SELECT

Lecture 3: WHERE

Lecture 4: IN

Lecture 5: BETWEEN

Lecture 6: NOT

Lecture 7: Logical operators

Lecture 8: Wildcards

Lecture 9: Functions

Lecture 10: ORDER BY

Lecture 11: Code – order by

Lecture 12: GROUP BY

Lecture 13: CODE – group by

Lecture 14: Exercise

Lecture 15: Solution

Lecture 16: HAVING

Lecture 17: CASE

Lecture 18: NULL functions

Lecture 19: Chapter summary & source code

Chapter 6: Multiple Tables

Lecture 1: What is a foreign key?

Lecture 2: Foreign key example

Lecture 3: CODE – foreign keys

Lecture 4: How to handle changes when dealing with multiple tables?

Lecture 5: Updating dependent tables example

Lecture 6: CODE – updating tables

Lecture 7: Exercise

Lecture 8: Solution

Chapter 7: Database Normalization

Lecture 1: What is database normalization?

Lecture 2: The first normal form

Lecture 3: The second normal form

Lecture 4: The third normal form

Chapter 8: Joining Multiple Tables

Lecture 1: Configuring the database tables – PERSON and UNIVERSITY

Lecture 2: Inner join introduction

Lecture 3: Inner join example

Lecture 4: CODE – inner join

Lecture 5: Left join introduction

Lecture 6: Left join example

Lecture 7: CODE – left join

Lecture 8: Right join introduction

Lecture 9: Right join example

Lecture 10: CODE – right join

Lecture 11: JOIN example – number of cities

Lecture 12: CODE – joining cities

Lecture 13: Exercise

Lecture 14: Solution

Lecture 15: UNION and UNION ALL

Lecture 16: CODE – UNION and UNION ALL

Lecture 17: Exercise

Lecture 18: Solution

Lecture 19: Online SQL console

Lecture 20: JOIN example – customers and orders

Lecture 21: JOIN example – number of orders by customers

Lecture 22: JOIN example – number of orders by country

Instructors

Holczer Balazs
Software Engineer

Rating Distribution

1 stars: 15 votes

2 stars: 36 votes

3 stars: 177 votes

4 stars: 516 votes

5 stars: 624 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!