Learn the basic concepts and functions that you will need to make queries with the most popular data manipulating programming language, SQL. This course is about SQL commands in the main. You will learn the basics of queries. This is a fundamental part of databases so it is definitly worth learning.
Section 1:
setting up the environment
installing MySQL
relational databases theory
Section 2:
SQL and MySQL basics
creating databases and database tables
updating tables
dropping tables
Section 3:
basic SQL and MySQL commands
select, where and wildcards
ORDER BY and GROUP BY commands
Section 4:
joining multiple database tables
Section 5:
advanced SQL and MySQL
subqueries
transactions (ACID principles)
views
indexes and constraints
Learning the fundamentals of SQL is a good choice and puts a powerful tool at your fingertips. SQL is easy to learn as well as it has excellent documentations.
The most important fact about SQL that it is used in almost every speciality from software engineering to financial analysis, so understanding the concepts and basic language features can prove to be very marketable.
Thanks for joining the course, let’s get started!
Instructor Details
Courses : 24
Specification: Introduction to SQL and MySQL
|
9 reviews for Introduction to SQL and MySQL
Add a review Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Price | $11.99 |
---|---|
Provider | |
Duration | 3.5 hours |
Year | 2019 |
Level | Beginner |
Language | English |
Certificate | Yes |
Quizzes | No |
$19.99 $11.99
Olubusola Akintayo –
Easy to learn and understand
Arnaldo de Barros Mussio –
O SO do instrutor esta na sua l ngua nativa, foi demorado encontra as configura es equivalentes no meu sistema.
Jayesh bhadane –
Yes,it is very nice course very helpful for improving basic knowlege
Hema Nathen –
The installation of SQL method needs to be updated to the current method of installation.
Jai Melendez –
Slow down… You go extremely fast
Eric Piper –
So far, it’s just a little vocab, so there’s not a lot of meat there to chew on.
Daniel Alan Peterson –
Excellent match. Instructor seems very experienced and confident.
Detric Benton –
I am a beginner in MySQL but I am learning a lot. The instructor is very smart.
Tom Underman –
speak english