Learn SQL (Structured Programming Language) in simple and easy steps starting from basics to advanced concepts.

Topics Covered

Chapter 1 : INTRODUCTION • Introduction Chapter 2 : DAY 1: DATABASE BASICS AND SCHEMA • Database • Tables • Set of Tables • Primary and Foreign Key • Data Types • Schema Chapter 3 : DAY 2 : MANAGING DATABASE AND TABLES • Database Creation • Show Database • Drop Database • Data Types • Create Table • Describe Table • Alter Table • Delete Table • Create Primary Key • Create Foreign Key Chapter 4 : DAY 3: POPULATING DATA • Setting up Database and Tables • Add Data to table • WHERE Clause • WHERE Clause examples • Arithmetic Operators and Expressions • Comparison Operators and Simple Condition • Logical Operators and Operator Precedence • Update Table Data • Delete Data from Table Chapter 5 : DAY 4: RETRIEVING DATA • Simple Select • Change Column Header • Select Specific Columns • Select Distinct Columns • Sorting the Data • Retrieve Data from Multiple Tables Chapter 6 : DAY 5: FUNCTIONS AND CREATING SUB-TOTALS • String Functions • Mathematical Functions • Date Functions • Logical Operators • NULL Data • GROUP BY clause • GROUP Functions • HAVING clause Chapter 7 : DAY 6: SUB-QUERIES • ub-Queries in SELECT • Sub-Queries in WHERE • Sub-Queries in WHERE - ANY Operator • Sub-Queries in WHERE - ALL Operator • Sub-Queries using EXISTS Operator • Sub-Queries in INSER Chapter 8 : CONCLUSION • Conclusion

Who should attend

Student or professionals

Pre-requisites

Little bit knowledge of Computers

What you need to bring

Pen and Notepad

Key Takeaways

SQL