Advanced SQL Course
What will I learn?
Oketsa bokgoni jwa gago jwa Botlhale jwa Kgwebo ka Koso ya rona ya Maemo a Godimo ya SQL, e e diretsweng batho ba ba itseng tiro ba ba batlang go itse dintlha tsotlhe tsa SQL. Ithute ka go dira database, go e tokafatsa, le go e dira ka bokgabane, o ithuta mekgwa e e jaaka maano a go tsenya diteng mo index le ditsela tsa go diragatsa dipotso. Tokafatsa bokgoni jwa gago jwa go dira dipego ka go tlhama ditokomane tsa SQL tse di tlhaloganyesegang le diboto tsa tshedimosetso tse di nang le botlhale. Sekaseka mekgwa e e kwa godimo e e jaaka Dipolelwana tse di Tlwaelegileng tsa Tafole le ditiro tsa window. Nna le bokgoni jo bo mosola mo go tsenyeng data, go e ntsha, le go e fetola, go go thusa go tsamaisa ditshwetso tse di ikaegileng ka data ka bokgabane.
Develop skills
Enhance the development of the practical skills listed below
Ithute go tokafatsa SQL: Oketsa lebelo la dipotso le bokgabane.
Dira didatabase tse di nonofileng: Diragatsa mekgwa e e siameng ya schema.
Tlhama dipego tse di nang le botlhale: Fetola data go nna dintlha tse di ka dirisiwang.
Dira tshekatsheko ya data e e kwa godimo: Dirisa CTE le ditiro tsa window.
Tlhabolola diboto tsa tshedimosetso tsa BI: Bona data ka matlho go tsaya ditshwetso tsa togamaano.
Suggested summary
Workload: between 4 and 360 hours
Before starting, you can modify the chapters and the workload.
- Choose which chapter to start with
- Add or remove chapters
- Increase or decrease the course workload
Examples of chapters you can add
You’ll be able to generate more chapters like the examples below
This is a free course, focused on personal and professional development. It is not equivalent to a technical, undergraduate, or postgraduate course, but offers practical and relevant knowledge for your professional journey.