SQL Development - Learning Guide

Get started with Coding in SQL with this Learning Path


Introduction

First appearing in 1974, SQL is another grand-daddy of programming languages along with C, C++, and Java. It was developed by Donald D. Chamberlin and Raymond F Boyce for RDBMS or Relational Database Management System at IBM. Though different companies like IBM, Microsoft, Oracle have had their versions of SQL. It has proven to be one of the most widely used, yet flexible languages across decades. The uniform adoption of SQL has been so popular, that even in the age of big data and NoSQL databases, the central commands and concepts remain the same.

Job Opportunities

This one is a paradox for a skill like SQL. While job opportunities with just SQL as a skill have been a bit on the decline, SQL is the most common skill needed for almost any programming and analytics job. One look at our different Learning Paths, or job requirement for any technology, data science, and analytics related job; and you'll see that SQL is a listed skill at every level.

So you may need this learning path to plan your SQL learning for another job you might be targeting. Though if this is something that really interests you, then you can specialize in database management and architecture, and target core database and SQL related jobs.

Now let's begin our learning path for SQL Development

Beginners Topics to Cover in SQL Development [ Days 1 - 4]

  1. Understanding Database, Tables
  2. Understanding Relational Database
  3. Entity Relationship logic in the database, SQL Schemas
  4. Download and installation of the database, configuring your database of choice (Oracle, Microsft, IBM)
  5. Data types, Primary Key, Foreign Key, Normalization
  6. SQL statement basics, SELECT Statement, Column aliases
  7. Distinct and Concatenation Operators, Arithmetic Operations, Null values
  8. Using Where clause, Comparison Operators

Intermediate Topics-I to Cover in SQL [ Days 5 - 8]

  1. Handling REACT Events with Methods
  2. BETWEEN, IN, LIKE, IS NULL operators
  3. Logical Operators and Rule of Precedence
  4. ORDER By Clause, ASC and DESC, NULLs First and NULLs Last
  5. Single Row Functions, Character Functions
  6. Number functions, Nesting Functions, Date Functions and Operations
  7. Conversion Functions (TO_CHAR, TO_DATE, COALESCE)
  8. Conditional Functions

Intermediate Topics-II to Cover in SQL [ Days 9 - 13]

  1. Group Functions (Avg, Count, Max, Min, SUM)
  2. Data Grouping ( GroupBy, Having, Nested Grouping)
  3. Joining Tables- USING, ON Clause
  4. Multiple Joins, Restricted Joins
  5. Joins- SELF, OUTER, LEFT OUTER, RIGHT OUTER, FULL OUTER, CROSS
  6. Subqueries- Single and Multiple Rows
  7. SET Operators- UNION, UNION All, INTERSECT, MINUS
  8. DML Statements- INSERT, UPDATE, DELETE, COMMIT, ROLLBACK
  9. DDL Statements- CREATE, ALTER, DROP, TRUNCATE Table
  10. Constraints- Unique Key, Primary Key, Foreign Key, Not Null, Check

Advanced Topics or Specializations to Cover in SQL [ Days 14 - 20]

  1. SSRS- SQL Server Reporting Services
  2. Data Warehouse and SQL Server Analysis Services- SSAS
  3. SQL Analytical Services
  4. Data Base Architecture

Complementary Skills

SQL is perhaps the most widely used complementing skill. So chances are that you would be learning SQL to complement some other primary skill from programming to analytics to big data. However, if you are someone who really wants to specialize in SQL, then you can focus on learning the intricacies of database management and architecture for enterprises. We can list some of those here, however, they are full-blown specialized learning and less like complementary skills. If we get enough interest, we might come up with a learning path for database architecture later on. 

Popular Job Titles with REACT JS Skills

  1. SQL developer
  2. Business Intelligence Developer
  3. Business Intelligence Analyst
  4. SQL Analyst
  5. Oracle Developer
  6. Database Administrator

Conclusion

This brings us to the end of this learning path for SQL development. We hope this learning path helped you. Let us know in case of any further questions or feedback here, QuickCode team will be here to help you with your learning needs.