• Home
  • Database
    • Relational Databases
    • database management system (DBMS)
    • Different Types of Databases
    • Big Data
    • The future of big data [infographic]
    • Database Fundamentals
      • Fundamentals of Database Part 1
  • SQL
    • SQL Syntax
    • SQL General Data Types
    • sql Join
    • Types of SQL Statements
    • Sql Select
    • SQL DISTINCT
    • SQL -Constraint
    • Microsoft SQL Server
  • SQLite
  • Big Data
    • Who uses big data?
    • Why Is Big Data Important?
    • What is big Data
  • Blockchain
    • What is blockchain ?
  • Books
    • Best Books in Sql
    • Best Books in Database
  • Contact US
  • You are here:  
  • Home

ChatGPT

ChatGPT 

 

ChatGPT (Generative Pre-trained Transformer)[1] is a chatbot launched by OpenAI in November 2022. It is built on top of OpenAI's GPT-3.5 family of large language models, and is fine-tuned with both supervised and reinforcement learning techniques.

ChatGPT was launched as a prototype on November 30, 2022, and quickly garnered attention for its detailed responses and articulate answers across many domains of knowledge, however its uneven factual accuracy was identified as a significant drawback.[2] Following the release of ChatGPT, OpenAI was reportedly valued at $29 billion.[3]

Contents

  • 1 Training
  • 2 Features and limitations
  • 3 Service
  • 4 Reception, criticism and issues
    • 4.1 Positive reactions
    • 4.2 Negative reactions
    • 4.3 Implications for cybersecurity
    • 4.4 Implications for education
  • 5 Jailbreaks
  • 6 See also
  • 7 References
  • 8 External links

Training

 
Pioneer Building, San Francisco, home of OpenAI HQ
 
OpenAI CEO Sam Altman

ChatGPT was fine-tuned on top of GPT-3.5 using supervised learning as well as reinforcement learning.[4] Both approaches used human trainers to improve the model's performance. In the case of supervised learning, the model was provided with conversations in which the trainers played both sides: the user and the AI assistant. In the reinforcement step, human trainers first ranked responses that the model had created in a previous conversation. These rankings were used to create 'reward models' that the model was further fine-tuned on using several iterations of Proximal Policy Optimization (PPO).[5][6] Proximal Policy Optimization algorithms present a cost-effective benefit to trust region policy optimization algorithms; they negate many of the computationally expensive operations with faster performance.[7][8] The models were trained in collaboration with Microsoft on their Azure supercomputing infrastructure.

In addition, OpenAI continues to gather data from ChatGPT users that could be used to further train and fine-tune ChatGPT. Users are allowed to upvote or downvote the responses they receive from ChatGPT; upon upvoting or downvoting, they can also fill out a text field with additional feedback.[9][10][11]

Features and limitations

While the core function of a chatbot is to mimic a human conversationalist, journalists have also noted ChatGPT's versatility and improvisation skills, including its ability to write and debug computer programs; to compose music, teleplays, fairy tales, and student essays; to answer test questions (sometimes, depending on the test, at a level above the average human test-taker);[12] to write poetry and song lyrics;[13] to emulate a Linux system; to simulate an entire chat room; to play games like tic-tac-toe; and to simulate an ATM.[14]

In comparison to its predecessor, InstructGPT, ChatGPT attempts to reduce harmful and deceitful responses;[15] in one example, while InstructGPT accepts the prompt "Tell me about when Christopher Columbus came to the US in 2015" as truthful, ChatGPT uses information about Columbus' voyages and information about the modern world – including perceptions of Columbus to construct an answer that assumes what would happen if Columbus came to the U.S. in 2015.[5] ChatGPT's training data includes man pages and information about Internet phenomena and programming languages, such as bulletin board systems and the Python programming language.[14]

Unlike most chatbots, ChatGPT remembers previous prompts given to it in the same conversation; journalists have suggested that this will allow ChatGPT to be used as a personalized therapist.[16] To prevent offensive outputs from being presented to and produced from ChatGPT, queries are filtered through OpenAI's company-wide[17][18] moderation API, and potentially racist or sexist prompts are dismissed.[5][16]

