![]() Static Files Add Static Files Install WhiteNoise Collect Static Files Add Global Static Files Add Styles to the Project ![]() QuerySets QuerySet Introduction QuerySet Get QuerySet Filter QuerySet Order By Programming with SQL Error Messages Some error messages from SQL engines Temporary Assessment section, before the main menu is finished.Django Tutorial Django Home Django Intro Django Get Started Create Virtual Environment Install Django Django Create Project Django Create App Django Views Django URLs Django Templates Django Models Django Insert Data Django Update Data Django Delete Data Django Update Modelĭisplay Data Prepare Template and View Add Link to Details Add Master Template Add Main Index Page Django 404 Template Add Test ViewĪdmin Django Admin Create User Include Models Set List Display Update Members Add Members Delete Membersĭjango Syntax Django Variables Django Tags Django If Else Django For Loop Django Comment Django Include Starting SQL How to connect to the server and execute SQL statements. 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. 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. 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. 5 SUM and COUNT In which we apply aggregate functions. 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. Tutorials: Learn SQL step by step 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |