Maven Analytics
If you’re looking to develop practical, real–world analytics and BI skills and learn how to create and maintain databases, you’ve come to the right place.
This course is unlike anything you’ve seen before, guaranteed. We’ll start from the ground up, teaching you the tools to get the job done, and most importantly how to you apply your skills to real projects and learn how to truly think like a Database Administrator.
You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases. Throughout the course, you’ll be working directly with the owners of various companies to help them manage data in their new and scaling enterprises. You will use the skills you learn to complete actual projects that database administration professionals work on every day.
COURSE OUTLINE:
SQL Intro & MySQL Setup
For 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 MySQL Community Server & MySQL Workbench. We’ll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we’ll analyze throughout the course.
Instructor Details
Courses : 2
Specification: MySQL Database Administration: Beginner SQL Database Design
|
24 reviews for MySQL Database Administration: Beginner SQL Database Design
Add a review
| Price | $13.99 |
|---|---|
| Provider | |
| Duration | 7 hours |
| Year | 2022 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$13.99
Matt O’Connor –
Only halfway through the course but I already really like the pace and the content. I work in pharma, and like a lot professionals I was thrusted into DW environments, SQL querying, etc.. without any formal training and I’ve never been some one to read a book and pick up a subject. So, I started with simple boolean queries and have worked my way up to more complicated joins as well as working on company initiatives to expand data sets in our DW and to use SQL to actionize complicated, disparate data sets; this course on administration is so helpful because it fills in so many of the knowledge gaps that I half knew from organically working with SQL everyday. This will directly allow me to be more independent in creating robust data environments as well as more knowledgeable when discussing commercial data build outs with IT consultants. Great job to John and the Mavens team on making a complicated subject easy to access.
Dan Slagen –
I love how interactive this course is, makes it so much easier to learn! These beginner courses can sometimes be too basic or overly complex, but this version of SQL database for beginners is the perfect mix. You’ll leave this class with 10x knowledge you can start applying to your work now. Thanks!
David Schrader –
I’ve taken the other courses offered by Mr. Pauler and this one has certainly lived up to the quality of those as well. Clear and concise, Mr. Pauler always knows how to get a message/lesson across in a way I can comprehend. Highly recommend this course as well as his others.
Annie OMalley –
Loved this course! Teacher was easy to understand and was very engaging. Would definitely recommend this course!
Michael D Wisnock –
no idea yet
Paul Joseph McDonald –
This course is awesome and I am learning a lot! Great work.
Abiot Bedane –
yes, ,so far I am very interesting to the course since I am a beginner .
Tsegay Berhe –
AWESOME lECTURING!!!!
Anjali –
Very clear and precise
ADITYA KUMAR –
EXCELLENT COURSE, with lots of assignments and projects. If anyone wants to be a DBA, or analyst you can dive into this course.
Steven Viddal –
Repeats some stuff which was covered in SQL Bootcamp, but expect it will also go more into depth on database adm than the bootcamp course did. Also, good to get familiar with MySQL in addition to Postgresql. As expected, halfway through more in depth on database management and design has been covered. Looking forward to the rest of the course.
Renu Maurya –
good for basic understanding of the MySQL server
Amit Kumar Dalal –
Very very basic. Tells only Server installation, startup and user management in name of DBA work. User management guides wrongly. Access should be granted at DB level but the course misguides and works this at Global level. Rest all is developer work on creating tables, databases etc.
Kalpesh Bangar –
Very Good session
Uma Ota –
A new area for me but looks interesting already
Faisal Bin Humaid –
It has been a good introduction to the course can’t wait to learn more.
Sandra Schultz –
Am enjoying this course. I had instructors 10 years ago with little to no business experience in software development, mainly academic work. As a result, this course is doing an excellent job expanding their work. You’ve added a wonderful dimension with your years of real life experience.
Steven –
Easy to follow so far.
Amar Pathak –
The course is best for beginners. It will give you good insights of DB. If you are new to DB then course is good to go.
Andrew Rhodd –
This is indeed an eye opener for me. I never thought I could master these concepts. The instructor explains it well ! Good job John!
Joshua Smith –
Great easy to follow course, with great real world examples.
Jim Carnegie –
very intuitive. This is the first course I have gotten all of the questions right in
Lee Wai San –
The course is very knowledgeable and suitable for beginer, i found it was a little messy for the arangement of contents, this can be improve.
Frederick Wilhelm Br nn –
Good