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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024