Database Administration and SQL Language Basics

Database Administration and SQL Language Basics
Database Administration and SQL Language Basics
English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 14h 33m | 1.38 GB

Welcome to the Database Administration and SQL Language Basics course! In this course, we will be using MySQL to learn about administering a database, as well as the basics of the SQL language. The first half of the course will begin with the installation of a MySQL server, then cover common administrative tasks such as creating databases and tables, inserting and viewing data, and running backups for recovery.

We will also cover the different data types that are allowed in MySQL, and wrap up the administrative side by discussing user access and privileges.

The second half of the course will focus on how to use the SQL language in order to view and manipulate data. This will include creating and deleting various database objects, adding and altering data within tables, and viewing and sorting data. After completing this course, you will have hands-on experience in administering a database know how to use the SQL language in order to manage it.

Table of Contents

1 About the Author
2 Connectors and APIs
3 Constraints
4 Backups and Recovery
5 Numeric Types
6 Date and Time Types
7 String Types
8 Views
9 Triggers
10 Stored Routines
11 Events
12 Course Overview
13 Creating and Deleting Users
14 Granting Privileges
15 Creating and Assigning Roles
16 Creating a Table with Constraints
17 Inserting
18 Updating
19 Altering Tables Part 1
20 Altering Tables Part 2
21 Deleting
22 Dropping
23 Databases
24 Creating an Index
25 Selecting
26 Clauses and Operators
27 GROUP BY and ORDER BY
28 Unions
29 Joins
30 What’s Next
31 Relational Database Management Systems (RDBMS)
32 MySQL Installation on CentOS
33 MySQL Installation on Ubuntu
34 Creating Databases
35 Creating Tables
36 Inserting, Viewing, and Deleting Data