- #PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE HOW TO#
- #PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE MOVIE#
- #PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE MANUALS#
- #PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE CODE#
- #PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE DOWNLOAD#
#PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE HOW TO#
Starting SQL How to connect to the server and execute SQL statements.
#PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE MANUALS#
SQL User Manuals Mimer MySQL Oracle SQL Server Access DB2 Sybase Postgres SQLite Online copies of implementation specific user manuals. Help Desk Calls to a support desk Guest House Managing bookings for a hotel Adventure Works An example based on a wholesaler (based on MicroSoft's sample database) University Timetables Schedules for lectures and tutorials Musicians Bands, Concerts, Performances Dressmaker Making and ordering dresses Congestion Charging Monitoring and charging cars going in and out of London Challenges Module Feedback Responses from students on their learning experience.
#PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE CODE#
11 Using SQL with C# Code to connect to a database in Visual Studio.Īssessments: More involved examples for confident usersĮach assessment includes 15 questions graded easy, medium and hard. Simpler instructions for students following module INF08104 at Edinburgh Napier University 10 An introduction to transactions Video tutorials showing how sessions can interfere with each other and how to stop it. 8 SQL Hacks Some SQL Hacks, taken from "SQL Hacks" published by O'Reilly 9 Using SQL with PHP on Amazon EC2 servers Video tutorials showing how to run MySQL, PHP and Apache on Amazon's EC2 cloud servers. 7 Meta Data How to find out what tables and columns exist. 6 Users How to create users, GRANT and DENY access, get at other peoples tables. 5 Functions How to use string functions, logical functions and mathematical functions. 4 DATE and TIME How to work with dates adding, subtracting and formatting. 3 INSERT and DELETE How to put records into a table, change them and how to take them out again. 2 CREATE and DROP How to create tables, indexes, views and other things. 1 SELECT How to read the data from a database. 10 Tutorial Quizzes Test your knowledge with multiple choice quizzes 11 Tutorial Student Records Creating a database 12 Tutorial DDL Instructions on how to import data and analyse it in mysql 9+ COVID 19 In which we measure the impact of COVID-19 9 Self join In which we join Edinburgh bus routes to Edinburgh bus routes. 9- Window function In which we examine UK general election results. previously Scottish Parliament 8+ Numeric Examples In which we look at a survey and deal with some more complex calculations. 8 Using Null In which we look at teachers in departments.
#PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE MOVIE#
previously music tutorial 7 More JOIN operations In which we join actors to movies in the Movie Database. more the same 6 JOIN In which we join two tables game and goals. Sort the results by LastName, FirstName, and MiddleName. Write a query that returns the business entity ID and name columns from the Person.Person table. 5 SUM and COUNT In which we apply aggregate functions. Solutions to Exercise 2-7: Sorting Data Use the AdventureWorks2008 database to complete the exercise to practice sorting the results of your queries.
4 SELECT within SELECT In which we form queries using other queries. 3 SELECT from Nobel Additional practice of the basic features using a table of Nobel Prize winners. Regular backups, index maintenance, etc are always a good idea and good practice.Tutorials: Learn SQL in stages 0 SELECT basics Some simple queries to get you started 1 SELECT name Some pattern matching queries 2 SELECT from World In which we query the World country profile table. This is a practice environment and most of what you are creating probably won’t be something you care about saving, but best practices are always a good idea.Don’t be afraid to add a new database to test things like in-memory, filestream etc that require additional filegroups.This will give you a place to create new tables, code, whatever that you don’t want to put in your AW or WWI databases. Over time, with lots of practicing, making changes etc they get a bit scrambled so it’s easier to just overwrite them. Keep the backups so you can restore over any changes you have made.Really all we are doing here is setting up a place to work and test things.
#PRACTICE QUESTIONS ON ADVENTUREWORKS DATABASE DOWNLOAD#
However for bonus points download the sample scripts, unzip them and review them. Simple enough and again, no grade involved. Then pick your instance(s) (if you have more than one) and restore them. Microsoft has provided copies of AdventureWorks for years and recently switched over to Wide World Importers. Now it’s time to put a sample database or two on at least one SQL instance. Last month your homework was to set up your own lab.
0 kommentar(er)
