What cable is usually used on serial ports of cisco routers.
cisco - Routing Serial cables instead of Ethernet - Network Engineering Stack Exchange
Cant use DCE or DTE cable on Cisco 1941 router (packet tracer)
Difference between using serial cable and Ethernet cable between routers?
Videos
I'm just starting to practice for CCNA and have never ever seen any Cisco equipment ( but have done some moderate networking on lower class devices). So Its mentioned that Cisco routers usually go to WAN using a serial port and I don't really understand what that is. All my life I've seen routers going want through either phone lines (dsl), utp cables or fiber( when FTTH is implemented). So why are Cisco's routers going out using that serial port and what's the cable that's sticked in there?
One of the jobs of a router is to connect networks that have physically different transmission media. Twisted-pair Ethernet is extremely common these days, but fiber (Ethernet, SONET/OC, and others) is used for most high-speed or long-distance runs, and different types of layer-2 and layer-1 networks have been used in the past and are still in use today, such as T1/T3 lines, ISDN, and Token Ring.
For historical reasons, serial cables such as HSSI may be used to connect equipment such as T1/T3 terminating devices. These will show up as interface SerialN, and you can get detailed information on the hardware installed in a router with show controllers serial.
Unfortunately, "DCE/DTE" technically applies to a number of different hardware signaling schemes. In the context of networking, it's most likely to refer to a serial interface that's used to connect to a WAN drop.
In the case of your simulator, you should practice with both types of interfaces. In most business networks, the "inside" interfaces will be Ethernet, while the WAN interface will be either serial or Ethernet depending on what service the telco is providing, and you'll need to be able to configure either one.
For the sake of completeness: Serial links are not solely used for gateway-WAN connections.
For instance, there are companies which host your network equipment and link your device via serial link to their infrastructure. Although your device is online with a public address, it still is not a DTE-like topology.
Another even more LAN-related serial link may be used on a daily basis by yourself and your colleagues: USB. Since USB does not only connect an end device to a storage device, but is also hosts to networks. An example for a host-to-LAN connection would be a tablet user currently being dislocated from a WAP. Because tablets usually do not have an Ethernet interface, a work-around is necessary. An example for a host-to-WAN connection would be field personnel accessing mobile broadband services via a pluggable antenna.
Short answer: No.
Longer answer: It's an RS-232 serial interface, not an Ethernet interface.
Side note: I've just checked a Cisco serial cable and confirmed that it's an 8P8C connector; but RJ45 is a different beast entirely.
No
Console cables are rollover cables. Pin 1 goes to pin 8. Pin 2 goes to pin 7. Etc. Regular network cables are straight through. Pin 1 goes to pin 1. Pin 2 goes to pin 2. etc.
Also, the communication is completely different. The console port uses serial communication. Ethernet ports use ethernet communication. I'm sure somebody smarter than me will come along and explain the difference.