Get yourself trained on Basic Concepts of with this Online Training Basic Concepts of MySQL Database.
Online Training Basic Concepts of MySQL Database
This course is introduction level for MySQL. It covers examples with handouts and MySQL queries. There will be also free online MySQL access for practice.Please Note that Last Chapter is very fast and it is more of installing MySQL database on Debian, Ubuntu, CENTOS. You must require root access if you want to perform those operations. If I am missing something; you can refer handout, and SQL script. You can also reach me through email if you need any explanation on specific topics.Chapter 1: Introduction on MySQLChapter 2: Data TypesChapter 3: SELECT StatementsChapter 4: BackticksChapter 5: NULLChapter 6: Limit and OffsetChapter 7: Creating databasesChapter 8: Using VariablesChapter 9: Comment MySQLChapter 10: INSERT StatementsChapter 11: DELETE StatementsChapter 12: UPDATE StatementsChapter 13: ORDER BY ClauseChapter 14: Group ByChapter 15: Errors in MySQLChapter 16: JoinsChapter 17: Joins continuedChapter 18: UNIONChapter 19: ArithmeticChapter 20: String operationsChapter 21: Date and Time OperationsChapter 22: Handling Time ZonesChapter 23: Regular ExpressionsChapter 24: VIEWSChapter 25: Table CreationChapter 26: ALTER TABLEChapter 27: Drop TableChapter 28: MySQL LOCK TABLEChapter 29: Error codesChapter 30: Stored routines (procedures and functions)Chapter 31: Indexes and KeysChapter 32: Full-Text searchChapter 33: PREPARE StatementsChapter 34: JSONChapter 35: Extract values from JSON typeChapter 36: MySQL AdminChapter 37: TRIGGERSChapter 38: Configuration and tuningChapter 39: EventsChapter 40: ENUMChapter 41: Collations, Transactions, Log files, Replication, Backup
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.