Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to SQL Development Bootcamp
Overview of SQL Development
- Data and databases
- Database management systems (DBMS)
- SQL key concepts
Getting Started with SQL Databases
- Installing DBMS software
- Initial configuration
- Connecting existing databases
- Database development methodology
Exploring SQL Statement Fundamentals
- Data definition language statements
- Transaction control statements
- Session and system control statements
- Embedded SQL statements
Working with SQL Data
- Filtering data
- Comparison and logical operators
- Sorting data
- Row limiting clause
- Substitution variables
- Define and verify commands
Using Single Row, Group, Conversion, and General Functions
- Character functions
- Numeric and date functions
- Conversion functions
- Case and decode functions
- Distinct and null values
- Group by clauses
- Having clauses
Working with SQL Join Clauses
- Inner join
- Non-equijoin
- Outer join
- Cross join
Using Subqueries and SET Operators
- Single row subqueries
- Multi row and multi column subqueries
- SET operators
- Correlated subquery
- Data manipulation with subqueries
Creating Databases and Tables
- Data types
- Primary and foreign keys
- Constraints
- Table actions (create, insert, update, delete)
- Data dictionary views
- Conditional expressions
Working with Views, Sequences, Synonyms, and Indexes
- Creating and querying views
- Creating and modifying sequences
- Creating synonyms
- Creating indexes
Managing Schema Objects
- Constraints management
- Temporary tables
- External tables
Controlling User Access
- System privileges
- Object privileges
- Roles
- Revoking privileges
Managing Data in Different Time Zones
- Interval data types
- Time functions
Troubleshooting
Summary and Conclusion
Requirements
- Familiarity with database management and database management systems
Audience
- Beginners
- Programmers
- Database admins
35 Hours
Testimonials (5)
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan
Course - SQL in SQL Server
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL Advanced
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.
Aynanie Kiram - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
Course - Transact SQL Basic
Herr Bless hat eine sehr freundliche, angenehme Persönlichkeit und weiss mit seiner Erfahrung und Begeisterung die Teilnehmer stets zu motivieren und bei kniffligen Übungen anzuspornen! Er hat stets sichergestellt, dass alle Teilnehmer den Inhalt verstehen und ist auf jegliche Fragen eingegangen. Gute Übungen helfen, den Theorieteil schnell in der Praxis anzuwenden. Generell war die Organisation und der Zuschniitt der Schulung auf die Anforderungen der Teilnehmer von Nobleprog sehr professionell. Vielen Dank!
