Assignment: SQL
Help with this activity. Include screen shots every step
All exercises are to be performed using query editor using T-SQL.
1. Create a folder under the root of the C: drive called SQL-LAB. Create a database in this location called testdbl using T-SQL.
Make sure the command has all the parameters needed to create the MDB and LDB files on this newly created folder. Use a size of 10, maxsize of 50 and filegrowth of 5.
2. What does the filegrowth parameter on our previous example does for us?
3. Create a dedicated sql login for a user called "mysqluser1- with a password of your choosing. Add the db_ddladmin role to this user. Close SSMS and re-open it while login with this user to test it.
4. What is DDL and DML language in SQL server. Provide two examples of each.
5. Using adventure works database on your SQL server, create a statement that selects the emailaddress field only from the table Person. Emailaddress.
6. Using adventureworks database. Create a query that will select the FirstName and LastName from the Person.Person table only of records that have a BusinessEntitylD greater than 500.
7. Define the ORDER BY statement.
8. Based on question #6 use the ORDER BY command to arrange our list by alphabetical order based on the LastName.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.