Development Online Course by Udemy, On Sale Here
Master advanced SQL skills for building, optimizing, and administering relational databases using MySQL Workbench
An excellent training about Database Design & Development
Advanced SQL Database Administration with MySQL Workbench
See why John is one of theTOP-RATEDSQL/MySQLInstructors on Udemy:”I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQLand had fun doing it. In fact, at the end of the day I didn’t want to stop learning – I wanted to keep charging on to the next lesson!”- Ann S.”This is an excellent advanced course! I’ve taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It’s much easier to grasp the concepts when you can see how they’re literally applied to scenarios and outcomes as opposed to just theory. Great work!”- Dan S.”John’s deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I’ve taken other SQL and MySQLcourses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!”- Steven M. COURSEDESCRIPTION: MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you’ll take your database administration skills to the next level, expanding into advanced concepts like replication, automation, and database security. We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing the key principles of normalized databases. From there we’ll work through more advanced concepts like replication, backup and recovery, and learn how to leverage automation via stored procedures, triggers, and scheduled events. Throughout the course, you’ll be playing the role of Lead Database Administrator for an e-commerce startup, and learn how to build and populate an entire database from the ground up using real-world projects and assignments. COURSEOUTLINE: SQLIntro & MySQLSetupFor students who haven’t completed one of our other SQL courses, we’ll demonstrate exactly how to download and install the tools that we’ll need to access MySQL, including MySQLCommunity Server & MySQLWorkbench. We’ll share download guides for both Mac & PC, and run our first piece of SQLcode to generate the project database that we’ll analyze throughout the course. Importing Data to the Database We’ll quickly review some basic concepts like creating, inserting, and deleting records. Then we’ll learn how to tackle large data imports with ease, using the table data import wizard. We’ll be using this handy tool throughout the course. You will construct and populate a database from the ground up as the business grows, just like a real DBAas part of the course project. Altering, Updating & Mapping KeysWe’ll briefly review critical concepts like altering tables and updating records, discuss the ins and outs of primary and foreign keys, and from there you’ll jump right into your assignments and quizzes for this section. Replication, Backup & RecoveryHere we’ll introduce the critical DBAconcepts of replication, backup and recovery. We’ll discuss the various benefits of replication, different methods of backing up your databases, and you’ll learn how to restore your data should the need arise. This is getting into some pretty serious stuff! MID-COURSEPROJECTYou will need all of the skills you’ve learned so far to complete this hands on mid-course project. You’ll help your CEO by enhancing the data structure to accommodate changing business needs, and insert new data into various places within your database. Trigger AutomationHere we’ll dive into one of the most powerful automation tools you’ll use as a DBA. triggers! You’ll learn how you can create triggers to look for changes in the database via create, update, and delete statements, and then automatically enact changes on one of more of your tables. Triggers will be your best friend as a DBA, and can be extremely handy for Analysts to understand as well. Creating ViewsSometimes you don’t need to create a table, and a view (aka “a virtual table)is a better option. We’ll walk through what views are, how you create them, and some of the major benefits of using views in certain situations. The EERDiagram EditorOne of the best tools at your disposal for understanding your database and communicating its structure to others in your organization is leveraging EERDiagrams. We’ll review some of the basics that we discussed in the Beginner course, and we’ll also learn how to use the EERDiagram Editor to reverse engineer your schema, which is an extremely handy tool! Stored Procedures & Scheduled EventsNext, we’ll dive deeper into automation by learning how to create stored procedures and scheduled events. If you liked triggers, you’re going to love these! You can use stored procedures to simplify your processes, make your code more modular and easier to understand, and centralize certain parts of complex queries
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.