With lots of students/professionals struggling to write the perfect query, this class is just for you. But wait SQL is not just about queries. Are you missing something? Well, to sum up merely the knowledge of just writing queries wont help you. You also need to know the data-structure, the relations and the object orientation behind the tables and Databases. Here we do exactly that and teach SQL from a very different perspective from scratch.

Topics Covered

Topics Covered in Part 1 1. What is exactly a Database? 2. How do we connect to a database? 3. Creating the Database. 4. Creating and Working with tables is not "Rocket Science". 5. All you ever wanted to know about Primary and Foreign Keys. 6. Demystifying Constraints (Default Constraint) 7. Tackling with the Toughest thing - "Cascading Referential Integrity Constraint" 8. Check Constraint - The Life Saver 9. Are you in Identity Crisis: Use Identity Column 10.Big Headache Resolved : Retrieving Identity Column Values 11. Be Unique: Unique Key Constraint 12. You're so Selective: Select Query 13: Lets attack in a Group: Group By Clause 14: No more Joint Pains: The Ultimate Guide to all types of Joins 15. Advanced and Intelligent Joints

Who should attend

Anyone who wants know about SQL starting from kids to professionals, whether you are looking for job or refreshing your knowledge on SQL. This is the perfect point.

Pre-requisites

No pre-requisites. Everything shall be dealt from scratch.

What you need to bring

Hold you pen & paper and take down notes and listen carefully.

Key Takeaways

1. Class Notes of what we have studied. 2. Lab notes of everything we have done online so that you can practise the same when you're frees and your ease.