The The SQL Workshop: Learn to create, manipulate and secure data and manage rel

Description: The The SQL Workshop by Frank Solomon, Prashanth Jayaram, Awni Al Saqqa Estimated delivery 3-12 business days Format Paperback Condition Brand New Description Filled with practical examples and realistic exercises, The SQL Workshop will get you up to speed with the fundamentals of SQL. Youll learn how to use SQL queries and functions to create and manage relational databases, and apply your new skills to creatively solve real-world problems. Publisher Description Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databasesKey FeaturesUnderstand the features and syntax of SQL and use them to query databasesLearn how to create databases and tables and manipulate the data within themCreate advanced queries and apply them on realistic databases with hands-on activitiesBook DescriptionMany software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully.This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. Youll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, youll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, youll secure your database against potential threats and use access control to keep your data safe.Throughout this Workshop, youll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world.By the end of this book, youll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL.What you will learnCreate databases and insert data into themUse SQL queries to create, read, update, and delete dataMaintain data integrity and consistency through normalizationCustomize your basic SQL queries to get the desired outputRefine your database search using the WHERE and HAVING clausesUse joins to fetch data from multiple tables and create custom reportsImprove web application performance by automating processesSecure a database with GRANT and REVOKE privilegesWho this book is forThis Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether youre an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running. Author Biography Frank Solomon started out building front-end and database software with Microsoft stack tools such as SQL Server and ASP and then extended into ASP.NET, C#, VB.NET, JavaScript, and more. He learns about new products, languages, and technologies all the time, and he pushed into technical writing as a way to present and express his research and discoveries. He works as a contractor right now. He has worked in start-ups himself, and he knows that the hard work of writers and developers makes the end user experience easier. Prashanth Jayaram is a database technologist, blogger, engineering lead, automation expert, TechNet wiki ninja, PowerShell Geek, and technologist enthusiast with extensive experience in designing database solutions. He is the author of PowerShell 6.0 Linux Administration Cookbook and has hands-on experience with the next generation database technologies. He has been awarded as ABOVE and BEYOND and Best SQL Author 2018 towards his contribution to SQL Server technology. He has articulated over 200+ articles widespread across SQL, NoSQL, PowerShell, Python, SQL on Linux, SQL on Azure, and SQL on AWS arenas. Awni Al Saqqa is a Microsoft Technology Specialist in MS SQL Server and a certified solutions developer since 2007. He has over a decade of experience with database development and administration on SQL Server, Oracle, and MySQL. He is a solutions architect, who is hands-on in many enterprise projects for different business sectors, such as education, hospitality, retail, manufacturing, marketing, and more, which has given him the perfect combination between business and technical experience. Details ISBN 1838642358 ISBN-13 9781838642358 Title The The SQL Workshop Author Frank Solomon, Prashanth Jayaram, Awni Al Saqqa Format Paperback Year 2019 Pages 288 Publisher Packt Publishing Limited GE_Item_ID:126484440; About Us Grand Eagle Retail is the ideal place for all your shopping needs! With fast shipping, low prices, friendly service and over 1,000,000 in stock items - you're bound to find what you want, at a price you'll love! Shipping & Delivery Times Shipping is FREE to any address in USA. Please view eBay estimated delivery times at the top of the listing. Deliveries are made by either USPS or Courier. We are unable to deliver faster than stated. International deliveries will take 1-6 weeks. NOTE: We are unable to offer combined shipping for multiple items purchased. This is because our items are shipped from different locations. Returns If you wish to return an item, please consult our Returns Policy as below: Please contact Customer Services and request "Return Authorisation" before you send your item back to us. Unauthorised returns will not be accepted. Returns must be postmarked within 4 business days of authorisation and must be in resellable condition. Returns are shipped at the customer's risk. We cannot take responsibility for items which are lost or damaged in transit. For purchases where a shipping charge was paid, there will be no refund of the original shipping charge. Additional Questions If you have any questions please feel free to Contact Us. Categories Baby Books Electronics Fashion Games Health & Beauty Home, Garden & Pets Movies Music Sports & Outdoors Toys

Price: 43.62 USD

Location: Fairfield, Ohio

End Time: 2024-10-04T06:13:08.000Z

Shipping Cost: 0 USD