ChatGPT suffers from multiple limitations. OpenAI acknowledged that ChatGPT "sometimes writes plausible-sounding but incorrect or nonsensical answers".[5] The reward model of ChatGPT, designed around human oversight, can be over-optimized and thus hinder performance, otherwise known as Goodhart's law.[19] ChatGPT has limited knowledge of events that occurred after 2021. According to the BBC, as of December 2022 ChatGPT is not allowed to "express political opinions or engage in political activism".[20] Yet, research suggests that ChatGPT exhibits a pro-environmental, left-libertarian orientation when prompted to take a stance on political statements from two established voting advice applications.[21] In training ChatGPT, human reviewers preferred longer answers, irrespective of actual comprehension or factual content.[5] Training data also suffers from algorithmic bias, which may be revealed when ChatGPT responds to prompts including descriptors of people. In one instance, ChatGPT generated a rap indicating that women and scientists of color were inferior to white and male scientists.[22][23]

Service

ChatGPT was launched on November 30, 2022, by San Francisco-based OpenAI, the creator of DALL·E 2 and Whisper. The service was launched as initially free to the public, with plans to monetize the service later.[24] By December 4, OpenAI estimated ChatGPT already had over one million users.[9] CNBC wrote on December 15, 2022, that the service "still goes down from time to time".[25] The service works best in English, but is also able to function in some other languages, to varying degrees of success.[13] Unlike some other recent high-profile advances in AI, as of December 2022, there is no sign of an official peer-reviewed technical paper about ChatGPT.[26]

According to OpenAI guest researcher Scott Aaronson, OpenAI is working on a tool to attempt to watermark its text generation systems so as to combat bad actors using their services for academic plagiarism or for spam.[27][28] The New York Times relayed in December 2022 that the next version of GPT, GPT-4, has been "rumored" to be launched sometime in 2023.[16]

Reception, criticism and issues

Positive reactions

ChatGPT was met in December 2022 with generally positive reviews; The New York Times labeled it "the best artificial intelligence chatbot ever released to the general public".[29] Samantha Lock of Britain's The Guardian newspaper noted that it was able to generate "impressively detailed" and "human-like" text.[30] Technology writer Dan Gillmor used ChatGPT on a student assignment, and found its generated text was on par with what a good student would deliver and opined that "academia has some very serious issues to confront".[31] Alex Kantrowitz of Slate magazine lauded ChatGPT's pushback to questions related to Nazi Germany, including the claim that Adolf Hitler built highways in Germany, which was met with information regarding Nazi Germany's use of forced labor.[32]

In The Atlantic's "Breakthroughs of the Year" for 2022, Derek Thompson included ChatGPT as part of "the generative-AI eruption" that "may change our mind about how we work, how we think, and what human creativity really is".[33]

Kelsey Piper of the Vox website wrote that "ChatGPT is the general public's first hands-on introduction to how powerful modern AI has gotten, and as a result, many of us are (stunned)" and that "ChatGPT is smart enough to be useful despite its flaws". Paul Graham of Y Combinator tweeted that "The striking thing about the reaction to ChatGPT is not just the number of people who are blown away by it, but who they are. These are not people who get excited by every shiny new thing. Clearly something big is happening."[34] Elon Musk wrote that "ChatGPT is scary good. We are not far from dangerously strong AI".[35] Musk paused OpenAI's access to a Twitter database pending better understanding of OpenAI's plans, stating that "OpenAI was started as open-source and non-profit. Neither are still true."[36][37] Musk had co-founded OpenAI in 2015, in part to address existential risk from artificial intelligence, but had resigned in 2018.[37]

In December 2022 Google internally expressed alarm at the unexpected strength of ChatGPT and the newly discovered potential of large language models to disrupt the search engine business, and CEO Sundar Pichai "upended" and reassigned teams within multiple departments to aid in its artificial intelligence products, according to The New York Times.[38] The Information reported on January 3, 2023 that Microsoft Bing was planning to add optional ChatGPT functionality into its public search engine, possibly around March 2023.[39][40]

Negative reactions

In a December 2022 opinion piece, economist Paul Krugman wrote that ChatGPT would affect the demand for knowledge workers.[41] The Verge's James Vincent saw the viral success of ChatGPT as evidence that artificial intelligence had gone mainstream.[6] Journalists have commented on ChatGPT's tendency to "hallucinate".[42] Mike Pearl of Mashable tested ChatGPT with multiple questions. In one example, he asked ChatGPT for "the largest country in Central America that isn't Mexico". ChatGPT responded with Guatemala, when the answer is instead Nicaragua.[43] When CNBC asked ChatGPT for the lyrics to "The Ballad of Dwight Fry", ChatGPT supplied invented lyrics rather than the actual lyrics.[25] Researchers cited by The Verge compared ChatGPT to a "stochastic parrot",[44] as did Professor Anton Van Den Hengel of the Australian Institute for Machine Learning.[45]

