MySQL Management and Administration with Navicat

October 30, 2020
MySQL Management and Administration with Navicat

Master the tools you thought you knew and discover the featuresyou never knew existed!Tips, tricks and fast-paced tutorials for getting the most outof NavicatMaster the visual design tools and editors with thoroughexamples.Discover how easy Navicat makes outsmarting the trickiestcases.Both Mac and PC versions covered, with screenshots detailingdifferences in performing tasksIn DetailAny database designer who wants to accomplish both everydaytasks and more advanced actions with a few clicks or drag-and-dropscan now do so using Navicat's advanced tools and this book.Starting with the basics before progressing with advancedfeatures, this book can be read from cover to cover, or simply usedas a reference guide for any problems you encounter.The book features 'work along' tutorials, some of which willsurprise you by revealing features of Navicat which you may neverhave known existed – features such as designing functions andstored procedures, event triggers, creating batch jobs andscheduling."MySQL Management and Administration with Navicat" is an idealresource to master Navicat and unlock its true potential.What you will learn from this bookEasily set up servers, establish connections, configure proxiesand SSL certificatesDesign databases, tables, complex views, queries, functions andstored procedures through hand coding, point-and-click, or a mix ofbothEstablish and manage complex relationships with visual editorsand get the automatically generated SQLImport data or an entire database from almost any data sourceand export to a different database platform or a plethora of fileformatsCreate visual models and create a database from them or justreverse-engineer an existing database into a visual diagramBackup and restore MySQL databases easilyCreate batch jobs and define automated schedulesManage complex privileges, analyze and repair tables with a fewclicksApproachStandard MiniWho this book is written forThis book is written for MySQL users, developers, and admins whowant to discover just how easy Navicat makes even normally arduoustasks.