Course Outline
Course Outline:
- What is the meaning of Databases. Comparison of RDBMS and DBMS
- Different RDBMS available in the market.
- What is SQL Server? Working with SQL Server Management Studio
- Working with sublanguages like DDL, DML, DAL.
- Creation of Tables, data types, Constraints and their definition.
- Using Insert, Delete and Update statements.
- Using Select Query and its various operators.
- Use of Null, Not Null, And, OR, Between, Exists, Order by, Group by, Having clause
- What are inbuilt functions? Math, String and Datetime functions.
- Working with Views. How they are used for data access.
- Working with Joins. Joins types and getting data from multiple tables.
- Working with Sub Queries. What is a correlated subquery. Difference between Sub Query and Joins.
- What are Common Table Expressions. Using Recursive Common Table expressions.
Requirements
Basic Computer Skills.
Testimonials (9)
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
The course built lesson to lesson, and the pacing was a big deal for me.