SQL Developer
This course introduces you to the shift in market from traditional Data mining to modern data science. This course will transition you from an amateur to an employable SQL developer. Although this course is great for those that may be new to programming, those that are well experienced in SQL Development will find a lot of concepts to learn and build upon. This course is different because it’s not just about writing code, it also about how and why code works the way it does. Because it focuses not only on small coding examples, but also on real-world projects and use cases.
SQL Developer
This course introduces you to the shift in market from traditional Data mining to modern data science. This course will transition you from an amateur to an employable SQL developer. Although this course is great for those that may be new to programming, those that are well experienced in SQL Development will find a lot of concepts to learn and build upon. This course is different because it’s not just about writing code, it also about how and why code works the way it does. Because it focuses not only on small coding examples, but also on real-world projects and use cases.
Course Introduction
This 90hrs (Lectures + hands-on Lab) SQL training is targeted to engineers and technical personnel involved in extraction and mining large set of data. SQL is used ubiquitous… because every application has data to process. You can’t consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company’s biggest asset is their data. All databases require the language SQL to store and retrieve data. SQL is a lab-intensive course and objectives are accomplished mainly through hands on learning.
The key to a high success rate is based on the program’s objectives as follows:
- Course contents are based on Industry requirement
- Dedicated Monitoring to evaluate and report candidates progress
- Extensive hands-on lab exercises
- Industry acclaimed, experienced and certified instructors
Course Highlights
- Project manager can be assigned to track candidates’ performance
- Curriculum based on SQL guidelines.
- This Instructor-led classroom course is designed with an aim to build theoretical knowledge supplemented by ample hands-on lab exercises
- Facility of Lab on cloud available (based on booking)
- Courseware includes reference material to maximize learning.
- Assignments and test to ensure concept absorption.
- Courseware includes reference material to maximize learning.
- Assignments and test to ensure concept absorption
- Repeating of lectures allowed (based on seat availability)
Course Objectives
- Become Job Ready to Start Contributing as a Database Developer
- Understanding the myriad buzzword of SQL
- Understanding the benefits of SQL
- Master the key constructs of SQL
- Take you from a SQL beginner to an SQL developer
- Understanding how to program and solve problems
- You will learn how to structure and organize code using common SQL Queries
- “Start with why” something works in SQL, not just “how”
- Understanding how to built and implements from scratch
- Understanding the myriad buzzword of JavaScript
- Have the Ability to Solve any SQL Problem
- Ability to think about code and implements
- Understand how and why code works the way it does
- Program in the SQL Language to Solve a Variety of Database Problems
- Become a SQL Ninja and Understand How the Oracle Database Works
- Obtain the Skills that are Necessary to Land a Job as a SQL Developer
- Create data privacy and encapsulation
- Understanding Oracle DBA
- Understanding about how server interact with Database
- SQL and DBA fundamentals
- Ability to think about code and implements
Course Topics
This course is created to impart knowledge and skills related to SQL developer, data science, uses of RDBMS, data mining. This course will help candidates prepare for SQL developer. The following topics are general guidelines to better reflect the contents of the course and for clarity purposes, the guidelines below may change at any time without notice.
Database Basics
- Describe buzzwords of SQL
- Variable and Data Types
- Operator in SQL
- Operator Precedence
- Control statements
- Functions and Statements
- Coding challenge
- Oracle Database Introduction & Basics of Table
- SQL Development Environment (Mac & Windows)
- Creating the schema in the Databa
Single Table Queries:
- Oracle Exams and Certification Information
- Understanding about the SELECT clause
- Retrieving Data Using the WHERE Clause in a Query
- Using Operators in the WHERE Clause
- Combining WHERE, AND & OR with Operators
- Query Filtering Continued BETWEEN, IN and NULL
- Query Filtering Conditions & Operator Precedence
- Ordering, Concatenating & Aliasing Query Results
- Project Practice
- Real world example
Single Row Functions (SRF):
- SRF and using the Dual Table
- Using Functions in WHERE And Character Based SRFs
- Numeric and Date Data type SRFs
- Conversion SRFs and Date Formatting
- Some More Date Functions
- Concluding SRFs & NULL / NULLIF Functions
- Practice with SRF
- Why Function
- Average Function
Grouping Functions:
- Grouping Functions MIN
- Grouping Functions MAX
- Grouping Functions AVG
- Grouping Functions COUNT,etc
- GROUP BY Clause & HAVING Clause
- Practice With The GROUP BY Clause
Multi Table Queries:
- SELECT within SELECT (sub-queries)
- Relating Tables Together Using JOIN
- Joins Continued INNER & OUTER Joins
- Correlated sub-queries with EXISTS & NOT EXIST operators
Various Joins:
- Inner Join
- Outer Join
- Cross Join
- Left Join
- Right Join
Creating Objects:
- Creating Your Own Tables & Design Considerations
- Inserting Data Into Our Table
- Create Table With a Primary Key Constraint
- Using ALTER to modify the table structure
- Create Table with SELECT + UPDATE Data
- Primary and Foreign Keys
Altering and Updating objects with SQL:
- DELETE, TRUNCATE, and DROP Commands
- Working With Database Indexes
- System Tables, Pseudo Columns & Deleting Duplicates
- Views and Other Objects and Commands
- User Creation
- Granting and Revoking Privileges
- BECOME A SQL QUERY Expert
- Brief intro about Oracle dba
Lab Topics
Not Available
Virtual Classroom
- Instructor led online training is an ideal vehicle for delivering training to individuals anywhere in the world at any time.
- This innovative approach presents live content with instructor delivering the training online.
- Candidates will be performing labs remotely on our labs on cloud in presence of an online instructor.
- Rstforum uses microsoft lync engine to deliver instructor led online training.
- Advances in computer network technology, improvements in bandwidth, interactions, chat and conferencing, and realtime audio and video offers unparalleled training opportunities.
- Instructor led online training can helps today’s busy professionals to perform their jobs and upgrade knowledge by integrating self-paced instructor led online training in their daily routines.
Miscellaneous
- Minimum batch size required for batch is 10 participants in the this course.
- The RST Forum reserves the right to cancel/postpone the class.
- Course schedule will be provided before commencement of the course.
- Certificate of participation will be awarded to participants with a minimum 90% attendance.
- All attendees are to observe the Copyright Law on intellectual properties such as software and courseware from respective vendors.
- The RST Forum reserves the right to include external participants in the program either for the entire course or individual courses.
- The RST Forum reserves the right to change/alter the sequence of courses. RST FORUM published Book would be given at 50% discounted rate to the forum students.