Latest Courses
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
Git &Github Practice Tests & Interview Questions (Basic/Adv)Check course
Machine Learning and Deep Learning for Interviews & ResearchCheck course
Laravel | Build Pizza E-commerce WebsiteCheck course
101 - F5 CERTIFICATION EXAMCheck course
Master Python by Practicing 100 QuestionCheck course
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
- 40% Introduction to SQL and MySQL

Introduction to SQL and MySQL

$11.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.1/10 (Our Score)
Product is rated as #139 in category SQL

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

Hi! My name is Balazs Holczer. I am from Budapest, Hungary. I am qualified as a physicist. At the moment I am working as a simulation engineer at a multinational company. I have been interested in algorithms and data structures and its implementations especially in Java since university. Later on I got acquainted with machine learning techniques, artificial intelligence, numerical methods and recipes such as solving differential equations, linear algebra, interpolation and extrapolation. These things may prove to be very very important in several fields: software engineering, research and development or investment banking. I have a special addiction to quantitative models such as the Black-Scholes model, or the Merton-model. Take a look at my website if you are interested in these topics!

Specification: Introduction to SQL and MySQL

Duration

3.5 hours

Year

2019

Level

Beginner

Certificate

Yes

Quizzes

No

9 reviews for Introduction to SQL and MySQL

3.8 out of 5
3
3
2
0
1
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Olubusola Akintayo

    Easy to learn and understand

    Helpful(0) Unhelpful(0)You have already voted this
  2. Arnaldo de Barros Mussio

    O SO do instrutor esta na sua l ngua nativa, foi demorado encontra as configura es equivalentes no meu sistema.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Jayesh bhadane

    Yes,it is very nice course very helpful for improving basic knowlege

    Helpful(0) Unhelpful(0)You have already voted this
  4. Hema Nathen

    The installation of SQL method needs to be updated to the current method of installation.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Jai Melendez

    Slow down… You go extremely fast

    Helpful(0) Unhelpful(0)You have already voted this
  6. Eric Piper

    So far, it’s just a little vocab, so there’s not a lot of meat there to chew on.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Daniel Alan Peterson

    Excellent match. Instructor seems very experienced and confident.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Detric Benton

    I am a beginner in MySQL but I am learning a lot. The instructor is very smart.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Tom Underman

    speak english

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Compare items
    • Total (0)
    Compare