SQL Practice Level One

We will go through the  series of tasks to practice SQL and make our hand fine-tuned over it:


Create a table with below Data:



SQL_Example_Task_one_for_practise
Task 1 Create Table.


Post the query in a comment if you are done with the First Task.




Task 2:
Create another table:

Create table worker(Worker_ID Int Primary key, First_Name varchar(20), Last_Name Varchar (20), Joining_date Date, Department char(20));

Now Alter table and add column Salary int,




3 comments:

  1. Task 1:
    Create table professionals (Pro_ID int primary key, First_Name varchar(30), Last_Name Varchar(30), Date_Join datetime, Profession varchar(30));
    insert into professionals(Pro_ID, First_name, Last_name, Salary, Date_Join, Profession)
    Values
    (1, 'Jhony', 'Depp', 500000, '2000-04-18 09:00:00:000', 'Actor'),
    (2, 'Steve', 'Jobs', 1500000, '1983-02-04 09:00:00:000', 'CEO'),
    (3, 'Bill', 'Gates', 2500000, '1975-04-04 09:00:00:000', 'CEO'),
    (4, 'Sunder', 'Pichai', 2000000, '2016-01-01 09:00:00:000','CEO'),
    (5, 'Michale', 'Dell', 3000000, '2007-01-01 09:00:00:000', 'CEO'),
    (6, 'Mark', 'Zukerburg', 1000000, '2005-01-01 09:00:00:000', 'CEO'),
    (7, 'Under', 'Taker', 5000000, '1970-01-01 09:00:00:000', 'Wrestler'),
    (8, 'Hit', 'Man', 3400000, '1969-01-01 09:00:00:000', 'Wrestler'),
    (9, 'Lex', 'Lugar', 1500000, '1980-01-01 09:00:00:000', 'Wrestler'),
    (10, 'Shawn', 'Michale', 4500000, '1987-01-01 09:00:00:000', 'Wrestler'),
    (11, 'Dwayne', 'Johnson', 9000000, '1995-01-01 09:00:00:000', 'Actor'),
    (12, 'Steve', 'Austin', 6000000, '1990-01-01 09:00:00:000', 'Wrestler'),
    (13, 'Robie', 'William', 1000000, '1980-01-01 09:00:00:000', 'Wrestler'),
    (14, 'VInce','Mcmahon', 1500000, '1980-01-01 09:00:00:000', 'Payroll'),
    (15, 'Silvestar', 'Stallon', 10000000, '1975-01-01 09:00:00:000', 'Wrestler'),
    (16, 'Arnold', 'Swaznager', 100000000, '1976-01-01 09:00:00:000', 'Wrestler');

    Select * from professionals

    ReplyDelete
    Replies
    1. ⚡️☑️MEET THE REAL HACKERS☑️⚡️

      It Tears me Up Whenever we receive complaints from Clients About Their Experience With the Hackers They Met Before They Heard about us.
      These Days There Are alot of Hackers Online, You Just Have to Be Careful about who you meet for help, because many people now don't know who to ask for help anymore but there's really an actual solution to that which I am giving you for free, Don't go out there seeking for Hackers Yourself, Because the probability of getting a Real Hacker Out there Is Very Slim . ❌❌ ❌ Most Of Them are actually not who they say they're, they are just here to Rip people Off, You Can Always Identify Them With Their False Advertisements and False Testimonies Trying To Lure you Into their Arms, Please Don’t Fall For Them🚷⚠️⚠️⚠️ Our Purpose Here Is To Link You Up With Top Legit Hackers With Great Online Reputations and Impressive LinkedIn Profiles That’ll Blow Your Mind.

      ☑️ COMPOSITE CYBER SECURITY SPECIALISTS is here to Provide you with The Best Hackers, So you can get saved from The Arms of the Fake Hackers❌❌

      ☑️We have Legit Hackers and Private investigators at your service. 💻 Every member of our team is well experienced in their various niches with Great Skills, Technical Hacking Strategies And Positive Online Reviews And Recommendations💻🛠

      ☑️We have Digital Forensic Specialists, Certified Ethical Hackers, Computer Engineers, Cyber Security Experts, Private investigators and more on our team. Some Of These Specialist Includes ⭐️ DAWID CZAGAN⭐️ JACK CABLE ⭐️ SEAN MELIA ⭐️ ARNE SWINNEN ⭐️And More.
      Some Of The Services we render includes:
      * Website hacking 💻
      * Facebook and social media hacking 📲
      * Database hacking, & Blog Cleaning🛠
      * Phone and Gadget Hacking 📲
      • CREDIT CARD MISHAPS 💳 💥
      * Clearing Of Criminal Records ❌
      * RECOVERY OF LOST FUNDS ON BINARY OPTIONS & CAPITAL INVESTMENTS💰
      * Location Tracking 📲
      and many More

      ☑️ Our Goal is to make your digital life secure, safe and hassle-free. All you Need To do is To Write us a Mail Then We’ll Assigned any of These Hackers To You Instantly.


      ☑️ CONTACT:
      ••• Email:
      composite.cybersecurity@protonmail.com

      🔘2020 © composite cybersecurity specialists
      🔘Want faster service? Contact us!
      🔘All Rights Reserved ®️

      Delete
  2. Task 2:

    ALter table dbo.worker add Salary int;

    ReplyDelete

Enter your email address:

Delivered by FeedBurner