MySQL Beginner

"MySQL is the world’s most popular open source database. According to DB-Engines, MySQL ranks as the second-most-popular database, behind Oracle Database. MySQL powers many of the most accessed applications, including Facebook, Twitter, Netflix, Uber, Airbnb, Shopify, and Booking.com. Since MySQL is open source, it includes numerous features developed in close cooperation with users over more than 25 years. So it’s very likely that your favorite application or programming language is supported by MySQL Database."

Created By admin admin English
What Will I Learn?
  • Installation
  • Basic Commands
  • Keywords
  • Operators
  • Clause
  • Functions
  • Views
  • Statements
  • Sub Query
  • Constraint
  • Joins
  • Indexes
  • Temporary Tables
  • Oracle Installation
  • Oracle Queries

Knowledge Detail
111 Lessons 04:35:08 Hours
  • Database Concepts -Database- DBMS- Data Models- RDBMS and SQL- 00:33:33
  • Practice SQL without installing any Software 00:11:47
  • Select Command 00:06:30
  • Distinct keyword 00:06:48
  • SQL is not case sensitive 00:03:13
  • Semicolon 00:08:42
  • Where Clause 00:14:02
  • Using Relational Operators in Where Clause Condition 00:07:46
  • Using Logical Operators-AND-OR-NOT 00:15:15
  • Between Operator 00:09:32
  • Order By Clause-ASC-DESC 00:11:52
  • Using Between Operator with Text 00:11:27
  • In OperatorSQL 00:07:23
  • Like Operator and Wildcard Characters 00:19:25
  • Aliases for Table Column Names AS Keyword 00:11:20
  • Limit Keyword 00:09:24
  • Breaking the Lengthy SQL Statement into multiple lines 00:05:31
  • MySQL Built in Functions 00:10:31
  • MySQL String Function 00:08:55
  • lower-- String Function 00:10:30
  • length-- String Function 00:10:39
  • instr-- String Function 00:12:05
  • substr-- String Function 00:14:15
  • concat-- String Function 00:12:25
  • trim-- String Function 00:16:44
  • abs-- Numeric Function 00:11:18
  • mod-- Numeric Function 00:09:25
  • greatest-- and least-- Numeric Functions 00:05:25
  • truncate-- Numeric Function 00:08:47
  • power-- and sqrt-- Numeric Functions 00:03:48
  • Current Date (curdate--- current-time--- curtime--- now-- - sysdate--) 00:11:25
  • year---month---day---monthname---dayname-- Date Time Functions 00:08:31
  • avg--- max--- min--- count-- and sum-- MySQL Aggregate Functions 00:06:40
  • Arithmetic Operators 00:05:16
  • For_Beginners_Installing_MySQL_Server_and_Workbench_Client_for_Practicing_SQL 00:14:20
  • Installing MySQL Server and Workbench Client for Practising SQL 00:34:44
  • Creating- Deleting- viewing and using Databases 00:18:16
  • Creating- Viewing- Describing and Deleting Tables 00:19:18
  • Insert Into Statements -For inserting data into Tables- 00:14:15
  • Data Types 00:35:47
  • Null Value- Is Null Operator and Is Not Null Operator 00:11:18
  • Delete Statement -For Deleting the Records from Table- 00:06:59
  • Update Statement and Set Keyword -For Updating the Table Records- 00:10:52
  • Rename statement and To Keyword -For Renaming Table Name 00:03:41
  • Alter Statement- Add- Modify Column- Rename Column- and Drop Column 00:09:59
  • Set Autocommit 00:11:47
  • Commit Statement 00:09:10
  • Rollback Statement 00:08:23
  • Truncate Statement 00:08:46
  • Single Line and Multi Line Comments 00:12:48
  • Group By Clause 00:10:19
  • Having Clause 00:12:43
  • Sequence of using where- group by- having and order by clauses 00:08:44
  • Set Operators 00:14:16
  • Union Operator 00:49:28
  • Union All Operator 00:13:31
  • Intersect Operator 00:16:19
  • Minus Operator 00:13:38
  • Tables and Aliases 00:17:26
  • Joins -Inner Join- Left Join- Right Join- Full Join and Self Join- 00:42:47
  • Sub Query -Single Row Sub Query explained by solving different problems- 00:18:57
  • In Operator 00:08:41
  • Using In Operator with Multi Row Sub Query 00:12:23
  • Using All Operator in Multi Row Sub Query 00:12:23
  • Using All Operator in Multi Row Sub Query 00:06:44
  • Exists Operator 00:06:53
  • Using Sub Queries for retrieving the records from multiple tables 00:14:09
  • Using Multiple Sub Queries in a single SQL statement 00:10:14
  • Integrity Constraints 00:09:27
  • Not Null Integrity Constraint 00:08:38
  • Unique Integrity Constraint 00:10:25
  • Primary Key Integrity Constraint 00:10:25
  • Foreign Key Integrity Constraint 00:35:01
  • Check Integrity Constraint 00:09:59
  • Default Integrity Constraint 00:10:25
  • Auto Increment 00:12:38
  • Insert Into 00:16:11
  • AS Keyword 00:08:16
  • IfNull-- function 00:07:43
  • Case- When- Then and End Keywords 00:22:39
  • Delimiter 00:07:28
  • Delimiter usage in Stored Procedures 00:15:10
  • Views 00:40:11
  • Indexes 00:30:05
  • JDBC -MySQL Database connection from Java Programs 00:01:02
  • ODBC -Object Database Connectivity- using SQL ODBC Query Client Tool 00:37:59
  • MySQL Shell Command Line Tool 00:12:15
  • MySQL Command Line Client 00:08:13
  • Connect MySQL Server Using Command Line 00:08:24
  • Types of SQL Statements 00:05:27
  • Grant and Revoke SQL Statements 00:18:58
  • Temporary Tables 00:08:18
  • Show Columns Show Indexes and Show Grants Statements 00:11:33
  • Inserting Null 00:05:07
  • Using trim for trimming the corner characters 00:12:21
  • Using wild cards as normal characters 00:08:06
  • Database Objects 00:08:34
  • Creating linux virtual machine 00:29:15
  • Installing MySQL Server in Linux Ubuntu Machine 00:21:43
  • Putty for Connecting to a Remote Machine having MySQL Server 00:36:37
  • Oracle 11g Software- SQL Plus- SQL Developer and Executing SQL Queries 00:44:06
  • Oracle SQL Queries - Part 1 00:59:34
  • Oracle SQL Built in functions 00:28:29
  • Oracle SQL Queries -Part 2 00:39:32
  • Oracle SQL Queries -Part 3 00:22:10
  • Oracle SQL Queries -Part 4 00:37:50
  • Oracle SQL Queries -Part 5 01:07:37
  • DBeaver Universal DB Client Tool 00:16:25
  • XAMPP for Practicing SQL 00:17:09
  • For Beginners - Savepoint 00:07:27
  • Uninstalling MySQL Server completely from Windows Machine 00:06:09
