
16
Apr
- 2700 (Registered)
-
Course Description
Did you know if you are the expert in SQL you can communicate with all Relational databases?
If you are not familiar with SQL watch this course and learn how to communicate with databases using SQL.
We will discuss the relationship, relational databases, databases type, NoSQL databases.
You will learn how to optimize your query.
You will also learn Basic + complex queries, joins and much more.
Learning Outcomes
- How to read and write complex queries to a database
- How to Use joins in SQL
- CRUD operation
- You can communicate with your database via SQL.
- You can easily write your queries
- You can join more than one table
- You can fetch data from multiple tables using joins
Course Content
-
Introduction
-
Basic concepts
- How Data Insert In Database
- Introduction To Relational Database
- Introduction To Databases
- SQL And NOSQL Databases
- SQL Syntax
- Comments In Sql
- How SQL Query Works
- Introduction To MYSQL Database
- The SQL SELECT Statement
- SQL WHERE Clause
- SELECT DISTINCT Statement In SQL
- AND Operator In SQL
- OR Operator In SQL
- Speical AND Condition In SQL
- SQL _ Wildcard
- Charector Matching In SQL
- ORDER BY Keyword In SQL
- INSERT INTO Statement In SQL
- UPDATE Statement In SQL
- DELETE Statement In SQL
- SELECT TOP Clause In SQL
- IN Operator In SQL
- BETWEEN Operator In SQL
- Aliases In SQL
- Introduction To Joins In SQL
- More About Joins In SQL
- INNER JOIN Keyword In SQL
- Left Outer Join OR Outer Join In SQL
- Right Outer Join OR Right Join In SQL
Students List
and 2700 students enrolled.