Job-Ready SQL in an Afternoon
Job-Ready SQL in an Afternoon, available at $64.99, has an average rating of 4.8, with 45 lectures, based on 60 reviews, and has 408 subscribers.
You will learn about Understand SQL databases Understand the relational model Learn to insert data into SQL databases Extract data from SQL databases Write complex queries to perform tasks like as required in technical interviews or on the job This course is ideal for individuals who are Anyone who wants to learn about database or Anyone who wants to integrate databases into their code or Anyone who wants to learn about SQL databases It is particularly useful for Anyone who wants to learn about database or Anyone who wants to integrate databases into their code or Anyone who wants to learn about SQL databases.
Enroll now: Job-Ready SQL in an Afternoon
Summary
Title: Job-Ready SQL in an Afternoon
Price: $64.99
Average Rating: 4.8
Number of Lectures: 45
Number of Published Lectures: 45
Number of Curriculum Items: 45
Number of Published Curriculum Objects: 45
Original Price: €114.99
Quality Status: approved
Status: Live
What You Will Learn
- Understand SQL databases
- Understand the relational model
- Learn to insert data into SQL databases
- Extract data from SQL databases
- Write complex queries to perform tasks like as required in technical interviews or on the job
Who Should Attend
- Anyone who wants to learn about database
- Anyone who wants to integrate databases into their code
- Anyone who wants to learn about SQL databases
Target Audiences
- Anyone who wants to learn about database
- Anyone who wants to integrate databases into their code
- Anyone who wants to learn about SQL databases
SQL is the language that you can use to interact with one major database type (SQL databases), one that is very wide-spread in today’s world.
Knowing SQL will give you a nice ability and understanding of how to handle data and databases, and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data.
In this course we’ll be learning SQL. We’ll start by going through some fundamental knowledge like learning about the relational model, as well as what schemas are, the different data types available, and how database tables are organized. Then we’ll go ahead and set up our own local Postgres database and populate it with data so that we have data to run queries against. Once our setup is done we’re then ready to directly jump into writing SQL code.
We’ll start with the basics like creating databases and tables, inserting and selecting data, and performing filtering and result ordering. This way we can make sure we’re comfortable with how the data is laid out and that we feel good performing the basic operations that usually make up all queries.
Then we’ll jump deeper into SQL by learning about aggregations, subqueries, joins, unions, and window functions.
By the end of this course you should be ready to successfully apply your SQL knowledge in both technical interviews as well as on the job.
Course Curriculum
Chapter 1: Fundamentals and Setup
Lecture 1: Intro to Relational Databases
Lecture 2: Data Types and Schemas
Lecture 3: [Mac] Setting Up a Local PostgreSQL Server
Lecture 4: [Windows] Setting Up a Local PostgreSQL Server
Lecture 5: [Mac] SQL Editor Postico
Lecture 6: SQL Editor DataGrip
Lecture 7: SQL Editor CLI
Lecture 8: Creating and Removing a Database
Chapter 2: Databases, Tables, and Basic Queries
Lecture 1: Creating Schemas
Lecture 2: Creating Tables
Lecture 3: Altering Tables
Lecture 4: Enumerated Types
Lecture 5: Inserting Values
Lecture 6: Running an SQL Script
Lecture 7: Reading Data
Lecture 8: Creating Tables Using Query Results
Lecture 9: Aliases and Ordering
Chapter 3: Conditionals and Arithmetics
Lecture 1: Conditional Filtering Direct Comparisons
Lecture 2: Conditional Filtering Grouped Comparisons
Lecture 3: Joining Conditionals
Lecture 4: Negating Conditionals
Lecture 5: Filtering Null Values
Lecture 6: Creating New Columns and Arithmetics
Lecture 7: Datatype Conversions
Lecture 8: Logic Statements
Chapter 4: Dates, Times, and Manipulating Data
Lecture 1: Manipulating Strings
Lecture 2: String Positional Information
Lecture 3: String Subsets and Concatenations
Lecture 4: String Replacements
Lecture 5: Date and Time
Lecture 6: Date and Time Intervals
Lecture 7: Comments
Lecture 8: Aggregation Functions
Lecture 9: Grouping and Filtering Aggregations
Chapter 5: Joins, Unions, and Subqueries
Lecture 1: Inner Join
Lecture 2: Left, Right, and Outer Joins
Lecture 3: Self Joins
Lecture 4: Unions
Lecture 5: Subqueries
Lecture 6: CTEs
Chapter 6: Window Functions
Lecture 1: Window Functions and Aliases
Lecture 2: Row Numbers and Ranks
Lecture 3: Using Other Rows with Window Functions
Lecture 4: NTiles
Lecture 5: Understanding Query Performance
Instructors
-
Max S
Data Engineer
Rating Distribution
- 1 stars: 3 votes
- 2 stars: 2 votes
- 3 stars: 8 votes
- 4 stars: 16 votes
- 5 stars: 31 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024