What's new

UDEMY [100% OFF COUPON - Time left : 5 hours] Learn SQL using MySQL Database

Admin

Administrator
Staff member
Learn SQL using MySQL Database
Author : AcroTop Demy
Last update : 8/2021
Language : English​
What you'll learn
  • Learn SQL Queries from Basics.
  • Learn the process of handling Complex Queries.
  • Learn how to manage database in MySQL.
  • Learn SQL queries to explore and analyze databases using MySQL.
Course content
7 sections • 40 lectures • 4h 17m total lengthExpand all sections
Introduction : 5 lectures • 27min
  • Introduction to the Course
  • Introduction to Database
  • Introduction to SQL
  • Introduction to MySQL
  • MySQL Installation Proces
  • Introduction to Database, SQL and MySQL
Dada Defination Languge (DDL) : 8 lectures • 59min
  • Data Types (INT, FLOAT, CHAR, VARCHAR, DATE etc.)
  • Creating a Database (CREATE DATABASE)
  • Creating a new Table (CREATE TABLE)
  • Creating Duplicate Table (CREATE TABLE)
  • Constraints (NOT NULL, UNIQUE, CHECK, PRIMARY KEY etc.)
  • Adding Column in a Table (ALTER)
  • Modifying and Deleting a Column in a Table(ALTER)
  • Renaming, Deleting All Data and Deleting a Table (RENAME, TRUNCATE , DROP)
  • DATA DEFINATION LANGUAGE (DDL)
  • Data Definition Language (DDL) SQL Queries
Data Manipulation Language (DML) : 3 lectures • 30min
  • Inserting Rows in a Table (INSERT INTO)
  • Updating Fields Values in a table (UPDATE)
  • Deleting Rows in a table (DELETE)
  • DATA MANIPULATION LANGUAGE (DML)
  • DATA MANUPULATION LANGUAGE (DML) SQL Queries.
Data Querying Language (DQL) : 10 lectures • 1hr 2min
  • Displaying Records (SELECT)
  • Displaying Records in an Order (ORDER BY ASC / DESC)
  • Displaying Records as per Criteria (WHERE)
  • Displaying Records as per Criteria with multiple values (IN)
  • Grouping Records as per specific values (GROUP BY)
  • Displaying Records within a specified range (BETWEEN)
  • Displaying Records as per Aggregate function as criteria (HAVING)
  • Displaying Records as per a Specified Similar values (LIKE)
  • Displaying Records with Unique values (DISTINCT)
  • Sub Query / Inner Query - Query within an another Query
  • DATA QUERY LANGUAGE (DQL)
  • DATA QUERY LANGUAGE (DQL) SQL Queries.
DQL in Multiple Table : 9 lectures • 45min
  • Referencial-integerity-CONCEPT
  • Referencial-integerity-PRACTICAL
  • JOIN-CONCEPT
  • INNER Join
  • Multiple INNER Join
  • LEFT Join
  • RIGHT Join
  • FULL-OUTER-Join
  • Self Join
  • DATA QUERY LANGUAGE (MULTIPLE TABLE)
  • DATA QUERY LANGUAGE (MULTIPLE TABLE), SQL QUERIES ON JOIN
TRANSACTION CONTROL Language (TCL) : 2 lectures • 15min
  • TCL- CONCEPT
  • TCL-PRACTICAL
  • TRANSACTION CONTROL LANGUGAGE (TCL)
MySQL Functions : 3 lectures • 18min
  • Numeric Functions
  • String Functions
  • Date Functions
  • MySQL Functions
Requirements
  • No Database, SQL or MySQL knowledge required. We will start from the very basics and prepare you to go for the expertise level.
Description
Now-a-days, everyone should have a sound knowledge in maintaining databases. You may be an IT expert, Business professional or in any other profession, if you don't know how to maintain data then you would not feel comfortable with your profession.
SQL and MySQL, both are the powerful tools for managing and analyzing relational databases. In this course you are going to learn both of them.
Each topics of the course have been demonstrated in MySQL Prompt that may enable you to understand the process of writing a high quality SQL.
The Instructor of this course has a Master's degree in Computer Science and Engineering with 15+ years of experience. He teaches in a very fundamental level and prepares you to learn in an expertise level.
If you are seriously interested in learning a Database with so many practical example then the Course may be a best choice for you.
Enroll in this course and take an opportunity to learn a very on-demand skill.
Course Content
----------------------------
=> Introduction
Introduction to Database, SQL and MySQL
=> Data Definition Language (DDL)
CREATE, ALTER, RENAME, DROP
=> Data Manipulation Language (DML)
INSERT, UPDATE, DELETE
=> Data Query Language (DQL)
SELECT, ORDER BY, WHERE, IN, HAVING, LIKE, DISTINCT etc.
=> DQL in Multiple Table
JOIN Concepts, LEFT Join, RIGHT Join, FULL OUTER Join, SELF Join
=> Transaction Control Language (TCL)
COMMT, ROLLBACK, SAVEPOINT etc.
=> MySQL Functions
Numeric, String, Date etc.
Who this course is for:
  • Everyone who are interested to learn and work with databases.
Instructor
AcroTop DemyStart your Journey to become a Software Professional
  • 4.3 Instructor Rating
  • 66 Reviews
  • 9,592 Students
  • 2 Courses
We aim at providing high quality and in-depth training in a little time with an affordable price.
We have a wide range of courses focused in different Programming languages and Web Technology Subjects.
We spend a lot of time in order to understand the Students. The doubts of the Students are grouped together and the Lesson Plans are designed accordingly.
Most of courses are basically designed for the Students who are struggling in College in order to learn programming and for those, who are preparing for Interview.