SQL

-

SQL Tutorial 1: Overview on Database, DBMS/RDBMS, SQL |Database Components | SQL for Testers

    
 

-----------------------------------------------------------------------------------------------------------------------------

SQL Tutorial 2: Installing MySQL, Working with SQL Workbench & Command Line Clients



MSSQL Commands:
  • mysql> show databases;
  • mysql> use <DB name>;
  • mysql> show tables;
  • mysql> select * from <table name>;   eg: mysql> select * from city;
<Contd. to the ppt, link shared below>
-----------------------------------------------------------------------------------------------------------------------------
Resources:

  • https://www.youtube.com/playlist?list=PLUDwpEzHYYLt0aRs7gvyEEviMp_CoTO3q&disable_polymer=true
  • https://www.slideshare.net/pavan5780/mysql-164020041/1

Comments

Post a Comment

Popular posts from this blog

Coding projects

-
  ·         Battery.py-- This will run in every 3 hrs and play music o    when battery level is below 50% when Power plugged in :   False o    when battery level is 90% when Power plugged in :   True # This will run in every 3 hrs and play music when battery level is below 50% # python script showing battery details import psutil from playsound import playsound import time while ( True ): # function returning time in hh:mm:ss def convertTime (seconds): minutes , seconds = divmod (seconds , 60 ) hours , minutes = divmod (minutes , 60 ) return "%d:%02d:%02d" % (hours , minutes , seconds) # returns a tuple battery = psutil.sensors_battery() print ( "Battery percentage : " , battery.percent) print ( "Power plugged in : " , battery.power_plugged) # converting seconds to hh:mm:ss print ( "Battery left : " , convertTime(battery.secsleft)) # import required modul...
Read more

Selenium with Python

-
Image
 Installing Python,Selenium & Pycharm IDE <Command Used >      where python                                         Command to : list all the libraries already available with python Install selenium How to Run Tests on Chrome, Firefox & IE Browsers Links https://www.selenium.dev/downloads/ https://github.com/mozilla/geckodriver/releases https://sites.google.com/a/chromium.org/chromedriver/ https://github.com/SeleniumHQ/selenium/wiki/InternetExplorerDriver#required-configuration https://selenium-release.storage.googleapis.com/index.html?path=3.9/ Code example: ...\SeleniumProject\MultiBrowser.py WebDriver Commands Code example: ...\SeleniumProject\basiccommands.py WebDriver Navigational Commands Code example: ...\SeleniumProject\navigationcommands.py WebDriver Conditional Commands Code example: ...\SeleniumProject\con...
Read more