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.

Description

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!

• This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

Course content

• Introduction
  • Introduction
• Environment
  • Installing MySQL server
• Databases
  • Non-relational database systems
  • Relational database systems
  • The Structured Query Language (SQL)
  • Data structure behind SQL - B-trees
  • Variants of SQL
• Table Manipulation
  • Data types
  • Creating a table
  • Inserting into a table
  • Delete row from a table
  • Updating a row
  • Changing table structure
  • Drop tables
  • Chapter summary & source code
• Basic SQL
  • SQL dump - the city and country tables
  • SELECT
  • WHERE
  • IN
  • BETWEEN
  • NOT - negation in SQL
  • Logical operators
  • Wildcards
  • Functions
  • ORDER BY
  • GROUP BY example I
  • GROUP BY example II
  • HAVING
  • Chapter summary & source code
• Joining Multiple Tables
  • Configuring the database tables - PERSON and UNIVERSITY
  • Inner join introduction
  • Inner join example
  • Left join introduction
  • Left join example
  • Right join introduction
  • Right join example
  • JOIN example - number of cities
  • JOIN example - total population by continent
  • Online SQL console
  • JOIN example - customers and orders
  • JOIN example - number of orders by customers
  • JOIN example - number of orders by country
  • Chapter summary & source code
• Advanced SQL - Subqueries
  • Subqueries introduction
  • Non-correlated scalar subquery
  • Non-correlated multiple-row subquery
  • Correlated subquery
  • Subqueries and joins
  • Transforming subquery into join
  • Chapter summary & source code
• Advanced SQL - Transactions
  • Transactions introduction - locking
  • Transactions introduction - transactions
  • ACID principles
  • Transaction example - COMMIT
  • Transaction example - ROLLBACK
  • Transaction example - SAVEPOINT
  • Chapter summary & source code
• Advanced SQL - Views
  • Views introduction
  • Views example - initialize database
  • Views example - create views
  • Views example - update views
  • Views example - dropping views
  • Chapter summary & source code
• Advanced SQL - Indexes And Constraints
  • Indexes introduction
  • Indexes example
  • Constraints introduction
  • Primary keys
  • Unique constraints
• Course Materials (DOWNLOADS)
  • Course materials
• DISCOUNT FOR OTHER COURSES!
  • 90% OFF For Other Courses