Got a job interview and they are asking for at least 1 years experience of SQL. I have done some beginners courses of SQL (writing basic queries). I wanted to know before i go into the interview of the things i would likely to be asked. Also there is a test on SQL so want to do some prep of the things that are likely to come up. Thanks
If you haven't been working with SQL Server, in SQL Server, doing SQL Server things for one year, then you don't have one year's worth of experience. You're likely to be asked the kinds of things that people who are junior may have done in the last year such as backups, basic queries, implementing changes to existing objects, changing security, the sorts of things that you'd do over the year. Beyond that, I won't go. I don't believe in helping people falsify their apparent knowledge and skill level. The only research you need to do for any job is research about the company and industry you're interviewing for so that you can ask intelligent questions of the interviewer.