The ideal WordPress theme for school or college
Registration
Notice
Online Course
Call Us
0192694455
Email Us
trendytheme@gmail.com
Home
Home Page 2
Pages
About us
Notice
Aims & Ethos
Development
History
International College
News from Edukare
OKS
Partnerships
The Headmaster
The King’s Society
Courses
Edukare Courses
Online Course
Teachers
Events
News
Elements
Shotcode List One
Alert Messages
Accordions and Toggles
Progress Bars
Image Block Shortcode
Shotcode List Two
Services Shortcode
Course Shortcode
Teachers Shortcode
Testimonials Shortcode
Shotcode List Three
Media Embeds Shortcode
Latest Post Shortcode
Event Shortcode
Photo Gallery
Shotcode List Four
Grid and Column
Buttons Shortcode
Tab Shortcode
Typography
Contact
Home
Home Page 2
Pages
About us
Notice
Aims & Ethos
Development
History
International College
News from Edukare
OKS
Partnerships
The Headmaster
The King’s Society
Courses
Edukare Courses
Online Course
Teachers
Events
News
Elements
Shotcode List One
Alert Messages
Accordions and Toggles
Progress Bars
Image Block Shortcode
Shotcode List Two
Services Shortcode
Course Shortcode
Teachers Shortcode
Testimonials Shortcode
Shotcode List Three
Media Embeds Shortcode
Latest Post Shortcode
Event Shortcode
Photo Gallery
Shotcode List Four
Grid and Column
Buttons Shortcode
Tab Shortcode
Typography
Contact
Latest Course
Computing and Arts
Arts
Statistics
Biomedical Engineering
Engineering
Advance Mathematics
Mathematics
Popular Events
Various versions have evolved over the years
Learning
Library
Lorem Ipsum is simply dummy text of…
Party
School
Lorem Ipsum is simply dummy text of…
Learning
School
Popular Right Now
5 Kid-Friendly Yoga Poses That Will Open…
edukare
8 Nov 2017
When Everything Is Your Favorite Thing
edukare
17 Oct 2017
Holisticly incentivize effective sources via extensible infomediarie
edukare
17 Oct 2017
Canvas Convocation Program
edukare
17 Oct 2017
Perfume Tips Tricks
edukare
17 Oct 2017
Learn SQL with MySQL Database
Introduction
What is SQL?
Who should learn SQL?
Quiz 1: Introduction
0 question
10 min
Setup a Testing Environment
Install MySQL database server on Mac operating system (MySQL 5.7.20)
Install MySQL database server on Linux operating system (MySQL 5.7.20)
How to add a new database user and add privileges
Quiz 2: Setup a Testing Environment
An Overview of SQL
What is DBMS and RDBMS?
Difference between Database Engine, Database Server and Database Software
What is a database table? How to create and use a database table?
How to add the data rows to a database table?
Data Definition Language(DDL) and Data Manipulation Language(DML)?
Data Manipulation Language
Learn about SQL SELECT Clause
SQL SELECT DISTINCT Statement
Learn about SQL WHERE Clause
Quiz 4: Important SQL Clauses
0 question
10 min
Conditions and Operators
SQL False Condition
SQL ALL Operator
SQL Functions
Functions in SQL and Types of SQL functions
SQL FIRST() Function
SQL LAST() Function
SQL MAX() Function
SQL AVG() Function
SQL MID() Function
SQL CASE() Function
SQL Data Types
Integer Numbers in SQL (Exact Values)
Fixed-Point Numbers in SQL (Exact Values)
Floating-Point Numbers in SQL (Approximate Values)
CHAR and VARCHAR in SQL (String Values)
NCHAR and NVARCHAR in SQL (String Values)
Quiz 10: SQL Data Types
0 question
10 min
Learn SQL with MySQL Database
Back to Course
This content is protected, please
login
and enroll course to view this content!
Prev
Who should learn SQL?
Next
Install MySQL database server on Mac operating system (MySQL 5.7.20)
Course Info
Lessons
28
Quizzes
3
Preview Lessons
0
All
31
Course Category
Database
(1)
Design
(1)
Development
(4)
Digital Marketing
(1)
Game Developmetn
(1)
IT
(0)
Programming
(2)
