{"product_id":"2940164708726","title":"Learn SQL in 24 Hours","description":"\u003cp\u003eDatabases can be found in almost all software applications. Infact it's hard to find a software that doesn’t use a database. SQL is the standard language to query a database. SQL stand for: Structured Query Language. SQL provides basic to advance commands to retrieve, update, delete, insert data into database.\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eThis book is designed for beginners with little or no prior database experience.\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eTable Of Content\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eHere is what you will learn:\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 1: Introduction to Database and MySQL\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is Data?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is a database?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is a Database Management System?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eTypes of DBMS\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is SQL?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is NoSQL?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 2: Install MySQL workbench\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is MySQL?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhy use MySQL?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eIntroducing MySQL Workbench\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eMySQL workbench- Modeling and Design tool\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eMySQL workbench - SQL development tool\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eInstall MySQL workbench Guide\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 3: Introduction To Database Design\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhy Database Design is Important?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eDatabase development life cycle\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eRequirements analysis\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eDatabase designing\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eImplementation\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eTypes of Database Techniques\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 4: Database Normalization\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is Normalization?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e1NF Rules\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is Composite Key\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e2NF Rules\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e3NF Rules\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eBoyce-Codd Normal Form (BCNF)\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 5: ER Modeling\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhat is ER Modeling?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eEnhanced Entity Relationship (EER) Model\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eWhy use ER Model?\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eEntities in the \"MyFlix\" library\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eDefining the relationships among entities\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 6: How To Create A Database\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eCreate Database\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eCreating Tables MySQL\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eData types\u003c\/p\u003e\u003cbr\u003e \u003cp\u003eMySQL workbench ER diagram forward Engineering\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 7: How to use SELECT in MySQL\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 8: Where clause in MySQL\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 9: How to use INSERT Into in MySQL\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 10: How to Delete \u0026amp; Update data in MySQL\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 11: ORDER BY, DESC and ASC\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 12: Group By\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 13: Wildcards\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 14: Regular Expressions\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 15: MySQL PHP\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 16: Aggregate Function in MySQL\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 17: Null value \u0026amp; Keyword in MySQL\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 18: Auto Increment\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 19: Alter, Drop \u0026amp; Rename\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 20: Limit keyword\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 21: Sub-Queries\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 22: Joins\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 23: Unions\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 24: Views\u003c\/strong\u003e\u003c\/p\u003e\u003cbr\u003e \u003cp\u003e\u003cstrong\u003eChapter 25: Index in MySQL\u003c\/strong\u003e\u003c\/p\u003e","brand":"PublishDrive","offers":[{"title":"Default Title","offer_id":46550386606321,"sku":"2940164708726","price":9.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0674\/5433\/7265\/files\/2940164708726_p0.jpg?v=1771057717","url":"https:\/\/shop.barnesandnoble.com\/products\/2940164708726","provider":"Barnes \u0026 Noble","version":"1.0","type":"link"}