Tutorials > Udemy - MySQL A Beginner'S Guide To MySQL

Udemy - MySQL A Beginner'S Guide To MySQL


Date: 2 August 2022 | Posted by: voska89
Udemy - MySQL A Beginner'S Guide To MySQL
Last updated 11/2014
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.11 GB | Duration: 9h 45m
MySQL is a complete beginners guide to learning MySQL in plain English.


What you'll learn
You'll learn how to install a database server on your own computer
You'll learn how to create and manage multiple databases
You'll be able to create, read, update and delete data from your databases
You'll learn how to write advanced queries on your data that can be used in real reports
You will be able to create stored functions and stored procedures
You'll be able to know what kind of database indexes to use depeding on your specific environment
Requirements
You will need to have basic Windows / Mac skills, as installation of software will be required
You will need to install one piece of free software called TOAD for MySQL (We'll show you the exact steps in the course)
Knowledge of programming is a "nice-to-have"
Description
Land Your Dream Programming Job! Learning about Databases and SQL is a skill that not only benefits Database Administrators, but also programmers too. This course is designed to give programmers a "leg-up" on the competition when it comes to landing a great job in the programming field. SQL in Plain English This course is taught by former senior software engineer and teaching expert Trevor Page. His "plain English" teaching style has students around the world jumping for joy as they pick up new and valuable skills with relative ease. You can learn the mysteries of Databases, how to "talk" to them and what a good Database design looks like. It may seem like voodoo, but with Trevor's help you'll be bragging to all your friends about how you created a relational database with a full spread of tables in third normal form. Full Walkthroughs (including how to install tools) Most courses just assume that you will know what tools to use and even how to install them. Not in this course!Trevor not only teaches you the core course material, but he also takes you step by step through the (sometimes) challenging process of installing a database server on your computer and the tools you'll need to administer your new databases. It's all laid out for you in beautiful HD video and audio! Security and Automated Backups One aspect of Databases that always scares newcomers to the SQL party is how to make sure your databases are secure and backed up. No worries, you'll learn exactly how to keep your data secure and backed up (automatically) so you'll always hit the sack with a smile on your face knowing your data is safe!
Overview
Section 1: Database Basics
Lecture 1 What is a Database
Lecture 2 Rows and Database Keys
Lecture 3 Installing your Database System
Section 2: The Structured Query Language
Lecture 4 What is SQL?
Lecture 5 Using the SQL Command Line
Lecture 6 SQL Data Types
Lecture 7 How to Create a Table
Lecture 8 CRUD - Part 1a
Lecture 9 CRUD - Part 1b
Lecture 10 CRUD - Part 2
Section 3: Database Relationships
Lecture 11 Relationships
Lecture 12 Normalization - Part 1
Lecture 13 Normalization - Part 2
Lecture 14 One to Many Relationship
Lecture 15 One to One Relationship
Lecture 16 Many to Many Relationship
Lecture 17 Database Tools
Lecture 18 Database Joins - Part 1
Lecture 19 Database Joins - Part 2
Lecture 20 Database Joins - Part 3
Section 4: Advanced Queries
Lecture 21 Grouping - Part 1
Lecture 22 Grouping - Part 2
Lecture 23 Aggregate Functions
Lecture 24 Having Keyword - Part 1
Lecture 25 Having Keyword - Part 2
Lecture 26 Ordering
Lecture 27 Select Into - Part 1
Lecture 28 Select Into - Part 2
Lecture 29 Alter Tables
Lecture 30 Views
Lecture 31 Subqueries - Part 1
Lecture 32 Subqueries - Part 2
Section 5: Bonus Videos
Lecture 33 Indexes - Part 1
Lecture 34 Indexes - Part 3
Lecture 35 Indexes - Part 2
Lecture 36 Backups - Part 1
Lecture 37 Backups - Part 2
Lecture 38 Stored Procedures and Functions - Part 1
Lecture 39 Stored Procedures and Functions - Part 2
Lecture 40 Stored Procedures and Functions - Part 3
Lecture 41 Stored Procedures and Functions - Part 4
Lecture 42 How to Read MySQL Documentation
This Databases and SQL course is meant for beginners who have either no prior experience with Databases, or very limited experience. This course isn't meant for those who already have a solid foundation of knowledge in SQL.

Homepage
https://www.udemy.com/course/mysql-a-beginners-guide-to-mysql/


DOWNLOAD LINK


Links are Interchangeable - No Password - Single Extraction

See full article