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.
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, andDELETE. - Advanced T-SQL: Dive deeper into Transact SQL with
LIKE,GROUP BY,BETWEEN, andDISTINCT. - Aggregate Functions: Explore
MIN,MAX,AVG,COUNT, andSUMfor powerful data analysis. - String Functions: Learn to manipulate text with functions like
SUBSTRING,FORMAT,LEFT,RIGHT,CONCAT,REPLACE, andLEN. - Joins: Master various join types including
INNER JOIN,FULL JOIN,LEFT JOIN,RIGHT JOIN,CROSS JOIN, andOUTER APPLY. - Date & Time Functions: Work with dates using
DATEADD,DATEDIFF,DATEPART, andEOMONTH. - Advanced T-SQL: Explore
MERGE,CHOOSE,IIF,CASE WHEN,OFFSET, andFETCH NEXT ROWS. - Error Handling: Implement robust code with
BEGIN TRYandBEGIN CATCHblocks, andIFandELSEstatements. - Window Functions: Unlock the power of ranking with
ROW_NUMBER,OVER,PARTITION BY,ROWS/RANGE UNBOUNDED PRECEDING,FIRST/LAST VALUES,LAG, andLEAD. - Data Conversion: Use
TRY CAST,TRY CONVERT,TRY PARSE, andPARSEfor 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
PRINTandINPUT. - 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, andelseifstatements. - Logical Operators: Understand
OR,AND, andNOToperators. - Data Structures: Work with lists and tuples.
- Loops: Utilize
FORandWHILEloops. - 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, andELSEstatements. - The SWITCH Command: Leverage the power of the
SWITCHcommand. - Arrays: Create and manipulate arrays.
- **Loops
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.