In December 2022, the question and answer website Stack Overflow banned the use of ChatGPT for generating answers to questions, citing the factually ambiguous nature of ChatGPT's responses.[2] In January 2023, the International Conference on Machine Learning banned any undocumented use of ChatGPT or other large language models to generate any text in submitted papers.[46]

Economist Tyler Cowen expressed concerns regarding its effects on democracy, citing the ability of one to write automated comments to affect the decision process of new regulations.[47] The Guardian questioned whether any content found on the Internet after ChatGPT's release "can be truly trusted" and called for government regulation.[48]

Implications for cybersecurity

Check Point Research and others noted that ChatGPT was capable of writing phishing emails and malware, especially when combined with OpenAI Codex.[49] The CEO of ChatGPT creator OpenAI, Sam Altman, wrote that advancing software could pose "(for example) a huge cybersecurity risk" and also continued to predict "we could get to real AGI (artificial general intelligence) in the next decade, so we have to take the risk of that extremely seriously". Altman argued that, while ChatGPT is "obviously not close to AGI", one should "trust the exponential. Flat looking backwards, vertical looking forwards."[9]

Implications for education

 

In The Atlantic magazine, Stephen Marche noted that its effect on academia and especially application essays is yet to be understood.[50] California high school teacher and author Daniel Herman wrote that ChatGPT would usher in "The End of High School English".[51]

In the Nature journal, Chris Stokel-Walker pointed out that teachers should be concerned about students using ChatGPT to outsource their writing but that education providers will adapt to enhance critical thinking or reasoning.[52]

Emma Bowman with NPR wrote of the danger of students plagiarizing through an AI tool that may output biased or nonsensical text with an authoritative tone: "There are still many cases where you ask it a question and it'll give you a very impressive-sounding answer that's just dead wrong."[53]

Joanna Stern with The Wall Street Journal described cheating in American high school English with the tool by submitting a generated essay.[54] Professor Darren Hick of Furman University described noticing ChatGPT's "style" in a paper submitted by a student. An online GPT detector claimed the paper was 99.9% likely to be computer-generated, but Hick had no hard proof. However, the student in question confessed to using GPT when confronted, and as a consequence failed the course.[55] Hick suggested a policy of giving an ad-hoc individual oral exam on the paper topic if a student is strongly suspected of submitting an AI-generated paper.[56] Edward Tian, a senior undergraduate student at Princeton University, claimed that he has created a program, named "GPTZero," that detects whether an essay is human written or not to combat academic plagiarism.[57][58]

As of January 4, 2023, the New York City Department of Education has restricted access to ChatGPT from its public school internet and devices.[59][60]

Jailbreaks

ChatGPT attempts to reject prompts that may violate its content policy. However, some users managed to jailbreak ChatGPT by using various prompt engineering techniques to bypass these restrictions in early December 2022 and successfully tricked ChatGPT into giving instructions for how to create a Molotov cocktail or a nuclear bomb, or into generating arguments in the style of a Neo-Nazi.[61] A Toronto Star reporter had uneven personal success in getting ChatGPT to make inflammatory statements shortly after launch: ChatGPT readily endorsed the Russian invasion of Ukraine, but even when asked to play along with a fictional scenario, ChatGPT balked at generating arguments for why Canadian Prime Minister Justin Trudeau was guilty of treason.[62][63]

See also

  • Anthropomorphism of computers
  • Commonsense reasoning
  • Computational creativity
  • Ethics of artificial intelligence
  • LaMDA (Google chatbot)
  • Turing test
  • Virtual assistant

Source https://en.wikipedia.org/wiki/ChatGPT

 

Best Online Resources for Learning SQL and Database Concepts

  • Database
  • SQL

Best Online Resources for Learning SQL and Database Concepts

1. W3Schools – “SQL Tutorial”

W3Schools claims to be the largest web developer site on the Internet. It provides various tutorials and references on web development languages such as HTML, CSS, JavaScript, PHP, SQL, and JQuery, covering most aspects of web programming.

sql w3school

2. Codecademy – “Learn SQL”

Codecademy is an online platform that offers a wide range of free coding courses in programming languages like HTML, JavaScript, jQuery, PHP, Python, and Ruby. In addition to these courses, Codecademy’s students can learn how to manage data with SQL.

 codecademy sql course 1 start page

3-1keydata

1keydata

 

 

4. Khan Academy – “Intro to SQL”

