Python et SQL pour les (grands) débutants

Learn Python & SQL: A Complete Beginner's Guide

Ready to dive into the world of programming? This comprehensive course is designed for complete beginners with no prior experience in Python or SQL, as well as developers looking to expand their skillset. Get the ultimate value by mastering two powerful languages for the price of one!

This course is structured into three distinct parts, providing a solid foundation in both SQL and Python.

Part 1: Master SQL - Data Management & Transact-SQL (TSQL)

This section covers everything you need to know about SQL, from basic to advanced concepts. You'll learn to:

• Set up your SQL environment: Install SQL Server and Management Studio.
• Database & Table Creation: Learn to create and manage databases and tables.
• Data Manipulation: Master fundamental SQL commands like SELECT, INSERT, UPDATE, and DELETE.
• Advanced T-SQL Techniques:
  • Utilize LIKE, GROUP BY, BETWEEN, and DISTINCT for powerful data filtering.
  • Explore aggregate functions with MIN, MAX, AVG, COUNT, and SUM.
  • Work with string functions like SUBSTRING, FORMAT, LEFT, RIGHT, CONCAT, REPLACE, and LEN.
  • Join tables effectively using INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and OUTER APPLY.
  • Manipulate dates with DATEADD, DATEDIFF, DATEPART, and EOMONTH.
  • Implement advanced T-SQL features: MERGE, CHOOSE, IIF, CASE WHEN, OFFSET, and FETCH NEXT ROWS ONLY.
  • Implement error handling using BEGIN TRY and BEGIN CATCH, and IF and ELSE statements.
  • Utilize powerful ranking functions like ROW_NUMBER, OVER, PARTITION BY, ROWS/RANGE UNBOUNDED PRECEDING, FIRST_VALUE, LAST_VALUE, LAG, and LEAD.
  • Handle data type conversions with TRY CAST, TRY CONVERT, TRY PARSE, and PARSE.
• Database Objects: Understand and utilize stored procedures, views, triggers, and functions.

Part 2: Unlock Python Programming - From Fundamentals to Practical Application

This section provides a thorough introduction to Python 3.9, with regular updates. You will:

• Python Setup: Install Python 3.9 and VS Code.
• Python Basics: Learn to write your first Python script using PRINT and INPUT statements.
• Variables & Data Types: Understand variable definition and different data types (strings, integers, etc.).
• String Manipulation: Learn to effectively work with strings.
• Control Flow: Master conditional statements (if, else, elseif) and logical operators (OR, AND, NOT).
• Data Structures: Work with lists and tuples.
• Loops: Utilize FOR and WHILE loops for efficient iteration.
• And much more! The course includes numerous exercises and quizzes to reinforce your learning.

Course Highlights:

• Concise & Engaging: This online course features short, digestible video lessons (under 10 minutes) with a focus on clear explanations.
• Practical Learning: 11.5 hours of video demonstrations combined with 30 minutes of focused theory. Theory is presented in class, not within the video lessons.
• Career Advancement: Mastering these languages will help you stand out from your peers and impress during job interviews.
• Up-to-Date: The course is regularly updated to reflect the latest versions of Python and SQL Server.