Master SQL in just 6 days! Learn how to manage and retrieve data confidently with our comprehensive video course designed for beginners.
This course is all about getting you comfy with SQL in just a week! You鈥檒l learn the basics of databases and how to add, edit, and pull data like a pro. It鈥檚 structured to help you become confident in writing data retrieval statements.
Learn SQL and handle databases confidently
"Learn SQL in 6 days" Video Course provides a basic understanding of databases, tables, as well as how to manipulate data with functions like add, edit or delete data from tables and databases. Data retrieval concepts, which includes sorting, filtering, multi-table join, sub-queries and using functions in retrieval statements are discussed in detail.
This course covers the following topics:
路 Database Basics
路 Schema
路 Managing Database and Tables
路 Populating Data
路 Retrieving Data
路 Functions
路 Creating Sub-totals
路 Sub-queries
路 Bonus exercises (on Simple Select)
This course requires approximately 4.5 hours to complete. But we would recommend you to split it into 6 days to have a complete understanding of the concepts.
Each section is well structured and is designed in such a way that the concept is explained first, then I have taken example and explained how to write the SQL for the problem statement. This might help you to understand the concepts better. To make it easier for the learner, all the examples are based on the schema explained in the Schema section.
This course is structured in such a way that one can start writing SQL in hours with confidence.
The bonus exercises section is an add-on, where I made some simple and lighter exercises to give some more input on Simple Select statements. The bonus section has around 10 exercises only on simple select statement.
The primary objective is to make the individual utilizing this tutorial an expert in writing data retrieval statements.
10 Lectures
9 Lectures
6 Lectures
8 Lectures
6 Lectures
1 Lectures
10 Lectures
John Anthony has a Masters in Computer Application with around 20 years of experience in the industry. The instructor has worked on real time projects in India and USA and has successfully designed, developed projects for clients in India as well as Abroad. Also, he has life-time experience on small, medium as well as large size projects. As an entrepreneur...
I didnt find much benefit from this if im honest. The instructor was very clear but I dont feel that ive learned more than what I already knew. Probably very good for a very new person to SQL. But I dont feel like ive fully learned it.
Thanks
This is being presented in short segments and broken down step by step to easily learn and understand the information presented.
Jeden z tych kurs贸w SQL-a, kt贸re s膮 艣wietne na pocz膮tek i potrzeby zbudowania w艂asnej wiedzy na ten temat. Warto jednak przed nim zasi臋gn膮膰 najbardziej podstawowej wiedzy o poj臋ciach we w艂asnym, ojczystym j臋zyku, bo fakt, 偶e prowadz膮cy nie jest 'native speaker-em' angielskiego sprawia, 偶e trzeba si臋 mocno domy艣la膰 z kontekstu sensu i znaczenia poszczeg贸lnych okre艣le艅 u偶ywanych przez autora do艣膰 uporczywie, cho膰 nie zawsze oddaj膮 one istot臋 opisywanego zagadnienia, a podpisy, cho膰 do艂膮czone - zosta艂y zbudowane przez co艣 pokroju 'Zamiana mowy na tekst pisany Google' i bardziej przeszkadza, ni偶 pomaga, bo algorytm wrzuca s艂owa zupe艂nie niezwi膮zane z tematem wyk艂adu pr贸buj膮c fonetycznie zapisa膰 to, co prowadz膮cy m贸wi. Struktura kursu jest do艣膰 czytelna i zrozumia艂a, cho膰 nie zawiera on mi臋dzy innymi informacji o usuwaniu danych z tabel, kolumn itp. Bardzo dobrze zbudowany zosta艂 bonusowy dzia艂 膰wiczeniowy, bo om贸wione zosta艂y problemy, kt贸rych owe 膰wiczenia dotycz膮, a wszystko mo偶na prze膰wiczy膰 w do艂膮czonym, zintegrowanym z Udemy 艣rodowisku bez konieczno艣ci instalowania MySQL u siebie. Szkoda, 偶e ostatnie kilka 膰wicze艅 nie ma mo偶liwo艣ci 膰wiczenia takiego kodowania - lec膮 one ci膮giem, 膰wiczenie w艂asnego pisania skryptu si臋 nie w艂膮cza - temat do poprawki. Og贸lnie - du偶y pozytyw za merytoryczne podej艣cie do tematu.
Would like more examples used true MYSQL worchbench. The examples are quite not good, and I haven't learned anything new
It could be better
amazing experience
Yes, it is a good match.
just want to change my domain from non-IT to Technical field. focusing on skills that's it.
The explanation was clear. Need some practice on the the SQL software to understand it better!
Your email address will not be published.聽Required fields are marked聽*
Jan K. H.
This course can be good for absolute beginners. It covers the basics, and I suppose that will get you started.