Share Description
In this course, you will learn:-
- We'll lay a solid foundation for SQL using a step-by-step method and real-world applications. We'll be able to do the following after completing this course
- SQL Queries are used to get all or a subset of rows from a database table
- Create SQL Queries to obtain all or a subset of a database table's columns
- SELECT, FROM, WHERE, ORDER BY, and the logical operator are all useful
- Use this information in relational databases like Oracle, Microsoft SQL Server, Microsoft Access, MySQL, SQLite, Postgre SQL, and IBM DB2
Syllabus:-
- Course Introduction
- Which SQL we will learn in this course?
- How to run an SQL query in Browser
- Northwind Sample Database Structure
- Write your first SQL Query - Bring all the records using SELECT statement
- How to retrieve selected columns/fields
- How to retrieve selected rows - apply criteria using WHERE clause
- Advanced criteria using WHERE clause and Logical Operators (>, =, <>, <)
- How to Sort records using ORDER By clause
- Recap - What have you learnt so far
