Learning the SQL Skills
Hello Steemit Community!
During my 15 plus years career, I worked as an IT technical support agent, analyst, specialist and an engineer. Then, I got laid off from my 7.5 years of tenure that I’ve worked in the firm. As I interviewed for a new position I was grilled for questions such as SQL and UNIX. Being a technical support team member you are acquired to learn enough to do your job and move to a more pressing matter within the day to day responsibilities of your daily job. I describe IT technical support person as a registered nurse (RN). An RN can be hired in any medical firm and you can plug’em in to any job that requires intermediate skills of medicine. Same goes for an IT technical support person. IT Technical support person can work for any firm’s infrastructure. Big or small does not matter as they know the basics. Put on many hats in order to complete their work on daily basis.
So I have decided to learn SQL skills. The first thing I research was what types of software out there in order to learn a language for database…SQL. SQL stands for structure query language for database that are being created in MS Access, Excel, Oracle, etc. All businesses from small to large use some kind of database. My purpose was/is to master the skills in learning SQL language. Why? That’s because I’ve been a technical support my entire career. I have put on many hats being in this position and became very good at my job. It is time to change the sounds of the beating drums and make some music out of it. Who knows I might even move to a different state due to the climate.
The craziest thing I learned is how to create and import sampledb.sql file into MYSQL on windows 8.1 laptop from the command line. Here’s what I did this. Since I am already logged into Mysql via command line in windows 8.1 and the path where Mysql server resides is C:\Program Files\MySQL\MySQL Server 5.6\bin. (VERY IMPORTANT - You MUST know the location of MySQL server)
- I copied the sampledb.sql file in my path “C:\Program Files\MySQL\MySQL Server 5.6\bin”.
- On prompt mysql > type create database customers; [Enter].
- Type use customers; [Enter].
- Type source sampledb.sql [Enter].
I Did This Successfully.
Keep learning at every level!!