CODE EXAMPLE FOR SQL

is firebase nosql

Yes, it is noSQL. 
"...
The Firebase Realtime Database is a cloud-hosted NoSQL database
..."
https://firebase.google.com/products/realtime-database