Udemybeginnerfr

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

Learn 3 essential programming languages for today's tech world! 13 hours of instruction. Boost your coding skills.

4.9(20)
135students
13h 17m
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

Python, SQL et Powershell pour les (grands) débutants (2025) is a beginner-level Udemy course taught by ELOA FORMATION Plateforme Eleaning, rejoignez nous ! SQL Server| Postgres | Powershell l Python|Azure|MongoDB| Oracle. It runs 13h 17m, is taught in French, and includes a certificate of completion. Learners rate it 4.9 out of 5 from 20 reviews, with 135 students enrolled. It is a paid course, last updated September 2025.

Ready to Master Data & Scripting? Learn Python, PowerShell & SQL!

This comprehensive course is designed for complete beginners in programming, as well as developers looking to expand their skillset with three powerful languages: SQL, Python, and PowerShell. Get the ultimate value – learn all three languages for the price of one!

This course is structured into three distinct parts, providing a solid foundation and practical skills.

Part 1: SQL - Database Fundamentals & Advanced Techniques

Whether you're a SQL beginner or have some existing knowledge, this section will take you from the basics to advanced database manipulation.

  • SQL Server Setup: Learn to install SQL Server and SQL Management Studio.
  • Database & Table Creation: Master creating databases and tables.
  • Data Manipulation (DML): Get hands-on with essential commands like SELECT, INSERT, UPDATE, and DELETE.
  • Advanced T-SQL: Dive deeper into Transact SQL with LIKE, GROUP BY, BETWEEN, and DISTINCT.
  • Aggregate Functions: Explore MIN, MAX, AVG, COUNT, and SUM for powerful data analysis.
  • String Functions: Learn to manipulate text with functions like SUBSTRING, FORMAT, LEFT, RIGHT, CONCAT, REPLACE, and LEN.
  • Joins: Master various join types including INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and OUTER APPLY.
  • Date & Time Functions: Work with dates using DATEADD, DATEDIFF, DATEPART, and EOMONTH.
  • Advanced T-SQL: Explore MERGE, CHOOSE, IIF, CASE WHEN, OFFSET, and FETCH NEXT ROWS.
  • Error Handling: Implement robust code with BEGIN TRY and BEGIN CATCH blocks, and IF and ELSE statements.
  • Window Functions: Unlock the power of ranking with ROW_NUMBER, OVER, PARTITION BY, ROWS/RANGE UNBOUNDED PRECEDING, FIRST/LAST VALUES, LAG, and LEAD.
  • Data Conversion: Use TRY CAST, TRY CONVERT, TRY PARSE, and PARSE for reliable data type conversions.
  • Stored Procedures, Views, Triggers & Functions: Learn to create and utilize these essential database objects.

Part 2: Python - A Beginner-Friendly Introduction (Python 3.9)

This section provides a detailed introduction to Python 3.9, with regular updates to ensure you're using the latest version.

  • Python Fundamentals: Learn the core concepts of Python in detail.
  • Environment Setup: Install Python and VS Code.
  • Scripting Basics: Write your first Python scripts using PRINT and INPUT.
  • Variables & Data Types: Understand variable assignment and different data types (strings, integers).
  • String Manipulation: Learn to work with strings effectively.
  • Conditional Statements: Master if, else, and elseif statements.
  • Logical Operators: Understand OR, AND, and NOT operators.
  • Data Structures: Work with lists and tuples.
  • Loops: Utilize FOR and WHILE loops.
  • And much more! The course includes numerous exercises and quizzes to reinforce your learning.

Part 3: PowerShell - Automate Tasks & Manage Systems

This section introduces you to PowerShell, a powerful scripting language for system administration and automation.

  • Cmdlets: Understand and utilize PowerShell cmdlets.
  • Aliases: Create your own custom aliases.
  • Comparison Operators: Use comparison operators effectively.
  • Pipelines: Master the PowerShell pipeline for data processing.
  • Scripting Fundamentals: Write your first PowerShell scripts to manipulate objects.
  • The $_ Variable: Learn to use the powerful $_ variable.
  • ISE (Integrated Scripting Environment): Explore the PowerShell ISE interface.
  • Variables & Comments: Declare variables and use comments.
  • Here-Strings & Constants: Utilize here-strings and constants.
  • Conditional Statements: Use IF, ELSEIF, and ELSE statements.
  • The SWITCH Command: Leverage the power of the SWITCH command.
  • Arrays: Create and manipulate arrays.
  • **Loops
$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(25)
6h 11m
beginner
5.0(2)
2h 28m
all
5.0(7)
1h 49m
beginner