ADVENTUREWORKS2012 ERD MODEL HOW TO
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.
ADVENTUREWORKS2012 ERD MODEL 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. 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 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.
0 kommentar(er)