Requirements
  • Good Laptop Min: 8GB RAM
  • Good Internet Connection
  • Any Degree
  • 4Hrs / Day For Learning
Description


MySQL is a relational database management system

Databases are the essential data repository for all software applications. For example, whenever someone conducts a web search, logs in to an account, or completes a transaction, a database system is storing the information so it can be accessed in the future.

A relational database stores data in separate tables rather than putting all the data in one big storeroom. The database structure is organized into physical files optimized for speed. The logical data model, with objects such as data tables, views, rows, and columns, offers a flexible programming environment. You set up rules governing the relationships between different data fields, such as one to one, one to many, unique, required, or optional, and “pointers” between different tables. The database enforces these rules so that with a well-designed database your application never sees data that’s inconsistent, duplicated, orphaned, out of date, or missing.

The “SQL” part of “MySQL” stands for “Structured Query Language.” SQL is the most common standardized language used to access databases. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or use a language-specific API that hides the SQL syntax.

MySQL is open source

Open source means it’s possible for anyone to use and modify the software. Anybody can download MySQL software from the internet and use it without paying for it. You can also change its source code to suit your needs. MySQL software uses the GNU General Public License (GPL) to define what you may and may not do with the software in different situations.

If you feel uncomfortable with the GNU GPL or need to embed MySQL code into a commercial application, you can buy a commercially licensed version from Oracle. See the MySQL Licensing Information section for more information.

+ View More
+ View More
Other Related Courses
12:32:12 Hours
Updated Thu, 14-Mar-2024
21:13:38 Hours
Updated Thu, 14-Mar-2024
14:09:25 Hours
Updated Wed, 21-Feb-2024
01:42:52 Hours
Updated Wed, 21-Feb-2024
02:41:11 Hours
Updated Wed, 21-Feb-2024
03:01:19 Hours
Updated Wed, 21-Feb-2024
02:03:47 Hours
Updated Wed, 21-Feb-2024
06:12:45 Hours
Updated Wed, 21-Feb-2024
16:41:35 Hours
Updated Wed, 25-Oct-2023
09:28:02 Hours
Updated Wed, 21-Feb-2024
03:25:07 Hours
Updated Wed, 21-Feb-2024
04:29:00 Hours
Updated Wed, 21-Feb-2024
05:25:03 Hours
Updated Wed, 21-Feb-2024
04:08:51 Hours
Updated Wed, 21-Feb-2024
01:56:53 Hours
Updated Sun, 28-Jan-2024
04:03:43 Hours
Updated Wed, 21-Feb-2024
05:06:18 Hours
Updated Wed, 21-Feb-2024
00:22:50 Hours
Updated Wed, 21-Feb-2024
01:15:47 Hours
Updated Wed, 21-Feb-2024
00:29:46 Hours
Updated Wed, 21-Feb-2024
05:54:00 Hours
Updated Wed, 21-Feb-2024
10:00:18 Hours
Updated Tue, 13-Feb-2024
10:37:55 Hours
Updated Wed, 21-Feb-2024
14:44:47 Hours
Updated Wed, 21-Feb-2024
00:00:00 Hours
Updated Mon, 26-Feb-2024
02:27:14 Hours
Updated Tue, 27-Feb-2024
21:01:59 Hours
Updated Wed, 28-Feb-2024
06:28:07 Hours
Updated Wed, 27-Mar-2024
Includes:
  • 04:35:08 Hours On Demand Videos
  • 111 Lessons
  • Full Lifetime Access
  • Access On Mobile And Laptop