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
Testimonials (9)
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Podczas szkolenia zostały bardzo szczegółowe - jak na dwa dni szkolenia - omówione wszystkie moduły, a na tym mi najbardziej zależało.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Course - SQL Advanced
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
I liked that he had actual know how of when to use each technology, that's valuable.
Radu Mazilu - eMAG IT Research
Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Exercises are entertaining and the topics were nicely introduced.