The Complete SQL Masterclass: From Beginner to Professional
If you want to support me: When you purchase the course through my link here, I receive a higher sales commission from Udemy than if the course is accessed and purchased through the platform directly.
Udemy assures me that you will receive the current best price at which this course is currently sold on the Udemy marketplace. So you should not pay more through my link than if you buy the course directly through the platform.
This course introduces participants to the database language SQL by presenting the two most common database systems MySQL and PostgreSQL. The knowledge acquired can often be directly transferred to other database systems such as SQLite, Microsoft SQL or Oracle Database.
At the beginning of the course, the basic commands are taught, such as changing, querying, filtering, deleting and inserting data in databases:
- Modifying data (
UPDATE) - Querying & filtering (
SELECT,SELECT ... WHERE), - Deleting (
DELETE) and - Adding data (
INSERT)
In the further course, the following somewhat advanced topics are then discussed:
- complex evaluation (
SUBSELECT), - grouping of data (
GROUP BY), - creation of reports by linking tables (
JOIN,LEFT JOIN,RIGHT JOIN), - acceleration of queries (
INDEX) and the - automatic consistency checking of data (foreign keys).
Subsequently, the course also addresses more demanding topics to bring participants to expert level. These include the differences between MySQL and PostgreSQL, how security in databases can be increased with the help of rights and how error management is operated in transactions.
It also covers:
- Stored Procedures & Stored Functions
- Full-text search in MySQL (
MATCHES AGAINST), - Full-text search with PostgreSQL (
TO_TSQUERY,TO_TSVECTOR, ...) and - Automatic execution of actions (
EVENTs).
The course content is consistently prepared in practice-related tasks, examples and an exercise database, so that participants can consolidate their knowledge through their own practical experience.