
Learn SQL from scratch with hands-on querying, covering data types (numeric, string, date/time), tables, DDL (create, drop, alter), and constraints such as null and default.
Download and install the required applications via Windows or Mac guides, follow the two videos and Google walk-through, access the download links and the resources folder, then begin learning escarole.
Download and install the SQL Server developer edition on Windows from the Microsoft page, then install SQL Server Management Studio for a graphical interface and easy taskbar access.
Learn to run SQL Server on a Mac by installing VirtualBox, setting up Windows 10, and deploying SQL Server 2019 Developer Edition with SQL Server Management Studio.
Learn foundational SQL skills for data analysis by creating and managing databases, building tables, inserting and querying records, and enforcing data constraints in SQL Server.
This course takes you from having little or no knowledge of SQL towards becoming proficient in coding with SQL.
Knowing SQL is highly important if you intend working with data and the demand for SQL skills is ever growing.
You will learn SQL in a server environment which is most likely how you would use SQL in the real world. Not only would you learn SQL but you get to experience working with SQL in a real life setting.
This course is hands-on with practice tasks which allows you get comfortable and familiar with querying in SQL.
Course Requirement or Prerequisites
This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. All applications necessary for learning the course would be downloaded free from the internet.
Who is this course for?
Anyone looking to work with data personally or professionally.
Looking into a career as Data Analyst, Data Scientist, Business Analyst, Report Analyst, ETL Specialist, BI Consultant, Data Engineer or any Data related field.