English | 2016 | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 4.5 Hours | 648 MB
Learn SQL From Scratch Using MySQL Databases, A Complete Course For Beginners
Here Is Everything You Will Learn In This Complete Course:
What are databases and why databases are used.
What is SQL and how it can be used to manipulate data into database.
What are the different types of data definition queries used to create tables.
What are the different types of data manipulation queries which can be used to manipulate data.
We first begin the course with the basic introduction about databases and understand what exactly are databases and why they are used. We then learn how to install the required tools which will allow us to create our own databases and add data into it.
Moving along, we learn some SQL operators, and we also learn how these operators can be used in SQL queries which allows us to form more complex queries.
Moving along we learn how SQL statements can be used to insert, update and delete data into the database. Once it is done, we move forward to learn about joins and learn what are different types of joins.
Once we complete each and every concept in SQL, we finally have a set of practice examples, which will allow you to practice SQL queries on your own.