Plan du cours
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.
Pré requis
Basic Computer Skills.
Nos Clients témoignent (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
Formation - Introduction to SQL Server 2012 Integration Services (SSIS)
J'ai aimé cette formation parce qu'elle était interactive
Amalia - Banca Transilvania
Formation - SQL Fundamentals
Traduction automatique
Lot of content and exactly the requested one.
Pascal - Diehl
Formation - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
J'ai beaucoup apprécié le rythme de la formation et les exercices donnés entre les explications.
Trana
Formation - SQL in SQL Server
Traduction automatique
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Formation - 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.
Formation - ORACLE SQL Fundamentals
J'ai apprécié l'équilibre entre les cours magistraux et les exercices. Lorsque j'étais bloqué, Luke m'aidait très bien à comprendre le problème et à trouver des solutions, ce qui a eu un impact très positif sur ma compréhension.
Tom - Welsh Revenue Authority
Formation - Transact SQL Basic
Traduction automatique
Really enjoyed compression data components
James - Medtech Limited
Formation - Transact SQL Advanced
The course built lesson to lesson, and the pacing was a big deal for me.