The network layer is above the data-link layer mainly because the network layer has a broader view of the network than the data-link layer. The data-link layer (Ethernet, WiFI, etc.) talks about network cards, links between them and local networks. The network layer (mainly IP) talks about IP addresses and how hosts must route a network packet to achieve an end-to-end communication.
To summarize the OSI pile very quickly:
Layer 1: physical layer -> copper, fiber, wireless, etc. - talks about frequencies, bit coding, etc.
Layer 2: data-link layer -> Ethernet, WiFi, Bluetooth, etc. - talks about network cards, links between them and allows the creation of local networks (via dedicated or shared media).
Layer 3: network layer -> mainly IP - talks about IP addresses and routing of packets to achieve an end-to-end communication.
Layer 4: transport layer -> mainly TCP/UDP - provide the concept of "port", allowing flow multiplexing between the same IP addresses. TCP also offers flow control, congestion control, in-order delivery and retrasmission of packets.
Layer 5: session layer -> some of its features (such as connections) are usually provided by TCP in real networks. See the Wikipedia article for details.
Layer 6: presentation layer -> some of its features (such as context transfer or encryption) are usually implemented by the application layer in real networks. See the Wikipedia article for details.
Layer 7: application layer -> HTTP, SMTP, POP, but also Skype, ed2k, torrent, etc. allows networked applications and services to communicate through their specific protocols.
And if you were asking yourself, yes, there still are network devices that implement the OSI stack as it was originally conceived. I've seen a few of them still operational. Maybe we could open another thread to know their name and purpose...