The description
SQL for Beginners: Learn SQL using MySQL and Database Design is a tutorial provided by Udemy site that teaches you the SQL programming language using MySQL database and database design. Nowadays, having the skills to work with databases has become a must for programmers and can create a variety of job opportunities for them. Becoming a database expert requires learning SQL, acquiring a database, and designing a database. This course will help you learn SQL and familiarize yourself with database design and data analysis.
During this training, you will learn how to create a custom database for your online movie ticket booking system. By building this database, you will become familiar with the SQL language, MySQL database, database design and data analysis, and in the end you will be able to fully master the types of databases. The tutor also teaches how to create, modify and delete tables, talks about updating and inserting information, shows how to select queries and familiarizes you with the functions of functions.
Courses taught in this course:
- SQL language training
- Learn to use MySQL database
- Introduction to database design
- Learn to analyze information
- Working with tables and database data
- Use queries and functions
- Complete construction of a custom database
SQL for Beginners Course Specifications: Learn SQL Using MySQL and Database Design:
- English language
- Duration: 7 hours and 47 minutes
- Number of courses: 123
- Education level: Intermediate
- Instructor: Tim Buchalka\’s Learn Programming Academy, Jon Avis – SQL Instructor
- File format: mp4
SQL for Beginners Course: Learn SQL Using MySQL:
123 lectures 07:47:34
Presentation of the course
2 lessons 05:10
Setup and setup
8 lectures 01:01:07
Data Definition Language
7 lessons 26:08
More about Alter Table
9 lessons 38:37
Data manipulation language
5 lessons 18:01
Selection in an array
18 class 58:09
Selection from multiple tables
8 sessions 33:23
Database design
10 lessons 39:41
Creation of a cinema reservation system database
10 sessions 41:11
Aggregate functions
12 lessons 33:39
Subqueries
7 lessons 28:40
MySQL Functions – String Functions and Date Functions
12 lessons 53:19
Challenges
13 sessions 29:11
bonus material
2 lessons 01:23
Preconditions for SQL for Beginners: Learn SQL with MySQL:
- A PC (Windows or Linux) or Mac is required
- No prior knowledge of databases, SQL or MySQL is required.
Pictures
sample movie
Installation guide
View with your favorite player after ripping.
english subtitle
Quality: 720p
Download link
File password(s): ngaur.com
Cut
1.7 GB