SQL

This book is an excellent guide for you on how to use SQL (Structured Query Language) in relational databases. The author has explored everything related to SQL, making this the best book for those in need of learning SQL for both academic and commercial purposes. The various data types supported by SQL have been discussed. The author takes you through the process of creating new databases and new tables with SQL. The process of viewing table data has been discussed. The various SQL operations that can be used to control the data under retrieval have been discussed. Examples include unions, intersections, limits, ordering, comparisons etc. You have been guided on how to create and impose constraints on the table columns to restrict the kind of data that can be stored. The author uses a practical approach, giving you the SQL statements you can use for various tasks, which have been accompanied by thorough explanations. Images have been added to ease understanding, especially for SQL beginners. What You will learn: SQL Data Types Creating a Database Creating Tables Inserting Data Viewing Table Data Conjunctive Operators Modifying Records Deleting Records LIKE Clause LIMIT, TOP and ROWNUM Clauses ORDER BY Clause GROUP BY Clause The DISTINCT Keyword SQL Constraints ALTER TABLE Command SQL Joins SQL UNIONS INTERSECT Clause Date and TimeKeywords: sql books, sql queries, query languages, sql, databases with sql, sql database programming, ms access, ms access 2016 book, mysql, sybase, oracle sql, postgres sql, informix, sql server, sql for dummies, programming basics, programming for the absolute beginner, programming for beginners, sql data types, sql for dummies, sql optimization, sql problems, sql server performance, sql for beginners.