Udemy – SQL for Beginners: Learn SQL using MySQL and Database Design 2019-7

Description

SQL for Beginners: Learn SQL using MySQL and Database Design is a training course provided by the Udemy site that teaches the SQL programming language using the MySQL database and database design. Nowadays, having skills in working with databases has become an essential thing for programmers and can create a variety of job opportunities for them. Becoming a database specialist requires learning SQL, familiarity with a database, and database design. This course will help you learn SQL and become familiar with database design and data analysis.

During this training, how to create a custom database for the online cinema ticket reservation system is shown. By building this database, you will become practically familiar with the SQL language, MySQL database, database design, and data analysis, and in the end you can work with complete mastery on a variety of databases. The course instructor will also teach you how to create, modify, and delete tables, talk about updating and entering information, show you how to select queries, and introduce you to the uses of functions.

Items that will be taught in this course

SQL language training

Learn how to use the MySQL database

Familiarity with database design

Learn to analyze information

Working with tables and database data

Use queries and functions

Complete build of a custom database

SQL course specifications for Beginners: Learn SQL using MySQL and Database Design

English language

Duration: 7 hours and 47 minutes

Number of courses: 123

Level of education: Intermediate

Instructor: Tim Buchalkas Learn Programming Academy, Jon Avis - SQL Instructor

File format: mp4

SQL course titles for Beginners: Learn SQL using MySQL

123 lectures 07:47:34

Course Introduction 2 lectures 05:10

Installation and Setup 8 lectures 01:01:07

Data Definition Language 7 lectures 26:08

More On Alter Table 9 lectures 38:37

Data Manipulation Language 5 lectures 18:01

Selecting from a Table 18 lectures 58:09

Selecting From Multiple Tables 8 lectures 33:23

Database Design 10 lectures 39:41

Creating a Cinema Booking System Database 10 lectures 41:11

Aggregate Functions 12 lectures 33:39

Subqueries 7 lectures 28:40

MySQL Functions – String Functions and Date Functions 12 lectures 53:19

Challenges 13 lectures 29:11

Bonus Material 2 lectures 01:23

SQL Prerequisites for Beginners: Learn SQL using MySQL

A PC (Windows or Linux) or Mac is required

No prior knowledge of Databases, SQL or MySQL is needed.

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p