Khan Academy provides its users with micro-lectures in the form of YouTube videos, lots of practice exercises, and a personalized learning dashboard. Combined, these tools empower learners to study at their own pace inside and outside of the classroom.

khan academy 1 sql course intro page

5. SQLZoo

SQLZoo is a nice free and interactive SQL tutorial developed and maintained by Edinburgh Napier University.

 sqlzoo 1 sql tutorial main page

6. Tutorials Point – “Learn SQL”

Tutorials Point claims to be the web’s largest library of tutorials. Indeed, it offers dozens of online courses in computer engineering, information technology, programming languages, and management.

tutorialspoint 1 learn sql main page

7. Udacity – “Intro to Relational Databases”

Udacity offers interactive online courses aimed at advancing academic and vocational skills. Although Udacity is profit-oriented, some courses are available for free.

 udacity intro to relational databases course 1

8. SQL Problems and Solutions

SQL Problems and Solutions is an interactive textbook which lets you visualize tables and execute queries against a sample database. The tutorial explains the basic concepts and constructs of SQL and provides examples at various levels of expertise.

sql problems and solutions 1 main page

9. Tuts+ – “SQL for Beginners”

Tuts+ offers video courses and written tutorials that teach a wide range of creative and technical skills, including coding. Unlike video courses, all tutorials and articles are completely free. Based around specific projects, they include step-by-step written instructions and screenshots to help you practice and master your skills.

tutsplus sql for beginners 1

10. Essential SQL

Essential SQL, authored by Kris Wenzel (@sqlkris), is a great place to learn the fundamentals of SQL and database concepts. The course is based on Microsoft SQL Server, which is why the author provides newbie users with a guide on how to get started using this database engine.

For more

18+ Best Online Resources for Learning SQL and Database Concepts

T-SQL Fundamentals, 3rd Edition

  • SQL
  • sql syntax
  • Books

 

 

Effectively query and modify data using Transact-SQL
Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL’s roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects.


Microsoft Data Platform MVP Itzik Ben-Gan shows you how to:

  • Review core SQL concepts and its mathematical roots
  • Create tables and enforce data integrity
  • Perform effective single-table queries by using the SELECT statement
  • Query multiple tables by using joins, subqueries, table expressions, and set operators
  • Use advanced query techniques such as window functions, pivoting, and grouping sets
  • Insert, update, delete, and merge data
  • Use transactions in a concurrent environment
  • Get started with programmable objects–from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL

Source  : microsoft press store

amazon

Save

Save

SQL

  • SQL

What is SQL?

             SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards    Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.

SQL stands for Structured Query Language

  • SQL lets you access and manipulate databases
  • SQL is an ANSI (American National Standards Institute) standard

What Can SQL do?

  • SQL can execute queries against a database
  • SQL can retrieve data from a database
  • SQL can insert records in a database
  • SQL can update records in a database
  • SQL can delete records from a database
  • SQL can create new databases
  • SQL can create new tables in a database
  • SQL can create stored procedures in a database
  • SQL can create views in a database
  • SQL can set permissions on tables, procedures, and views

source

https://en.wikipedia.org/wiki/SQL

http://www.w3schools.com/sql/sql_intro.asp

http://www.sqlcourse.com/intro.html

SQL Antipatterns

  • Database
  • SQL
  • relational database
  • Books

lrg

Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he’s sharing his collection of antipatterns—the most common errors he’s identified in those thousands of requests for help.

Most developers aren’t SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What’s more, it shows you what’s behind these fixes, so you’ll learn a lot about relational databases along the way.

Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the anti​patterns in terms of logical database design, physical database design, queries, and application development.

The chances are good that your application's database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future.

SQL Antipatterns gives you a rare glimpse into an SQL expert's playbook. Now you can stamp out these common database errors once and for all.

Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.

Source  SQL Antipatterns

 

 

Save

  1. Best Database books
  2. Best Books in Sql
  3. Big Data

Page 1 of 2

  • Start
  • Prev
  • 1
  • 2
  • Next
  • End

Popular Tags

  • Database
  • SQL
  • relational database
  • sql syntax
  • Books
  • Big Data
  • SQLite
  • Blockchain

Latest Articles

  • ChatGPT
  • Microsoft SQL Server
  • Big Data
  • Who uses big data?
  • Why Is Big Data Important?

Today 38

Yesterday 63

Week 38

Month 903

All 139997

Currently are 5 guests and no members online

Kubik-Rubik Joomla! Extensions