I m starting in Mobile application development
iOS and Android
Swift and Java(these two I know)
throughout my career, will I ever be dealing with anything that will be SQL?
I know about SQLite that used in Android apps, isn't that enough?
The question is a good indicator that the answer is: quite possibly. If you don't even know what you will be dealing with throughout your career, how can we? You won't always be developing for Android. Even on Android, you won't always be using SQLite. Android itself won't always be using SQLite. Etc. etc.
SQL stands for structured query language. It is used to run queries against relational databases. While there is a lot of excitement about NoSQL databases there will always be a need for relational databases because complicated data relationships will always exist. NoSQL databases are mostly used for simple key value pair relationships because this is what they are best at. I think you should at least learn basic SQL, and it is very straight forward and intuitive so in a couple hours of reading out of a good book you will be able to claim that you know the basics. This might sound a little old school but you might get more out of going to the public library and finding a beginner SQL book rather than surfing around the web for it. On the web you will get lost in a lot of intellectual debates instead of just getting the facts. The Dummies books are a great starting point most of the time. There is no reason to be afraid of SQL. It is really one of the easier things to learn compared to something like Java. If you want to practice after you learn, then download a free copy of MySQL and create your own tables and join the tables using queries etc.