Introduction to SQL and MySQL
What you'll learn
- Understand the basic concepts of databases
- Get a good grasp of SQL queries
Requirements
- We will perform the queries with the help of an online platform, so no previous software installations are required
Description
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!
Who this course is for:
- This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge
Course content
- Preview01:32
Instructor
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!