SQL 101 : CH 1 Notes : Teach yourself SQL
These notes should be more than enough to revise and learn stuff. No need to go to book after it. Examples are also included for better revision and understanding of concepts. SQL session commands : 1) CONNECT - Command is used to connect to a database. This command can either invoke a connection or change the connection to the database. Ex. connected as USER1 and gave command of USER2, the command will terminate the previous user connection and establish the connection for USER2. Syntax: CONNECT user@database. link: Official documentation for CONNECT command Takeaway -> Initializing a database can be tricky and not as simple as opening a Jupyter book. Be thorough with the process. All SQL servers are password-protected. 2) DISCONNECT AND EXIT -> Use to disconnect a user from a database. Exit: While giving the disconnect command, the soft...