Learn SQL with MySQL Database: Beginner to Expert

468 Enrolled

9 Hours

Deal Price$12.00

Suggested Price$199.00

You save 93%

SQL Tutorial: Learn SQL with MySQL Database - Beginner2Expert

115 Lessons (9h)

Introduction
Lecture 1: Course Introduction1:13
Lecture 2: What is SQL?2:23
Lecture 3: Who should learn SQL?2:17
Setup a Testing Environment
Lecture 4: Install MySQL database server on Windows operating system13:31
Lecture 5: Install MySQL database server on Mac operating system12:49
Lecture 6: Install MySQL database server on Linux operating system6:58
Lecture 7: How to add a new database user and add privileges10:04
Lecture 8: MySQL Command Line Client shortcut for Windows users6:40
An Overview of SQL
Lecture 9: What is DBMS and RDBMS?3:02
Lecture 10: Difference between Database Engine, Database Server and Database Software2:31
Lecture 11: What is a database? How to create and use a database?5:53
Lecture 12: What is a database table? How to create and use a database table?8:44
Lecture 13: How to add the data rows to a database table?7:19
Lecture 14: Understand Keywords, Identifiers, Constants and Clauses2:56
Lecture 15: Learn about SQL Statements1:30
Lecture 16: Data Definition Language(DDL) and Data Manipulation Language(DML)?2:34
Important SQL Clauses (Data Manipulation Language)
Lecture 17: Create example databases, tables and data rows10:50
Lecture 18: Learn about SQL SELECT Clause5:33
Lecture 19: SQL SELECT DISTINCT Statement5:16
Lecture 20: Learn about SQL FROM Clause3:10
Lecture 21: Learn about SQL WHERE Clause4:56
Conditions and Operators (Data Manipulation Language)
Lecture 22: SQL True Condition4:18
Lecture 23: SQL False Condition4:42
Lecture 24: SQL AND Operator5:59
Lecture 25: SQL OR Operator6:58
Lecture 26: SQL IN Operator5:09
Lecture 27: SQL EXISTS Condition7:49
Lecture 28: SQL NOT IN or NOT EXISTS? Conditions4:48
Lecture 29: SQL Comparison Operators4:17
Lecture 30: SQL LIKE Operator5:40
Lecture 31: SQL BETWEEN Operator4:35
Lecture 32: SQL Numeric Operators4:14
Lecture 33: SQL Concatenation Operator2:22
Lecture 34: SQL Temporal Operator1:59
Data grouping, sorting, select and dates (Data Manipulation Language)
Lecture 35: Learn about SQL GROUP BY Clause7:34
Lecture 36: Learn about SQL HAVING Clause5:45
Lecture 37: Learn about SQL ORDER BY Clause4:53
Lecture 38: SQL LIMIT or TOP Clause2:55
Lecture 39: SQL Wildcards4:56
Lecture 40: SQL Aliases6:05
Lecture 41: SQL Dates4:07
Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
Lecture 42: Add the data rows in a table using INSERT INTO Statement6:04
Lecture 43: SQL INSERT INTO SELECT Statement6:10
Lecture 44: Update data rows using UPDATE Statement7:10
Lecture 45: Delete data rows using DELETE Statement3:38
Lecture 46: What is SQL Injection and How to secure a database?5:49
SQL JOINS (Data Manipulation Language)
Lecture 47: What are JOINS in SQL? Types of SQL JOINS5:01
Lecture 48: Learn about INNER JOIN in SQL11:05
Lecture 49: Learn about LEFT OUTER JOIN in SQL7:31
Lecture 50: Learn about RIGHT OUTER JOIN in SQL7:32
Lecture 51: Learn about FULL OUTER JOIN in SQL3:52
Lecture 52: Learn about CROSS JOIN in SQL4:29
Lecture 53: SQL UNION Operator4:31
Lecture 54: SQL VIEWS8:12
Lecture 55: Derived Tables or Inline Views5:22
SQL Functions
Lecture 56: Functions in SQL and Types of SQL functions1:17
Lecture 57: SQL COUNT() Function6:02
Lecture 58: SQL FIRST() Function2:26
Lecture 59: SQL LAST() Function2:47
Lecture 60: SQL SUM() Function2:52
Lecture 61: SQL MIN() Function3:27
Lecture 62: SQL MAX() Function3:14
Lecture 63: SQL AVG() Function3:12
Lecture 64: SQL UCASE() Function2:27
Lecture 65: SQL LCASE() Function2:13
Lecture 66: SQL MID() Function2:51
Lecture 67: SQL LEN() Function2:25
Lecture 68: SQL ROUND() Function3:23
Lecture 69: SQL FORMAT() Function2:48
Lecture 70: SQL SUBSTRING() Function3:05
Lecture 71: SQL COALESCE() Function2:43
Lecture 72: SQL CHAR_LENGTH() Function2:45
Lecture 73: SQL CAST() Function3:41
Lecture 74: SQL CASE() Function6:25
Lecture 75: SQL NULLIF() Function6:12
SQL Data Types
Lecture 76: What is data type in SQL?2:04
Lecture 77: Integer Numbers in SQL (Exact Values)3:01
Lecture 78: Fixed-Point Numbers in SQL (Exact Values)3:30
Lecture 79: Floating-Point Numbers in SQL (Approximate Values)3:12
Lecture 80: CHAR and VARCHAR in SQL (String Values)2:47
Lecture 81: NCHAR and NVARCHAR in SQL (String Values)1:12
Lecture 82: CLOB and BLOB in SQL (String Values)0:57
Lecture 83: DATE, TIME and TIMESTAMP in SQL (Temporal Values)1:33
Data Definition Language
Lecture 84: Learn how to create and display databases4:11
Lecture 85: Select and use existing database2:45
Lecture 86: Remove or delete database from database management system2:57
Lecture 87: Learn how to create the database table using right method3:41
Lecture 88: Modify or update the database table details6:10
Lecture 89: Remove or delete an existing table2:16
Lecture 90: Understand Constraints in SQL1:00
Lecture 91: NOT NULL Constraint in SQL8:05
Lecture 92: UNIQUE Constraint in SQL6:46
Lecture 93: PRIMARY KEY Constraint in SQL3:23
Lecture 94: FOREIGN KEY Constraint in SQL10:32
Lecture 95: CHECK Constraint in SQL0:55
Lecture 96: DEFAULT Constraint in SQL4:19
Lecture 97: AUTO INCREMENT or SEQUENCE in SQL4:03
Database Relationships
Lecture 98: Understand Database Relationship in SQL1:43
Lecture 99: One-to-One (1:1) Relationship in SQL8:45
Lecture 100: One-to-Many (1:M) Relationship in SQL5:27
Lecture 101: Many-to-Many (M:M) Relationship in SQL7:08
Database Normalization
Lecture 102: What is Database Normalization in SQL?2:32
Lecture 103: First Normal Form (1NF) in database normalization1:14
Lecture 104: Second Normal Form (2NF) in database normalization1:30
Lecture 105: Third Normal Form (3NF) in database normalization1:19
SQL Database Export and Import
Lecture 106: What is SQL Export and Import?1:17
Lecture 107: How to Export the database using SQL statement8:32
Lecture 108: How to Import the database using SQL statement5:16
MySQL Workbench
Lecture 109: What is MySQL Workbench?5:14
Lecture 110: Create a new user and connect to database using MySQL Workbench4:20
Lecture 111: Create, Alter, Drop database using MySQL Workbench3:38
Lecture 112: Create, Alter, Drop table using MySQL Workbench7:34
Lecture 113: Insert, Read, Update, Delete data rows using MySQL Workbench4:19
Lecture 114: Database Export and Import using MySQL Workbench8:07
Thank You!
Lecture 115: Thank You!1:20

DescriptionInstructorImportant DetailsRelated Products

Learn SQL & Database Development From the Experts

Pradnyankur Nikam

Instructor

Pradnyankur Nikam is a freelance PHP and WordPress developer from Pune, Maharashtra, India. He has more than seven years of practical experience working in web designing & development, SEO (Search Engine Optimization), SMO (Social Media Optimization), Online Marketing and more. He designs web applications for clients using HTML5, CSS3, JavaScript, JQuery, Ajax, PHP, MySQL, and WordPress. He's also familiar with Java and Android application development.

Description

Course Description

Start learning SQL with practical examples, and you'll be working with tons of popular database systems like MySQL and PostgreSQL in no time. This course will teach you how exactly SQL works so you can start to master effective database design overall. These SQL skills have the power to open immense career opportunities from working as a database administrator in IT to working from home as a freelancer.

Learn database installation & SQL fundamentals w/ 115 lectures & 9 hours of content
Study Data Manipulation Language Clauses, Various Conditions and Operators, Data Filtering & more
Understand SQL Data Types in more detail
Study the MySQL Workbench, a unified visual tool for database development
Study SQL Joins, SQL functions & SQL data types
Understand database relationships & normalization
Master database export & import

Specs

Important Details

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...