HRS SQL

COURSE OVERVIEW

SQL Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data.

COURSE OUTLINE

  • Introduction To Database Design
  • Learn Database Normalization with the help of a case study
  • Learn ER Modeling with a Case Study
  • How To Create A Database & MySQL DataTypes
  • How to use SELECT in MySQL
  • How to query data using Where clause in MySQL
  • How to use Insert Into in MySQL
  • How to Delete & Update data in MySQL
  • How sorting is done in MySQL using ORDER BY, DESC and ASC
  • How to use Group By in MySQL
  • How to use Wildcards in MySQL
  • Using Regular Expressions & Wild Cards in MySQL
  • Ultimate guide to Functions used in PHP
  • How to use Aggregate Function in MySQL
  • All about Null value & Keyword in MySQL
  • How to use Auto Increment in MySQL
  • How to use Alter, Drop & Rename function in MySQL
  • How to use Limit keyword in MySQL
  • Using Sub-Queries in MySQL
  • How to use Joins in MySQL
  • How to use Unions in MySQL
  • How to use Views in MySQL
  • How to use Index in MySQL
  • Creating an Application using MySQL
  • Oracle MySQL 5.6 Certification with Study Guide
  • SQL vs MySQL: What's the Difference?
  • 20 Best SQL Management Tools
  • Top 50 SQL Interview Questions & Answers
  • ASP.NET Application & PAGE Life Cycle
  • ASP.NET First Program Example
  • ASP.Net - Intro, Life Cycle & Hello World Program
  • ASP.Net - Intro, Life Cycle & Hello World Program 2
  • ASP.NET Web Forms Tutorial: User Controls Examples
  • Insert, Update, Delete: ASP.NET Database Connection Tutorial
  • Asp.Net Page Level Tracing, Debugging, Error Handling [Example]
  • How to Host a Website on IIS: Setup & Deploy Web Application
  • How to Create and Run Asp.Net Unit Testing Project
  • ASP.NET MVC Tutorial for Beginners
  • 50 ASP.Net Interview Questions & Answers
  • Potential Security Threats To Your Computer Systems

Learning Path