MySQL Database Administration: Beginner SQL Database Design

Partner: Udemy
Affiliate Name:
Area:
Description: If you’re looking to develop practical, real-world data analytics & business intelligence skills and learn the foundations of database administration (DBA) and analysis, 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 SetupFor 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.Creating, Altering, and Deleting Schemas & Tables In this section we'll learn how to create schemas and tables using SQL code and with the Workbench UI tools. Then, we will learn how to alter tables by adding and removing columns. Finally, we will walk through dropping schemas and tables (be careful with this one).Inserting, Updating, and Deleting RecordsAfter we get up to speed
Category: Development > Database Design & Development > Database Administration
Partner ID:
Price: 129.99
Commission:
Source: Impact
Go to Course