Are you thinking about learning SQL, but not sure where to start?
Big data is prevalent now, with more data than we ever dreamed possible being made available . And all that data needs to be stored in such a way it can be easily accessed.
That’s where databases and SQL come in, providing the means to manage and interpret data easily. SQL is the go-to language for database management, the most reliable and widely used, and it’s showing no signs of losing its popularity.
This SQL guide for beginners covers all the basics you need to know about working with data and databases. The book is divided into six parts and includes instructions on downloading a sample database to work with throughout.
In this guide, you will learn:
- How to install SQL Oracle
- How to query data
- How to sort and filter tables
- Using the SELECT statement
- Using the ORDER BY and WHERE clauses
- Oracle operators
- All the different Oracle Joins, including INNER, OUTER, LEFT, RIGHT, and more
- How to create and alter tables
- SQL data types
- And much more
If you are interested in learning SQL, this is the best place to begin and set yourself on course to become a master SQL programmer.
Introduction Part One – Getting Started How to Install Oracle on Windows Connecting to the Oracle Database Introducing the OT Oracle Sample Database Create the Oracle Sample Database for Practice Creating Database Tables Connect to Oracle Database Part Two – Querying, Sorting, and Filtering Data Oracle SELECT Statement Oracle DUAL Table Oracle ORDER BY Clause Oracle SELECT DISTINCT Oracle WHERE Clause Oracle Alias Column Alias Table Alias LIMIT and FETCH LIMIT Clause FETCH Clause ONLY WITH TIES Oracle AND Operator Oracle OR Operator Oracle IN Arguments Oracle BETWEEN Oracle LIKE Oracle IS NULL Oracle IS NOT NULL operator Part Three – Oracle JOINS INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN SELF JOIN Part Four – Grouping Data and Subqueries GROUP BY Clause HAVING Clause Subquery Correlated Subquery EXISTS Operator NOT EXISTS Operator ANY Operator ALL Operator CREATE TABLE ALTER TABLE Oracle Virtual Column ALTER TABLE MODIFY Column RENAME Table Part Six – Set Operators and Data Types UNION Operator INTERSECT Operator MINUS Operator Oracle Data Types NUMBER Data Type FLOAT Data Type BINARY_FLOAT & BINARY_DOUBLE Oracle Identity Column CHAR Data Type CHAR Examples NCHAR Data Type VARCHAR2 Data Type NVARCHAR2 DATE Data Type Date Format Converting String to Date Date Format TIMESTAMP Data Type TIMESTAMP WITH TIME ZONE Conclusion Resources References
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.