Udemyallfr

MongoDB et SQL Server 2022 : Guide Complet pour Débutants

Learn SQL from Canal+ & TF1's SQL DBA Techlead! Master database skills with this expert-led SQL course. Become a SQL expert today.

4.6(14)
199students
9h 24m
Certificate
ELOA FORMATION Plateforme Eleaning, rejoignez nous ! SQL Server| Postgres | Powershell l Python|Azure|MongoDB| Oracle
ELOA FORMATION Plateforme Eleaning, rejoignez nous ! SQL Server| Postgres | Powershell l Python|Azure|MongoDB| OracleRéférent technique chez Canal + sur SQL, Azure, et Postgres

Course Content

MongoDB et SQL Server 2022 : Guide Complet pour Débutants is an all-levels Udemy course taught by ELOA FORMATION Plateforme Eleaning, rejoignez nous ! SQL Server| Postgres | Powershell l Python|Azure|MongoDB| Oracle. It runs 9h 24m, is taught in French, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 14 reviews, with 199 students enrolled. It is a paid course, last updated June 2024.

Embark on a transformative learning journey in SQL and NoSQL databases! This intensive 10-hour course is perfectly designed for beginners looking to build a strong foundation in database management. We'll cover both relational and non-relational database approaches, equipping you with in-demand skills for today's data-driven world.

Part 1: Mastering SQL Server 2022

  • Installation & Configuration: Learn how to install and configure SQL Server 2022 for optimal performance.
  • Database & Table Management: Gain practical skills in creating and managing databases and tables within SQL Server.
  • Fundamental SQL Queries: Become proficient in essential SQL commands like SELECT, INSERT, UPDATE, and DELETE.
  • Advanced SQL Techniques: Explore advanced concepts including operators, joins, aggregate functions, and Transact-SQL (T-SQL) for complex data manipulation.
  • SQL Server Management Studio (SSMS) Tips: Discover practical tips and tricks to enhance your workflow within SQL Server Management Studio.
  • Database Objects: Learn to create views, stored procedures, triggers, and functions to extend the capabilities of your SQL Server databases.

Part 2: Exploring MongoDB 5.0 (NoSQL)

  • MongoDB & Mongo Compass Setup: Install MongoDB 5.0 and learn to effectively use Mongo Compass for database management.
  • NoSQL Database & Collection Management: Understand how to manage NoSQL databases and collections in MongoDB.
  • MongoDB Querying: Master MongoDB query language with commands like find(), pretty(), and limit().
  • Advanced Operators: Utilize advanced operators like gt, gte, lt, lte, and, or, in, nin, all, and exists for powerful data filtering.
  • Document Manipulation (CRUD): Learn to update and delete documents, implementing fundamental CRUD (Create, Read, Update, Delete) operations.
  • Data Joins & Performance Optimization: Discover techniques for performing joins and optimizing performance using indexes in MongoDB.

Course Benefits:

  • Balanced Approach: 9.5 hours of practical demonstrations combined with 30 minutes of concise theory.
  • Hands-on Learning: A practical, application-focused approach ensures rapid comprehension.
  • Extensive Practice: Over 80 practical exercises to reinforce your learning and solidify your skills.
  • Beginner-Friendly: Designed to make you comfortable and confident with both SQL and NoSQL database technologies.

Invest in your future! Join this course to acquire robust SQL and NoSQL skills, essential for success in modern database environments.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(8)
1h 18m
beginner

PostgreSQL et MySQL pour les (grands) débutants (2025)

by ELOA FORMATION Plateforme Eleaning, rejoignez nous ! SQL Server| Postgres | Powershell l Python|Azure|MongoDB| Oracle

4.9(49)
6h 45m
beginner

Python, SQL et Powershell pour les (grands) débutants (2025)

by ELOA FORMATION Plateforme Eleaning, rejoignez nous ! SQL Server| Postgres | Powershell l Python|Azure|MongoDB| Oracle

4.9(135)
13h 17m
beginner
4.9(28)
1h 28m
beginner

SQL server: Améliorez la performance des procédures stockées

by ELOA FORMATION Plateforme Eleaning, rejoignez nous ! SQL Server| Postgres | Powershell l Python|Azure|MongoDB| Oracle

4.8(25)
59m
intermediate
4.8(124)
3h 27m
all