SQL Programming
Cód:
491_9783985560066
You are 1-Click Away From Understanding The Ins & Outs Of SQL Fast, In Simple Language!Data is the new currency these days. But how exactly do you generate/capture this data, organize it, manipulate it, give people access to it and store it in a way that you can start analyze and make sense of it?The answer is simple; leverage the power of SQL!But what exactly is SQL?What does it do?How do you use SQL to achieve different goals?What benefits can you expect from learning SQL?If you have these and related questions, this book answers these and other questions you may have about SQL in simple language to help you to start applying what you learn immediately. The book covers SQL deeply and widely to enable you to have more than average level knowledge of the different concepts about SQL that you should know to effectively it in different facets of your life.Here is a summary of what you will learn from the book:The basics about SQL including what it is, how SQL has evolved over the years, the different SQL query types, why databases as critical and moreThe concept of Data Definition Language (DDL), including DDL for table and database creation, DDL foreign key in tables, DDL altering for foreign key, using DDL to create views, delete and drop tables and moreHow to ensure the integrity of data with unique constraints, not null constraints, foreign key constraints, primary key constraints and much moreUnions and joins of SQL, including union all command, union command, left join, right join and inner joinThe ins and outs of databases in SQL, including how to create databases, remove databases, create schema, create tables and insert data into the tables, populate a table with new data, insert null values, sorting entries, using various clauses and moreHow to create, delete and change roles, users and logins for different parts of a database in SQLThe ins and outs of SQL views, including how to add a view to a database, create an updateable view, set up database securi
Veja mais
