6 hrs Free Masterclass All About SQL with Nawaj

Topics

• Installation & get to know MySQL
  • Installing Visual C
  • Installing MySQL Workbench and Server
  • The Client-Server Model
  • Installing MySQL on Windows, macOS and Unix systems
  • Creating a New User and a New Connection to it
  • Linking GUI with the MySQL Server
  • SQL Fundamentals - MySQL Session and Databases
  • Familiarize Yourself with the MySQL Interface
  • SQL Fundamentals - DROP, CREATE, SELECT, INSERT, DELETE
• Relational Database & introduction to SQL
  • Why use MySQL?
  • Why use SQL?
  • Relational Database Fundamentals
  • Introducing Databases
  • Important Database Terminology
  • Comparing Databases and Spreadsheets
  • The Concept of Relational Schemas: Foreign Key
  • The Concept of Relational Schemas: Primary Key
  • The Concept of Relational Schemas: Relationships Between Tables
  • The Concept of Relational Schemas: Unique Key and Null Values
• Best SQL Practices
  • Coding Tips and Best Practices