SQL For Beginners: Learn to communicate with databases
- Description
- Curriculum
- FAQ
- Reviews
Why Learn SQL?
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.
Almost all applications you interact with on a daily basis involves data which are stored in databases . Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.
SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.
In this beginners course, you will learn the building blocks of SQL by interacting with a MySQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.
Topics include:
-
Creating database and tables
-
Retrieving data from database table
-
Updating data inside a table
-
Deleting data inside a database table
-
Filtering data returned from a database table
-
Sorting data returned from a database table
-
Retrieving data using various operators
-
Combining data from multiple tables
-
Using aggregate functions to manipulate data.
-
Using subqueries
Take-Away Skills:
In this course, you’ll learn how to communicate with relational databases through SQL.
-
1IntroductionVideo lesson
-
2What is SQLVideo lesson
-
3What is MySQLVideo lesson
-
4Download and Install MySQL (Windows)Video lesson
-
5MySQL Installation ( Macs )Video lesson
-
6What is MySQL WorkbenchVideo lesson
-
7Installing MySQL Workbench on MacsVideo lesson
-
8Basic Database ConceptsVideo lesson
-
9What is a SchemaVideo lesson
-
10Setting up default database in MySQLVideo lesson
-
11Showing existing databaseVideo lesson
-
12Showing existing tablesVideo lesson
-
13Create your first databaseVideo lesson
-
14Create your first tableVideo lesson
-
15Basic MySQL CommandsVideo lesson
-
23What is an SQL Statement | QueryVideo lesson
-
24SQL WHERE clauseVideo lesson
-
25SQL SELECT StatementVideo lesson
-
26Removing duplicates with SQL DISTINCTVideo lesson
-
27Sorting Data with ORDER BY clauseVideo lesson
-
28Grouping data with GROUP BY clauseVideo lesson
-
29SQL HAVING clauseVideo lesson
-
30SQL SubqueriesVideo lesson
-
31Nested subqueryVideo lesson
External Links May Contain Affiliate Links read more