Become an expert at SQL Database!
What you will learn
Description
Content
What you will learn
Description
This course will turn you into a SQL query expert. You’ll learn the skills you need to extract critical insight from data sitting in a database.
This course teaches you SQL Database, from not knowing nothing about Database to an advanced understanding about Databases and, more particularly, about SQL Databases. We’ll begin by understanding the basics of SQ;, gradually and -most importantly – with confidence we’ll move to more advanced topics, which I will cover in depth using intuitive and practical examples.
Topics covered in this course:
- What is a Database
- Creating Tables
- SELECT Statement
- WHERE Clause
- AND & OR
- Filtering Operators
- ORDER BY
- LIMIT
- Renaming Columns
- Functions
- GROUP BY & HAVING Clauses
- Aggregation Queries
- Subqueries
- CASE Clause
- Correlated Subqueries
- Table Joins
- INNER and OUTER Joins
Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using aggregations, joins, rand using conditional expressions in very interesting ways.
Who this course is for?
If you are a Android Developer or an IOS Developer and you want to add to your skills SQL Databases- then, this course if for you!
If you are a developer who wants create apps that are going to bring value to the world and, implicitly, this means that you’ll need to use Databases to store and communicate with data, because SQL Database is the most popular Database in the world, then, this course is for you!
Content